DBA Data[Home] [Help]

APPS.OTA_EL_TRAINING_SS dependencies on HR_API

Line 1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

1086: l_object_version_number number;
1087: l_person_details OTA_EL_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
1088: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1089: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1092: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1093: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1094: l_transaction_table hr_transaction_ss.transaction_table;

Line 1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

1087: l_person_details OTA_EL_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
1088: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1089: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1092: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1093: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1094: l_transaction_table hr_transaction_ss.transaction_table;
1095: l_from varchar2(15);

Line 1092: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

1088: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1089: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1092: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1093: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1094: l_transaction_table hr_transaction_ss.transaction_table;
1095: l_from varchar2(15);
1096: l_cancel_boolean BOOLEAN;

Line 1093: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

1089: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1092: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1093: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1094: l_transaction_table hr_transaction_ss.transaction_table;
1095: l_from varchar2(15);
1096: l_cancel_boolean BOOLEAN;
1097: l_auto_create_finance VARCHAR2(40);

Line 1567: update hr_api_transaction_values

1563: 'BOOKING_ID',
1564: l_booking_id);
1565:
1566: -- update p_from in transaction table
1567: update hr_api_transaction_values
1568: set varchar2_value = 'APPROVE'
1569: where transaction_step_id = p_transaction_step_id
1570: and name = 'P_FROM';
1571: