Playing with CUSTOM.pll
Written by Anil Passi   
Wednesday, 08 November 2006
Please find some commands for CUSTOM.pll


To convert from CUSTOM.pll to CUSTOM.pld
f60gen module_type=LIBRARY module=CUSTOM script=YES userid=apps/apps

To convert back from CUSTOM.pld to CUSTOM.pll ( after having edited the text pld file )
f60gen module_type=LIBRARY module=CUSTOM parse=YES userid=apps/apps

To convert from CUSTOM.pll to CUSTOM.plx
f60gen module_type=LIBRARY module=CUSTOM userid=apps/apps

 

Comments (20)add
...
written by Charley , November 13, 2006
Anil,

I find that now with the Forms Personalization released last year, it is rare that Custom.pll will be needed. So many of the things I used to do with it are now included in the personalization capability of the forms.
...
written by Charley , November 13, 2006
Anil,

I find that now with the Forms Personalization released last year, it is rare that Custom.pll will be needed. So many of the things I used to do with it are now included in the personalization capability of the forms.
...
written by Anil Passi , November 15, 2006
indeed, i stopped using custom.pll too...almost.

Forms personalization still wont suppoort the scenario, when you want to provide a message box with multiple choices...hence good old custom.pll is still alive
...
written by Anil Passi , November 15, 2006
indeed, i stopped using custom.pll too...almost.

Forms personalization still wont suppoort the scenario, when you want to provide a message box with multiple choices...hence good old custom.pll is still alive
...
written by AragoRn , November 22, 2006
Anil,
i worked on 11.5.10.2, there i didnt find an option of changing the record group query attached to lov using form personalization. the same thing i can do comfortably using custom.pll

i feel for complex customizations is better to go for custom.pll ... what does .pld used for?
and how does custom.pll gets called when the form is developed from Templat.fmb ... i hav a vague idea of APPCORE lib internal calls Custom.pll n thts the reason for using APPCORE2 lib functions in custom.pll rather than APPCORE routines. can u elaborate more on the tight integration of custom.pll with forms and apps??

can u plz throw some light on whether we hav a custom.pll in coming fusion versions? i heard oracle completely gonna rule out the usage of D2K, then vl there b an existence of custom.pll then??

Regards,
Kishore
...
written by AragoRn , November 22, 2006
Anil,
i worked on 11.5.10.2, there i didnt find an option of changing the record group query attached to lov using form personalization. the same thing i can do comfortably using custom.pll

i feel for complex customizations is better to go for custom.pll ... what does .pld used for?
and how does custom.pll gets called when the form is developed from Templat.fmb ... i hav a vague idea of APPCORE lib internal calls Custom.pll n thts the reason for using APPCORE2 lib functions in custom.pll rather than APPCORE routines. can u elaborate more on the tight integration of custom.pll with forms and apps??

can u plz throw some light on whether we hav a custom.pll in coming fusion versions? i heard oracle completely gonna rule out the usage of D2K, then vl there b an existence of custom.pll then??

Regards,
Kishore
...
written by Anil Passi , December 10, 2006
There was a typo...
It should have read..
CUSTOM.pll is attached to APPCORE.
APPCORE2 is attached to CUSTOM.pll

Hence the execution is
APPCORE-->CUSTOM-->APPCORE2[if need be]

========
If instead we ever had
CUSTOM.pll attached to APPCORE.
APPCORE attached to CUSTOM.pll
then possible execution could be
APPCORE-->CUSTOM-->APPCORE-->CUSTOM--APPCORE--CUSTOM
Hence causing circular reference.

Hence, APPCORE2 is attached to CUSTOM.pll
So that when CUSTOM.pll calls for example APP_DATE, then it gets executed from APPCORE2.

This is so because APPCORE is not attached to CUSTOM.pll


Oracle Apps Dev guide documents this as well

Thanks
Anil Passi
...
written by Anil Passi , December 10, 2006
There was a typo...
It should have read..
CUSTOM.pll is attached to APPCORE.
APPCORE2 is attached to CUSTOM.pll

Hence the execution is
APPCORE-->CUSTOM-->APPCORE2[if need be]

========
If instead we ever had
CUSTOM.pll attached to APPCORE.
APPCORE attached to CUSTOM.pll
then possible execution could be
APPCORE-->CUSTOM-->APPCORE-->CUSTOM--APPCORE--CUSTOM
Hence causing circular reference.

Hence, APPCORE2 is attached to CUSTOM.pll
So that when CUSTOM.pll calls for example APP_DATE, then it gets executed from APPCORE2.

This is so because APPCORE is not attached to CUSTOM.pll


Oracle Apps Dev guide documents this as well

Thanks
Anil Passi
...
written by Anil Passi , January 21, 2007
Hi Suresh

Simply open the jsp file, and you will either find jdbc commands using tables or the java class files being referenced [the class files might have table referenced]
...
written by suresh , January 21, 2007
how to find table information in a .jsp

thanks
...
written by Anil Passi , January 21, 2007
Hi Suresh

Simply open the jsp file, and you will either find jdbc commands using tables or the java class files being referenced [the class files might have table referenced]
...
written by suresh , January 21, 2007
how to find table information in a .jsp

thanks
...
written by raj , January 29, 2007
Sunil,
can u give us more light on custom.pll
i.e what are the basics that we need to follow to use custom.pll with an example

regards
raj
...
written by Shripad , March 06, 2007
Hi Anil,
I am trying to learn oracle apps forms.
I have written a package and attached it to
custom.pll.I am having a procedure TEST_PROC(event_name).I want to know how the event value will be passed to my formal parameter event_name
...
written by rapps , May 20, 2007
hi anil,
i have a doubt regarding custom.pll how this code will be executed when a from is opened.. i saw the code of custom.pll in it most of the code was commented ,,how this code will be executed

thank you
rapps
...
written by PRASAD , August 04, 2007
HI ANIL,

I AM PRETY NEW TO THIS ORACLE APPS. CAN U TEL ME THE DIFFERENCE BETWEEN CUSTOM TABLE AND DATABASE TABLE.


THANKS
PRASAD
...
written by Anil Passi , August 04, 2007
Custom table is a database table itself.
But it is a table that is not delivered out of the box by Oracle ERP

You create that table, in a custom schema, to extend the functionality of Oracle Apps.

Thanks,
Anil Passi
...
written by malati , September 11, 2007
Hi Anil,

Great site for beginners.thanks for sharing ur knowledge.I would like to request u to please write an article on custom.pll's.that would be really helpful for all of us.

Thanks in advance.
Malati
How to use CUSTOM.PLL for ZOOM.
written by Pavankumar B Barlota , January 29, 2008
Hi Anil,

Can you please help me out to use Custom.pll for zoom?

I am calling my Custom form from the ISO form using ZOOM button there.
So, what are the changes needed for this...in custom.pll.

Plese give me step by step detail as i am new to this technology.
If it is easy to use by personalization then explain that too!

waiting for u r reply....
Custom.pll
written by tara , February 01, 2008
hi anil

iam new to this software job especially in oracle apps. can you tell me how to take first step and proceed to get through.

Thanks
mona
You must be logged in to a comment. Please register if you do not have an account yet.

busy