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 409: l_api_updating := per_asg_shd.api_updating

405: ,p_argument_value => p_validation_end_date
406: );
407: hr_utility.set_location(l_proc, 20);
408: --
409: l_api_updating := per_asg_shd.api_updating
410: (p_assignment_id => p_assignment_id
411: ,p_effective_date => p_effective_date
412: ,p_object_version_number => p_object_version_number
413: );

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

413: );
414: hr_utility.set_location(l_proc, 30);
415: --
416: if (l_api_updating and
417: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
418: <> nvl(p_payroll_id, hr_api.g_number)) or
419: (per_asg_shd.g_old_rec.assignment_type='A' and
420: p_assignment_type='E')
421: )

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

415: --
416: if (l_api_updating and
417: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
418: <> nvl(p_payroll_id, hr_api.g_number)) or
419: (per_asg_shd.g_old_rec.assignment_type='A' and
420: p_assignment_type='E')
421: )
422: )
423: or NOT l_api_updating

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

424: then
425: hr_utility.set_location(l_proc, 40);
426: --
427: if (l_api_updating and
428: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
429: <> nvl(p_payroll_id, hr_api.g_number)) then
430: --
431: -- As payroll id has been updated, set p_payroll_id_updated to true.
432: -- This functionality is required for the /update/delete_assignment

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

571: close csr_any_future_changes;
572: hr_utility.set_location(l_proc, 90);
573: --
574: if (l_api_updating
575: and (per_asg_shd.g_old_rec.payroll_id is not null
576: and p_payroll_id is not null
577: and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id))
578: or (l_future_change
579: and (p_datetrack_mode = 'DELETE_NEXT_CHANGE'

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

573: --
574: if (l_api_updating
575: and (per_asg_shd.g_old_rec.payroll_id is not null
576: and p_payroll_id is not null
577: and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id))
578: or (l_future_change
579: and (p_datetrack_mode = 'DELETE_NEXT_CHANGE'
580: or p_datetrack_mode = 'FUTURE_CHANGE'
581: or p_datetrack_mode = 'UPDATE_OVERRIDE'

Line 789: -- and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id changed for bug 8404508

785: end if;
786: --
787: --
788: if (l_api_updating
789: -- and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id changed for bug 8404508
790: and NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
791: <> NVL(p_payroll_id,hr_api.g_number)
792: )
793: or (p_datetrack_mode = 'DELETE_NEXT_CHANGE'

Line 790: and NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)

786: --
787: --
788: if (l_api_updating
789: -- and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id changed for bug 8404508
790: and NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
791: <> NVL(p_payroll_id,hr_api.g_number)
792: )
793: or (p_datetrack_mode = 'DELETE_NEXT_CHANGE'
794: or p_datetrack_mode = 'FUTURE_CHANGE'

Line 906: l_api_updating := per_asg_shd.api_updating

902: -- Only proceed with validation if :
903: -- a) The current g_old_rec is current and
904: -- b) The value for people group has changed
905: --
906: l_api_updating := per_asg_shd.api_updating
907: (p_assignment_id => p_assignment_id
908: ,p_effective_date => p_effective_date
909: ,p_object_version_number => p_object_version_number
910: );

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

910: );
911: hr_utility.set_location(l_proc, 30);
912: --
913: if ((l_api_updating and
914: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>
915: nvl(p_people_group_id, hr_api.g_number)) or
916: (NOT l_api_updating))
917: then
918: hr_utility.set_location(l_proc, 40);

Line 1025: l_api_updating := per_asg_shd.api_updating

1021: -- Only proceed with validation if :
1022: -- a) The current g_old_rec is current and
1023: -- b) The value for performance review period frequency has changed
1024: --
1025: l_api_updating := per_asg_shd.api_updating
1026: (p_assignment_id => p_assignment_id
1027: ,p_effective_date => p_effective_date
1028: ,p_object_version_number => p_object_version_number
1029: );

Line 1033: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,

1029: );
1030: hr_utility.set_location(l_proc, 30);
1031: --
1032: if ((l_api_updating and
1033: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1034: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency,
1035: hr_api.g_varchar2))
1036: or
1037: (NOT l_api_updating))

Line 1122: l_api_updating := per_asg_shd.api_updating

1118: -- Only proceed with validation if :
1119: -- a) The current g_old_rec is current and
1120: -- b) The value for perf review period has changed
1121: --
1122: l_api_updating := per_asg_shd.api_updating
1123: (p_assignment_id => p_assignment_id
1124: ,p_effective_date => p_effective_date
1125: ,p_object_version_number => p_object_version_number);
1126: --

Line 1130: nvl(per_asg_shd.g_old_rec.perf_review_period,

1126: --
1127: hr_utility.set_location(l_proc, 2);
1128: --
1129: if ((l_api_updating and
1130: nvl(per_asg_shd.g_old_rec.perf_review_period,
1131: hr_api.g_number) <> nvl(p_perf_review_period,
1132: hr_api.g_number))
1133: or (NOT l_api_updating))
1134: then

Line 1205: l_api_updating := per_asg_shd.api_updating

1201: );
1202: --
1203: -- Check if the assignment is being updated.
1204: --
1205: l_api_updating := per_asg_shd.api_updating
1206: (p_assignment_id => p_assignment_id
1207: ,p_effective_date => p_effective_date
1208: ,p_object_version_number => p_object_version_number);
1209: --

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

1213: -- changed.
1214: --
1215: if ((l_api_updating)
1216: and
1217: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1218: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1219: or
1220: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1221: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))

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

1216: and
1217: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1218: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1219: or
1220: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1221: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))
1222: or
1223: (NOT l_api_updating)) then
1224: --

Line 1327: l_api_updating := per_asg_shd.api_updating

1323: hr_utility.set_location(l_proc, 20);
1324: --
1325: -- Check if the assignment is being updated.
1326: --
1327: l_api_updating := per_asg_shd.api_updating
1328: (p_assignment_id => p_assignment_id
1329: ,p_effective_date => p_effective_date
1330: ,p_object_version_number => p_object_version_number
1331: );

Line 1539: l_api_updating := per_asg_shd.api_updating

1535: -- Only proceed with validation if :
1536: -- a) The current g_old_rec is current and
1537: -- b) The value for person referred by has changed
1538: --
1539: l_api_updating := per_asg_shd.api_updating
1540: (p_assignment_id => p_assignment_id
1541: ,p_effective_date => p_effective_date
1542: ,p_object_version_number => p_object_version_number);
1543: hr_utility.set_location(l_proc, 30);

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

1542: ,p_object_version_number => p_object_version_number);
1543: hr_utility.set_location(l_proc, 30);
1544: --
1545: if ((l_api_updating and
1546: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)
1547: <> nvl(p_person_referred_by_id, hr_api.g_number)) or
1548: (NOT l_api_updating)) then
1549: hr_utility.set_location(l_proc, 40);
1550: --

Line 1723: l_api_updating := per_asg_shd.api_updating

1719: -- Only proceed with validation if :
1720: -- a) The current g_old_rec is current and
1721: -- b) The value for position_id has changed
1722: --
1723: l_api_updating := per_asg_shd.api_updating
1724: (p_assignment_id => p_assignment_id
1725: ,p_effective_date => p_effective_date
1726: ,p_object_version_number => p_object_version_number);
1727: --

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

1726: ,p_object_version_number => p_object_version_number);
1727: --
1728: if ((l_api_updating
1729: and
1730: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1731: nvl(p_position_id, hr_api.g_number))
1732: or
1733: (NOT l_api_updating)) then
1734: hr_utility.set_location(l_proc, 30);

Line 1855: l_api_updating := per_asg_shd.api_updating

1851: -- Only proceed with validation if :
1852: -- a) The current g_old_rec is current and
1853: -- b) The value for position_id or grade_id has changed
1854: --
1855: l_api_updating := per_asg_shd.api_updating
1856: (p_assignment_id => p_assignment_id
1857: ,p_effective_date => p_effective_date
1858: ,p_object_version_number => p_object_version_number);
1859: --

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

1857: ,p_effective_date => p_effective_date
1858: ,p_object_version_number => p_object_version_number);
1859: --
1860: if (l_api_updating and
1861: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1862: nvl(p_position_id, hr_api.g_number))
1863: or
1864: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1865: nvl(p_grade_id, hr_api.g_number))))

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

