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

Line 59: l_api_updating := per_asg_shd.api_updating

55: );
56: --
57: -- Check if the assignment is being updated
58: --
59: l_api_updating := per_asg_shd.api_updating
60: (p_assignment_id => p_assignment_id
61: ,p_effective_date => p_effective_date
62: ,p_object_version_number => p_object_version_number
63: );

Line 69: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number)

65: --
66: -- Check if the assignment is being inserted or updated.
67: --
68: if ((l_api_updating and
69: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number)
70: <> nvl(p_pay_basis_id, hr_api.g_number)) or
71: (NOT l_api_updating)) then
72: hr_utility.set_location(l_proc, 3);
73: --

Line 399: l_api_updating := per_asg_shd.api_updating

395: ,p_argument_value => p_validation_end_date
396: );
397: hr_utility.set_location(l_proc, 20);
398: --
399: l_api_updating := per_asg_shd.api_updating
400: (p_assignment_id => p_assignment_id
401: ,p_effective_date => p_effective_date
402: ,p_object_version_number => p_object_version_number
403: );

Line 407: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)

403: );
404: hr_utility.set_location(l_proc, 30);
405: --
406: if (l_api_updating and
407: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
408: <> nvl(p_payroll_id, hr_api.g_number)) or
409: (per_asg_shd.g_old_rec.assignment_type='A' and
410: p_assignment_type='E')
411: )

Line 409: (per_asg_shd.g_old_rec.assignment_type='A' and

405: --
406: if (l_api_updating and
407: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
408: <> nvl(p_payroll_id, hr_api.g_number)) or
409: (per_asg_shd.g_old_rec.assignment_type='A' and
410: p_assignment_type='E')
411: )
412: )
413: or NOT l_api_updating

Line 418: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)

414: then
415: hr_utility.set_location(l_proc, 40);
416: --
417: if (l_api_updating and
418: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
419: <> nvl(p_payroll_id, hr_api.g_number)) then
420: --
421: -- As payroll id has been updated, set p_payroll_id_updated to true.
422: -- This functionality is required for the /update/delete_assignment

Line 540: and (per_asg_shd.g_old_rec.payroll_id is not null

536: close csr_any_future_changes;
537: hr_utility.set_location(l_proc, 90);
538: --
539: if (l_api_updating
540: and (per_asg_shd.g_old_rec.payroll_id is not null
541: and p_payroll_id is not null
542: and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id))
543: or (l_future_change
544: and (p_datetrack_mode = 'DELETE_NEXT_CHANGE'

Line 542: and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id))

538: --
539: if (l_api_updating
540: and (per_asg_shd.g_old_rec.payroll_id is not null
541: and p_payroll_id is not null
542: and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id))
543: or (l_future_change
544: and (p_datetrack_mode = 'DELETE_NEXT_CHANGE'
545: or p_datetrack_mode = 'FUTURE_CHANGE'
546: or p_datetrack_mode = 'UPDATE_OVERRIDE'))

Line 752: and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id

748: end if;
749: end if;
750: --
751: if (l_api_updating
752: and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id
753: )
754: or (p_datetrack_mode = 'DELETE_NEXT_CHANGE'
755: or p_datetrack_mode = 'FUTURE_CHANGE'
756: or p_datetrack_mode = 'UPDATE_OVERRIDE'

Line 866: l_api_updating := per_asg_shd.api_updating

862: -- Only proceed with validation if :
863: -- a) The current g_old_rec is current and
864: -- b) The value for people group has changed
865: --
866: l_api_updating := per_asg_shd.api_updating
867: (p_assignment_id => p_assignment_id
868: ,p_effective_date => p_effective_date
869: ,p_object_version_number => p_object_version_number
870: );

Line 874: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>

870: );
871: hr_utility.set_location(l_proc, 30);
872: --
873: if ((l_api_updating and
874: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>
875: nvl(p_people_group_id, hr_api.g_number)) or
876: (NOT l_api_updating))
877: then
878: hr_utility.set_location(l_proc, 40);

Line 985: l_api_updating := per_asg_shd.api_updating

981: -- Only proceed with validation if :
982: -- a) The current g_old_rec is current and
983: -- b) The value for performance review period frequency has changed
984: --
985: l_api_updating := per_asg_shd.api_updating
986: (p_assignment_id => p_assignment_id
987: ,p_effective_date => p_effective_date
988: ,p_object_version_number => p_object_version_number
989: );

