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

Line 1: PACKAGE BODY PER_ASSIGNMENTS_F_PKG AS

1: PACKAGE BODY PER_ASSIGNMENTS_F_PKG AS
2: /* $Header: peasg01t.pkb 120.50.12020000.8 2013/02/06 07:35:03 srannama ship $ */
3: -----------------------------------------------------------------------------
4: --
5: -- **** Standard ON-* procedures of base view. *****

Line 12: --g_package varchar2(21) := 'PER_ASSIGNMENTS_F_PKG.';

8: --
9: -- Standard Insert procedure
10: --
11: --bug no 6028006 starts here
12: --g_package varchar2(21) := 'PER_ASSIGNMENTS_F_PKG.';
13: g_package varchar2(22) := 'PER_ASSIGNMENTS_F_PKG.';
14: --bug no 6028006 ends here
15: g_debug boolean; -- debug flag
16: --

Line 13: g_package varchar2(22) := 'PER_ASSIGNMENTS_F_PKG.';

9: -- Standard Insert procedure
10: --
11: --bug no 6028006 starts here
12: --g_package varchar2(21) := 'PER_ASSIGNMENTS_F_PKG.';
13: g_package varchar2(22) := 'PER_ASSIGNMENTS_F_PKG.';
14: --bug no 6028006 ends here
15: g_debug boolean; -- debug flag
16: --
17: procedure insert_row(

Line 135: l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';

131: l_work_at_home varchar2(1); --FIX FOR BUG 9215178
132: l_return_code number;
133: l_return_text varchar2(240);
134: l_session_date date;
135: l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';
136: l_labour_union_member_flag varchar2(1); -- bug fix 7698212
137: --
138: /*
139: --WWBUG 2130950 Begin hrwf synchronization --tpapired

Line 165: from per_assignments_f

161: select per_assignments_s.nextval
162: from sys.dual;
163: cursor c2 is
164: select rowid
165: from per_assignments_f
166: where assignment_id = P_ASSIGNMENT_ID
167: and effective_start_date = P_EFFECTIVE_START_DATE
168: and effective_end_date = P_EFFECTIVE_END_DATE;
169: begin

Line 206: insert into per_assignments_f (

202:
203: --- Fix For Bug # 10037392 Ends ---
204:
205: begin
206: insert into per_assignments_f (
207: assignment_id,
208: effective_start_date,
209: effective_end_date,
210: business_group_id,

Line 458: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');

454: if ac1%notfound then
455: close ac1;
456: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
457: fnd_message.set_token('PROCEDURE',
458: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
459: fnd_message.set_token('STEP', '0');
460: fnd_message.raise_error;
461: end if;
462: close ac1;

Line 639: delete from per_assignments_f a

635: -- Standard delete procedure
636: --
637: procedure delete_row(p_row_id varchar2) is
638: begin
639: delete from per_assignments_f a
640: where a.rowid = chartorowid(P_ROW_ID);
641: end delete_row;
642: -----------------------------------------------------------------------------
643: --

Line 760: from per_assignments_f a

756: ) is
757: --
758: cursor ASS_CUR is
759: select *
760: from per_assignments_f a
761: where a.rowid = chartorowid(P_ROW_ID)
762: FOR UPDATE OF ASSIGNMENT_ID NOWAIT;
763: --
764: ass_rec ASS_CUR%rowtype;

Line 776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');

772: if ASS_CUR%notfound then
773: close ASS_CUR;
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE',
776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
777: fnd_message.set_token('STEP', '1');
778: fnd_message.raise_error;
779: end if;
780: close ASS_CUR;

Line 1318: from per_assignments_f pav,

1314: cursor perav1(c_row_id rowid) is
1315: select pav.organization_id,
1316: pbg.legislation_code,
1317: pav.location_id
1318: from per_assignments_f pav,
1319: per_business_groups pbg
1320: where c_row_id = pav.rowid
1321: and pav.business_group_id = pbg.business_group_id;
1322: --

Line 1326: from PER_ASSIGNMENTS_F paf

1322: --
1323:
1324: cursor csr_chk_loc_change is
1325: select paf.location_id
1326: from PER_ASSIGNMENTS_F paf
1327: where paf.assignment_id = p_assignment_id
1328: and p_session_date between paf.effective_start_date
1329: and paf.effective_end_date;
1330:

Line 1428: from per_assignments_f a

1424: -- Start changes for bug 10180700
1425: --
1426: cursor ASS_CUR is
1427: select *
1428: from per_assignments_f a
1429: where a.rowid = chartorowid(P_ROW_ID);
1430: --
1431: ass_rec ASS_CUR%rowtype;
1432:

Line 1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');

1441: --
1442: if ASS_CUR%notfound then
1443: close ASS_CUR;
1444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
1446: fnd_message.set_token('STEP', '1');
1447: fnd_message.raise_error;
1448: end if;
1449: --

Line 1457: --to per_assignments_f. This is because all secure users will be able to see

1453:
1454: --
1455: -- #294004 If the organization_id has been changed away from the default
1456: --business_group, an update to ins_per_list should be invoked, after the update
1457: --to per_assignments_f. This is because all secure users will be able to see
1458: --the person when assigned to the default business group and we want to
1459: --restrict access immediately the organization is entered, rather than waiting
1460: --for the next run of listgen.
1461: --

Line 1462: hr_utility.set_location('per_assignments_f_pkg.update_row',1);

1458: --the person when assigned to the default business group and we want to
1459: --restrict access immediately the organization is entered, rather than waiting
1460: --for the next run of listgen.
1461: --
1462: hr_utility.set_location('per_assignments_f_pkg.update_row',1);
1463: open csr_chk_loc_change;
1464: fetch csr_chk_loc_change into l_loc_id;
1465:
1466: if csr_chk_loc_change%NOTFOUND then

Line 1470: 'per_assignments_f_pkg.update_row');

1466: if csr_chk_loc_change%NOTFOUND then
1467: close csr_chk_loc_change;
1468: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE',
1470: 'per_assignments_f_pkg.update_row');
1471: fnd_message.set_token('STEP','1');
1472: fnd_message.raise_error;
1473: else
1474: if l_loc_id <> p_location_id then

Line 1489: hr_utility.set_location('per_assignments_f_pkg.update_row',10);

1485: --
1486: if p_pay_basis_id is null then
1487: open c_pay_proposals;
1488:
1489: hr_utility.set_location('per_assignments_f_pkg.update_row',10);
1490: fetch c_pay_proposals into l_change_date;
1491: if c_pay_proposals%FOUND then
1492: if l_change_date < p_session_date then
1493: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');

Line 1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);

1492: if l_change_date < p_session_date then
1493: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');
1494: fnd_message.raise_error;
1495: end if;
1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1497: end if;
1498: hr_utility.set_location('per_assignments_f_pkg.update_row',30);
1499: end if;
1500:

Line 1498: hr_utility.set_location('per_assignments_f_pkg.update_row',30);

1494: fnd_message.raise_error;
1495: end if;
1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1497: end if;
1498: hr_utility.set_location('per_assignments_f_pkg.update_row',30);
1499: end if;
1500:
1501: -- End Bug 2365872
1502: **/

Line 1514: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');

1510: if perav1%notfound then
1511: close perav1;
1512: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1513: fnd_message.set_token('PROCEDURE',
1514: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1515: fnd_message.set_token('STEP', '1');
1516: fnd_message.raise_error;
1517: end if;
1518: close perav1;

Line 1611: from per_assignments_f

1607: --
1608: hr_utility.set_location(g_package || l_proc, 40);
1609: -- Retrieve Previous assignment_status_id
1610: select assignment_status_type_id into l_previous_asg_status
1611: from per_assignments_f
1612: where rowid = chartorowid(P_ROW_ID);
1613:
1614: hr_utility.set_location(g_package || l_proc, 45);
1615:

Line 1628: update per_assignments_f a

1624: , p_object_version_number => l_asg_status_ovn);
1625: end if;
1626:
1627: hr_utility.set_location(g_package || l_proc, 50);
1628: update per_assignments_f a
1629: set a.assignment_id = P_ASSIGNMENT_ID,
1630: a.effective_start_date = P_EFFECTIVE_START_DATE,
1631: a.effective_end_date = P_EFFECTIVE_END_DATE,
1632: a.business_group_id = P_BUSINESS_GROUP_ID,

Line 1992: END PER_ASSIGNMENTS_F_PKG;

1988: -- **** End of standard ON-* checks. ****
1989: --
1990: -----------------------------------------------------------------------------
1991: --
1992: END PER_ASSIGNMENTS_F_PKG;