1860: if (l_api_updating and
1861: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1862: nvl(p_position_id, hr_api.g_number))
1863: or
1864: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1865: nvl(p_grade_id, hr_api.g_number))))
1866: or
1867: (NOT l_api_updating) then
1868: --

Line 1980: l_api_updating := per_asg_shd.api_updating

1976: -- Only proceed with validation if :
1977: -- a) The current g_old_rec is current and
1978: -- b) The value for position_id or grade_id has changed
1979: --
1980: l_api_updating := per_asg_shd.api_updating
1981: (p_assignment_id => p_assignment_id
1982: ,p_effective_date => p_effective_date
1983: ,p_object_version_number => p_object_version_number);
1984: --

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

1983: ,p_object_version_number => p_object_version_number);
1984: --
1985:
1986: if (l_api_updating and
1987: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1988: nvl(p_position_id, hr_api.g_number))
1989: or
1990: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1991: nvl(p_organization_id, hr_api.g_number))))

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

1986: if (l_api_updating and
1987: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1988: nvl(p_position_id, hr_api.g_number))
1989: or
1990: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1991: nvl(p_organization_id, hr_api.g_number))))
1992: or
1993: (NOT l_api_updating) then
1994: --

Line 2100: l_api_updating := per_asg_shd.api_updating

2096: -- Only proceed with validation if :
2097: -- a) The current g_old_rec is current and
2098: -- b) The value for position or job has changed
2099: --
2100: l_api_updating := per_asg_shd.api_updating
2101: (p_assignment_id => p_assignment_id
2102: ,p_effective_date => p_effective_date
2103: ,p_object_version_number => p_object_version_number);
2104: hr_utility.set_location(l_proc, 30);

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

2103: ,p_object_version_number => p_object_version_number);
2104: hr_utility.set_location(l_proc, 30);
2105: --
2106: if (l_api_updating and
2107: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2108: nvl(p_position_id, hr_api.g_number))
2109: or
2110: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2111: nvl(p_job_id, hr_api.g_number))))

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

2106: if (l_api_updating and
2107: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2108: nvl(p_position_id, hr_api.g_number))
2109: or
2110: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2111: nvl(p_job_id, hr_api.g_number))))
2112: or
2113: (NOT l_api_updating)
2114: then

Line 2205: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id

2201: --
2202: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2203: SELECT per_system_status
2204: FROM per_ass_status_type_amends
2205: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id
2206: AND business_group_id = csr_chk_amends.p_bg_id;
2207: --
2208: CURSOR csr_valid_ast IS
2209: SELECT per_system_status

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

2207: --
2208: CURSOR csr_valid_ast IS
2209: SELECT per_system_status
2210: FROM per_assignment_status_types
2211: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
2212: --
2213: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2214: --
2215: -- 120.10 (END)

Line 2310: l_api_updating := per_asg_shd.api_updating

2306: -- Only proceed with validation if :
2307: -- a) The current g_old_rec is current and
2308: -- b) The value for primary flag has changed
2309: --
2310: l_api_updating := per_asg_shd.api_updating
2311: (p_assignment_id => p_assignment_id
2312: ,p_effective_date => p_effective_date
2313: ,p_object_version_number => p_object_version_number);
2314: --

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

2314: --
2315: hr_utility.set_location(l_proc, 30);
2316: --
2317: if ((l_api_updating and
2318: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>
2319: nvl(p_primary_flag, hr_api.g_varchar2)) or
2320: (NOT l_api_updating)) then
2321: --
2322: -- Check if primary flag is either 'Y' or 'N'.

Line 2326: per_asg_shd.constraint_error

2322: -- Check if primary flag is either 'Y' or 'N'.
2323: --
2324: If p_primary_flag not in('Y','N') then
2325: --
2326: per_asg_shd.constraint_error
2327: (p_constraint_name => 'PER_ASS_PRIMARY_FLAG_CHK');
2328: --
2329: hr_utility.set_location(l_proc, 30);
2330: --

Line 2582: l_api_updating := per_asg_shd.api_updating

