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 130: -- Update status of ghr_pa_requests (in pa_routing_history - Action Taken is set to 'UPDATE_HR_COMPLETE'

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

Line 167: l_agency_code ghr_pa_requests.agency_code%type;

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

Line 168: l_from_agency_code ghr_pa_requests.from_agency_code%type;

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

Line 169: l_from_agency_desc ghr_pa_requests.from_agency_desc%type;

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

Line 170: l_from_symbol ghr_pa_requests.from_office_symbol%type;

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

Line 171: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

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

Line 172: l_employee_dept_or_agency ghr_pa_requests.employee_dept_or_agency%type;

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

Line 173: l_to_office_symbol ghr_pa_requests.to_office_symbol%type;

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

Line 174: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

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

Line 175: l_object_version_number ghr_pa_requests.object_version_number%type;

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

Line 176: l_assignment_id ghr_pa_requests.employee_assignment_id%type;

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

Line 177: l_person_id ghr_pa_requests.person_id%type;

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

Line 186: from ghr_pa_requests par

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

Line 229: -- Update ghr_pa_requests with Notification Details

225: End if;
226: End if;
227:
228:
229: -- Update ghr_pa_requests with Notification Details
230:
231: open C_Sel1;
232: Fetch C_Sel1 Into l_pa_notification_id;
233: Close C_Sel1;

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

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

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

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

Line 315: l_from_agency_code ghr_pa_requests.from_agency_code%type;

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

Line 316: l_agency_code ghr_pa_requests.agency_code%type;

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

Line 318: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

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

Line 319: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;

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

Line 320: l_noa_code ghr_pa_requests.first_noa_code%type;

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

Line 337: from ghr_pa_requests par

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

Line 344: from ghr_pa_requests par

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

Line 364: from ghr_pa_requests par

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