APPS.PQP_SS_VEHICLE_MILEAGE_CLAIMS dependencies on HR_API_TRANSACTION_STEPS

Line 108: UPDATE hr_api_transaction_steps hats

104: UPDATE hr_api_transactions hat
105: SET hat.item_key = itemkey
106: WHERE hat.transaction_id=l_transaction_id;
107:
108: UPDATE hr_api_transaction_steps hats
109: SET hats.item_key = itemkey
110: WHERE hats.transaction_id=l_transaction_id;
111: result :='Y';
112: end;

Line 308: from hr_api_transaction_steps hats

304: l_transaction_id hr_api_transactions.transaction_id%type;
305: -- cursor to select the transaction_id of the step
306: cursor csr_hats is
307: select hats.transaction_id
308: from hr_api_transaction_steps hats
309: where hats.transaction_step_id = p_transaction_step_id;
310: begin
311:
312:

Line 488: FROM hr_api_transaction_steps hats

484:
485: CURSOR c_del_values
486: IS
487: SELECT transaction_step_id
488: FROM hr_api_transaction_steps hats
489: WHERE transaction_id = x_transaction_id;
490:
491: l_del_values c_del_values%ROWTYPE;
492: l_transaction_id NUMBER;

Line 496: l_api_name hr_api_transaction_steps.api_name%TYPE

492: l_transaction_id NUMBER;
493: l_trans_tbl hr_transaction_ss.transaction_table;
494: l_count NUMBER :=0;
495: l_transaction_step_id NUMBER;
496: l_api_name hr_api_transaction_steps.api_name%TYPE
497: := 'PQP_SS_VEHICLE_MILEAGE_CLAIMS.DELETE_PROCESS_API';
498: l_result VARCHAR2(100);
499: l_trns_object_version_number NUMBER;
500: l_review_proc_call VARCHAR2(30);-- := 'PqpVehStatusReview';

Line 677: FROM hr_api_transaction_steps hats

673: IS
674: CURSOR c_del_values
675: IS
676: SELECT transaction_step_id
677: FROM hr_api_transaction_steps hats
678: WHERE transaction_id = x_transaction_id;
679: l_del_values c_del_values%ROWTYPE;
680: l_transaction_id NUMBER;
681: l_trans_tbl hr_transaction_ss.transaction_table;

Line 684: l_api_name hr_api_transaction_steps.api_name%TYPE

680: l_transaction_id NUMBER;
681: l_trans_tbl hr_transaction_ss.transaction_table;
682: l_count NUMBER :=0;
683: l_transaction_step_id NUMBER;
684: l_api_name hr_api_transaction_steps.api_name%TYPE
685: := 'PQP_SS_VEHICLE_MILEAGE_CLAIMS.PROCESS_API';
686: l_result VARCHAR2(100);
687: l_trns_object_version_number NUMBER;
688: l_review_proc_call VARCHAR2(30) := 'PqpMileageClaimReview';