Showing posts with label oracle apps. Show all posts
Showing posts with label oracle apps. Show all posts

Monday, January 5, 2009

How to attach calender to a field in oracle apps?

Steps to attach calendar to a field

1. Go to properties of that field and put the lov as ENABLE_LIST_LAMP.
2. Put the validate from list in that properties NO.
3. Put the KEY-LISTVAL trigger on that item and in that write clender.show ();

Code for calling oracle report and oracle form in oracle apps

The below is the code to call oracle report from oracle form in oracle apps.

DECLARE
v_order_imp_id number;
v_admno VARCHAR2(20);
begin
v_admno := :STD_PER_INFO_50448.ADMNO;
v_order_imp_id:= fnd_request.submit_request ('CUSTOM','EMP98','hi', NULL, FALSE,
v_admno,'','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','');
COMMIT;
MESSAGE ('Your Request Id is'v_order_imp_id);
MESSAGE ('Your Request Id is'v_order_imp_id);
END;

The below is the code to call oracle form from oracle form in oracle apps.

FND_FUNCTION.execute(‘Function Name you want to call and function should exist in your menu’);