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_ASG_BUS3 dependencies on PER_ASG_SHD

Line 81: l_api_updating := per_asg_shd.api_updating

77: -- Only proceed with validation if :
78: -- a) The cagr_id_flex_num is changing
79: -- b) The grade_def_id is changing or new
80: --
81: l_api_updating := per_asg_shd.api_updating
82: (p_assignment_id => p_assignment_id
83: ,p_effective_date => p_effective_date
84: ,p_object_version_number => p_object_version_number);
85: hr_utility.set_location(l_proc, 30);

Line 89: and nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)

85: hr_utility.set_location(l_proc, 30);
86: --
87: if ((l_api_updating
88: and (p_cagr_grade_def_id is not null)
89: and nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)
90: <> nvl(p_cagr_id_flex_num, hr_api.g_number))
91: or
92: (NOT l_api_updating and p_cagr_grade_def_id is not null)
93: or

Line 95: nvl(per_asg_shd.g_old_rec.cagr_grade_def_id, hr_api.g_number)

91: or
92: (NOT l_api_updating and p_cagr_grade_def_id is not null)
93: or
94: (l_api_updating and (p_cagr_grade_def_id is not null) and
95: nvl(per_asg_shd.g_old_rec.cagr_grade_def_id, hr_api.g_number)
96: <> nvl(p_cagr_grade_def_id, hr_api.g_number))) THEN
97: --
98: hr_utility.set_location(l_proc, 40);
99: --

Line 197: l_api_updating := per_asg_shd.api_updating

193: -- Only proceed with validation if :
194: -- a) The id_flex_num is changing or new
195: -- b) The value for collective_agreement_id is changing and id_flex_num is present
196: --
197: l_api_updating := per_asg_shd.api_updating
198: (p_assignment_id => p_assignment_id
199: ,p_effective_date => p_effective_date
200: ,p_object_version_number => p_object_version_number);
201: hr_utility.set_location(l_proc, 30);

Line 204: nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)

200: ,p_object_version_number => p_object_version_number);
201: hr_utility.set_location(l_proc, 30);
202: --
203: if ((l_api_updating and (p_cagr_id_flex_num is not null) and
204: nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)
205: <> nvl(p_cagr_id_flex_num, hr_api.g_number))
206: or
207: (NOT l_api_updating and p_cagr_id_flex_num is not null)
208: or

Line 210: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)

206: or
207: (NOT l_api_updating and p_cagr_id_flex_num is not null)
208: or
209: (l_api_updating and (p_cagr_id_flex_num is not null) and
210: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)
211: <> nvl(p_collective_agreement_id, hr_api.g_number))) THEN
212: --
213: hr_utility.set_location(l_proc, 40);
214: --

Line 319: l_api_updating := per_asg_shd.api_updating

315: -- Only proceed with validation if :
316: -- a) The contract_id is changing or new
317: -- b) The value for contract_id is changing and not null
318: --
319: l_api_updating := per_asg_shd.api_updating
320: (p_assignment_id => p_assignment_id
321: ,p_effective_date => p_effective_date
322: ,p_object_version_number => p_object_version_number);
323: hr_utility.set_location(l_proc, 30);

Line 326: nvl(per_asg_shd.g_old_rec.contract_id, hr_api.g_number)

322: ,p_object_version_number => p_object_version_number);
323: hr_utility.set_location(l_proc, 30);
324: --
325: if ((l_api_updating and
326: nvl(per_asg_shd.g_old_rec.contract_id, hr_api.g_number)
327: <> nvl(p_contract_id, hr_api.g_number) AND (p_contract_id is not null))
328: or
329: (NOT l_api_updating and p_contract_id is not null)) THEN
330: hr_utility.set_location(l_proc, 40);

Line 434: l_api_updating := per_asg_shd.api_updating

430: -- b) The value for collective_agreement_id has changed or is new
431: -- or
432: -- c) if French, if either establishment_id or collective_id has changed
433: --
434: l_api_updating := per_asg_shd.api_updating
435: (p_assignment_id => p_assignment_id
436: ,p_effective_date => p_effective_date
437: ,p_object_version_number => p_object_version_number);
438: hr_utility.set_location(l_proc, 30);

Line 441: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)

437: ,p_object_version_number => p_object_version_number);
438: hr_utility.set_location(l_proc, 30);
439: --
440: if ((l_api_updating and
441: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)
442: <> nvl(p_collective_agreement_id, hr_api.g_number))
443: or
444: (NOT l_api_updating)
445: or

Line 447: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)

443: or
444: (NOT l_api_updating)
445: or
446: (l_api_updating and
447: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)
448: <> nvl(p_establishment_id, hr_api.g_number) AND (l_legislation_code = 'FR')))
449: THEN
450: hr_utility.set_location(l_proc, 40);
451: --