2578: -- Only proceed with validation if :
2579: -- a) The current g_old_rec is current and
2580: -- b) The value for probation period has changed
2581: --
2582: l_api_updating := per_asg_shd.api_updating
2583: (p_assignment_id => p_assignment_id
2584: ,p_effective_date => p_effective_date
2585: ,p_object_version_number => p_object_version_number
2586: );

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

2586: );
2587: hr_utility.set_location(l_proc, 30);
2588: --
2589: if ((l_api_updating and
2590: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2591: <> nvl(p_probation_period, hr_api.g_number))
2592: or
2593: (NOT l_api_updating))
2594: then

Line 2670: l_api_updating := per_asg_shd.api_updating

2666: -- Only proceed with validation if :
2667: -- a) The current g_old_rec is current and
2668: -- b) The value for probation unit has changed
2669: --
2670: l_api_updating := per_asg_shd.api_updating
2671: (p_assignment_id => p_assignment_id
2672: ,p_effective_date => p_effective_date
2673: ,p_object_version_number => p_object_version_number
2674: );

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

2674: );
2675: hr_utility.set_location(l_proc, 30);
2676: --
2677: if ((l_api_updating and
2678: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2679: <> nvl(p_probation_unit, hr_api.g_varchar2))
2680: or
2681: (NOT l_api_updating))
2682: then

Line 2759: l_api_updating := per_asg_shd.api_updating

2755: -- Only proceed with validation if :
2756: -- a) The current g_old_rec is current and
2757: -- b) The value for probation unit or probation period changed.
2758: --
2759: l_api_updating := per_asg_shd.api_updating
2760: (p_assignment_id => p_assignment_id
2761: ,p_effective_date => p_effective_date
2762: ,p_object_version_number => p_object_version_number);
2763: --

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

2762: ,p_object_version_number => p_object_version_number);
2763: --
2764: if ((l_api_updating
2765: and
2766: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2767: <> nvl(p_probation_unit, hr_api.g_varchar2)
2768: or
2769: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2770: <> nvl(p_probation_period, hr_api.g_number))

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

2765: and
2766: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2767: <> nvl(p_probation_unit, hr_api.g_varchar2)
2768: or
2769: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2770: <> nvl(p_probation_period, hr_api.g_number))
2771: or
2772: (NOT l_api_updating)) then
2773: --

Line 2874: l_api_updating := per_asg_shd.api_updating

2870: -- Only proceed with validation if :
2871: -- a) The current g_old_rec is current and
2872: -- b) The value for recruiter has changed
2873: --
2874: l_api_updating := per_asg_shd.api_updating
2875: (p_assignment_id => p_assignment_id
2876: ,p_effective_date => p_effective_date
2877: ,p_object_version_number => p_object_version_number);
2878: hr_utility.set_location(l_proc, 50);

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

2877: ,p_object_version_number => p_object_version_number);
2878: hr_utility.set_location(l_proc, 50);
2879: --
2880: if ((l_api_updating and
2881: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>
2882: nvl(p_recruiter_id, hr_api.g_number)) or
2883: (NOT l_api_updating)) then
2884: hr_utility.set_location(l_proc, 60);
2885: --

Line 3029: l_api_updating := per_asg_shd.api_updating

3025: -- Only proceed with validation if :
3026: -- a) The current g_old_rec is current and
3027: -- b) The value for recruitment activity has changed
3028: --
3029: l_api_updating := per_asg_shd.api_updating
3030: (p_assignment_id => p_assignment_id
3031: ,p_effective_date => p_effective_date
3032: ,p_object_version_number => p_object_version_number
3033: );

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

3033: );
3034: hr_utility.set_location(l_proc, 30);
3035: --
3036: if ((l_api_updating and
3037: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>
3038: nvl(p_recruitment_activity_id, hr_api.g_number)) or
3039: (NOT l_api_updating))
3040: then
3041: hr_utility.set_location(l_proc, 40);

Line 3473: l_api_updating := per_asg_shd.api_updating

3469: -- Only proceed with validation if :
3470: -- a) The current g_old_rec is current and
3471: -- b) The value for salary review period frequency has changed
3472: --
3473: l_api_updating := per_asg_shd.api_updating
3474: (p_assignment_id => p_assignment_id
3475: ,p_effective_date => p_effective_date
3476: ,p_object_version_number => p_object_version_number
3477: );

