Oracle Apps FND functions

                                           Oracle Apps FND function

                    -----------------------------------------------------------------

Call Form from Another Form in Oracle Apps
------------------------------------------------------------

FND_FUNCTION.EXECUTE( FUNCTION_NAME=> ,
                      OPEN_FLAG=>'Y',
                      SESSION_FLAG=>'Y',
                      ACTIVATE_FLAG=>'ACTIVATE',
                      OTHER_PARAMS=>'P_MP_RANK="'||:BO_SERVICE_REQUEST_BLK.MP_RANK||'"');


FND_GLOBAL.APPS_INITIALIZE(p_user_id, p_resp_id, p_resp_appl_id);



To get the values of
p_user_id,
p_resp_id
p_resp_appl_id

use the following sql from sqlplus as apps user:

Oracle Apps FND Table Name
-----------------------------------------

select application_id, Responsibility_id, responsibility_name
  from fnd_responsibility_vl
 where responsibility_name like 'your_reponsibility_name'


select user_id, user_name  
     from FND_USER
      where user_name = 'your_user_name'

Oracle Apps Report Initialization
---------------------------------------------------

For example:

   exec fnd_global.APPS_INITIALIZE (1271,50243,222);


     fnd_global.conc_request_id   ----> To get the concurrent Request Id

     MO_GLOBAL.init() API to execute the multiple organizations initialization.

The FND_GLOBAL.APPS_INITIALIZE routine does NOT automatically call mo_global.init routine.
You must explicitly invoke the mo_global.init routine to initialize the organization context.

fnd_submit.set_mode
fnd_submit.set_nls_options
fnd_submit.set_repeat_options
fnd_submit.set_rel_class_options
fnd_submit.set_print_options
fnd_submit.add_printer
fnd_submit.add_notification
fnd_submit.set_request_set
fnd_submit.submit_program
fnd_submit.submit_set

How to set org context in Oracle apps R12 and 11i
Set org context in R12
The SQL command to set the ORG_ID prior to running a script is:

SQL> exec mo_global.init('AR');
exec mo_global.set_policy_context('S','&org_id');

Enter the org_id when prompted.
The procedure - mo_global.set_policy_context has two parameters

p_access_mode & p_org_id

p_access_mode Description

S   ----- >    In case you want your current session to work against Single ORG_ID
M   ----- >    In case you want your current session to work against multiple ORG_IDs


p_org_id  :  Only applicable if p_access_mode is passed value of "S"

Oracle Apps Form Property
----------------------------------------------

set_item_property(:system.cursor_item,background_color,1);

SET_ITEM_PROPERTY(':CONTROL.CREATE', FOREGROUND_COLOR, 'red');