Thursday, September 20, 2007

Form Customization through Custom.pll

Hi
This is Rakesh.C . I am an Oracle Apps Technical Consultant working in APL Hyderabad.In this post i am giving some of the facts about Custom.pll in Customizing the Oracle Forms.If you have any queries contact on rakhi.oraapps@gmail.com

CUSTOM.PLL
Oracle Apps contains set of forms, reports and other concurrent programs designed and integrated to meet the needs of specific business functionality.
In order to customize the reports and other concurrent programs we need to download the program from the server and we have to make the customizations.

There are 2 ways to customize the form in the oracle apps.they are
1.download the source (form) from AU_TOP dir, then start customize the form &
2.download the custom.pll from AU_TOP/resource dir, then start customize the form according to specific events


CUSTOMIZING WITH CUSTOM.PLL
The Custom.pll is a Oracle forms pl/sql library which is used for the optimization of Oracle Forms. Through custom.pll we can customize with 2 types of events.They are
1.Generic events and
2. Product specific events

Generic events includes:

When_form_navigate
When_new_form_instance
When_new_block_instance
When_new_record_instance
When_new_item_instance
When_validate_record
Specialn (where n is a number between 1 & 45)
Zoom
Export
Key-Fn (n is between 1 and 8)

Product-specific events includes:
When_logon_changed
When_responsibility_changed
When_password_changed

In order to code the logic through custon.pll we have to mainly observe the following things
1.Formname
2.Blockname and
3.In which event, logic has to be fired

In order to support the various functionality we have to explicitly add the corresponding packages like APPCORE2 etc. APPCORE2 library supports the same functionality as APPCORE package. The main reason for not attaching the APPCORE package to the custom because custom is attached to the APPCORE so it would cause a recursion problem.

Custom.pll contains the following functions and procedures
Function zoom_available return BOOLEAN;
Function style (event_name varchar2) return integer;
Procedure event (event_name varchar2);

Zoom_available function returns the zoom status of the form and block. Style function is used, whenever there is logic for the particular form for particular event and through custom.pll if we used the same event then we can use the style function to change the order of execution for the two same events. And event procedure is used to write the code for various events for the particular form and block based on the customization.

By using this functions and procedures in custom.pll we can easily customize the business login of the forms.

4 comments:

oakleyses said...

nike air max, gucci handbags, ugg boots, louis vuitton outlet, polo ralph lauren, christian louboutin outlet, christian louboutin uk, cheap oakley sunglasses, nike free, tory burch outlet, burberry pas cher, polo outlet, jordan shoes, sac longchamp pas cher, oakley sunglasses, replica watches, louis vuitton, longchamp outlet, oakley sunglasses, nike free run, christian louboutin shoes, ray ban sunglasses, oakley sunglasses wholesale, louis vuitton outlet, nike air max, louis vuitton, louboutin pas cher, tiffany jewelry, prada handbags, nike roshe, oakley sunglasses, air max, prada outlet, ugg boots, nike outlet, tiffany and co, ray ban sunglasses, longchamp outlet, chanel handbags, michael kors pas cher, longchamp pas cher, jordan pas cher, replica watches, polo ralph lauren outlet online, uggs on sale, longchamp outlet, kate spade outlet, christian louboutin

oakleyses said...

ray ban uk, coach purses, polo lacoste, sac vanessa bruno, nike tn, hogan outlet, michael kors, michael kors outlet online, converse pas cher, nike air max uk, kate spade, michael kors outlet, hollister pas cher, uggs outlet, coach outlet, north face, michael kors outlet, north face uk, nike air max uk, ray ban pas cher, uggs outlet, nike air force, ralph lauren uk, mulberry uk, lululemon canada, nike free uk, true religion jeans, guess pas cher, replica handbags, timberland pas cher, nike blazer pas cher, coach outlet store online, michael kors outlet online, burberry handbags, abercrombie and fitch uk, michael kors, nike air max, michael kors outlet, vans pas cher, oakley pas cher, true religion outlet, hollister uk, nike roshe run uk, sac hermes, true religion outlet, new balance, michael kors outlet online, burberry outlet, true religion outlet

oakleyses said...

timberland boots, instyler, wedding dresses, mcm handbags, beats by dre, ghd hair, converse, oakley, herve leger, nike huaraches, hollister, valentino shoes, nfl jerseys, mac cosmetics, vans, abercrombie and fitch, insanity workout, mont blanc pens, hollister clothing, reebok outlet, bottega veneta, louboutin, lululemon, p90x workout, baseball bats, nike roshe run, celine handbags, vans outlet, converse outlet, north face outlet, hermes belt, new balance shoes, north face outlet, ray ban, longchamp uk, jimmy choo outlet, babyliss, ralph lauren, gucci, chi flat iron, soccer jerseys, asics running shoes, iphone cases, ferragamo shoes, hollister, nike trainers uk, soccer shoes, nike air max, giuseppe zanotti outlet, nike air max

oakleyses said...

canada goose, moncler outlet, canada goose outlet, toms shoes, montre pas cher, louis vuitton, moncler, canada goose, swarovski, juicy couture outlet, louis vuitton, replica watches, links of london, moncler, canada goose uk, moncler uk, hollister, wedding dresses, thomas sabo, karen millen uk, canada goose outlet, barbour uk, louis vuitton, ugg uk, ugg,ugg australia,ugg italia, moncler outlet, doudoune moncler, ugg,uggs,uggs canada, canada goose, supra shoes, coach outlet, canada goose outlet, ugg pas cher, ugg, pandora uk, louis vuitton, canada goose jackets, juicy couture outlet, moncler, marc jacobs, louis vuitton, pandora jewelry, lancel, swarovski crystal, pandora jewelry, pandora charms, barbour, moncler