Line 3481: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,

3477: );
3478: hr_utility.set_location(l_proc, 30);
3479: --
3480: if ((l_api_updating and
3481: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3482: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency,
3483: hr_api.g_varchar2))
3484: or
3485: (NOT l_api_updating))

Line 3569: l_api_updating := per_asg_shd.api_updating

3565: -- Only proceed with validation if :
3566: -- a) The current g_old_rec is current and
3567: -- b) The value for perf review period has changed
3568: --
3569: l_api_updating := per_asg_shd.api_updating
3570: (p_assignment_id => p_assignment_id
3571: ,p_effective_date => p_effective_date
3572: ,p_object_version_number => p_object_version_number);
3573: --

Line 3577: nvl(per_asg_shd.g_old_rec.sal_review_period,

3573: --
3574: hr_utility.set_location(l_proc, 2);
3575: --
3576: if ((l_api_updating and
3577: nvl(per_asg_shd.g_old_rec.sal_review_period,
3578: hr_api.g_number) <> nvl(p_sal_review_period,
3579: hr_api.g_number)) or (NOT l_api_updating)) then
3580: --
3581: hr_utility.set_location(l_proc, 3);

Line 3652: l_api_updating := per_asg_shd.api_updating

3648: -- a) The current g_old_rec is current and
3649: -- b) The value for sal review period frequency or sal review period has
3650: -- changed.
3651: --
3652: l_api_updating := per_asg_shd.api_updating
3653: (p_assignment_id => p_assignment_id
3654: ,p_effective_date => p_effective_date
3655: ,p_object_version_number => p_object_version_number);
3656: --

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

3653: (p_assignment_id => p_assignment_id
3654: ,p_effective_date => p_effective_date
3655: ,p_object_version_number => p_object_version_number);
3656: --
3657: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3658: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3659: or
3660: nvl(per_asg_shd.g_old_rec.sal_review_period,
3661: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))

Line 3660: nvl(per_asg_shd.g_old_rec.sal_review_period,

3656: --
3657: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3658: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3659: or
3660: nvl(per_asg_shd.g_old_rec.sal_review_period,
3661: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))
3662: or
3663: (NOT l_api_updating)) then
3664: --

Line 3749: l_api_updating := per_asg_shd.api_updating

3745: -- Only proceed with validation if :
3746: -- a) The current g_old_rec is current and
3747: -- b) The value for set_of_books_id has changed
3748: --
3749: l_api_updating := per_asg_shd.api_updating
3750: (p_assignment_id => p_assignment_id
3751: ,p_effective_date => p_effective_date
3752: ,p_object_version_number => p_object_version_number
3753: );

Line 3757: nvl(per_asg_shd.g_old_rec.set_of_books_id,

3753: );
3754: hr_utility.set_location(l_proc, 30);
3755: --
3756: if ((l_api_updating and
3757: nvl(per_asg_shd.g_old_rec.set_of_books_id,
3758: hr_api.g_number) <> nvl(p_set_of_books_id, hr_api.g_number)) or
3759: (NOT l_api_updating))
3760: then
3761: hr_utility.set_location(l_proc, 40);

Line 3887: l_api_updating := per_asg_shd.api_updating

3883: -- a) The current g_old_rec is current and
3884: -- b) The value for soft coding keyflex has changed
3885: -- c) Soft coding keyflex is null and Payroll is populated. --#2182184
3886: --
3887: l_api_updating := per_asg_shd.api_updating
3888: (p_assignment_id => p_assignment_id
3889: ,p_effective_date => p_effective_date
3890: ,p_object_version_number => p_object_version_number
3891: );

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

3891: );
3892: hr_utility.set_location(l_proc, 30);
3893: --
3894: if ((l_api_updating and
3895: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>
3896: nvl(p_soft_coding_keyflex_id, hr_api.g_number)) or
3897: --
3898: -- ****** Start new code for bug #2182184 **************************
3899: --

Line 4043: l_api_updating := per_asg_shd.api_updating

4039: -- Only proceed with validation if :
4040: -- a) The current g_old_rec is current and
4041: -- b) The value for source organization has changed
4042: --
4043: l_api_updating := per_asg_shd.api_updating
4044: (p_assignment_id => p_assignment_id
4045: ,p_effective_date => p_effective_date
4046: ,p_object_version_number => p_object_version_number
4047: );

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

