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.GHR_SF52_POST_UPDATE dependencies on GHR_PA_REQUESTS

Line 18: p_sf52_data_result in ghr_pa_requests%rowtype,

14: p_object_version_number in out NOCOPY number,
15: p_from_position_id in number default null,
16: p_to_position_id in number default null,
17: p_agency_code in varchar2 default null, -- to_agency_code
18: p_sf52_data_result in ghr_pa_requests%rowtype,
19: p_called_from in varchar2 default null
20: )
21: is
22:

Line 24: l_agency_code ghr_pa_requests.agency_code%type;

20: )
21: is
22:
23: l_proc varchar2(72):= 'Post_sf52_process';
24: l_agency_code ghr_pa_requests.agency_code%type;
25: l_from_agency_code ghr_pa_requests.from_agency_code%type;
26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

Line 25: l_from_agency_code ghr_pa_requests.from_agency_code%type;

21: is
22:
23: l_proc varchar2(72):= 'Post_sf52_process';
24: l_agency_code ghr_pa_requests.agency_code%type;
25: l_from_agency_code ghr_pa_requests.from_agency_code%type;
26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;

Line 26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;

22:
23: l_proc varchar2(72):= 'Post_sf52_process';
24: l_agency_code ghr_pa_requests.agency_code%type;
25: l_from_agency_code ghr_pa_requests.from_agency_code%type;
26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;

Line 27: l_from_symbol ghr_pa_requests.from_office_symbol%type;

23: l_proc varchar2(72):= 'Post_sf52_process';
24: l_agency_code ghr_pa_requests.agency_code%type;
25: l_from_agency_code ghr_pa_requests.from_agency_code%type;
26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

Line 28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

24: l_agency_code ghr_pa_requests.agency_code%type;
25: l_from_agency_code ghr_pa_requests.from_agency_code%type;
26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
32: l_object_version_number ghr_pa_requests.object_version_number%type;

Line 29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;

25: l_from_agency_code ghr_pa_requests.from_agency_code%type;
26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
32: l_object_version_number ghr_pa_requests.object_version_number%type;
33:

Line 30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;

26: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
32: l_object_version_number ghr_pa_requests.object_version_number%type;
33:
34: Cursor C_Sel1 is

Line 31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

27: l_from_symbol ghr_pa_requests.from_office_symbol%type;
28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
32: l_object_version_number ghr_pa_requests.object_version_number%type;
33:
34: Cursor C_Sel1 is
35: select ghr_pa_notifications_s.nextval from sys.dual;

Line 32: l_object_version_number ghr_pa_requests.object_version_number%type;

28: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
29: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
30: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
31: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
32: l_object_version_number ghr_pa_requests.object_version_number%type;
33:
34: Cursor C_Sel1 is
35: select ghr_pa_notifications_s.nextval from sys.dual;
36:

Line 45: -- Just get the notification_id and update ghr_pa_requests

41: l_object_version_number := p_object_version_number;
42:
43: hr_utility.set_location(l_proc ,10);
44:
45: -- Just get the notification_id and update ghr_pa_requests
46: --
47: open C_Sel1;
48: Fetch C_Sel1 Into l_pa_notification_id;
49: Close C_Sel1;

Line 133: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'UPDATE_HR_COMPLETE'

129: hr_utility.set_location(l_proc ,20);
130:
131: --
132: --
133: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'UPDATE_HR_COMPLETE'
134: --
135: hr_utility.set_location(l_proc,40);
136:
137: ghr_sf52_api.end_sf52

Line 170: l_agency_code ghr_pa_requests.agency_code%type;

166: )
167: is
168:
169: l_proc varchar2(72):= 'Post_sf52_cancel';
170: l_agency_code ghr_pa_requests.agency_code%type;
171: l_from_agency_code ghr_pa_requests.from_agency_code%type;
172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

Line 171: l_from_agency_code ghr_pa_requests.from_agency_code%type;

167: is
168:
169: l_proc varchar2(72):= 'Post_sf52_cancel';
170: l_agency_code ghr_pa_requests.agency_code%type;
171: l_from_agency_code ghr_pa_requests.from_agency_code%type;
172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;

Line 172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;

168:
169: l_proc varchar2(72):= 'Post_sf52_cancel';
170: l_agency_code ghr_pa_requests.agency_code%type;
171: l_from_agency_code ghr_pa_requests.from_agency_code%type;
172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;

Line 173: l_from_symbol ghr_pa_requests.from_office_symbol%type;

169: l_proc varchar2(72):= 'Post_sf52_cancel';
170: l_agency_code ghr_pa_requests.agency_code%type;
171: l_from_agency_code ghr_pa_requests.from_agency_code%type;
172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

Line 174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

170: l_agency_code ghr_pa_requests.agency_code%type;
171: l_from_agency_code ghr_pa_requests.from_agency_code%type;
172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
178: l_object_version_number ghr_pa_requests.object_version_number%type;

Line 175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;

171: l_from_agency_code ghr_pa_requests.from_agency_code%type;
172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
178: l_object_version_number ghr_pa_requests.object_version_number%type;
179: l_assignment_id ghr_pa_requests.employee_assignment_id%type;

Line 176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;

172: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;
173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
178: l_object_version_number ghr_pa_requests.object_version_number%type;
179: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
180: l_person_id ghr_pa_requests.person_id%type;

Line 177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

173: l_from_symbol ghr_pa_requests.from_office_symbol%type;
174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
178: l_object_version_number ghr_pa_requests.object_version_number%type;
179: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
180: l_person_id ghr_pa_requests.person_id%type;
181: l_exists boolean;

Line 178: l_object_version_number ghr_pa_requests.object_version_number%type;

174: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
178: l_object_version_number ghr_pa_requests.object_version_number%type;
179: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
180: l_person_id ghr_pa_requests.person_id%type;
181: l_exists boolean;
182:

Line 179: l_assignment_id ghr_pa_requests.employee_assignment_id%type;

175: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;
176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
178: l_object_version_number ghr_pa_requests.object_version_number%type;
179: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
180: l_person_id ghr_pa_requests.person_id%type;
181: l_exists boolean;
182:
183: Cursor C_Sel1 is

Line 180: l_person_id ghr_pa_requests.person_id%type;

176: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;
177: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
178: l_object_version_number ghr_pa_requests.object_version_number%type;
179: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
180: l_person_id ghr_pa_requests.person_id%type;
181: l_exists boolean;
182:
183: Cursor C_Sel1 is
184: select ghr_pa_notifications_s.nextval from sys.dual;

Line 189: from ghr_pa_requests par

185:
186: Cursor C_person is
187: select par.person_id,
188: par.employee_assignment_id
189: from ghr_pa_requests par
190: where par.pa_request_id = p_pa_request_id;
191:
192:
193: Cursor C_asg_posn is

Line 232: -- Update ghr_pa_requests with Notification Details

228: End if;
229: End if;
230:
231:
232: -- Update ghr_pa_requests with Notification Details
233:
234: open C_Sel1;
235: Fetch C_Sel1 Into l_pa_notification_id;
236: Close C_Sel1;

Line 246: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'CANCELED'

242: hr_utility.set_location(l_proc ,20);
243:
244:
245: --
246: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'CANCELED'
247: --
248: hr_utility.set_location(l_proc,40);
249:
250: ghr_sf52_api.end_sf52

Line 273: -- the approver's work title will already be available in the ghr_pa_requests table

269: -- ----------------------------------------------------------------------------
270: -- |--------------------------< post_sf52_future >--------------------------|
271: -- ----------------------------------------------------------------------------
272: -- With the new enhancement to support elec. authentication, the approval date and
273: -- the approver's work title will already be available in the ghr_pa_requests table
274: -- and hence nothing needs to be done in this procedure.
275: --But leaving it as it is, so that , if later we identify any special routines to be
276: -- performed as a part of FUTURE actions, can be included here.
277:

Line 318: l_from_agency_code ghr_pa_requests.from_agency_code%type;

314: is
315:
316: l_proc varchar2(72):= 'get_other_data';
317: l_bus_gp per_people_f.business_group_id%type;
318: l_from_agency_code ghr_pa_requests.from_agency_code%type;
319: l_agency_code ghr_pa_requests.agency_code%type;
320: l_appr_person_id per_people_f.person_id%type;
321: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
322: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;

Line 319: l_agency_code ghr_pa_requests.agency_code%type;

315:
316: l_proc varchar2(72):= 'get_other_data';
317: l_bus_gp per_people_f.business_group_id%type;
318: l_from_agency_code ghr_pa_requests.from_agency_code%type;
319: l_agency_code ghr_pa_requests.agency_code%type;
320: l_appr_person_id per_people_f.person_id%type;
321: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
322: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
323: l_noa_code ghr_pa_requests.first_noa_code%type;

Line 321: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

317: l_bus_gp per_people_f.business_group_id%type;
318: l_from_agency_code ghr_pa_requests.from_agency_code%type;
319: l_agency_code ghr_pa_requests.agency_code%type;
320: l_appr_person_id per_people_f.person_id%type;
321: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
322: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
323: l_noa_code ghr_pa_requests.first_noa_code%type;
324: l_pos_ei_data per_position_extra_info%rowtype;
325: -- Bug#4005843

Line 322: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;

318: l_from_agency_code ghr_pa_requests.from_agency_code%type;
319: l_agency_code ghr_pa_requests.agency_code%type;
320: l_appr_person_id per_people_f.person_id%type;
321: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
322: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
323: l_noa_code ghr_pa_requests.first_noa_code%type;
324: l_pos_ei_data per_position_extra_info%rowtype;
325: -- Bug#4005843
326: l_effective_date date;

Line 323: l_noa_code ghr_pa_requests.first_noa_code%type;

319: l_agency_code ghr_pa_requests.agency_code%type;
320: l_appr_person_id per_people_f.person_id%type;
321: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
322: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
323: l_noa_code ghr_pa_requests.first_noa_code%type;
324: l_pos_ei_data per_position_extra_info%rowtype;
325: -- Bug#4005843
326: l_effective_date date;
327:

Line 340: from ghr_pa_requests par

336: cursor c_orig_par is
337: select par.noa_family_code,
338: par.altered_pa_request_id,
339: par.second_noa_code -- Bug 3451929
340: from ghr_pa_requests par
341: where par.pa_request_id = p_pa_request_id;
342:
343: cursor c_par is
344: select par.noa_family_code,

Line 347: from ghr_pa_requests par

343: cursor c_par is
344: select par.noa_family_code,
345: par.first_noa_code,
346: par.second_noa_code
347: from ghr_pa_requests par
348: where par.pa_request_id = p_pa_request_id;
349:
350: cursor c_par_ei(p_information_type varchar2) is
351: select parei.rei_information4,

Line 367: from ghr_pa_requests par

363: par.employee_dept_or_agency,
364: par.from_office_symbol,
365: par.to_office_symbol,
366: par.personnel_office_id
367: from ghr_pa_requests par
368: where par.pa_request_id = l_altered_pa_request_id;
369:
370: BEGIN
371: hr_utility.set_location('Entering:'||l_proc, 5);