APPS.PQP_GENERIC_EIT_SS dependencies on HR_API_TRANSACTION_STEPS

Line 10: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 11: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

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

Line 65: DELETE from hr_api_transaction_steps

61: BEGIN
62: DELETE from hr_api_transaction_values
63: WHERE transaction_step_id = p_transaction_step_id;
64:
65: DELETE from hr_api_transaction_steps
66: WHERE transaction_step_id = p_transaction_step_id;
67:
68: EXCEPTION
69: ---------

Line 495: l_api_name hr_api_transaction_steps.api_name%TYPE

491: l_transaction_table hr_transaction_ss.transaction_table;
492: l_review_item_name VARCHAR2(50);
493: l_eit_number NUMBER := 0;
494: l_object_version_number NUMBER:=1;
495: l_api_name hr_api_transaction_steps.api_name%TYPE
496: := 'PQP_GENERIC_EIT_SS.PROCESS_API';
497: l_review_proc_call VARCHAR2(30) := 'PqpVehInfoReview';
498: l_get_action VARCHAR2(30);
499: l_extra_info_id NUMBER;

Line 1557: FROM hr_api_transaction_steps hats

1553: l_ignore BOOLEAN;
1554: CURSOR c_get_other_tstep
1555: IS
1556: SELECT hats.item_type,hats.item_key
1557: FROM hr_api_transaction_steps hats
1558: WHERE hats.transaction_step_id =p_transaction_step_id;
1559: l_get_other_tstep c_get_other_tstep%ROWTYPE;
1560: CURSOR c_get_details IS
1561: SELECT pvr.vehicle_repository_id