eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ENROLL_REVIEW_SS dependencies on HR_API

Line 895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

891: l_object_version_number number;
892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;
893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
897: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
898: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
899: l_transaction_table hr_transaction_ss.transaction_table;

Line 896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;
893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
897: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
898: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
899: l_transaction_table hr_transaction_ss.transaction_table;
900: l_from varchar2(15);

Line 897: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
897: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
898: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
899: l_transaction_table hr_transaction_ss.transaction_table;
900: l_from varchar2(15);
901: l_cancel_boolean BOOLEAN;

Line 898: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
897: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
898: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
899: l_transaction_table hr_transaction_ss.transaction_table;
900: l_from varchar2(15);
901: l_cancel_boolean BOOLEAN;
902: l_auto_create_finance VARCHAR2(40);

Line 1374: update hr_api_transaction_values

1370: 'BOOKING_ID',
1371: l_booking_id);
1372:
1373: -- update p_from in transaction table
1374: update hr_api_transaction_values
1375: set varchar2_value = 'APPROVE'
1376: where transaction_step_id = p_transaction_step_id
1377: and name = 'P_FROM';
1378:

Line 1885: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

1881: l_transaction_step_id number;
1882: l_eventid ota_events.event_id%type;
1883:
1884: l_approval_mode wf_activity_attr_values.text_value%type;
1885: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1886: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1887: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1888:
1889: begin

Line 1886: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

1882: l_eventid ota_events.event_id%type;
1883:
1884: l_approval_mode wf_activity_attr_values.text_value%type;
1885: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1886: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1887: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1888:
1889: begin
1890:

Line 1887: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

1883:
1884: l_approval_mode wf_activity_attr_values.text_value%type;
1885: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1886: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1887: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1888:
1889: begin
1890:
1891: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type