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.PQH_PROCESS_EMP_REVIEW dependencies on HR_TRANSACTION_API

Line 28: SELECT hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EVENT_ID'||x_row) event_id,

24: reviewer.comments,
25: reviewer.status,
26: reviewer.business_group_id
27: FROM (
28: SELECT hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EVENT_ID'||x_row) event_id,
29: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BOOKING_ID'||x_row) booking_id,
30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,
31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,
32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,

Line 29: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BOOKING_ID'||x_row) booking_id,

25: reviewer.status,
26: reviewer.business_group_id
27: FROM (
28: SELECT hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EVENT_ID'||x_row) event_id,
29: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BOOKING_ID'||x_row) booking_id,
30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,
31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,
32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,
33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,

Line 30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,

26: reviewer.business_group_id
27: FROM (
28: SELECT hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EVENT_ID'||x_row) event_id,
29: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BOOKING_ID'||x_row) booking_id,
30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,
31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,
32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,
33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,
34: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BUSINESS_GROUP_ID'||x_row) business_group_id

Line 31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,

27: FROM (
28: SELECT hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EVENT_ID'||x_row) event_id,
29: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BOOKING_ID'||x_row) booking_id,
30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,
31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,
32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,
33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,
34: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BUSINESS_GROUP_ID'||x_row) business_group_id
35: FROM ( select substr(abc.name,14) x_row

Line 32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,

28: SELECT hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EVENT_ID'||x_row) event_id,
29: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BOOKING_ID'||x_row) booking_id,
30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,
31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,
32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,
33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,
34: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BUSINESS_GROUP_ID'||x_row) business_group_id
35: FROM ( select substr(abc.name,14) x_row
36: from hr_api_transaction_values abc

Line 33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,

29: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BOOKING_ID'||x_row) booking_id,
30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,
31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,
32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,
33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,
34: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BUSINESS_GROUP_ID'||x_row) business_group_id
35: FROM ( select substr(abc.name,14) x_row
36: from hr_api_transaction_values abc
37: where abc.transaction_step_id = p_transaction_step_id

Line 34: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BUSINESS_GROUP_ID'||x_row) business_group_id

30: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_EMPLOYEE_NO'||x_row) employee_no,
31: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_PERSON_ID'||x_row) person_id,
32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,
33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,
34: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BUSINESS_GROUP_ID'||x_row) business_group_id
35: FROM ( select substr(abc.name,14) x_row
36: from hr_api_transaction_values abc
37: where abc.transaction_step_id = p_transaction_step_id
38: and abc.name like 'P_EMPLOYEE_NO%'

Line 181: x_event_Id := hr_transaction_api.get_varchar2_value

177: return;
178: end if;
179: --
180:
181: x_event_Id := hr_transaction_api.get_varchar2_value
182: (p_transaction_step_id => l_transaction_step_id,
183: p_name => 'P_EVENT_ID');
184:
185: x_Assignment_Id := hr_transaction_api.get_varchar2_value

Line 185: x_Assignment_Id := hr_transaction_api.get_varchar2_value

181: x_event_Id := hr_transaction_api.get_varchar2_value
182: (p_transaction_step_id => l_transaction_step_id,
183: p_name => 'P_EVENT_ID');
184:
185: x_Assignment_Id := hr_transaction_api.get_varchar2_value
186: (p_transaction_step_id => l_transaction_step_id,
187: p_name => 'P_ASSIGNMENT_ID');
188:
189: x_Type := hr_transaction_api.get_varchar2_value

Line 189: x_Type := hr_transaction_api.get_varchar2_value

185: x_Assignment_Id := hr_transaction_api.get_varchar2_value
186: (p_transaction_step_id => l_transaction_step_id,
187: p_name => 'P_ASSIGNMENT_ID');
188:
189: x_Type := hr_transaction_api.get_varchar2_value
190: (p_transaction_step_id => l_transaction_step_id,
191: p_name => 'P_TYPE');
192:
193:

Line 196: x_Date_Start := hr_transaction_api.get_varchar2_value

192:
193:
194:
195:
196: x_Date_Start := hr_transaction_api.get_varchar2_value
197: (p_transaction_step_id => l_transaction_step_id,
198: p_name => 'P_DATE_START');
199:
200: x_Date_End :=hr_transaction_api.get_varchar2_value

Line 200: x_Date_End :=hr_transaction_api.get_varchar2_value

196: x_Date_Start := hr_transaction_api.get_varchar2_value
197: (p_transaction_step_id => l_transaction_step_id,
198: p_name => 'P_DATE_START');
199:
200: x_Date_End :=hr_transaction_api.get_varchar2_value
201: (p_transaction_step_id => l_transaction_step_id,
202: p_name => 'P_DATE_END');
203:
204: x_Time_Start :=hr_transaction_api.get_varchar2_value

Line 204: x_Time_Start :=hr_transaction_api.get_varchar2_value

200: x_Date_End :=hr_transaction_api.get_varchar2_value
201: (p_transaction_step_id => l_transaction_step_id,
202: p_name => 'P_DATE_END');
203:
204: x_Time_Start :=hr_transaction_api.get_varchar2_value
205: (p_transaction_step_id => l_transaction_step_id,
206: p_name => 'P_TIME_START');
207:
208: x_Time_End := hr_transaction_api.get_varchar2_value

Line 208: x_Time_End := hr_transaction_api.get_varchar2_value

204: x_Time_Start :=hr_transaction_api.get_varchar2_value
205: (p_transaction_step_id => l_transaction_step_id,
206: p_name => 'P_TIME_START');
207:
208: x_Time_End := hr_transaction_api.get_varchar2_value
209: (p_transaction_step_id => l_transaction_step_id,
210: p_name => 'P_TIME_END');
211:
212:

Line 214: x_Location_id := hr_transaction_api.get_varchar2_value

210: p_name => 'P_TIME_END');
211:
212:
213:
214: x_Location_id := hr_transaction_api.get_varchar2_value
215: (p_transaction_step_id => l_transaction_step_id,
216: p_name => 'P_LOCATION_ID');
217:
218: x_Comments := hr_transaction_api.get_varchar2_value

Line 218: x_Comments := hr_transaction_api.get_varchar2_value

214: x_Location_id := hr_transaction_api.get_varchar2_value
215: (p_transaction_step_id => l_transaction_step_id,
216: p_name => 'P_LOCATION_ID');
217:
218: x_Comments := hr_transaction_api.get_varchar2_value
219: (p_transaction_step_id => l_transaction_step_id,
220: p_name => 'P_COMMENTS');
221:
222: x_Business_Group_Id := hr_transaction_api.get_varchar2_value

Line 222: x_Business_Group_Id := hr_transaction_api.get_varchar2_value

218: x_Comments := hr_transaction_api.get_varchar2_value
219: (p_transaction_step_id => l_transaction_step_id,
220: p_name => 'P_COMMENTS');
221:
222: x_Business_Group_Id := hr_transaction_api.get_varchar2_value
223: (p_transaction_step_id => l_transaction_step_id,
224: p_name => 'P_BUSINESS_GROUP_ID' );
225:
226:

Line 228: x_notify_flag := hr_transaction_api.get_varchar2_value

224: p_name => 'P_BUSINESS_GROUP_ID' );
225:
226:
227:
228: x_notify_flag := hr_transaction_api.get_varchar2_value
229: (p_transaction_step_id => l_transaction_step_id,
230: p_name => 'P_NOTIFY_FLAG');
231:
232: /* x_person_id := hr_transaction_api.get_number_value

Line 232: /* x_person_id := hr_transaction_api.get_number_value

228: x_notify_flag := hr_transaction_api.get_varchar2_value
229: (p_transaction_step_id => l_transaction_step_id,
230: p_name => 'P_NOTIFY_FLAG');
231:
232: /* x_person_id := hr_transaction_api.get_number_value
233: (p_transaction_step_id => l_transaction_step_id,
234: p_name => 'P_PERSON_ID' );
235:
236: */

Line 336: x_Event_Id := hr_transaction_api.get_varchar2_value

332: end if;
333: --
334:
335:
336: x_Event_Id := hr_transaction_api.get_varchar2_value
337: (p_transaction_step_id => l_transaction_step_id,
338: p_name => 'P_EVENT_ID'||x_row_number);
339:
340:

Line 341: x_Booking_Id := hr_transaction_api.get_varchar2_value

337: (p_transaction_step_id => l_transaction_step_id,
338: p_name => 'P_EVENT_ID'||x_row_number);
339:
340:
341: x_Booking_Id := hr_transaction_api.get_varchar2_value
342: (p_transaction_step_id => l_transaction_step_id,
343: p_name => 'P_BOOKING_ID'||x_row_number );
344:
345:

Line 346: x_Employee_no := hr_transaction_api.get_varchar2_value

342: (p_transaction_step_id => l_transaction_step_id,
343: p_name => 'P_BOOKING_ID'||x_row_number );
344:
345:
346: x_Employee_no := hr_transaction_api.get_varchar2_value
347: (p_transaction_step_id => l_transaction_step_id,
348: p_name => 'P_EMPLOYEE_NO'||x_row_number );
349:
350: x_Comments := hr_transaction_api.get_varchar2_value

Line 350: x_Comments := hr_transaction_api.get_varchar2_value

346: x_Employee_no := hr_transaction_api.get_varchar2_value
347: (p_transaction_step_id => l_transaction_step_id,
348: p_name => 'P_EMPLOYEE_NO'||x_row_number );
349:
350: x_Comments := hr_transaction_api.get_varchar2_value
351: (p_transaction_step_id => l_transaction_step_id,
352: p_name => 'P_COMMENTS'||x_row_number );
353:
354:

Line 355: x_Business_Group_Id := hr_transaction_api.get_varchar2_value

351: (p_transaction_step_id => l_transaction_step_id,
352: p_name => 'P_COMMENTS'||x_row_number );
353:
354:
355: x_Business_Group_Id := hr_transaction_api.get_varchar2_value
356: (p_transaction_step_id => l_transaction_step_id,
357: p_name => 'P_BUSINESS_GROUP_ID'||x_row_number );
358:
359: x_status := hr_transaction_api.get_varchar2_value

Line 359: x_status := hr_transaction_api.get_varchar2_value

355: x_Business_Group_Id := hr_transaction_api.get_varchar2_value
356: (p_transaction_step_id => l_transaction_step_id,
357: p_name => 'P_BUSINESS_GROUP_ID'||x_row_number );
358:
359: x_status := hr_transaction_api.get_varchar2_value
360: (p_transaction_step_id => l_transaction_step_id,
361: p_name => 'P_STATUS'||x_row_number );
362:
363: x_person_id := hr_transaction_api.get_varchar2_value

Line 363: x_person_id := hr_transaction_api.get_varchar2_value

359: x_status := hr_transaction_api.get_varchar2_value
360: (p_transaction_step_id => l_transaction_step_id,
361: p_name => 'P_STATUS'||x_row_number );
362:
363: x_person_id := hr_transaction_api.get_varchar2_value
364: (p_transaction_step_id => l_transaction_step_id,
365: p_name => 'P_PERSON_ID'||x_row_number );
366:
367:

Line 424: hr_transaction_api.get_transaction_step_info

420: l_effective_date := SYSDATE;
421: --
422:
423:
424: hr_transaction_api.get_transaction_step_info
425: (p_item_type => x_item_type
426: ,p_item_key => x_item_key
427: ,p_activity_id => x_activity_id
428: ,p_transaction_step_id => l_transaction_step_id

Line 570: hr_transaction_api.get_transaction_step_info

566: l_review_proc_call := 'PqhEmployeeReview';
567: l_effective_date := SYSDATE;
568:
569:
570: hr_transaction_api.get_transaction_step_info
571: (p_item_type => x_item_type
572: ,p_item_key => x_item_key
573: ,p_activity_id => x_activity_id
574: ,p_transaction_step_id => l_transaction_step_id

Line 776: l_person_id := hr_transaction_api.get_varchar2_value (

772: l_time_end, l_location_id, l_location_code, l_comments, l_Assignment_Id,
773: l_notify_flag, l_business_group_id;
774: close empReviewCsr;
775: --
776: l_person_id := hr_transaction_api.get_varchar2_value (
777: p_transaction_step_id => p_transaction_step_id,
778: p_name => 'P_PERSON_ID');
779:
780: wf_directory.GetUserName