Line 589: l_api_updating := per_asg_shd.api_updating

585: -- or
586: -- c) if French, if the assignment has changed to Employee
587: -- d) if French, the employee's establishment is changing to null
588: --
589: l_api_updating := per_asg_shd.api_updating
590: (p_assignment_id => p_assignment_id
591: ,p_effective_date => p_effective_date
592: ,p_object_version_number => p_object_version_number);
593: hr_utility.set_location(l_proc, 30);

Line 596: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)

592: ,p_object_version_number => p_object_version_number);
593: hr_utility.set_location(l_proc, 30);
594: --
595: if ((l_api_updating and
596: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)
597: <> nvl(p_establishment_id, hr_api.g_number)
598: AND (p_establishment_id is not null))
599: or
600: ((l_api_updating) AND (l_legislation_code = 'FR') AND (p_assignment_type = 'E')

Line 601: AND (p_establishment_id is null) AND ( nvl(per_asg_shd.g_old_rec.establishment_id,

597: <> nvl(p_establishment_id, hr_api.g_number)
598: AND (p_establishment_id is not null))
599: or
600: ((l_api_updating) AND (l_legislation_code = 'FR') AND (p_assignment_type = 'E')
601: AND (p_establishment_id is null) AND ( nvl(per_asg_shd.g_old_rec.establishment_id,
602: hr_api.g_number) <> nvl(p_establishment_id, hr_api.g_number)) )
603: or
604: (NOT l_api_updating )
605: or

Line 607: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)

603: or
604: (NOT l_api_updating )
605: or
606: (l_api_updating and
607: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
608: <> nvl(p_assignment_type, hr_api.g_varchar2) AND (l_legislation_code = 'FR')
609: and (p_assignment_type = 'E')))
610: THEN
611: hr_utility.set_location(l_proc, 40);

Line 695: (per_asg_shd.g_old_rec.notice_period <> p_notice_period))) THEN

691: -- b) The value for notice_period has changed
692: --
693: IF ( (p_assignment_id IS NULL) OR
694: ((p_assignment_id IS NOT NULL) AND
695: (per_asg_shd.g_old_rec.notice_period <> p_notice_period))) THEN
696:
697: hr_utility.set_location('Entering:'|| l_proc, 20);
698:
699: --

Line 759: (per_asg_shd.g_old_rec.notice_period_uom <> p_notice_period_uom))) THEN

755: -- b) The value for notice_period_uom has changed
756: --
757: IF ( (p_assignment_id IS NULL) OR
758: ((p_assignment_id IS NOT NULL) AND
759: (per_asg_shd.g_old_rec.notice_period_uom <> p_notice_period_uom))) THEN
760:
761: hr_utility.set_location('Entering:'|| l_proc, 20);
762:
763: IF (p_notice_period IS NOT NULL AND p_notice_period_uom IS NULL ) then

Line 832: (nvl(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2) <> p_employee_category))) THEN

828: -- b) The value for employee category has changed
829: --
830: IF ( (p_assignment_id IS NULL) OR
831: ((p_assignment_id IS NOT NULL) AND
832: (nvl(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2) <> p_employee_category))) THEN
833:
834: hr_utility.set_location(l_proc, 40);
835:
836: l_catg_lookup := 'EMPLOYEE_CATG';

Line 937: l_api_updating := per_asg_shd.api_updating

933: hr_utility.set_location(l_proc, 20);
934: --
935: -- Check if the assignment is being updated.
936: --
937: l_api_updating := per_asg_shd.api_updating
938: (p_assignment_id => p_assignment_id
939: ,p_effective_date => p_effective_date
940: ,p_object_version_number => p_object_version_number
941: );

Line 1076: l_api_updating := per_asg_shd.api_updating

1072: -- Only proceed with validation if :
1073: -- a) The current g_old_rec is current and
1074: -- b) The value being validated has changed.
1075: --
1076: l_api_updating := per_asg_shd.api_updating
1077: (p_assignment_id => p_assignment_id
1078: ,p_effective_date => p_effective_date
1079: ,p_object_version_number => p_object_version_number);
1080:

Line 1086: NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number) <>

1082: hr_utility.set_location(l_proc, 30);
1083: END IF;
1084:
1085: IF ((l_api_updating AND
1086: NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number) <>
1087: NVL(p_vendor_id, hr_api.g_number)) OR
1088: (NOT l_api_updating)) THEN
1089:
1090: IF g_debug THEN

Line 1208: l_api_updating := per_asg_shd.api_updating