Line 993: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,

989: );
990: hr_utility.set_location(l_proc, 30);
991: --
992: if ((l_api_updating and
993: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
994: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency,
995: hr_api.g_varchar2))
996: or
997: (NOT l_api_updating))

Line 1082: l_api_updating := per_asg_shd.api_updating

1078: -- Only proceed with validation if :
1079: -- a) The current g_old_rec is current and
1080: -- b) The value for perf review period has changed
1081: --
1082: l_api_updating := per_asg_shd.api_updating
1083: (p_assignment_id => p_assignment_id
1084: ,p_effective_date => p_effective_date
1085: ,p_object_version_number => p_object_version_number);
1086: --

Line 1090: nvl(per_asg_shd.g_old_rec.perf_review_period,

1086: --
1087: hr_utility.set_location(l_proc, 2);
1088: --
1089: if ((l_api_updating and
1090: nvl(per_asg_shd.g_old_rec.perf_review_period,
1091: hr_api.g_number) <> nvl(p_perf_review_period,
1092: hr_api.g_number))
1093: or (NOT l_api_updating))
1094: then

Line 1165: l_api_updating := per_asg_shd.api_updating

1161: );
1162: --
1163: -- Check if the assignment is being updated.
1164: --
1165: l_api_updating := per_asg_shd.api_updating
1166: (p_assignment_id => p_assignment_id
1167: ,p_effective_date => p_effective_date
1168: ,p_object_version_number => p_object_version_number);
1169: --

Line 1177: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,

1173: -- changed.
1174: --
1175: if ((l_api_updating)
1176: and
1177: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1178: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1179: or
1180: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1181: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))

Line 1180: (nvl(per_asg_shd.g_old_rec.perf_review_period,

1176: and
1177: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1178: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1179: or
1180: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1181: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))
1182: or
1183: (NOT l_api_updating)) then
1184: --

Line 1287: l_api_updating := per_asg_shd.api_updating

1283: hr_utility.set_location(l_proc, 20);
1284: --
1285: -- Check if the assignment is being updated.
1286: --
1287: l_api_updating := per_asg_shd.api_updating
1288: (p_assignment_id => p_assignment_id
1289: ,p_effective_date => p_effective_date
1290: ,p_object_version_number => p_object_version_number
1291: );

Line 1499: l_api_updating := per_asg_shd.api_updating

1495: -- Only proceed with validation if :
1496: -- a) The current g_old_rec is current and
1497: -- b) The value for person referred by has changed
1498: --
1499: l_api_updating := per_asg_shd.api_updating
1500: (p_assignment_id => p_assignment_id
1501: ,p_effective_date => p_effective_date
1502: ,p_object_version_number => p_object_version_number);
1503: hr_utility.set_location(l_proc, 30);

Line 1506: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)

1502: ,p_object_version_number => p_object_version_number);
1503: hr_utility.set_location(l_proc, 30);
1504: --
1505: if ((l_api_updating and
1506: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)
1507: <> nvl(p_person_referred_by_id, hr_api.g_number)) or
1508: (NOT l_api_updating)) then
1509: hr_utility.set_location(l_proc, 40);
1510: --

Line 1683: l_api_updating := per_asg_shd.api_updating

1679: -- Only proceed with validation if :
1680: -- a) The current g_old_rec is current and
1681: -- b) The value for position_id has changed
1682: --
1683: l_api_updating := per_asg_shd.api_updating
1684: (p_assignment_id => p_assignment_id
1685: ,p_effective_date => p_effective_date
1686: ,p_object_version_number => p_object_version_number);
1687: --

Line 1690: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

1686: ,p_object_version_number => p_object_version_number);
1687: --
1688: if ((l_api_updating
1689: and
1690: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1691: nvl(p_position_id, hr_api.g_number))
1692: or
1693: (NOT l_api_updating)) then
1694: hr_utility.set_location(l_proc, 30);

Line 1815: l_api_updating := per_asg_shd.api_updating

1811: -- Only proceed with validation if :
1812: -- a) The current g_old_rec is current and
1813: -- b) The value for position_id or grade_id has changed
1814: --
1815: l_api_updating := per_asg_shd.api_updating
1816: (p_assignment_id => p_assignment_id
1817: ,p_effective_date => p_effective_date
1818: ,p_object_version_number => p_object_version_number);
1819: --

