APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on HR_API_TRANSACTION_STEPS

Line 110: from hr_api_transaction_steps hats

106: l_transaction_id hr_api_transactions.transaction_id%type;
107: -- cursor to select the transaction_id of the step
108: cursor csr_hats is
109: select hats.transaction_id
110: from hr_api_transaction_steps hats
111: where hats.transaction_step_id = p_transaction_step_id;
112: begin
113:
114:

Line 283: UPDATE hr_api_transaction_steps hats

279: UPDATE hr_api_transactions hat
280: set hat.item_key = itemkey
281: WHERE hat.transaction_id=l_transaction_id;
282:
283: UPDATE hr_api_transaction_steps hats
284: set hats.item_key = itemkey
285: WHERE hats.transaction_id=l_transaction_id;
286: result :='Y';
287: end;

Line 361: FROM hr_api_transaction_steps s,

357: OPEN csr FOR
358: SELECT DISTINCT (a.number_value) person_usr_id
359: , b.number_value assignment_usr_id
360: , c.varchar2_value usr_type
361: FROM hr_api_transaction_steps s,
362: hr_api_transaction_values a,
363: hr_api_transaction_steps s1,
364: hr_api_transaction_values b,
365: hr_api_transaction_steps s2,

Line 363: hr_api_transaction_steps s1,

359: , b.number_value assignment_usr_id
360: , c.varchar2_value usr_type
361: FROM hr_api_transaction_steps s,
362: hr_api_transaction_values a,
363: hr_api_transaction_steps s1,
364: hr_api_transaction_values b,
365: hr_api_transaction_steps s2,
366: hr_api_transaction_values c
367: WHERE s.transaction_step_id = a.transaction_step_id

Line 365: hr_api_transaction_steps s2,

361: FROM hr_api_transaction_steps s,
362: hr_api_transaction_values a,
363: hr_api_transaction_steps s1,
364: hr_api_transaction_values b,
365: hr_api_transaction_steps s2,
366: hr_api_transaction_values c
367: WHERE s.transaction_step_id = a.transaction_step_id
368: AND s1.transaction_step_id = b.transaction_step_id
369: AND s2.transaction_step_id = c.transaction_step_id

Line 2027: FROM hr_api_transaction_steps hats

2023:
2024: CURSOR c_del_values
2025: IS
2026: SELECT transaction_step_id
2027: FROM hr_api_transaction_steps hats
2028: WHERE transaction_id = x_transaction_id;
2029:
2030: l_del_values c_del_values%ROWTYPE;
2031: l_transaction_id NUMBER;

Line 2035: l_api_name hr_api_transaction_steps.api_name%TYPE

2031: l_transaction_id NUMBER;
2032: l_trans_tbl hr_transaction_ss.transaction_table;
2033: l_count NUMBER :=0;
2034: l_transaction_step_id NUMBER;
2035: l_api_name hr_api_transaction_steps.api_name%TYPE
2036: := 'PQP_SS_VEHICLE_TRANSACTIONS.DELETE_PROCESS_API';
2037: l_result VARCHAR2(100);
2038: l_trns_object_version_number NUMBER;
2039: l_review_proc_call VARCHAR2(30) := 'PqpVehDelReview';

Line 2327: FROM hr_api_transaction_steps hats

2323: IS
2324: CURSOR c_del_values
2325: IS
2326: SELECT transaction_step_id
2327: FROM hr_api_transaction_steps hats
2328: WHERE transaction_id = x_transaction_id;
2329:
2330: l_del_values c_del_values%ROWTYPE;
2331: l_transaction_id NUMBER;

Line 2335: l_api_name hr_api_transaction_steps.api_name%TYPE

2331: l_transaction_id NUMBER;
2332: l_trans_tbl hr_transaction_ss.transaction_table;
2333: l_count NUMBER :=0;
2334: l_transaction_step_id NUMBER;
2335: l_api_name hr_api_transaction_steps.api_name%TYPE
2336: := 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API';
2337: l_result VARCHAR2(100);
2338: l_trns_object_version_number number;
2339: l_review_proc_call VARCHAR2(30) := 'PqpVehInfoReview';

Line 3614: FROM hr_api_transaction_steps hats

3610: p_user_info t_user_info;
3611: CURSOR c_get_other_tstep
3612: IS
3613: SELECT hats.item_type,hats.item_key
3614: FROM hr_api_transaction_steps hats
3615: WHERE hats.transaction_id=l_transaction_id
3616: AND hats.transaction_step_id =p_transaction_step_id;
3617:
3618: l_get_other_tstep c_get_other_tstep%ROWTYPE;