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.PER_OTHERBG_APL_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 11: apl_assignment_id in per_all_assignments_f.assignment_id%type,

7: -- |------------------------< close_application >---------------------------|
8: -- ---------------------------------------------------------------------------
9: --
10: procedure close_application(
11: apl_assignment_id in per_all_assignments_f.assignment_id%type,
12: effective_date date
13: ) is
14: l_proc varchar2(72) := g_package||'close_application';
15:

Line 16: cursor csr_person_id(l_apl_asg_id per_all_assignments_f.assignment_id%type,l_effective_date date) is

12: effective_date date
13: ) is
14: l_proc varchar2(72) := g_package||'close_application';
15:
16: cursor csr_person_id(l_apl_asg_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
17: select papf.person_id,papf.object_version_number,papf.business_group_id,paaf.object_version_number
18: from per_all_people_f papf, per_all_assignments_f paaf
19: where paaf.assignment_id = l_apl_asg_id
20: and l_effective_date between nvl(paaf.effective_start_date,l_effective_date) and nvl(paaf.effective_end_date,l_effective_date)

Line 18: from per_all_people_f papf, per_all_assignments_f paaf

14: l_proc varchar2(72) := g_package||'close_application';
15:
16: cursor csr_person_id(l_apl_asg_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
17: select papf.person_id,papf.object_version_number,papf.business_group_id,paaf.object_version_number
18: from per_all_people_f papf, per_all_assignments_f paaf
19: where paaf.assignment_id = l_apl_asg_id
20: and l_effective_date between nvl(paaf.effective_start_date,l_effective_date) and nvl(paaf.effective_end_date,l_effective_date)
21: and l_effective_date between nvl(papf.effective_start_date,l_effective_date) and nvl(papf.effective_end_date,l_effective_date)
22: and papf.person_id = paaf.person_id;

Line 40: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,

36: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y'
37: and (business_group_id is null or
38: business_group_id = bg_id);
39:
40: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,
41: l_apl_asg_id per_all_assignments_f.assignment_id%type) is
42: select 1
43: from per_all_assignments_f
44: where person_id = l_person_id

Line 41: l_apl_asg_id per_all_assignments_f.assignment_id%type) is

37: and (business_group_id is null or
38: business_group_id = bg_id);
39:
40: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,
41: l_apl_asg_id per_all_assignments_f.assignment_id%type) is
42: select 1
43: from per_all_assignments_f
44: where person_id = l_person_id
45: and l_effective_date +1 between nvl(effective_start_date,l_effective_date)

Line 43: from per_all_assignments_f

39:
40: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,
41: l_apl_asg_id per_all_assignments_f.assignment_id%type) is
42: select 1
43: from per_all_assignments_f
44: where person_id = l_person_id
45: and l_effective_date +1 between nvl(effective_start_date,l_effective_date)
46: and nvl(effective_end_date,l_effective_date)
47: and assignment_id <> l_apl_asg_id

Line 53: from per_all_assignments_f

49:
50: cursor csr_apl_asg_end_date(l_person_id number , l_effective_date date , l_apl_asg_id number)
51: is
52: select max(effective_end_date)
53: from per_all_assignments_f
54: where person_id = l_person_id
55: and assignment_id <> l_apl_asg_id
56: and assignment_type = 'A';
57:

Line 60: l_person_id per_all_assignments_f.person_id%type;

56: and assignment_type = 'A';
57:
58: l_exists varchar2(1);
59: l_asg_max_end_date date;
60: l_person_id per_all_assignments_f.person_id%type;
61: a_object_version_number per_all_assignments_f.object_version_number%TYPE;
62: l_object_version_number per_all_people_f.object_version_number%TYPE;
63: l_business_group_id per_all_people_f.business_group_id%TYPE;
64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;

Line 61: a_object_version_number per_all_assignments_f.object_version_number%TYPE;

57:
58: l_exists varchar2(1);
59: l_asg_max_end_date date;
60: l_person_id per_all_assignments_f.person_id%type;
61: a_object_version_number per_all_assignments_f.object_version_number%TYPE;
62: l_object_version_number per_all_people_f.object_version_number%TYPE;
63: l_business_group_id per_all_people_f.business_group_id%TYPE;
64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;

Line 74: a_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

70: t_effective_start_date per_all_people_f.effective_start_date%TYPE;
71: t_effective_end_date per_all_people_f.effective_end_date%TYPE;
72: t_remove_fut_asg_warning BOOLEAN;
73:
74: a_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
75: a_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
76:
77: begin
78: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 75: a_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

71: t_effective_end_date per_all_people_f.effective_end_date%TYPE;
72: t_remove_fut_asg_warning BOOLEAN;
73:
74: a_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
75: a_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
76:
77: begin
78: hr_utility.set_location('Entering:'|| l_proc, 5);
79:

Line 167: apl_assignment_id in per_all_assignments_f.assignment_id%type,

163: -- |------------------------< close_source_application >---------------------------|
164: -- ---------------------------------------------------------------------------
165: --
166: procedure close_source_application(
167: apl_assignment_id in per_all_assignments_f.assignment_id%type,
168: effective_date date
169: ) is
170: l_proc varchar2(72) := g_package||'close_source_application';
171:

Line 172: cursor csr_irc_asg(l_tgt_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is

168: effective_date date
169: ) is
170: l_proc varchar2(72) := g_package||'close_source_application';
171:
172: cursor csr_irc_asg(l_tgt_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
173: select src_apl_asg_id
174: from per_vac_linked_assignments
175: where tgt_apl_asg_id = l_tgt_assignment_id
176: and l_effective_date between trunc(nvl(start_date,l_effective_date)) and trunc(nvl(end_date,l_effective_date)) ;

Line 178: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;

174: from per_vac_linked_assignments
175: where tgt_apl_asg_id = l_tgt_assignment_id
176: and l_effective_date between trunc(nvl(start_date,l_effective_date)) and trunc(nvl(end_date,l_effective_date)) ;
177:
178: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;
179:
180: begin
181: hr_utility.set_location('Entering:'|| l_proc, 5);
182: open csr_irc_asg(apl_assignment_id,effective_date);

Line 199: apl_assignment_id in per_all_assignments_f.assignment_id%type,

195: -- |------------------------< close_target_applications >---------------------------|
196: -- ---------------------------------------------------------------------------
197: --
198: procedure close_target_applications(
199: apl_assignment_id in per_all_assignments_f.assignment_id%type,
200: effective_date date
201: ) is
202: l_proc varchar2(72) := g_package||'close_target_applications';
203:

Line 204: cursor csr_irc_src_asg(l_src_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is

200: effective_date date
201: ) is
202: l_proc varchar2(72) := g_package||'close_target_applications';
203:
204: cursor csr_irc_src_asg(l_src_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
205: select tgt_apl_asg_id
206: from per_vac_linked_assignments
207: where src_apl_asg_id = l_src_assignment_id
208: and l_effective_date between trunc(nvl(start_date,l_effective_date)) and trunc(nvl(end_date,l_effective_date))

Line 211: l_trg_apl_asg_id per_all_assignments_f.assignment_id%type;

207: where src_apl_asg_id = l_src_assignment_id
208: and l_effective_date between trunc(nvl(start_date,l_effective_date)) and trunc(nvl(end_date,l_effective_date))
209: and tgt_apl_asg_id <> apl_assignment_id;
210:
211: l_trg_apl_asg_id per_all_assignments_f.assignment_id%type;
212:
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 5);
215:

Line 233: apl_assignment_id in per_all_assignments_f.assignment_id%type,

229: -- |------------------------< close_otherbg_applications >---------------------------|
230: -- ---------------------------------------------------------------------------
231: --
232: procedure close_otherbg_applications(
233: apl_assignment_id in per_all_assignments_f.assignment_id%type,
234: effective_date date,
235: close_mode varchar2
236: ) is
237: l_proc varchar2(72) := g_package||'close_otherbg_applications';

Line 264: apl_assignment_id in per_all_assignments_f.assignment_id%type,

260: -- |------------------------< open_source_application >---------------------------|
261: -- ---------------------------------------------------------------------------
262: --
263: procedure open_source_application(
264: apl_assignment_id in per_all_assignments_f.assignment_id%type,
265: effective_date date
266: ) is
267: l_proc varchar2(72) := g_package||'open_source_application';
268:

Line 269: cursor csr_irc_asg(l_tgt_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is

265: effective_date date
266: ) is
267: l_proc varchar2(72) := g_package||'open_source_application';
268:
269: cursor csr_irc_asg(l_tgt_assignment_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
270: select src_apl_asg_id
271: from per_vac_linked_assignments
272: where tgt_apl_asg_id = l_tgt_assignment_id;
273:

Line 274: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;

270: select src_apl_asg_id
271: from per_vac_linked_assignments
272: where tgt_apl_asg_id = l_tgt_assignment_id;
273:
274: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;
275:
276: begin
277: hr_utility.set_location('Entering:'|| l_proc, 5);
278: open csr_irc_asg(apl_assignment_id,effective_date);

Line 295: apl_assignment_id in per_all_assignments_f.assignment_id%type,

291: -- |------------------------< open_otherbg_applications >---------------------------|
292: -- ---------------------------------------------------------------------------
293: --
294: procedure open_otherbg_applications(
295: apl_assignment_id in per_all_assignments_f.assignment_id%type,
296: effective_date date,
297: open_mode varchar2
298: ) is
299: l_proc varchar2(72) := g_package||'open_otherbg_applications';

Line 317: function isMultiRegVac(apl_assignment_id in per_all_assignments_f.assignment_id%type) return boolean

313: -- ---------------------------------------------------------------------------
314: -- |------------------------< isMultiRegVac >---------------------------|
315: -- ---------------------------------------------------------------------------
316: --
317: function isMultiRegVac(apl_assignment_id in per_all_assignments_f.assignment_id%type) return boolean
318: is
319: l_proc varchar2(72) := g_package||'isMultiRegVac';
320: cursor cur_tgt_applications is
321: select SRC_APL_ASG_ID

Line 363: PROCEDURE reverse_terminate(apl_assignment_id in per_all_assignments_f.assignment_id%type,

359:
360: -- we need to pass the source applicant assignment id.. to remove the end date / change the ex applicant to applicant
361: -- comments added
362:
363: PROCEDURE reverse_terminate(apl_assignment_id in per_all_assignments_f.assignment_id%type,
364: effective_date date) IS
365:
366: l_proc varchar2(72) := g_package||'reverse_terminate';
367:

Line 368: cursor person_details(l_apl_assignment_id per_all_assignments_f.assignment_id%type) is

364: effective_date date) IS
365:
366: l_proc varchar2(72) := g_package||'reverse_terminate';
367:
368: cursor person_details(l_apl_assignment_id per_all_assignments_f.assignment_id%type) is
369: select papf.person_id, papf.application_id, papf.business_group_id, papf.effective_end_date
370: from per_all_assignments_f papf
371: where papf.assignment_id = apl_assignment_id;
372: -- and effective_date between nvl(papf.effective_start_date,effective_date) and nvl(papf.effective_end_date,effective_date) ;

Line 370: from per_all_assignments_f papf

366: l_proc varchar2(72) := g_package||'reverse_terminate';
367:
368: cursor person_details(l_apl_assignment_id per_all_assignments_f.assignment_id%type) is
369: select papf.person_id, papf.application_id, papf.business_group_id, papf.effective_end_date
370: from per_all_assignments_f papf
371: where papf.assignment_id = apl_assignment_id;
372: -- and effective_date between nvl(papf.effective_start_date,effective_date) and nvl(papf.effective_end_date,effective_date) ;
373:
374: cursor csr_ptu_row(l_person_id per_all_assignments_f.person_id%type,l_date_received Date) is

Line 374: cursor csr_ptu_row(l_person_id per_all_assignments_f.person_id%type,l_date_received Date) is

370: from per_all_assignments_f papf
371: where papf.assignment_id = apl_assignment_id;
372: -- and effective_date between nvl(papf.effective_start_date,effective_date) and nvl(papf.effective_end_date,effective_date) ;
373:
374: cursor csr_ptu_row(l_person_id per_all_assignments_f.person_id%type,l_date_received Date) is
375: select ptu.effective_start_date
376: from per_person_type_usages_f ptu
377: ,per_person_types ppt
378: where ptu.person_id = l_person_id

Line 386: l_person_id per_all_assignments_f.person_id%type;

382: order by ptu.effective_start_date;
383:
384: l_exists varchar2(1);
385:
386: l_person_id per_all_assignments_f.person_id%type;
387: l_business_group_id per_all_assignments_f.business_group_id%type;
388: l_application_id per_all_assignments_f.application_id %type;
389: l_end_of_time DATE;
390: l_legislation_code per_business_groups.legislation_code%type;

Line 387: l_business_group_id per_all_assignments_f.business_group_id%type;

383:
384: l_exists varchar2(1);
385:
386: l_person_id per_all_assignments_f.person_id%type;
387: l_business_group_id per_all_assignments_f.business_group_id%type;
388: l_application_id per_all_assignments_f.application_id %type;
389: l_end_of_time DATE;
390: l_legislation_code per_business_groups.legislation_code%type;
391: l_date_end per_all_assignments_f.effective_end_date%type;

Line 388: l_application_id per_all_assignments_f.application_id %type;

384: l_exists varchar2(1);
385:
386: l_person_id per_all_assignments_f.person_id%type;
387: l_business_group_id per_all_assignments_f.business_group_id%type;
388: l_application_id per_all_assignments_f.application_id %type;
389: l_end_of_time DATE;
390: l_legislation_code per_business_groups.legislation_code%type;
391: l_date_end per_all_assignments_f.effective_end_date%type;
392: l_date_received Date;

Line 391: l_date_end per_all_assignments_f.effective_end_date%type;

387: l_business_group_id per_all_assignments_f.business_group_id%type;
388: l_application_id per_all_assignments_f.application_id %type;
389: l_end_of_time DATE;
390: l_legislation_code per_business_groups.legislation_code%type;
391: l_date_end per_all_assignments_f.effective_end_date%type;
392: l_date_received Date;
393: l_date_end1 Date;
394: l_new_end_date Date;
395: l_exists_p varchar2(1);

Line 427: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,

423: l_apl_bg_id number;
424: l_asg_end_date date;
425:
426:
427: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,
428: l_apl_asg_id per_all_assignments_f.assignment_id%type,l_apl_bg_id number) is
429: select 1
430: from per_all_assignments_f
431: where person_id = l_person_id

Line 428: l_apl_asg_id per_all_assignments_f.assignment_id%type,l_apl_bg_id number) is

424: l_asg_end_date date;
425:
426:
427: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,
428: l_apl_asg_id per_all_assignments_f.assignment_id%type,l_apl_bg_id number) is
429: select 1
430: from per_all_assignments_f
431: where person_id = l_person_id
432: and l_effective_date + 1 between nvl(effective_start_date,l_effective_date)

Line 430: from per_all_assignments_f

426:
427: cursor csr_apl_assignments(l_person_id per_all_assignments_f.person_id%type,l_effective_date date,
428: l_apl_asg_id per_all_assignments_f.assignment_id%type,l_apl_bg_id number) is
429: select 1
430: from per_all_assignments_f
431: where person_id = l_person_id
432: and l_effective_date + 1 between nvl(effective_start_date,l_effective_date)
433: and nvl(effective_end_date,l_effective_date) -- added 1 to the date for bug#12593632 fix
434: and assignment_id <> l_apl_asg_id

Line 461: from per_all_assignments_f

457: --- Fix For Bug # 12654541 ---
458:
459: -- 12868703
460: select distinct business_group_id into l_apl_bg_id
461: from per_all_assignments_f
462: where assignment_id = apl_assignment_id;
463:
464: select max(effective_end_date) into l_asg_end_date
465: from per_all_assignments_f

Line 465: from per_all_assignments_f

461: from per_all_assignments_f
462: where assignment_id = apl_assignment_id;
463:
464: select max(effective_end_date) into l_asg_end_date
465: from per_all_assignments_f
466: where assignment_id = apl_assignment_id;
467:
468: hr_utility.set_location('l_apl_bg_id :'|| l_apl_bg_id, 5);
469: hr_utility.set_location('l_asg_end_date :'|| l_asg_end_date, 5);

Line 505: from per_all_assignments_f

501: select legislation_code into l_legislation_code
502: from per_business_groups
503: where business_group_id in
504: (select business_group_id
505: from per_all_assignments_f
506: where assignment_id = apl_assignment_id);
507:
508: per_applications_pkg.cancel_chk_current_emp(
509: P_person_id =>l_person_id,

Line 712: update per_all_assignments_f

708: null,
709: null ,
710: l_cost_warning) ;
711:
712: update per_all_assignments_f
713: set effective_end_date = hr_api.g_eot -- to_date('31-Dec-4712','DD-MON-YYYY')
714: where assignment_id = p_assignment_id;
715:
716: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 15 ) ;