Line 1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

1817: ,p_effective_date => p_effective_date
1818: ,p_object_version_number => p_object_version_number);
1819: --
1820: if (l_api_updating and
1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1822: nvl(p_position_id, hr_api.g_number))
1823: or
1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1825: nvl(p_grade_id, hr_api.g_number))))

Line 1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>

1820: if (l_api_updating and
1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1822: nvl(p_position_id, hr_api.g_number))
1823: or
1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1825: nvl(p_grade_id, hr_api.g_number))))
1826: or
1827: (NOT l_api_updating) then
1828: --

Line 1940: l_api_updating := per_asg_shd.api_updating

1936: -- Only proceed with validation if :
1937: -- a) The current g_old_rec is current and
1938: -- b) The value for position_id or grade_id has changed
1939: --
1940: l_api_updating := per_asg_shd.api_updating
1941: (p_assignment_id => p_assignment_id
1942: ,p_effective_date => p_effective_date
1943: ,p_object_version_number => p_object_version_number);
1944: --

Line 1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

1943: ,p_object_version_number => p_object_version_number);
1944: --
1945:
1946: if (l_api_updating and
1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1948: nvl(p_position_id, hr_api.g_number))
1949: or
1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1951: nvl(p_organization_id, hr_api.g_number))))

Line 1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>

1946: if (l_api_updating and
1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1948: nvl(p_position_id, hr_api.g_number))
1949: or
1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1951: nvl(p_organization_id, hr_api.g_number))))
1952: or
1953: (NOT l_api_updating) then
1954: --

Line 2060: l_api_updating := per_asg_shd.api_updating

2056: -- Only proceed with validation if :
2057: -- a) The current g_old_rec is current and
2058: -- b) The value for position or job has changed
2059: --
2060: l_api_updating := per_asg_shd.api_updating
2061: (p_assignment_id => p_assignment_id
2062: ,p_effective_date => p_effective_date
2063: ,p_object_version_number => p_object_version_number);
2064: hr_utility.set_location(l_proc, 30);

Line 2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

2063: ,p_object_version_number => p_object_version_number);
2064: hr_utility.set_location(l_proc, 30);
2065: --
2066: if (l_api_updating and
2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2068: nvl(p_position_id, hr_api.g_number))
2069: or
2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2071: nvl(p_job_id, hr_api.g_number))))

Line 2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>

2066: if (l_api_updating and
2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2068: nvl(p_position_id, hr_api.g_number))
2069: or
2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2071: nvl(p_job_id, hr_api.g_number))))
2072: or
2073: (NOT l_api_updating)
2074: then

Line 2165: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id

2161: --
2162: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2163: SELECT per_system_status
2164: FROM per_ass_status_type_amends
2165: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id
2166: AND business_group_id = csr_chk_amends.p_bg_id;
2167: --
2168: CURSOR csr_valid_ast IS
2169: SELECT per_system_status

Line 2171: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;

2167: --
2168: CURSOR csr_valid_ast IS
2169: SELECT per_system_status
2170: FROM per_assignment_status_types
2171: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
2172: --
2173: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2174: --
2175: -- 120.10 (END)

Line 2270: l_api_updating := per_asg_shd.api_updating

2266: -- Only proceed with validation if :
2267: -- a) The current g_old_rec is current and
2268: -- b) The value for primary flag has changed
2269: --
2270: l_api_updating := per_asg_shd.api_updating
2271: (p_assignment_id => p_assignment_id
2272: ,p_effective_date => p_effective_date
2273: ,p_object_version_number => p_object_version_number);
2274: --

Line 2278: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>

2274: --
2275: hr_utility.set_location(l_proc, 30);
2276: --
2277: if ((l_api_updating and
2278: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>
2279: nvl(p_primary_flag, hr_api.g_varchar2)) or
2280: (NOT l_api_updating)) then
2281: --
2282: -- Check if primary flag is either 'Y' or 'N'.

Line 2286: per_asg_shd.constraint_error

2282: -- Check if primary flag is either 'Y' or 'N'.
2283: --
2284: If p_primary_flag not in('Y','N') then
2285: --
2286: per_asg_shd.constraint_error
2287: (p_constraint_name => 'PER_ASS_PRIMARY_FLAG_CHK');
2288: --
2289: hr_utility.set_location(l_proc, 30);
2290: --

