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

Line 973: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

969: l_object_version_number number;
970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
972: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
973: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
974: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
975: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
976: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
977: l_transaction_table hr_transaction_ss.transaction_table;

Line 974: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
972: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
973: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
974: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
975: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
976: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
977: l_transaction_table hr_transaction_ss.transaction_table;
978: l_from varchar2(15);

Line 975: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
972: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
973: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
974: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
975: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
976: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
977: l_transaction_table hr_transaction_ss.transaction_table;
978: l_from varchar2(15);
979: l_cancel_boolean BOOLEAN;

Line 976: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

972: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
973: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
974: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
975: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
976: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
977: l_transaction_table hr_transaction_ss.transaction_table;
978: l_from varchar2(15);
979: l_cancel_boolean BOOLEAN;
980: l_auto_create_finance VARCHAR2(40);

Line 1517: update hr_api_transaction_values

1513: 'BOOKING_ID',
1514: l_booking_id);
1515:
1516: -- update p_from in transaction table
1517: update hr_api_transaction_values
1518: set varchar2_value = 'APPROVE'
1519: where transaction_step_id = p_transaction_step_id
1520: and name = 'P_FROM';
1521:

Line 2469: ,hr_api_transaction_steps hrtrns

2465: From
2466: wf_item_activity_statuses process
2467: ,wf_item_attribute_values attribute2
2468: ,wf_process_activities activity
2469: ,hr_api_transaction_steps hrtrns
2470: Where
2471: activity.activity_name = p_process_name
2472: and activity.process_item_type = 'HRSSA'
2473: and activity.activity_item_type = 'HRSSA'