4047: );
4048: hr_utility.set_location(l_proc, 30);
4049: --
4050: if ((l_api_updating
4051: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)
4052: <> nvl(p_source_organization_id, hr_api.g_number))
4053: or
4054: (NOT l_api_updating))
4055: then

Line 4179: l_api_updating := per_asg_shd.api_updating

4175: -- Only proceed with validation if :
4176: -- a) The current g_old_rec is current and
4177: -- b) The value for source type has changed
4178: --
4179: l_api_updating := per_asg_shd.api_updating
4180: (p_assignment_id => p_assignment_id
4181: ,p_effective_date => p_effective_date
4182: ,p_object_version_number => p_object_version_number
4183: );

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

4183: );
4184: hr_utility.set_location(l_proc, 30);
4185: --
4186: if ((l_api_updating and
4187: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>
4188: nvl(p_source_type, hr_api.g_varchar2))
4189: or (NOT l_api_updating))
4190: then
4191: hr_utility.set_location(l_proc, 40);

Line 4365: l_api_updating := per_asg_shd.api_updating

4361: -- Only proceed with validation if :
4362: -- a) The current g_old_rec is current and
4363: -- b) The value for special ceiling step has changed
4364: --
4365: l_api_updating := per_asg_shd.api_updating
4366: (p_assignment_id => p_assignment_id
4367: ,p_effective_date => p_effective_date
4368: ,p_object_version_number => p_object_version_number
4369: );

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

4369: );
4370: hr_utility.set_location(l_proc, 30);
4371: --
4372: if ((l_api_updating and
4373: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>
4374: nvl(p_special_ceiling_step_id, hr_api.g_number)) or
4375: (NOT l_api_updating)) then
4376: hr_utility.set_location(l_proc, 40);
4377: --

Line 4600: l_api_updating := per_asg_shd.api_updating

4596: -- Only proceed with validation if :
4597: -- a) The current g_old_rec is current and
4598: -- b) The value for supervisor_id has changed
4599: --
4600: l_api_updating := per_asg_shd.api_updating
4601: (p_assignment_id => p_assignment_id
4602: ,p_effective_date => p_effective_date
4603: ,p_object_version_number => p_object_version_number
4604: );

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

4604: );
4605: hr_utility.set_location(l_proc, 30);
4606: --
4607: if ((l_api_updating and
4608: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4609: nvl(p_supervisor_id, hr_api.g_number)) or
4610: (NOT l_api_updating))
4611: then
4612: hr_utility.set_location(l_proc, 40);

Line 4798: l_api_updating := per_asg_shd.api_updating

4794: -- Only proceed with validation if :
4795: -- a) The current g_old_rec is current and
4796: -- b) The value for supervisor_id has changed
4797: --
4798: l_api_updating := per_asg_shd.api_updating
4799: (p_assignment_id => p_assignment_id
4800: ,p_effective_date => p_effective_date
4801: ,p_object_version_number => p_object_version_number
4802: );

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

4806: -- Re-validate if either the supervisor or supervisor assignment
4807: -- has changed.
4808: --
4809: if (l_api_updating and
4810: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4811: nvl(p_supervisor_id, hr_api.g_number))
4812: or
4813: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4814: nvl(p_supervisor_assignment_id, hr_api.g_number))) or

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

4809: if (l_api_updating and
4810: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4811: nvl(p_supervisor_id, hr_api.g_number))
4812: or
4813: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4814: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4815: (NOT l_api_updating))
4816: then
4817:

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

4816: then
4817:
4818: hr_utility.set_location(l_proc, 40);
4819: ----
4820: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4821: nvl(p_supervisor_id, hr_api.g_number))
4822: and
4823: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4824: nvl(p_supervisor_assignment_id, hr_api.g_number))) then

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

