API To Upload Value Set Values

DECLARE

   v_enabled_flag        VARCHAR2 (2)                  := 'Y';

   v_summary_flag        VARCHAR2 (2)                  := 'Y';

   v_start_date_active   DATE                          := SYSDATE;

   v_error_msg           VARCHAR2 (1000)               := NULL;

   v_who_type            fnd_flex_loader_apis.who_type;

How to Register / Delete procedure in USER Hook

How TO REGISTER/DELETE PROCEDURE IN USER Hook

1)     Create API Hook Call (Register Procedure in User Hook)

PACKAGE Name: hr_api_hook_call_api.create_api_hook_call

DECLARE

   l_api_hook_call_id        NUMBER;

   l_object_version_number   NUMBER;

Concurrent Managers that are currently running requests

SELECT Concurrent_Queue_Name Manager,

       Request_Id Request,

       User_name,

       Concurrent_Program_Name Program,

       Run_Alone_Flag,

       TO_CHAR (Actual_Start_Date, 'DD-MON-YY HH24:MI') Started

  FROM Fnd_Concurrent_Queues Fcq,

       Fnd_Concurrent_Requests Fcr,

       Fnd_Concurrent_Programs Fcp,

       Fnd_User Fu,

       Fnd_Concurrent_Processes Fpro

 WHERE Phase_Code = 'R' AND Fcr.Controlling_Manager = Concurrent_Process_Id

       AND (Fcq.Concurrent_Queue_Id = Fpro.Concurrent_Queue_Id

            AND Fcq.Application_Id = Fpro.Queue_Application_Id)

       AND (Fcr.Concurrent_Program_Id = Fcp.Concurrent_Program_Id

            AND Fcr.Program_Application_Id = Fcp.Application_Id)

       AND Fcr.Requested_By = User_Id

Print the Log file names of the managers that can run a given request

SELECT    'The '

       || Concurrent_Queue_Name

       || ' concurrent manager ran your request from',

          TO_CHAR (Actual_Start_date, '     MON-DD-YY HH:MI:SS AM')

       || ' - to - '

       || TO_CHAR (Actual_COMPLETION_date, 'MON-DD-YY HH:MI:SS AM'),

          'The '

       || Concurrent_Queue_Name

       || ' concurrent manager log file is '

       || P.Logfile_Name,

       'Request log file is ' || R.Logfile_Name

  FROM Fnd_Concurrent_Queues Q,

       Fnd_Concurrent_requests R,

       Fnd_Concurrent_Processes P

 WHERE (P.Concurrent_Queue_ID = Q.Concurrent_Queue_ID

        AND Queue_Application_ID = Q.Application_ID)

       AND R.Controlling_Manager = P.Concurrent_Process_ID

       AND R.Phase_Code = 'C'

       AND Request_ID = &Request_ID