1)Download the CUSTOM.pll from AU_TOP\11.5.0\Resource folder.
2)Open with Forms 6i.
3)Goto Event Procedure
Write the Following Code in the place of 'Real Code Starts Here'
form_name varchar2(30) := name_in('system.current_form');
block_name varchar2(30) := name_in('system.cursor_block');
begin
if (event_name = 'WHEN-NEW-FORM-INSTANCE') then
if (form_name = 'APXWCARD' and block_name = 'CARDS') then
APP_ITEM_PROPERTY2.SET_PROPERTY('CARDS.DEPARTMENT_NAME', -BlockName.FieldName
DISPLAYED,
PROPERTY_OFF);
APP_ITEM_PROPERTY2.SET_PROPERTY('PO_HEADERS.SEGMENT1',
PROMPT_TEXT,
'PO Number');
APP_ITEM_PROPERTY2.SET_PROPERTY('REGIONS.REGION_LONG_NAME',
CASE_RESTRICTION,
UPPERCASE);
end if;
end if; (attach the Library called APPCORE2.pll)
4) Compile the Library we can get .pll (Program link Library)
Execute the Library we will get .plx (Program Link Executable)
(File ->Administration->Compile File)
5)Transfer both .pll and .plx files into the Resource folder in the AU top.
(Note: before going to copy into the server close the complete Application)
Note:When we are copying the custom.PLL in to the Resource folder
we have to close the application because If application is opened
CUSTOM.pll being used , All the forms in oracle
applications developed with TEMPLETE.fmb contains CUSTOM.pll
If file is being used by other program we can not Update the file.
thats why we will close the application.
When we are working inthe project all the Users will be connected to
Oracle apps we can not ask every one to closethe application.for that
we will get the
Alternative Path(Link File Path) from DBA we will place the CUSTOM.pll
in that folder.only we have to reLogin we can find the Customization
Other users no need to Logout.
2)Open with Forms 6i.
3)Goto Event Procedure
Write the Following Code in the place of 'Real Code Starts Here'
form_name varchar2(30) := name_in('system.current_form');
block_name varchar2(30) := name_in('system.cursor_block');
begin
if (event_name = 'WHEN-NEW-FORM-INSTANCE') then
if (form_name = 'APXWCARD' and block_name = 'CARDS') then
APP_ITEM_PROPERTY2.SET_PROPERTY('CARDS.DEPARTMENT_NAME', -BlockName.FieldName
DISPLAYED,
PROPERTY_OFF);
APP_ITEM_PROPERTY2.SET_PROPERTY('PO_HEADERS.SEGMENT1',
PROMPT_TEXT,
'PO Number');
APP_ITEM_PROPERTY2.SET_PROPERTY('REGIONS.REGION_LONG_NAME',
CASE_RESTRICTION,
UPPERCASE);
end if;
end if; (attach the Library called APPCORE2.pll)
4) Compile the Library we can get .pll (Program link Library)
Execute the Library we will get .plx (Program Link Executable)
(File ->Administration->Compile File)
5)Transfer both .pll and .plx files into the Resource folder in the AU top.
(Note: before going to copy into the server close the complete Application)
Note:When we are copying the custom.PLL in to the Resource folder
we have to close the application because If application is opened
CUSTOM.pll being used , All the forms in oracle
applications developed with TEMPLETE.fmb contains CUSTOM.pll
If file is being used by other program we can not Update the file.
thats why we will close the application.
When we are working inthe project all the Users will be connected to
Oracle apps we can not ask every one to closethe application.for that
we will get the
Alternative Path(Link File Path) from DBA we will place the CUSTOM.pll
in that folder.only we have to reLogin we can find the Customization
Other users no need to Logout.