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 1364: hr_api.set_legislation_context(l_leg_code);

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

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

2143: OPEN c_del_values;
2144: FETCH c_del_values INTO l_del_values;
2145: CLOSE c_del_values;
2146:
2147: DELETE from hr_api_transaction_values
2148: WHERE transaction_step_id = l_del_values.transaction_step_id;
2149: l_transaction_step_id := l_del_values.transaction_step_id;
2150: END IF;
2151:

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

3319: FETCH c_del_values INTO l_del_values;
3320: CLOSE c_del_values;
3321:
3322: hr_utility.set_location('leaving c del value :',20);
3323: DELETE from hr_api_transaction_values
3324: WHERE transaction_step_id = l_del_values.transaction_step_id;
3325: l_transaction_step_id := l_del_values.transaction_step_id;
3326: hr_utility.set_location('leaving delete :',25);
3327: END IF;

Line 3603: FROM hr_api_transaction_values hatv

3599: l_transaction_id NUMBER;
3600: CURSOR c_get_count
3601: IS
3602: SELECT count(hatv.name)
3603: FROM hr_api_transaction_values hatv
3604: WHERE hatv.transaction_step_id=p_transaction_step_id
3605: AND hatv.name like 'P_PERSON_USR_ID%';
3606: --
3607: --

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;