Line 2542: l_api_updating := per_asg_shd.api_updating

2538: -- Only proceed with validation if :
2539: -- a) The current g_old_rec is current and
2540: -- b) The value for probation period has changed
2541: --
2542: l_api_updating := per_asg_shd.api_updating
2543: (p_assignment_id => p_assignment_id
2544: ,p_effective_date => p_effective_date
2545: ,p_object_version_number => p_object_version_number
2546: );

Line 2550: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)

2546: );
2547: hr_utility.set_location(l_proc, 30);
2548: --
2549: if ((l_api_updating and
2550: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2551: <> nvl(p_probation_period, hr_api.g_number))
2552: or
2553: (NOT l_api_updating))
2554: then

Line 2630: l_api_updating := per_asg_shd.api_updating

2626: -- Only proceed with validation if :
2627: -- a) The current g_old_rec is current and
2628: -- b) The value for probation unit has changed
2629: --
2630: l_api_updating := per_asg_shd.api_updating
2631: (p_assignment_id => p_assignment_id
2632: ,p_effective_date => p_effective_date
2633: ,p_object_version_number => p_object_version_number
2634: );

Line 2638: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)

2634: );
2635: hr_utility.set_location(l_proc, 30);
2636: --
2637: if ((l_api_updating and
2638: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2639: <> nvl(p_probation_unit, hr_api.g_varchar2))
2640: or
2641: (NOT l_api_updating))
2642: then

Line 2719: l_api_updating := per_asg_shd.api_updating

2715: -- Only proceed with validation if :
2716: -- a) The current g_old_rec is current and
2717: -- b) The value for probation unit or probation period changed.
2718: --
2719: l_api_updating := per_asg_shd.api_updating
2720: (p_assignment_id => p_assignment_id
2721: ,p_effective_date => p_effective_date
2722: ,p_object_version_number => p_object_version_number);
2723: --

Line 2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)

2722: ,p_object_version_number => p_object_version_number);
2723: --
2724: if ((l_api_updating
2725: and
2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2727: <> nvl(p_probation_unit, hr_api.g_varchar2)
2728: or
2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2730: <> nvl(p_probation_period, hr_api.g_number))

Line 2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)

2725: and
2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2727: <> nvl(p_probation_unit, hr_api.g_varchar2)
2728: or
2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2730: <> nvl(p_probation_period, hr_api.g_number))
2731: or
2732: (NOT l_api_updating)) then
2733: --

Line 2834: l_api_updating := per_asg_shd.api_updating

2830: -- Only proceed with validation if :
2831: -- a) The current g_old_rec is current and
2832: -- b) The value for recruiter has changed
2833: --
2834: l_api_updating := per_asg_shd.api_updating
2835: (p_assignment_id => p_assignment_id
2836: ,p_effective_date => p_effective_date
2837: ,p_object_version_number => p_object_version_number);
2838: hr_utility.set_location(l_proc, 50);

Line 2841: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>

2837: ,p_object_version_number => p_object_version_number);
2838: hr_utility.set_location(l_proc, 50);
2839: --
2840: if ((l_api_updating and
2841: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>
2842: nvl(p_recruiter_id, hr_api.g_number)) or
2843: (NOT l_api_updating)) then
2844: hr_utility.set_location(l_proc, 60);
2845: --

Line 2989: l_api_updating := per_asg_shd.api_updating

2985: -- Only proceed with validation if :
2986: -- a) The current g_old_rec is current and
2987: -- b) The value for recruitment activity has changed
2988: --
2989: l_api_updating := per_asg_shd.api_updating
2990: (p_assignment_id => p_assignment_id
2991: ,p_effective_date => p_effective_date
2992: ,p_object_version_number => p_object_version_number
2993: );

Line 2997: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>

2993: );
2994: hr_utility.set_location(l_proc, 30);
2995: --
2996: if ((l_api_updating and
2997: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>
2998: nvl(p_recruitment_activity_id, hr_api.g_number)) or
2999: (NOT l_api_updating))
3000: then
3001: hr_utility.set_location(l_proc, 40);

Line 3433: l_api_updating := per_asg_shd.api_updating

