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_APP_ASG_PKG dependencies on PER_ASSIGNMENTS_F

Line 19: update per_assignments_f a

15: p_assignment_id number ) is
16: --
17: begin
18: --
19: update per_assignments_f a
20: set a.effective_end_date = p_new_end_date
21: where a.assignment_id = p_assignment_id
22: and a.effective_end_date = (
23: select max(a2.effective_end_date)

Line 24: from per_assignments_f a2

20: set a.effective_end_date = p_new_end_date
21: where a.assignment_id = p_assignment_id
22: and a.effective_end_date = (
23: select max(a2.effective_end_date)
24: from per_assignments_f a2
25: where a2.assignment_id = a.assignment_id);
26: --
27: end set_end_date;
28:

Line 98: from per_assignments_f a

94: where r2.letter_request_id = p.letter_request_id
95: and r2.request_status = 'PENDING')
96: and not exists
97: (select null
98: from per_assignments_f a
99: where assignment_id = p_assignment_id
100: and ( (a.effective_start_date = p.date_from
101: and
102: a.assignment_status_type_id = p.assignment_status_type_id)

Line 105: from per_assignments_f a2

101: and
102: a.assignment_status_type_id = p.assignment_status_type_id)
103: or (a.effective_end_date =
104: (select max(a2.effective_end_date)
105: from per_assignments_f a2
106: where a2.assignment_id = p_assignment_id)
107: and a.effective_end_date = p.date_from ))) ;
108: --
109: end cleanup_letters ;

Line 203: from per_assignments_f

199: select per_assignments_s.nextval
200: from sys.dual;
201: cursor c2 is
202: select rowid
203: from per_assignments_f
204: where assignment_id = P_ASSIGNMENT_ID
205: and effective_start_date = P_EFFECTIVE_START_DATE
206: and effective_end_date = P_EFFECTIVE_END_DATE;
207: --

Line 241: insert into per_assignments_f (

237: --
238: --
239: begin
240: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 4 ) ;
241: insert into per_assignments_f (
242: assignment_id,
243: effective_start_date,
244: effective_end_date,
245: business_group_id,

Line 567: delete from per_assignments_f a

563: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 5 ) ;
564: delete_child ( p_assignment_id
565: ,p_delete_mode);
566:
567: delete from per_assignments_f a
568: where a.rowid = chartorowid(P_ROW_ID);
569: --
570:
571:

Line 701: from per_assignments_f a

697: p_supervisor_assignment_id number ) is
698:
699: cursor ASS_CUR is
700: select *
701: from per_assignments_f a
702: where a.rowid = chartorowid(P_ROW_ID)
703: FOR UPDATE OF ASSIGNMENT_ID NOWAIT;
704: --
705: ass_rec ASS_CUR%rowtype;

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

1146: */
1147: --
1148: select assignment_status_type_id, vacancy_id
1149: into l_previous_asg_status, l_previous_vacancy_id
1150: from per_assignments_f where rowid = chartorowid(P_ROW_ID);
1151:
1152: -- Start of OAB code addition
1153: -- Whenever Applicant Information is getting changed/inserted via Applicant forms
1154: -- we need to trigger OAB Lifeevents. The following ben call will trigger LE

Line 1220: update per_assignments_f a

1216: hr_utility.set_location ( 'After OAB Call' , 11 ) ;
1217:
1218: -- Bug 3506363
1219: -- end of OAB Code change
1220: update per_assignments_f a
1221: set a.assignment_id = P_ASSIGNMENT_ID,
1222: a.effective_start_date = P_EFFECTIVE_START_DATE,
1223: a.effective_end_date = P_EFFECTIVE_END_DATE,
1224: a.business_group_id = P_BUSINESS_GROUP_ID,

Line 1435: from per_assignments_f paf,

1431: p_status out nocopy varchar2 ) is
1432:
1433: cursor get_max_apl_date is
1434: select max(effective_end_date)
1435: from per_assignments_f paf,
1436: per_assignment_status_types past
1437: where paf.application_id = p_application_id
1438: and paf.assignment_id = p_assignment_id
1439: and paf.assignment_type = 'A'

Line 1560: from per_assignments_f a

1556: procedure check_future_stat_change ( p_assignment_id in number ) is
1557: l_dummy number ;
1558: cursor c1 is
1559: select 1
1560: from per_assignments_f a
1561: where assignment_id = p_assignment_id
1562: and exists
1563: (select null
1564: from per_assignment_status_types b

Line 1585: from per_assignments_f

1581: p_warning_set out nocopy boolean ) is
1582: l_dummy_date date := NULL ;
1583: cursor c1 is
1584: select max(effective_end_date)
1585: from per_assignments_f
1586: where assignment_id = p_assignment_id ;
1587: begin
1588: --
1589: open c1 ;

Line 1615: from per_assignments_f

1611: cursor c1 is
1612: select 1
1613: from sys.dual
1614: where exists ( select 1
1615: from per_assignments_f
1616: where assignment_id <> p_assignment_id ) ;
1617: --
1618: cursor c2 is
1619: select nvl(a.date_end,to_date('31/12/4712','DD/MM/YYYY'))

Line 1695: select 'Y' from per_assignments_f apl

1691: and assignment_type = 'E'
1692: and effective_start_date > cp_effective_date;
1693: --
1694: cursor csr_other_asgs(cp_asg_id number, cp_appl_id number) is
1695: select 'Y' from per_assignments_f apl
1696: where apl.assignment_type = 'A'
1697: and apl.application_id = cp_appl_id
1698: and apl.assignment_id <> cp_asg_id
1699: and (apl.effective_end_date = hr_general.end_of_time

Line 1765: from per_assignments_f

1761: p_delete_mode in varchar2 ) is
1762: l_max_end_date date ;
1763: cursor c1 is
1764: select min(effective_start_date)-1
1765: from per_assignments_f
1766: where assignment_id = p_assignment_id ;
1767: begin
1768: --
1769: if ( p_delete_mode in ( 'FUTURE_CHANGE' , 'DELETE_NEXT_CHANGE' ) ) then

Line 1809: from per_assignments_f

1805: p_new_end_date in out nocopy date ) is
1806: l_max_end_date date ;
1807: cursor c1 is
1808: select min(effective_start_date)-1
1809: from per_assignments_f
1810: where assignment_id = p_assignment_id ;
1811: --
1812: procedure check_appl_term ( p_application_id in number,
1813: p_validation_end_date in date ,