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 ();
Monday, January 5, 2009
How to attach calender to a field in oracle apps?
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’);