3429: -- Only proceed with validation if :
3430: -- a) The current g_old_rec is current and
3431: -- b) The value for salary review period frequency has changed
3432: --
3433: l_api_updating := per_asg_shd.api_updating
3434: (p_assignment_id => p_assignment_id
3435: ,p_effective_date => p_effective_date
3436: ,p_object_version_number => p_object_version_number
3437: );

Line 3441: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,

3437: );
3438: hr_utility.set_location(l_proc, 30);
3439: --
3440: if ((l_api_updating and
3441: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3442: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency,
3443: hr_api.g_varchar2))
3444: or
3445: (NOT l_api_updating))

Line 3529: l_api_updating := per_asg_shd.api_updating

3525: -- Only proceed with validation if :
3526: -- a) The current g_old_rec is current and
3527: -- b) The value for perf review period has changed
3528: --
3529: l_api_updating := per_asg_shd.api_updating
3530: (p_assignment_id => p_assignment_id
3531: ,p_effective_date => p_effective_date
3532: ,p_object_version_number => p_object_version_number);
3533: --

Line 3537: nvl(per_asg_shd.g_old_rec.sal_review_period,

3533: --
3534: hr_utility.set_location(l_proc, 2);
3535: --
3536: if ((l_api_updating and
3537: nvl(per_asg_shd.g_old_rec.sal_review_period,
3538: hr_api.g_number) <> nvl(p_sal_review_period,
3539: hr_api.g_number)) or (NOT l_api_updating)) then
3540: --
3541: hr_utility.set_location(l_proc, 3);

Line 3612: l_api_updating := per_asg_shd.api_updating

3608: -- a) The current g_old_rec is current and
3609: -- b) The value for sal review period frequency or sal review period has
3610: -- changed.
3611: --
3612: l_api_updating := per_asg_shd.api_updating
3613: (p_assignment_id => p_assignment_id
3614: ,p_effective_date => p_effective_date
3615: ,p_object_version_number => p_object_version_number);
3616: --

Line 3617: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,

3613: (p_assignment_id => p_assignment_id
3614: ,p_effective_date => p_effective_date
3615: ,p_object_version_number => p_object_version_number);
3616: --
3617: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3618: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3619: or
3620: nvl(per_asg_shd.g_old_rec.sal_review_period,
3621: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))

Line 3620: nvl(per_asg_shd.g_old_rec.sal_review_period,

3616: --
3617: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3618: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3619: or
3620: nvl(per_asg_shd.g_old_rec.sal_review_period,
3621: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))
3622: or
3623: (NOT l_api_updating)) then
3624: --

Line 3709: l_api_updating := per_asg_shd.api_updating

3705: -- Only proceed with validation if :
3706: -- a) The current g_old_rec is current and
3707: -- b) The value for set_of_books_id has changed
3708: --
3709: l_api_updating := per_asg_shd.api_updating
3710: (p_assignment_id => p_assignment_id
3711: ,p_effective_date => p_effective_date
3712: ,p_object_version_number => p_object_version_number
3713: );

Line 3717: nvl(per_asg_shd.g_old_rec.set_of_books_id,

3713: );
3714: hr_utility.set_location(l_proc, 30);
3715: --
3716: if ((l_api_updating and
3717: nvl(per_asg_shd.g_old_rec.set_of_books_id,
3718: hr_api.g_number) <> nvl(p_set_of_books_id, hr_api.g_number)) or
3719: (NOT l_api_updating))
3720: then
3721: hr_utility.set_location(l_proc, 40);

Line 3847: l_api_updating := per_asg_shd.api_updating

3843: -- a) The current g_old_rec is current and
3844: -- b) The value for soft coding keyflex has changed
3845: -- c) Soft coding keyflex is null and Payroll is populated. --#2182184
3846: --
3847: l_api_updating := per_asg_shd.api_updating
3848: (p_assignment_id => p_assignment_id
3849: ,p_effective_date => p_effective_date
3850: ,p_object_version_number => p_object_version_number
3851: );

Line 3855: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>

