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;
queryig form
======================================================
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
Attach Calendar:
================
1)Select the Field properties and select the property called
List of Values : ENABLE_LIST_LAMP
2)Goto the Item level Trigger called KEY-LIST-VAL trigger call the following API
CAlendar.Show();
Attach the LOV:
----------------
1)Define the Record Group Either Static Values or By using the Query
2)Create LOV and attach the Record Group
3)Attach the LOV to field in the property called list of Values.
Implement WHO Columns:
=====================
1)Select All the WHO Columns in the Datablock
2)define following Two Triggers at DataBlock level 1)Pre-Insert
2)Pre-Update
3)Call the following API from both the Triggers
FND_STANDARD.SET_WHO():
Standard Libraries Contains all these API's.
we can download all these Libraries from Resource folder in AU_TOP.
APPDAYPK : It will Support for All CAlendar and Date time Functions
FNDSQF : It Will support for al the Flexfield,profile,WHO Columns functionality.