4819: ----
4820: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4821: nvl(p_supervisor_id, hr_api.g_number))
4822: and
4823: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4824: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4825: p_supervisor_assignment_id := NULL;
4826: end if;
4827: ---

Line 5447: l_api_updating := per_asg_shd.api_updating

5443: -- Only proceed with validation if :
5444: -- a) The current g_old_rec is current and
5445: -- b) The value for vacancy has changed
5446: --
5447: l_api_updating := per_asg_shd.api_updating
5448: (p_assignment_id => p_assignment_id
5449: ,p_effective_date => p_effective_date
5450: ,p_object_version_number => p_object_version_number
5451: );

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

5451: );
5452: hr_utility.set_location(l_proc, 30);
5453: --
5454: if ((l_api_updating and
5455: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>
5456: nvl(p_vacancy_id, hr_api.g_number)) or
5457: (NOT l_api_updating)) then
5458: hr_utility.set_location(l_proc, 40);
5459: --

Line 5732: l_api_updating := per_asg_shd.api_updating

5728: -- a) The current g_old_rec is current and
5729: -- b) One or more of the values for date probation end, probation period or
5730: -- probation unit has changed.
5731: --
5732: l_api_updating := per_asg_shd.api_updating
5733: (p_assignment_id => p_assignment_id
5734: ,p_effective_date => p_effective_date
5735: ,p_object_version_number => p_object_version_number
5736: );

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

5738: --
5739: if NOT l_api_updating
5740: or
5741: (l_api_updating and
5742: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5743: nvl(p_date_probation_end, hr_api.g_date))
5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))

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

5741: (l_api_updating and
5742: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5743: nvl(p_date_probation_end, hr_api.g_date))
5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))
5747: or
5748: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5749: nvl(p_probation_period, hr_api.g_number))))

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

5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))
5747: or
5748: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5749: nvl(p_probation_period, hr_api.g_number))))
5750: then
5751: hr_utility.set_location(l_proc, 40);
5752: --

Line 5837: l_api_updating := per_asg_shd.api_updating

5833: -- Only proceed with validation if :
5834: -- a) The current g_old_rec is current and
5835: -- b) The value for internal address line has changed
5836: --
5837: l_api_updating := per_asg_shd.api_updating
5838: (p_assignment_id => p_assignment_id
5839: ,p_effective_date => p_effective_date
5840: ,p_object_version_number => p_object_version_number);
5841: hr_utility.set_location(l_proc, 30);

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

5840: ,p_object_version_number => p_object_version_number);
5841: hr_utility.set_location(l_proc, 30);
5842: --
5843: if ((l_api_updating and
5844: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)
5845: <> nvl(p_internal_address_line, hr_api.g_varchar2))
5846: or
5847: (NOT l_api_updating)) then
5848: hr_utility.set_location(l_proc, 40);

Line 5903: l_api_updating := per_asg_shd.api_updating

5899: begin
5900: hr_utility.set_location('Entering:'|| l_proc, 10);
5901: --
5902: --
5903: l_api_updating := per_asg_shd.api_updating
5904: (p_assignment_id => p_assignment_id
5905: ,p_effective_date => p_effective_date
5906: ,p_object_version_number => p_object_version_number
5907: );

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

5906: ,p_object_version_number => p_object_version_number
5907: );
5908: --
5909: if ((l_api_updating and
5910: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>
5911: nvl(p_applicant_rank, hr_api.g_number)) or
5912: (NOT l_api_updating)) then
5913:
5914: hr_utility.set_location(l_proc, 20);

Line 5999: l_api_updating := per_asg_shd.api_updating

5995: begin
5996: --
5997: hr_utility.set_location('Entering:'|| l_proc, 10);
5998: --
5999: l_api_updating := per_asg_shd.api_updating
6000: (p_assignment_id => p_assignment_id
6001: ,p_effective_date => p_effective_date
6002: ,p_object_version_number => p_object_version_number
6003: );

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

6002: ,p_object_version_number => p_object_version_number
6003: );
6004: --
6005: if ((l_api_updating and
6006: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>
6007: nvl(p_posting_content_id, hr_api.g_number)) or
6008: (NOT l_api_updating)) then
6009:
6010: hr_utility.set_location(l_proc, 20);