3851: );
3852: hr_utility.set_location(l_proc, 30);
3853: --
3854: if ((l_api_updating and
3855: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>
3856: nvl(p_soft_coding_keyflex_id, hr_api.g_number)) or
3857: --
3858: -- ****** Start new code for bug #2182184 **************************
3859: --

Line 4003: l_api_updating := per_asg_shd.api_updating

3999: -- Only proceed with validation if :
4000: -- a) The current g_old_rec is current and
4001: -- b) The value for source organization has changed
4002: --
4003: l_api_updating := per_asg_shd.api_updating
4004: (p_assignment_id => p_assignment_id
4005: ,p_effective_date => p_effective_date
4006: ,p_object_version_number => p_object_version_number
4007: );

Line 4011: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)

4007: );
4008: hr_utility.set_location(l_proc, 30);
4009: --
4010: if ((l_api_updating
4011: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)
4012: <> nvl(p_source_organization_id, hr_api.g_number))
4013: or
4014: (NOT l_api_updating))
4015: then

Line 4139: l_api_updating := per_asg_shd.api_updating

4135: -- Only proceed with validation if :
4136: -- a) The current g_old_rec is current and
4137: -- b) The value for source type has changed
4138: --
4139: l_api_updating := per_asg_shd.api_updating
4140: (p_assignment_id => p_assignment_id
4141: ,p_effective_date => p_effective_date
4142: ,p_object_version_number => p_object_version_number
4143: );

Line 4147: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>

4143: );
4144: hr_utility.set_location(l_proc, 30);
4145: --
4146: if ((l_api_updating and
4147: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>
4148: nvl(p_source_type, hr_api.g_varchar2))
4149: or (NOT l_api_updating))
4150: then
4151: hr_utility.set_location(l_proc, 40);

Line 4325: l_api_updating := per_asg_shd.api_updating

4321: -- Only proceed with validation if :
4322: -- a) The current g_old_rec is current and
4323: -- b) The value for special ceiling step has changed
4324: --
4325: l_api_updating := per_asg_shd.api_updating
4326: (p_assignment_id => p_assignment_id
4327: ,p_effective_date => p_effective_date
4328: ,p_object_version_number => p_object_version_number
4329: );

Line 4333: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>

4329: );
4330: hr_utility.set_location(l_proc, 30);
4331: --
4332: if ((l_api_updating and
4333: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>
4334: nvl(p_special_ceiling_step_id, hr_api.g_number)) or
4335: (NOT l_api_updating)) then
4336: hr_utility.set_location(l_proc, 40);
4337: --

Line 4550: l_api_updating := per_asg_shd.api_updating

4546: -- Only proceed with validation if :
4547: -- a) The current g_old_rec is current and
4548: -- b) The value for supervisor_id has changed
4549: --
4550: l_api_updating := per_asg_shd.api_updating
4551: (p_assignment_id => p_assignment_id
4552: ,p_effective_date => p_effective_date
4553: ,p_object_version_number => p_object_version_number
4554: );

Line 4558: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>

4554: );
4555: hr_utility.set_location(l_proc, 30);
4556: --
4557: if ((l_api_updating and
4558: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4559: nvl(p_supervisor_id, hr_api.g_number)) or
4560: (NOT l_api_updating))
4561: then
4562: hr_utility.set_location(l_proc, 40);

Line 4725: l_api_updating := per_asg_shd.api_updating

4721: -- Only proceed with validation if :
4722: -- a) The current g_old_rec is current and
4723: -- b) The value for supervisor_id has changed
4724: --
4725: l_api_updating := per_asg_shd.api_updating
4726: (p_assignment_id => p_assignment_id
4727: ,p_effective_date => p_effective_date
4728: ,p_object_version_number => p_object_version_number
4729: );

Line 4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>

4733: -- Re-validate if either the supervisor or supervisor assignment
4734: -- has changed.
4735: --
4736: if (l_api_updating and
4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4738: nvl(p_supervisor_id, hr_api.g_number))
4739: or
4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4741: nvl(p_supervisor_assignment_id, hr_api.g_number))) or

Line 4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>

4736: if (l_api_updating and
4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4738: nvl(p_supervisor_id, hr_api.g_number))
4739: or
4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4741: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4742: (NOT l_api_updating))
4743: then
4744:

Line 4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>

4743: then
4744:
4745: hr_utility.set_location(l_proc, 40);
4746: ----
4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4748: nvl(p_supervisor_id, hr_api.g_number))
4749: and
4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4751: nvl(p_supervisor_assignment_id, hr_api.g_number))) then

Line 4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =

4746: ----
4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4748: nvl(p_supervisor_id, hr_api.g_number))
4749: and
4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4751: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4752: p_supervisor_assignment_id := NULL;
4753: end if;
4754: ---

Line 5242: l_api_updating := per_asg_shd.api_updating

5238: -- Only proceed with validation if :
5239: -- a) The current g_old_rec is current and
5240: -- b) The value for vacancy has changed
5241: --
5242: l_api_updating := per_asg_shd.api_updating
5243: (p_assignment_id => p_assignment_id
5244: ,p_effective_date => p_effective_date
5245: ,p_object_version_number => p_object_version_number
5246: );

Line 5250: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>

5246: );
5247: hr_utility.set_location(l_proc, 30);
5248: --
5249: if ((l_api_updating and
5250: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>
5251: nvl(p_vacancy_id, hr_api.g_number)) or
5252: (NOT l_api_updating)) then
5253: hr_utility.set_location(l_proc, 40);
5254: --

Line 5527: l_api_updating := per_asg_shd.api_updating

5523: -- a) The current g_old_rec is current and
5524: -- b) One or more of the values for date probation end, probation period or
5525: -- probation unit has changed.
5526: --
5527: l_api_updating := per_asg_shd.api_updating
5528: (p_assignment_id => p_assignment_id
5529: ,p_effective_date => p_effective_date
5530: ,p_object_version_number => p_object_version_number
5531: );

Line 5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>

5533: --
5534: if NOT l_api_updating
5535: or
5536: (l_api_updating and
5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5538: nvl(p_date_probation_end, hr_api.g_date))
5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))

Line 5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>

5536: (l_api_updating and
5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5538: nvl(p_date_probation_end, hr_api.g_date))
5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))
5542: or
5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5544: nvl(p_probation_period, hr_api.g_number))))

Line 5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>

5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))
5542: or
5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5544: nvl(p_probation_period, hr_api.g_number))))
5545: then
5546: hr_utility.set_location(l_proc, 40);
5547: --

Line 5632: l_api_updating := per_asg_shd.api_updating

5628: -- Only proceed with validation if :
5629: -- a) The current g_old_rec is current and
5630: -- b) The value for internal address line has changed
5631: --
5632: l_api_updating := per_asg_shd.api_updating
5633: (p_assignment_id => p_assignment_id
5634: ,p_effective_date => p_effective_date
5635: ,p_object_version_number => p_object_version_number);
5636: hr_utility.set_location(l_proc, 30);

Line 5639: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)

5635: ,p_object_version_number => p_object_version_number);
5636: hr_utility.set_location(l_proc, 30);
5637: --
5638: if ((l_api_updating and
5639: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)
5640: <> nvl(p_internal_address_line, hr_api.g_varchar2))
5641: or
5642: (NOT l_api_updating)) then
5643: hr_utility.set_location(l_proc, 40);

Line 5698: l_api_updating := per_asg_shd.api_updating

5694: begin
5695: hr_utility.set_location('Entering:'|| l_proc, 10);
5696: --
5697: --
5698: l_api_updating := per_asg_shd.api_updating
5699: (p_assignment_id => p_assignment_id
5700: ,p_effective_date => p_effective_date
5701: ,p_object_version_number => p_object_version_number
5702: );

Line 5705: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>

5701: ,p_object_version_number => p_object_version_number
5702: );
5703: --
5704: if ((l_api_updating and
5705: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>
5706: nvl(p_applicant_rank, hr_api.g_number)) or
5707: (NOT l_api_updating)) then
5708:
5709: hr_utility.set_location(l_proc, 20);

Line 5794: l_api_updating := per_asg_shd.api_updating

5790: begin
5791: --
5792: hr_utility.set_location('Entering:'|| l_proc, 10);
5793: --
5794: l_api_updating := per_asg_shd.api_updating
5795: (p_assignment_id => p_assignment_id
5796: ,p_effective_date => p_effective_date
5797: ,p_object_version_number => p_object_version_number
5798: );

Line 5801: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>

5797: ,p_object_version_number => p_object_version_number
5798: );
5799: --
5800: if ((l_api_updating and
5801: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>
5802: nvl(p_posting_content_id, hr_api.g_number)) or
5803: (NOT l_api_updating)) then
5804:
5805: hr_utility.set_location(l_proc, 20);