add

About Me

My photo
Oracle Apps - Techno Functional consultant

Tuesday, June 21

Calling Another Form Parameters

1)Develop both forms and register in application.
2)Place the Button in first from
3)Write the following code in WHEN-BUTTON-PRESSED Trigger.

Fnd_FunCtion.execute(function_name => 'Second form function Name',
open_flag => 'Y' ,
OTHER_PARAMS => 'P1 = '||:PO_VENDORS.VENDOR_ID);

P1 is Second form parameter

4)Open the Second foRm and define the Parmaeter called P1

5)goto PRE-QUERY trigger and write the following code to change the query dynamically.

:PO_VENDOR_SITES_ALL.VENDOR_ID := :PARAMETER.P1;
--:Blockname .fieldname := :PARAMETER.Parametername

6) Goto the WHEN-NEW-FORM-INSTANCE Trigger at form level. write the following code
GO_BLOCK('PO_VENDOR_SITES_ALL');
EXECUTE_QUERY;

Passing Parameters at the time of creating Functions:
===============================================
1)Develop the form
2)Register the form
3)Create Two functions for the same form.
first function without parameters
second function is with parameter called 'QUERY_0NLY="YES" '
enter the paraneter in the field called Parameter field.

SubMenu Creations:
==================
1)Copy the Functions whatever we would like to define as submenu
delete from the main menu.
2)Create new menu and attach the functions whatever we have copied.

3)Copy the menu whatever we have created attach to the main menu by selecting the
field called submenu.

Hiding the forms and Menus at Responsibility level=
===================================================
1)Open the Responsibility Form attach the menu
2)By default we will get all the forms and as well we menus will be displayed.
3)Select the Tab called Menu Exclusions Tab
Select the type = Function to hide the funtion.
select the type = Menu name to hide the menu.

Calling SRS Window from Menu:
============================
1)Create the Function for the User form name called "Run Reports"
2)Attach the Function to the menu.
3)Attach the menu to the responsibility
so that user can call the form from the menu.

Attach the Request group to the SRS Function:
===============================================
1)Create the Request group in System administrator by specifying the request group
code
Copy the Request group name
application short name
request group code
2)Goto the Appllication developer create the fucntion for the user form name called
" Run Reports"

3)Pass the follwoing Parameters while creation of the function.
REQUEST_GROUP_CODE="CUSTOMERCODE1"
REQUEST_GROUP_APPL_SHORT_NAME="AR"
TITLE="23CUSTOMERS"

4)Attch the function to the Menu , Menu to Responsibility , Responsibility to user

5)when we open the form we can get the programs which are there in the request
group.

note: We will follow this prcocedure to attach the multiple request groups to the
single Responsibility.

Display the Message Boxes in the Forms:
=======================================
1)Create the Message in Application Developer
2)Run the Concurrent Program called "Generate Messages"
by passing language code and as well as application name
3)Call the message from form triggers by using FND_MESSAGE API's.

begin
FND_MESSAGE.SET_NAME ('PO', 'NEW MESSAGE');
fnd_message.show();
end;

Libraries:
----------
APPDAYPK: This Library will support for all the Date and Time functionality in the
application.

FNDSQF : This Library will support for all the flexfield,Curency,WHO Coluns,Log File
Message functionalities.

APPCORE : It will support for all the Menu and Tool Bar functionality in the application.

CUSTOM : Will be used to make small customizations in the standard forms without
downloading the (.fmb)

Note: 1)We can download all these libraries from the AU_TOP\11.5.0\Resource Folder
where we will find all the Libraries both (.pll) and (.plx).
.pll = Program Link Library
.plx = Program link Executable

2)we are not suppose to customize any of these libraries we can utilize the existing
API's
3)We can Customize only one Library that is CUSTOM.pll

No comments: