APPS.PER_APP_ASG_PKG dependencies on PER_ASSIGNMENTS_F

Line 20: update per_assignments_f a

16: --
17: begin
18: --
19: hr_utility.set_location ( 'PER_APP_ASG_PKG.set_end_date' , 5) ;
20: update per_assignments_f a
21: set a.effective_end_date = p_new_end_date
22: where a.assignment_id = p_assignment_id
23: and a.effective_end_date = (
24: select max(a2.effective_end_date)

Line 25: from per_assignments_f a2

21: set a.effective_end_date = p_new_end_date
22: where a.assignment_id = p_assignment_id
23: and a.effective_end_date = (
24: select max(a2.effective_end_date)
25: from per_assignments_f a2
26: where a2.assignment_id = a.assignment_id);
27: --
28: hr_utility.set_location ( 'PER_APP_ASG_PKG.set_end_date' , 10) ;
29: --

Line 103: from per_assignments_f a

99: where r2.letter_request_id = p.letter_request_id
100: and r2.request_status = 'PENDING')
101: and not exists
102: (select null
103: from per_assignments_f a
104: where assignment_id = p_assignment_id
105: and ( (a.effective_start_date = p.date_from
106: and
107: a.assignment_status_type_id = p.assignment_status_type_id)

Line 110: from per_assignments_f a2

106: and
107: a.assignment_status_type_id = p.assignment_status_type_id)
108: or (a.effective_end_date =
109: (select max(a2.effective_end_date)
110: from per_assignments_f a2
111: where a2.assignment_id = p_assignment_id)
112: and a.effective_end_date = p.date_from ))) ;
113: --
114: hr_utility.set_location ( 'PER_APP_ASG_PKG.cleanup_letters' , 10) ;

Line 210: from per_assignments_f

206: select per_assignments_s.nextval
207: from sys.dual;
208: cursor c2 is
209: select rowid
210: from per_assignments_f
211: where assignment_id = P_ASSIGNMENT_ID
212: and effective_start_date = P_EFFECTIVE_START_DATE
213: and effective_end_date = P_EFFECTIVE_END_DATE;
214: --

Line 248: insert into per_assignments_f (

244: --
245: --
246: begin
247: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 4 ) ;
248: insert into per_assignments_f (
249: assignment_id,
250: effective_start_date,
251: effective_end_date,
252: business_group_id,

Line 645: delete from per_assignments_f a

641: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 5 ) ;
642: delete_child ( p_assignment_id
643: ,p_delete_mode);
644:
645: delete from per_assignments_f a
646: where a.rowid = chartorowid(P_ROW_ID);
647: --
648: --- Fix For Bug # 9183199 ---
649: open csr_asg_data;

Line 796: from per_assignments_f a

792: p_supervisor_assignment_id number ) is
793:
794: cursor ASS_CUR is
795: select *
796: from per_assignments_f a
797: where a.rowid = chartorowid(P_ROW_ID)
798: FOR UPDATE OF ASSIGNMENT_ID NOWAIT;
799: --
800: ass_rec ASS_CUR%rowtype;

Line 1238: from per_assignments_f a

1234:
1235: -- Start changes for bug 13059935
1236: cursor ASS_CUR is
1237: select *
1238: from per_assignments_f a
1239: where a.rowid = chartorowid(P_ROW_ID);
1240: --
1241: ass_rec ASS_CUR%rowtype;
1242: -- End changes for bug 13059935

Line 1259: from per_assignments_f where rowid = chartorowid(P_ROW_ID);

1255: */
1256: --
1257: select assignment_status_type_id, vacancy_id
1258: into l_previous_asg_status, l_previous_vacancy_id
1259: from per_assignments_f where rowid = chartorowid(P_ROW_ID);
1260:
1261:
1262: -- Start changes for bug 13059935
1263: open ASS_CUR;

Line 1339: update per_assignments_f a

1335: hr_utility.set_location ( 'After OAB Call' , 12 ) ;
1336:
1337: -- Bug 3506363
1338: -- end of OAB Code change
1339: update per_assignments_f a
1340: set a.assignment_id = P_ASSIGNMENT_ID,
1341: a.effective_start_date = P_EFFECTIVE_START_DATE,
1342: a.effective_end_date = P_EFFECTIVE_END_DATE,
1343: a.business_group_id = P_BUSINESS_GROUP_ID,

Line 1622: from per_assignments_f paf,

1618: p_status out nocopy varchar2 ) is
1619:
1620: cursor get_max_apl_date is
1621: select max(effective_end_date)
1622: from per_assignments_f paf,
1623: per_assignment_status_types past
1624: where paf.application_id = p_application_id
1625: and paf.assignment_id = p_assignment_id
1626: and paf.assignment_type = 'A'

Line 1755: from per_assignments_f a

1751: procedure check_future_stat_change ( p_assignment_id in number ) is
1752: l_dummy number ;
1753: cursor c1 is
1754: select 1
1755: from per_assignments_f a
1756: where assignment_id = p_assignment_id
1757: and exists
1758: (select null
1759: from per_assignment_status_types b

Line 1782: from per_assignments_f

1778: p_warning_set out nocopy boolean ) is
1779: l_dummy_date date := NULL ;
1780: cursor c1 is
1781: select max(effective_end_date)
1782: from per_assignments_f
1783: where assignment_id = p_assignment_id ;
1784: begin
1785: --
1786: hr_utility.set_location ('per_app_asg_pkg.check_end_date', 10);

Line 1814: from per_assignments_f

1810: cursor c1 is
1811: select 1
1812: from sys.dual
1813: where exists ( select 1
1814: from per_assignments_f
1815: where assignment_id <> p_assignment_id ) ;
1816: --
1817: cursor c2 is
1818: select nvl(a.date_end,to_date('31/12/4712','DD/MM/YYYY'))

Line 1898: select 'Y' from per_assignments_f apl

1894: and assignment_type = 'E'
1895: and effective_start_date > cp_effective_date;
1896: --
1897: cursor csr_other_asgs(cp_asg_id number, cp_appl_id number) is
1898: select 'Y' from per_assignments_f apl
1899: where apl.assignment_type = 'A'
1900: and apl.application_id = cp_appl_id
1901: and apl.assignment_id <> cp_asg_id
1902: and (apl.effective_end_date = hr_general.end_of_time

Line 1973: from per_assignments_f

1969: p_delete_mode in varchar2 ) is
1970: l_max_end_date date ;
1971: cursor c1 is
1972: select min(effective_start_date)-1
1973: from per_assignments_f
1974: where assignment_id = p_assignment_id ;
1975: begin
1976: --
1977: hr_utility.set_location ('per_app_asg_pkg.key_delrec', 10);

Line 2022: from per_assignments_f

2018: p_new_end_date in out nocopy date ) is
2019: l_max_end_date date ;
2020: cursor c1 is
2021: select min(effective_start_date)-1
2022: from per_assignments_f
2023: where assignment_id = p_assignment_id ;
2024: --
2025: procedure check_appl_term ( p_application_id in number,
2026: p_validation_end_date in date ,