All posts by Neel Rao

ORACLE EBS TRAINING IN PUNE ONLINE

ORACLE EBS TRAINING IN PUNE ONLINE

ORACLE EBS TRAINING IN PUNE ONLINE

Module 1

Overview of Coding Standards

  • Importance of these Standards
  • Coding Principles
  • Coding With Handlers
  • Libraries
  • Performance
  • Coding for Web Compatibility

The Standard Development Environment

  • Oracle Application Object Library for Release
  • Shared Objects
  • Standard Libraries
  • Property Classes
  • Visual Attributes

Overview of Building an Application

  • Overall Design Issues to Consider
  • Overview of Application Development Steps
  • Overview of Form Development Steps.

Module 2

Setting Up Your Application Framework

Overview of Setting Up Your Application Framework

  • Definitions
  • Set Up Your Application Directory Structures
  • Register Your Application
  • Modify Your Environment Files
  • Set Up and Register Your Oracle Schema
  • Create Database Objects and Integrate with APPS Schema
  • Add Your Application to a Data Group
  • Set Up Concurrent Managers

Applications Window

  • Prerequisites
  • Applications Block

Module 3

Building Your Database Objects

Overview of Building Your Database Objects

  • Using Cost–Based Optimization
  • Tracking Data Changes with Record History (WHO)
  • Oracle8i Declarative Constraints
  • LONG, LONG RAW and RAW Datatypes
  • Columns Using a Reserved Word
  • Views
  • Sequences

Table Registration API

  • Procedures in the AD_DD Package
  • Example of Using the AD_DD Package

Module 4

Using PL/SQL in Oracle Applications

Overview of Using PL/SQL in Applications

  • Definitions
  • General PL/SQL Coding Standards
  • Database Server Side versus Client Side
  • Formatting PL/SQL Code
  • Exception Handling
  • SQL Coding Guidelines
  • Triggers in Forms
  • Resources

Replacements for Oracle Forms Built–ins

  • Coding Item, Event and Table Handlers
  • Coding Item Handlers
  • Coding Event Handlers
  • Coding Table Handlers
  • Example Client–Side Table Handler
  • Example Server–Side Table Handler.

Module 5

Setting the Properties of Container Objects

Module

Windows

  • Non–Modal Windows
  • Modal Windows

Canvases

  • Content Canvases
  • Stacked Canvases

Blocks

  • Context Blocks
  • Dialog Blocks
  • Data Blocks With No Base Table
  • Single–Record Data Blocks
  • Multi–Record Blocks
  • Combination Blocks
  • Master–Detail Relations
  • Dynamic WHERE Clauses

Regions

  • Tabbed Regions
  • Alternative Regions (Obsolete for Release 11i)
  • Overflow Regions.

Module 6

Setting the Properties of Widget Objects

Text Items

  • Date Fields

Display Items

Poplists

Option Groups

Check Boxes

Buttons

Lists of Values (LOVs)

  • LOV Behaviors
  • LOVs in ENTER–QUERY Mode

Alerts

Editors

Flexfields

Setting Item Properties

  • Using APP_ITEM_PROPERTY.SET_PROPERTY
  • Item Properties with Unique Oracle Applications Behavior
  • Impact of Item–level and Item–instance–level Settings
  • Setting Properties at Design Time
  • Setting Visual Attributes Programmatically.

Module 7

Controlling Window, Block and Region Behavior

Controlling Window Behavior

  • Positioning Windows Upon Opening
  • Closing Windows
  • Setting Window Titles Dynamically

Controlling Block Behavior

  • Coding Master–Detail Relations
  • Implementing a Combination Block

Coding Tabbed Regions

  • Definitions
  • Tabbed Region Behavior
  • Three Degrees of Coding Difficulty
  • Implementing Tabbed Regions
  • Tab Handler Logic
  • WHEN–TAB–PAGE–CHANGED Logic
  • WHEN–NEW–ITEM–INSTANCE Logic
  • Handling Dynamic Tabs
  • Other Code You May Need

Coding Alternative Region Behavior

  • Alternative Regions
  • Example: Coding an Alternative Region

Controlling Records in a Window

  • Duplicating Records
  • Renumbering All Records in a Window

Passing Instructions to a Form.

Module 8

Enabling Query Behavior

Overview of Query Find

  • Raising Query Find on Form Startup

Implementing Row–LOV

  • Implementing Find Windows.

Module 9

 

Item Relations

  • Dependent Items
  • Conditionally Dependent Item
  • Multiple Dependent Items
  • Two Master Items and One Dependent Item
  • Cascading Dependence
  • Mutually Exclusive Items
  • Mutually Inclusive Items
  • Mutually Inclusive Items with Dependent Items
  • Conditionally Mandatory Items

Defaults

Integrity Checking

  • Uniqueness Check
  • Referential Integrity Check

The Calendar

  • Advanced Calendar Options
  • Calendar Examples

CALENDAR: Calendar Package

  • SHOW
  • SETUP
  • EV