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 2014: FROM hr_api_transaction_steps hats

2010:
2011: CURSOR c_del_values
2012: IS
2013: SELECT transaction_step_id
2014: FROM hr_api_transaction_steps hats
2015: WHERE transaction_id = x_transaction_id;
2016:
2017: l_del_values c_del_values%ROWTYPE;
2018: l_transaction_id NUMBER;

Line 2022: l_api_name hr_api_transaction_steps.api_name%TYPE

2018: l_transaction_id NUMBER;
2019: l_trans_tbl hr_transaction_ss.transaction_table;
2020: l_count NUMBER :=0;
2021: l_transaction_step_id NUMBER;
2022: l_api_name hr_api_transaction_steps.api_name%TYPE
2023: := 'PQP_SS_VEHICLE_TRANSACTIONS.DELETE_PROCESS_API';
2024: l_result VARCHAR2(100);
2025: l_trns_object_version_number NUMBER;
2026: l_review_proc_call VARCHAR2(30) := 'PqpVehDelReview';

Line 2314: FROM hr_api_transaction_steps hats

2310: IS
2311: CURSOR c_del_values
2312: IS
2313: SELECT transaction_step_id
2314: FROM hr_api_transaction_steps hats
2315: WHERE transaction_id = x_transaction_id;
2316:
2317: l_del_values c_del_values%ROWTYPE;
2318: l_transaction_id NUMBER;

Line 2322: l_api_name hr_api_transaction_steps.api_name%TYPE

2318: l_transaction_id NUMBER;
2319: l_trans_tbl hr_transaction_ss.transaction_table;
2320: l_count NUMBER :=0;
2321: l_transaction_step_id NUMBER;
2322: l_api_name hr_api_transaction_steps.api_name%TYPE
2323: := 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API';
2324: l_result VARCHAR2(100);
2325: l_trns_object_version_number number;
2326: l_review_proc_call VARCHAR2(30) := 'PqpVehInfoReview';

Line 3589: FROM hr_api_transaction_steps hats

3585: p_user_info t_user_info;
3586: CURSOR c_get_other_tstep
3587: IS
3588: SELECT hats.item_type,hats.item_key
3589: FROM hr_api_transaction_steps hats
3590: WHERE hats.transaction_id=l_transaction_id
3591: AND hats.transaction_step_id =p_transaction_step_id;
3592:
3593: l_get_other_tstep c_get_other_tstep%ROWTYPE;