APPS.HR_PROCESS_ADDRESS_SS dependencies on HR_API_TRANSACTION_STEPS

Line 8: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

4: -- Package scope global variables.
5: l_transaction_table hr_transaction_ss.transaction_table;
6: l_count INTEGER := 0;
7: l_praddr_ovrlap VARCHAR2(2);
8: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
9: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
10: g_package varchar2(31) := 'HR_PROCESS_ADDRESS_SS';
11: g_data_error exception;
12: l_message_number VARCHAR2(10);

Line 9: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

5: l_transaction_table hr_transaction_ss.transaction_table;
6: l_count INTEGER := 0;
7: l_praddr_ovrlap VARCHAR2(2);
8: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
9: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
10: g_package varchar2(31) := 'HR_PROCESS_ADDRESS_SS';
11: g_data_error exception;
12: l_message_number VARCHAR2(10);
13: p_trans_rec_count integer;

Line 2585: from hr_api_transaction_steps hats1

2581:
2582: BEGIN
2583: select nvl(hats1.transaction_step_id,0)
2584: into l_sfl_g_contact_step_id
2585: from hr_api_transaction_steps hats1
2586: where hats1.item_type = 'HRSSA'
2587: and hats1.item_key =
2588: (select hats2.item_key
2589: from hr_api_transaction_steps hats2

Line 2589: from hr_api_transaction_steps hats2

2585: from hr_api_transaction_steps hats1
2586: where hats1.item_type = 'HRSSA'
2587: and hats1.item_key =
2588: (select hats2.item_key
2589: from hr_api_transaction_steps hats2
2590: where hats2.item_type = 'HRSSA'
2591: and hats2.transaction_step_id = p_transaction_step_id )
2592: and hats1.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API';
2593: