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_TRAINING_SS dependencies on HR_API

Line 1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

1341: l_object_version_number number;
1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1347: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1348: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1349: l_transaction_table hr_transaction_ss.transaction_table;

Line 1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1347: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1348: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1349: l_transaction_table hr_transaction_ss.transaction_table;
1350: l_from varchar2(15);

Line 1347: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1347: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1348: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1349: l_transaction_table hr_transaction_ss.transaction_table;
1350: l_from varchar2(15);
1351: l_cancel_boolean BOOLEAN;

Line 1348: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1347: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1348: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1349: l_transaction_table hr_transaction_ss.transaction_table;
1350: l_from varchar2(15);
1351: l_cancel_boolean BOOLEAN;
1352: l_auto_create_finance VARCHAR2(40);

Line 1823: update hr_api_transaction_values

1819: 'BOOKING_ID',
1820: l_booking_id);
1821:
1822: -- update p_from in transaction table
1823: update hr_api_transaction_values
1824: set varchar2_value = 'APPROVE'
1825: where transaction_step_id = p_transaction_step_id
1826: and name = 'P_FROM';
1827:

Line 2364: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

2360: l_transaction_step_id number;
2361: l_eventid ota_events.event_id%type;
2362:
2363: l_approval_mode wf_activity_attr_values.text_value%type;
2364: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
2365: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
2366: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
2367:
2368: begin

Line 2365: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

2361: l_eventid ota_events.event_id%type;
2362:
2363: l_approval_mode wf_activity_attr_values.text_value%type;
2364: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
2365: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
2366: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
2367:
2368: begin
2369:

Line 2366: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

2362:
2363: l_approval_mode wf_activity_attr_values.text_value%type;
2364: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
2365: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
2366: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
2367:
2368: begin
2369:
2370: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type