eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on HR_API

Line 106: l_transaction_id hr_api_transactions.transaction_id%type;

102: -- --------------------------------------------------------------------------
103: -- declare local variables
104: -- --------------------------------------------------------------------------
105: l_proc varchar2(72);
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

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 279: UPDATE hr_api_transactions hat

275: itemkey =>itemkey,
276: aname =>'HR_RUNTIME_APPROVAL_REQ_FLAG',
277: avalue =>'YES');
278:
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

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 362: hr_api_transaction_values a,

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,
366: hr_api_transaction_values c

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 364: hr_api_transaction_values b,

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
368: AND s1.transaction_step_id = b.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 366: hr_api_transaction_values c

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
370: AND s.transaction_step_id = p_transaction_step_id

Line 1363: hr_api.set_legislation_context(l_leg_code);

1359: --Getting the legislationId for business groupId
1360: l_leg_code :=
1361: pqp_vre_bus.get_legislation_code(p_business_group_id);
1362: --setting the lg context
1363: hr_api.set_legislation_context(l_leg_code);
1364:
1365: OPEN c_fiscal_uom;
1366: FETCH c_fiscal_uom INTO l_lookup_code;
1367: CLOSE c_fiscal_uom;

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 2134: DELETE from hr_api_transaction_values

2130: OPEN c_del_values;
2131: FETCH c_del_values INTO l_del_values;
2132: CLOSE c_del_values;
2133:
2134: DELETE from hr_api_transaction_values
2135: WHERE transaction_step_id = l_del_values.transaction_step_id;
2136: l_transaction_step_id := l_del_values.transaction_step_id;
2137: END IF;
2138:

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 3298: DELETE from hr_api_transaction_values

3294: FETCH c_del_values INTO l_del_values;
3295: CLOSE c_del_values;
3296:
3297: hr_utility.set_location('leaving c del value :',20);
3298: DELETE from hr_api_transaction_values
3299: WHERE transaction_step_id = l_del_values.transaction_step_id;
3300: l_transaction_step_id := l_del_values.transaction_step_id;
3301: hr_utility.set_location('leaving delete :',25);
3302: END IF;

Line 3578: FROM hr_api_transaction_values hatv

3574: l_transaction_id NUMBER;
3575: CURSOR c_get_count
3576: IS
3577: SELECT count(hatv.name)
3578: FROM hr_api_transaction_values hatv
3579: WHERE hatv.transaction_step_id=p_transaction_step_id
3580: AND hatv.name like 'P_PERSON_USR_ID%';
3581: --
3582: --

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;