1204: -- Only proceed with validation if :
1205: -- a) The current g_old_rec is current and
1206: -- b) The value being validated has changed.
1207: --
1208: l_api_updating := per_asg_shd.api_updating
1209: (p_assignment_id => p_assignment_id
1210: ,p_effective_date => p_effective_date
1211: ,p_object_version_number => p_object_version_number);
1212:

Line 1218: NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number) <>

1214: hr_utility.set_location(l_proc, 30);
1215: END IF;
1216:
1217: IF ((l_api_updating AND
1218: NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number) <>
1219: NVL(p_vendor_site_id, hr_api.g_number)) OR
1220: (NOT l_api_updating)) THEN
1221:
1222: IF g_debug THEN

Line 1360: l_api_updating := per_asg_shd.api_updating

1356: -- Only proceed with validation if :
1357: -- a) The current g_old_rec is current and
1358: -- b) The value being validated has changed.
1359: --
1360: l_api_updating := per_asg_shd.api_updating
1361: (p_assignment_id => p_assignment_id
1362: ,p_effective_date => p_effective_date
1363: ,p_object_version_number => p_object_version_number);
1364:

Line 1370: NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number) <>

1366: hr_utility.set_location(l_proc, 30);
1367: END IF;
1368:
1369: IF ((l_api_updating AND
1370: NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number) <>
1371: NVL(p_po_header_id, hr_api.g_number)) OR
1372: (NOT l_api_updating)) THEN
1373:
1374: IF g_debug THEN

Line 1520: l_api_updating := per_asg_shd.api_updating

1516: -- Only proceed with validation if :
1517: -- a) The current g_old_rec is current and
1518: -- b) The value being validated has changed.
1519: --
1520: l_api_updating := per_asg_shd.api_updating
1521: (p_assignment_id => p_assignment_id
1522: ,p_effective_date => p_effective_date
1523: ,p_object_version_number => p_object_version_number);
1524:

Line 1530: NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number) <>

1526: hr_utility.set_location(l_proc, 30);
1527: END IF;
1528:
1529: IF ((l_api_updating AND
1530: NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number) <>
1531: NVL(p_po_line_id, hr_api.g_number)) OR
1532: (NOT l_api_updating)) THEN
1533:
1534: IF g_debug THEN

Line 1662: l_api_updating := per_asg_shd.api_updating

1658: -- Only proceed with validation if :
1659: -- a) The current g_old_rec is current and
1660: -- b) The value being validated has changed.
1661: --
1662: l_api_updating := per_asg_shd.api_updating
1663: (p_assignment_id => p_assignment_id
1664: ,p_effective_date => p_effective_date
1665: ,p_object_version_number => p_object_version_number);
1666:

Line 1672: NVL(per_asg_shd.g_old_rec.projected_assignment_end, hr_api.g_date) <>

1668: hr_utility.set_location(l_proc, 30);
1669: END IF;
1670:
1671: IF ((l_api_updating AND
1672: NVL(per_asg_shd.g_old_rec.projected_assignment_end, hr_api.g_date) <>
1673: NVL(p_projected_assignment_end, hr_api.g_date)) OR
1674: (NOT l_api_updating)) THEN
1675:
1676: IF g_debug THEN

Line 1774: l_api_updating := per_asg_shd.api_updating

1770: -- Only proceed with validation if :
1771: -- a) The current g_old_rec is current and
1772: -- b) The value being validated has changed.
1773: --
1774: l_api_updating := per_asg_shd.api_updating
1775: (p_assignment_id => p_assignment_id
1776: ,p_effective_date => p_effective_date
1777: ,p_object_version_number => p_object_version_number);
1778:

Line 1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)

1781: END IF;
1782:
1783: IF (l_api_updating
1784: AND
1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
1786: <> NVL(p_vendor_id, hr_api.g_number))
1787: OR
1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
1789: <> NVL(p_vendor_site_id, hr_api.g_number))))

Line 1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)

1784: AND
1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
1786: <> NVL(p_vendor_id, hr_api.g_number))
1787: OR
1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
1789: <> NVL(p_vendor_site_id, hr_api.g_number))))
1790: OR
1791: NOT l_api_updating THEN
1792:

Line 1892: l_api_updating := per_asg_shd.api_updating

1888: -- Only proceed with validation if :
1889: -- a) The current g_old_rec is current and
1890: -- b) The value being validated has changed.
1891: --
1892: l_api_updating := per_asg_shd.api_updating
1893: (p_assignment_id => p_assignment_id
1894: ,p_effective_date => p_effective_date
1895: ,p_object_version_number => p_object_version_number);
1896:

Line 1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)

1899: END IF;
1900:
1901: IF (l_api_updating
1902: AND
1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
1904: <> NVL(p_po_header_id, hr_api.g_number))
1905: OR
1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
1907: <> NVL(p_po_line_id, hr_api.g_number))))

Line 1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)

1902: AND
1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
1904: <> NVL(p_po_header_id, hr_api.g_number))
1905: OR
1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
1907: <> NVL(p_po_line_id, hr_api.g_number))))
1908: OR
1909: NOT l_api_updating THEN
1910:

Line 2013: l_api_updating := per_asg_shd.api_updating

2009: -- Only proceed with validation if :
2010: -- a) The current g_old_rec is current and
2011: -- b) The value being validated has changed.
2012: --
2013: l_api_updating := per_asg_shd.api_updating
2014: (p_assignment_id => p_assignment_id
2015: ,p_effective_date => p_effective_date
2016: ,p_object_version_number => p_object_version_number);
2017:

Line 2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)

2020: END IF;
2021:
2022: IF (l_api_updating
2023: AND
2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
2025: <> NVL(p_vendor_id, hr_api.g_number))
2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))

Line 2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)

2023: AND
2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
2025: <> NVL(p_vendor_id, hr_api.g_number))
2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))
2029: OR
2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
2031: <> NVL(p_po_header_id, hr_api.g_number))))

Line 2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)

2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))
2029: OR
2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
2031: <> NVL(p_po_header_id, hr_api.g_number))))
2032: OR
2033: NOT l_api_updating THEN
2034:

Line 2120: l_api_updating := per_asg_shd.api_updating

2116: -- Only proceed with validation if :
2117: -- a) The current g_old_rec is current and
2118: -- b) The value being validated has changed.
2119: --
2120: l_api_updating := per_asg_shd.api_updating
2121: (p_assignment_id => p_assignment_id
2122: ,p_effective_date => p_effective_date
2123: ,p_object_version_number => p_object_version_number);
2124:

Line 2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)

2127: END IF;
2128:
2129: IF (l_api_updating
2130: AND
2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
2132: <> NVL(p_job_id, hr_api.g_number))
2133: OR
2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
2135: <> NVL(p_po_line_id, hr_api.g_number))))

Line 2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)

2130: AND
2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
2132: <> NVL(p_job_id, hr_api.g_number))
2133: OR
2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
2135: <> NVL(p_po_line_id, hr_api.g_number))))
2136: OR
2137: NOT l_api_updating THEN
2138:

Line 2212: l_api_updating := per_asg_shd.api_updating

2208: -- Only proceed with validation if :
2209: -- a) The current g_old_rec is current and
2210: -- b) The value for vacancy has changed
2211: --
2212: l_api_updating := per_asg_shd.api_updating
2213: (p_assignment_id => p_assignment_id
2214: ,p_effective_date => p_effective_date
2215: ,p_object_version_number => p_object_version_number);
2216: --

Line 2220: NVL(per_asg_shd.g_old_rec.vendor_assignment_number, hr_api.g_varchar2) <>

2216: --
2217: hr_utility.set_location(l_proc, 30);
2218: --
2219: IF ((l_api_updating AND
2220: NVL(per_asg_shd.g_old_rec.vendor_assignment_number, hr_api.g_varchar2) <>
2221: NVL(p_vendor_assignment_number, hr_api.g_varchar2)) OR
2222: (NOT l_api_updating)) THEN
2223: --
2224: hr_utility.set_location(l_proc, 40);

Line 2292: l_api_updating := per_asg_shd.api_updating

2288: -- Only proceed with validation if :
2289: -- a) The current g_old_rec is current and
2290: -- b) The value for vacancy has changed
2291: --
2292: l_api_updating := per_asg_shd.api_updating
2293: (p_assignment_id => p_assignment_id
2294: ,p_effective_date => p_effective_date
2295: ,p_object_version_number => p_object_version_number);
2296: --

Line 2300: NVL(per_asg_shd.g_old_rec.vendor_employee_number, hr_api.g_varchar2) <>

2296: --
2297: hr_utility.set_location(l_proc, 30);
2298: --
2299: IF ((l_api_updating AND
2300: NVL(per_asg_shd.g_old_rec.vendor_employee_number, hr_api.g_varchar2) <>
2301: NVL(p_vendor_employee_number, hr_api.g_varchar2)) OR
2302: (NOT l_api_updating)) THEN
2303: --
2304: hr_utility.set_location(l_proc, 40);

Line 2368: (nvl(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2) <> p_work_at_home))) THEN

2364: -- b) The value for notice_period_uom has changed
2365: --
2366: IF ( (p_assignment_id IS NULL) OR
2367: ((p_assignment_id IS NOT NULL) AND
2368: (nvl(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2) <> p_work_at_home))) THEN
2369:
2370: hr_utility.set_location(l_proc, 40);
2371:
2372: l_wah_lookup := 'YES_NO';