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.HR_PSF_BUS dependencies on HR_API

Line 46: hr_api.mandatory_arg_error(p_api_name => l_proc,

42: end if;
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error(p_api_name => l_proc,
47: p_argument => 'position_id',
48: p_argument_value => p_position_id);
49: --
50: open csr_sec_grp;

Line 64: hr_api.set_security_group_id

60: close csr_sec_grp;
61: --
62: -- Set the security_group_id in CLIENT_INFO
63: --
64: hr_api.set_security_group_id
65: (p_security_group_id => l_security_group_id
66: );
67: --
68: if g_debug then

Line 116: hr_api.mandatory_arg_error

112: end if;
113: --
114: -- Check mandatory parameters have been set
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'date_effective'
119: ,p_argument_value => p_date_effective
120: );

Line 126: hr_api.mandatory_arg_error

122: if g_debug then
123: hr_utility.set_location(l_proc, 10);
124: end if;
125: --
126: hr_api.mandatory_arg_error
127: (p_api_name => l_proc
128: ,p_argument => 'validation_start_date'
129: ,p_argument_value => p_validation_start_date
130: );

Line 730: hr_api.mandatory_arg_error

726: end if;
727: --
728: -- Check mandatory parameters have been set
729: --
730: hr_api.mandatory_arg_error
731: (p_api_name => l_proc
732: ,p_argument => 'validation_start_date'
733: ,p_argument_value => p_validation_start_date
734: );

Line 736: hr_api.mandatory_arg_error

732: ,p_argument => 'validation_start_date'
733: ,p_argument_value => p_validation_start_date
734: );
735: --
736: hr_api.mandatory_arg_error
737: (p_api_name => l_proc
738: ,p_argument => 'validation_end_date'
739: ,p_argument_value => p_validation_end_date
740: );

Line 742: hr_api.mandatory_arg_error

738: ,p_argument => 'validation_end_date'
739: ,p_argument_value => p_validation_end_date
740: );
741: --
742: hr_api.mandatory_arg_error
743: (p_api_name => l_proc
744: ,p_argument => 'effective_date'
745: ,p_argument_value => p_effective_date
746: );

Line 748: hr_api.mandatory_arg_error

744: ,p_argument => 'effective_date'
745: ,p_argument_value => p_effective_date
746: );
747: --
748: hr_api.mandatory_arg_error
749: (p_api_name => l_proc
750: ,p_argument => 'business_group_id'
751: ,p_argument_value => p_business_group_id
752: );

Line 771: nvl(hr_psf_shd.g_old_rec.entry_step_id, hr_api.g_number) <>

767: hr_utility.set_location(l_proc, 30);
768: end if;
769: --
770: if ((l_api_updating and
771: nvl(hr_psf_shd.g_old_rec.entry_step_id, hr_api.g_number) <>
772: nvl(p_entry_step_id, hr_api.g_number)) or
773: (NOT l_api_updating)) then
774: if g_debug then
775: hr_utility.set_location(l_proc, 40);

Line 772: nvl(p_entry_step_id, hr_api.g_number)) or

768: end if;
769: --
770: if ((l_api_updating and
771: nvl(hr_psf_shd.g_old_rec.entry_step_id, hr_api.g_number) <>
772: nvl(p_entry_step_id, hr_api.g_number)) or
773: (NOT l_api_updating)) then
774: if g_debug then
775: hr_utility.set_location(l_proc, 40);
776: end if;

Line 875: between date_from and nvl(date_to, hr_api.g_eot);

871: select business_group_id
872: from per_grades
873: where grade_id = p_entry_grade_id
874: and p_validation_start_date
875: between date_from and nvl(date_to, hr_api.g_eot);
876: --
877: begin
878: if g_debug then
879: l_proc := g_package||'chk_entry_grade_id';

Line 886: hr_api.mandatory_arg_error

882:
883: --
884: -- Check mandatory parameters have been set
885: --
886: hr_api.mandatory_arg_error
887: (p_api_name => l_proc
888: ,p_argument => 'effective_date'
889: ,p_argument_value => p_effective_date
890: );

Line 892: hr_api.mandatory_arg_error

888: ,p_argument => 'effective_date'
889: ,p_argument_value => p_effective_date
890: );
891: --
892: hr_api.mandatory_arg_error
893: (p_api_name => l_proc
894: ,p_argument => 'validation_start_date'
895: ,p_argument_value => p_validation_start_date
896: );

Line 898: hr_api.mandatory_arg_error

894: ,p_argument => 'validation_start_date'
895: ,p_argument_value => p_validation_start_date
896: );
897: --
898: hr_api.mandatory_arg_error
899: (p_api_name => l_proc
900: ,p_argument => 'validation_end_date'
901: ,p_argument_value => p_validation_end_date
902: );

Line 904: hr_api.mandatory_arg_error

900: ,p_argument => 'validation_end_date'
901: ,p_argument_value => p_validation_end_date
902: );
903: --
904: hr_api.mandatory_arg_error
905: (p_api_name => l_proc
906: ,p_argument => 'business_group_id'
907: ,p_argument_value => p_business_group_id
908: );

Line 927: nvl(hr_psf_shd.g_old_rec.entry_grade_id, hr_api.g_number) <>

923: hr_utility.set_location(l_proc, 30);
924: end if;
925: --
926: if ((l_api_updating and
927: nvl(hr_psf_shd.g_old_rec.entry_grade_id, hr_api.g_number) <>
928: nvl(p_entry_grade_id, hr_api.g_number)) or
929: (NOT l_api_updating)) then
930: if g_debug then
931: hr_utility.set_location(l_proc, 40);

Line 928: nvl(p_entry_grade_id, hr_api.g_number)) or

924: end if;
925: --
926: if ((l_api_updating and
927: nvl(hr_psf_shd.g_old_rec.entry_grade_id, hr_api.g_number) <>
928: nvl(p_entry_grade_id, hr_api.g_number)) or
929: (NOT l_api_updating)) then
930: if g_debug then
931: hr_utility.set_location(l_proc, 40);
932: end if;

Line 1016: hr_api.mandatory_arg_error

1012:
1013: --
1014: -- Check mandatory parameters have been set
1015: --
1016: hr_api.mandatory_arg_error
1017: (p_api_name => l_proc
1018: ,p_argument => 'effective_date'
1019: ,p_argument_value => p_effective_date
1020: );

Line 1022: hr_api.mandatory_arg_error

1018: ,p_argument => 'effective_date'
1019: ,p_argument_value => p_effective_date
1020: );
1021: --
1022: hr_api.mandatory_arg_error
1023: (p_api_name => l_proc
1024: ,p_argument => 'validation_start_date'
1025: ,p_argument_value => p_validation_start_date
1026: );

Line 1028: hr_api.mandatory_arg_error

1024: ,p_argument => 'validation_start_date'
1025: ,p_argument_value => p_validation_start_date
1026: );
1027: --
1028: hr_api.mandatory_arg_error
1029: (p_api_name => l_proc
1030: ,p_argument => 'validation_end_date'
1031: ,p_argument_value => p_validation_end_date
1032: );

Line 1034: hr_api.mandatory_arg_error

1030: ,p_argument => 'validation_end_date'
1031: ,p_argument_value => p_validation_end_date
1032: );
1033: --
1034: hr_api.mandatory_arg_error
1035: (p_api_name => l_proc
1036: ,p_argument => 'business_group_id'
1037: ,p_argument_value => p_business_group_id
1038: );

Line 1057: nvl(hr_psf_shd.g_old_rec.entry_grade_rule_id, hr_api.g_number) <>

1053: hr_utility.set_location(l_proc, 30);
1054: end if;
1055: --
1056: if ((l_api_updating and
1057: nvl(hr_psf_shd.g_old_rec.entry_grade_rule_id, hr_api.g_number) <>
1058: nvl(p_entry_grade_rule_id, hr_api.g_number)) or
1059: (NOT l_api_updating)) then
1060: if g_debug then
1061: hr_utility.set_location(l_proc, 40);

Line 1058: nvl(p_entry_grade_rule_id, hr_api.g_number)) or

1054: end if;
1055: --
1056: if ((l_api_updating and
1057: nvl(hr_psf_shd.g_old_rec.entry_grade_rule_id, hr_api.g_number) <>
1058: nvl(p_entry_grade_rule_id, hr_api.g_number)) or
1059: (NOT l_api_updating)) then
1060: if g_debug then
1061: hr_utility.set_location(l_proc, 40);
1062: end if;

Line 1158: hr_api.mandatory_arg_error

1154: end if;
1155: --
1156: -- Check mandatory parameters have been set
1157: --
1158: hr_api.mandatory_arg_error
1159: (p_api_name => l_proc
1160: ,p_argument => 'business_group_id'
1161: ,p_argument_value => p_business_group_id
1162: );

Line 1164: hr_api.mandatory_arg_error

1160: ,p_argument => 'business_group_id'
1161: ,p_argument_value => p_business_group_id
1162: );
1163: --
1164: hr_api.mandatory_arg_error
1165: (p_api_name => l_proc
1166: ,p_argument => 'validation_start_date'
1167: ,p_argument_value => p_validation_start_date
1168: );

Line 1170: hr_api.mandatory_arg_error

1166: ,p_argument => 'validation_start_date'
1167: ,p_argument_value => p_validation_start_date
1168: );
1169: --
1170: hr_api.mandatory_arg_error
1171: (p_api_name => l_proc
1172: ,p_argument => 'effective_date'
1173: ,p_argument_value => p_effective_date
1174: );

Line 1176: hr_api.mandatory_arg_error

1172: ,p_argument => 'effective_date'
1173: ,p_argument_value => p_effective_date
1174: );
1175: --
1176: hr_api.mandatory_arg_error
1177: (p_api_name => l_proc
1178: ,p_argument => 'validation_end_date'
1179: ,p_argument_value => p_validation_end_date
1180: );

Line 1195: (nvl(hr_psf_shd.g_old_rec.pay_freq_payroll_id, hr_api.g_number)

1191: hr_utility.set_location(l_proc, 30);
1192: end if;
1193: --
1194: if (l_api_updating and
1195: (nvl(hr_psf_shd.g_old_rec.pay_freq_payroll_id, hr_api.g_number)
1196: <> nvl(p_pay_freq_payroll_id, hr_api.g_number))
1197: )
1198: or NOT l_api_updating
1199: then

Line 1196: <> nvl(p_pay_freq_payroll_id, hr_api.g_number))

1192: end if;
1193: --
1194: if (l_api_updating and
1195: (nvl(hr_psf_shd.g_old_rec.pay_freq_payroll_id, hr_api.g_number)
1196: <> nvl(p_pay_freq_payroll_id, hr_api.g_number))
1197: )
1198: or NOT l_api_updating
1199: then
1200: if g_debug then

Line 1320: hr_api.mandatory_arg_error

1316: end if;
1317: --
1318: -- Check mandatory parameters have been set
1319: --
1320: hr_api.mandatory_arg_error
1321: (p_api_name => l_proc
1322: ,p_argument => 'business_group_id'
1323: ,p_argument_value => p_business_group_id
1324: );

Line 1329: hr_api.mandatory_arg_error

1325: if g_debug then
1326: hr_utility.set_location(l_proc, 20);
1327: end if;
1328: --
1329: hr_api.mandatory_arg_error
1330: (p_api_name => l_proc
1331: ,p_argument => 'position_definition_id'
1332: ,p_argument_value => p_position_definition_id
1333: );

Line 1338: hr_api.mandatory_arg_error

1334: if g_debug then
1335: hr_utility.set_location(l_proc, 30);
1336: end if;
1337: --
1338: hr_api.mandatory_arg_error
1339: (p_api_name => l_proc
1340: ,p_argument => 'validation_start_date'
1341: ,p_argument_value => p_validation_start_date
1342: );

Line 1347: hr_api.mandatory_arg_error

1343: if g_debug then
1344: hr_utility.set_location(l_proc, 40);
1345: end if;
1346: --
1347: hr_api.mandatory_arg_error
1348: (p_api_name => l_proc
1349: ,p_argument => 'validation_end_date'
1350: ,p_argument_value => p_validation_end_date
1351: );

Line 1356: hr_api.mandatory_arg_error

1352: if g_debug then
1353: hr_utility.set_location(l_proc, 50);
1354: end if;
1355: --
1356: hr_api.mandatory_arg_error
1357: (p_api_name => l_proc
1358: ,p_argument => 'effective_date'
1359: ,p_argument_value => p_effective_date
1360: );

Line 1375: (nvl(hr_psf_shd.g_old_rec.position_definition_id, hr_api.g_number)

1371: hr_utility.set_location(l_proc, 70);
1372: end if;
1373: --
1374: if (l_api_updating and
1375: (nvl(hr_psf_shd.g_old_rec.position_definition_id, hr_api.g_number)
1376: <> nvl(p_position_definition_id, hr_api.g_number))
1377: )
1378: or NOT l_api_updating
1379: then

Line 1376: <> nvl(p_position_definition_id, hr_api.g_number))

1372: end if;
1373: --
1374: if (l_api_updating and
1375: (nvl(hr_psf_shd.g_old_rec.position_definition_id, hr_api.g_number)
1376: <> nvl(p_position_definition_id, hr_api.g_number))
1377: )
1378: or NOT l_api_updating
1379: then
1380: if g_debug then

Line 1467: hr_api.mandatory_arg_error

1463: end if;
1464: --
1465: -- Check mandatory parameters have been set
1466: --
1467: hr_api.mandatory_arg_error
1468: (p_api_name => l_proc
1469: ,p_argument => 'business_group_id'
1470: ,p_argument_value => p_business_group_id
1471: );

Line 1476: hr_api.mandatory_arg_error

1472: if g_debug then
1473: hr_utility.set_location(l_proc, 2);
1474: end if;
1475: --
1476: hr_api.mandatory_arg_error
1477: (p_api_name => l_proc
1478: ,p_argument => 'name'
1479: ,p_argument_value => p_name
1480: );

Line 1485: hr_api.mandatory_arg_error

1481: if g_debug then
1482: hr_utility.set_location(l_proc, 3);
1483: end if;
1484: --
1485: hr_api.mandatory_arg_error
1486: (p_api_name => l_proc
1487: ,p_argument => 'effective_date'
1488: ,p_argument_value => p_effective_date
1489: );

Line 1504: (nvl(hr_psf_shd.g_old_rec.name, hr_api.g_varchar2)

1500: hr_utility.set_location(l_proc, 30);
1501: end if;
1502: --
1503: if (l_api_updating and
1504: (nvl(hr_psf_shd.g_old_rec.name, hr_api.g_varchar2)
1505: <> nvl(p_name, hr_api.g_varchar2))
1506: )
1507: or NOT l_api_updating
1508: then

Line 1505: <> nvl(p_name, hr_api.g_varchar2))

1501: end if;
1502: --
1503: if (l_api_updating and
1504: (nvl(hr_psf_shd.g_old_rec.name, hr_api.g_varchar2)
1505: <> nvl(p_name, hr_api.g_varchar2))
1506: )
1507: or NOT l_api_updating
1508: then
1509: if g_debug then

Line 1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>

1619: ,p_effective_date => p_effective_date
1620: ,p_object_version_number => p_object_version_number);
1621: --
1622: if ((l_api_updating and
1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>
1624: nvl(p_working_hours,hr_api.g_number) or
1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
1626: nvl(p_frequency,hr_api.g_varchar2)))) or
1627: (NOT l_api_updating)) then

Line 1624: nvl(p_working_hours,hr_api.g_number) or

1620: ,p_object_version_number => p_object_version_number);
1621: --
1622: if ((l_api_updating and
1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>
1624: nvl(p_working_hours,hr_api.g_number) or
1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
1626: nvl(p_frequency,hr_api.g_varchar2)))) or
1627: (NOT l_api_updating)) then
1628: --

Line 1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>

1621: --
1622: if ((l_api_updating and
1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>
1624: nvl(p_working_hours,hr_api.g_number) or
1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
1626: nvl(p_frequency,hr_api.g_varchar2)))) or
1627: (NOT l_api_updating)) then
1628: --
1629: -- Check for values consistency

Line 1626: nvl(p_frequency,hr_api.g_varchar2)))) or

1622: if ((l_api_updating and
1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>
1624: nvl(p_working_hours,hr_api.g_number) or
1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
1626: nvl(p_frequency,hr_api.g_varchar2)))) or
1627: (NOT l_api_updating)) then
1628: --
1629: -- Check for values consistency
1630: --

Line 1716: hr_api.mandatory_arg_error(p_api_name => l_proc,

1712: end if;
1713: --
1714: -- Ensure that all the mandatory parameter are not null
1715: --
1716: hr_api.mandatory_arg_error(p_api_name => l_proc,
1717: p_argument => 'position_id',
1718: p_argument_value => p_position_id);
1719: --
1720: if g_debug then

Line 1723: hr_api.mandatory_arg_error(p_api_name => l_proc,

1719: --
1720: if g_debug then
1721: hr_utility.set_location('Entering : ' || l_proc, 10);
1722: end if;
1723: hr_api.mandatory_arg_error(p_api_name => l_proc,
1724: p_argument => 'position_id',
1725: p_argument_value => p_position_id);
1726: --
1727: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1727: hr_api.mandatory_arg_error(p_api_name => l_proc,

1723: hr_api.mandatory_arg_error(p_api_name => l_proc,
1724: p_argument => 'position_id',
1725: p_argument_value => p_position_id);
1726: --
1727: hr_api.mandatory_arg_error(p_api_name => l_proc,
1728: p_argument => 'business_group_id',
1729: p_argument_value => p_business_group_id);
1730: --
1731: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1731: hr_api.mandatory_arg_error(p_api_name => l_proc,

1727: hr_api.mandatory_arg_error(p_api_name => l_proc,
1728: p_argument => 'business_group_id',
1729: p_argument_value => p_business_group_id);
1730: --
1731: hr_api.mandatory_arg_error(p_api_name => l_proc,
1732: p_argument => 'validation_start_date',
1733: p_argument_value => p_validation_start_date);
1734: --
1735: open c1;

Line 1782: hr_api.mandatory_arg_error(p_api_name => l_proc,

1778: end if;
1779: --
1780: -- Ensure that all the mandatory parameter are not null
1781: --
1782: hr_api.mandatory_arg_error(p_api_name => l_proc,
1783: p_argument => 'position_id',
1784: p_argument_value => p_position_id);
1785: --
1786: open csr_leg_code;

Line 1876: hr_api.mandatory_arg_error

1872: end if;
1873: --
1874: -- Check mandatory parameters have been set
1875: --
1876: hr_api.mandatory_arg_error
1877: (p_api_name => l_proc
1878: ,p_argument => 'date_effective'
1879: ,p_argument_value => p_date_effective
1880: );

Line 1882: hr_api.mandatory_arg_error

1878: ,p_argument => 'date_effective'
1879: ,p_argument_value => p_date_effective
1880: );
1881:
1882: hr_api.mandatory_arg_error
1883: (p_api_name => l_proc
1884: ,p_argument => 'validation_start_date'
1885: ,p_argument_value => p_validation_start_date
1886: );

Line 1888: hr_api.mandatory_arg_error

1884: ,p_argument => 'validation_start_date'
1885: ,p_argument_value => p_validation_start_date
1886: );
1887:
1888: hr_api.mandatory_arg_error
1889: (p_api_name => l_proc
1890: ,p_argument => 'validation_end_date'
1891: ,p_argument_value => p_validation_end_date
1892: );

Line 1950: if p_date_effective > nvl(p_date_end,hr_api.g_eot) then

1946: if g_debug then
1947: hr_utility.set_location(l_proc, 3);
1948: end if;
1949: --
1950: if p_date_effective > nvl(p_date_end,hr_api.g_eot) then
1951: hr_utility.set_message(800,'HR_51362_POS_INVAL_EFF_DATE');
1952: hr_utility.raise_error;
1953: end if;
1954: --

Line 1979: if (nvl(p_date_effective, hr_api.g_date) <>

1975: hr_utility.set_message(800,'HR_PSF_DE_MUST_LATER_OR_EQ_ESD');
1976: hr_utility.raise_error;
1977: end if;
1978: --
1979: if (nvl(p_date_effective, hr_api.g_date) <>
1980: nvl(hr_psf_shd.g_old_rec.effective_start_date, hr_api.g_date)) then
1981: -- find if date_Effective can be modified
1982: --
1983: DE_Update_properties(

Line 1980: nvl(hr_psf_shd.g_old_rec.effective_start_date, hr_api.g_date)) then

1976: hr_utility.raise_error;
1977: end if;
1978: --
1979: if (nvl(p_date_effective, hr_api.g_date) <>
1980: nvl(hr_psf_shd.g_old_rec.effective_start_date, hr_api.g_date)) then
1981: -- find if date_Effective can be modified
1982: --
1983: DE_Update_properties(
1984: p_position_id => p_position_id,

Line 2045: and nvl(job.date_to,hr_api.g_eot);

2041: select 'x'
2042: from per_jobs_v job
2043: where job.job_id = p_job_id
2044: and p_validation_date between job.date_from
2045: and nvl(job.date_to,hr_api.g_eot);
2046: --
2047:
2048: begin
2049: if g_debug then

Line 2056: hr_api.mandatory_arg_error

2052: end if;
2053: --
2054: -- Check mandatory arguments
2055: --
2056: hr_api.mandatory_arg_error
2057: (p_api_name => l_proc
2058: ,p_argument => 'job_id'
2059: ,p_argument_value => p_job_id
2060: );

Line 2062: hr_api.mandatory_arg_error

2058: ,p_argument => 'job_id'
2059: ,p_argument_value => p_job_id
2060: );
2061: --
2062: hr_api.mandatory_arg_error
2063: (p_api_name => l_proc
2064: ,p_argument => 'effective_date'
2065: ,p_argument_value => p_effective_date
2066: );

Line 2068: hr_api.mandatory_arg_error

2064: ,p_argument => 'effective_date'
2065: ,p_argument_value => p_effective_date
2066: );
2067: --
2068: hr_api.mandatory_arg_error
2069: (p_api_name => l_proc
2070: ,p_argument => 'validation_start_date'
2071: ,p_argument_value => p_validation_start_date
2072: );

Line 2074: hr_api.mandatory_arg_error

2070: ,p_argument => 'validation_start_date'
2071: ,p_argument_value => p_validation_start_date
2072: );
2073: --
2074: hr_api.mandatory_arg_error
2075: (p_api_name => l_proc
2076: ,p_argument => 'validation_end_date'
2077: ,p_argument_value => p_validation_end_date
2078: );

Line 2100: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))

2096: -- b) The value for job has changed
2097: --
2098: if ((l_api_updating and
2099: nvl(hr_psf_shd.g_old_rec.job_id,
2100: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))
2101: or
2102: NOT l_api_updating) then
2103: if g_debug then
2104: hr_utility.set_location(l_proc, 40);

Line 2174: and nvl(oru.date_to,hr_api.g_eot);

2170: select 'x'
2171: from hr_organization_units oru
2172: where oru.organization_id = p_organization_id
2173: and p_validation_date between oru.date_from
2174: and nvl(oru.date_to,hr_api.g_eot);
2175: --
2176:
2177: begin
2178: if g_debug then

Line 2185: hr_api.mandatory_arg_error

2181: end if;
2182: --
2183: -- Check mandatory parameters have been set
2184: --
2185: hr_api.mandatory_arg_error
2186: (p_api_name => l_proc
2187: ,p_argument => 'effective_date'
2188: ,p_argument_value => p_effective_date
2189: );

Line 2191: hr_api.mandatory_arg_error

2187: ,p_argument => 'effective_date'
2188: ,p_argument_value => p_effective_date
2189: );
2190: --
2191: hr_api.mandatory_arg_error
2192: (p_api_name => l_proc
2193: ,p_argument => 'organization_id'
2194: ,p_argument_value => p_organization_id
2195: );

Line 2197: hr_api.mandatory_arg_error

2193: ,p_argument => 'organization_id'
2194: ,p_argument_value => p_organization_id
2195: );
2196: --
2197: hr_api.mandatory_arg_error
2198: (p_api_name => l_proc
2199: ,p_argument => 'business_group_id'
2200: ,p_argument_value => p_business_group_id
2201: );

Line 2203: hr_api.mandatory_arg_error

2199: ,p_argument => 'business_group_id'
2200: ,p_argument_value => p_business_group_id
2201: );
2202: --
2203: hr_api.mandatory_arg_error
2204: (p_api_name => l_proc
2205: ,p_argument => 'validation_start_date'
2206: ,p_argument_value => p_validation_start_date
2207: );

Line 2209: hr_api.mandatory_arg_error

2205: ,p_argument => 'validation_start_date'
2206: ,p_argument_value => p_validation_start_date
2207: );
2208: --
2209: hr_api.mandatory_arg_error
2210: (p_api_name => l_proc
2211: ,p_argument => 'validation_end_date'
2212: ,p_argument_value => p_validation_end_date
2213: );

Line 2346: hr_api.mandatory_arg_error

2342: -- b) The successor_position_id value has changed
2343: --
2344: if p_successor_position_id is not null then
2345: --
2346: hr_api.mandatory_arg_error
2347: (p_api_name => l_proc
2348: ,p_argument => 'effective date'
2349: ,p_argument_value => p_effective_date);
2350: --

Line 2351: hr_api.mandatory_arg_error

2347: (p_api_name => l_proc
2348: ,p_argument => 'effective date'
2349: ,p_argument_value => p_effective_date);
2350: --
2351: hr_api.mandatory_arg_error
2352: (p_api_name => l_proc
2353: ,p_argument => 'validation start date'
2354: ,p_argument_value => p_validation_start_date);
2355: --

Line 2356: hr_api.mandatory_arg_error

2352: (p_api_name => l_proc
2353: ,p_argument => 'validation start date'
2354: ,p_argument_value => p_validation_start_date);
2355: --
2356: hr_api.mandatory_arg_error
2357: (p_api_name => l_proc
2358: ,p_argument => 'validation end date'
2359: ,p_argument_value => p_validation_end_date);
2360: --

Line 2472: hr_api.mandatory_arg_error

2468: -- b) The relief_position_id value has changed
2469: --
2470: if p_relief_position_id is not null then
2471: --
2472: hr_api.mandatory_arg_error
2473: (p_api_name => l_proc
2474: ,p_argument => 'effective date'
2475: ,p_argument_value => p_effective_date);
2476: --

Line 2482: hr_api.mandatory_arg_error

2478: (p_position_id => p_position_id
2479: ,p_effective_date => p_effective_date
2480: ,p_object_version_number => p_object_version_number);
2481: --
2482: hr_api.mandatory_arg_error
2483: (p_api_name => l_proc
2484: ,p_argument => 'validation start date'
2485: ,p_argument_value => p_validation_start_date);
2486: --

Line 2488: hr_api.mandatory_arg_error

2484: ,p_argument => 'validation start date'
2485: ,p_argument_value => p_validation_start_date);
2486: --
2487: --
2488: hr_api.mandatory_arg_error
2489: (p_api_name => l_proc
2490: ,p_argument => 'validation end date'
2491: ,p_argument_value => p_validation_end_date);
2492: --

Line 2550: hr_api.g_eot);

2546: select 'x'
2547: from hr_locations loc
2548: where loc.location_id = p_location_id
2549: and p_effective_date < nvl(loc.inactive_date,
2550: hr_api.g_eot);
2551:
2552: --
2553: begin
2554:

Line 2562: hr_api.mandatory_arg_error

2558: end if;
2559: --
2560: -- Check mandatory parameters have been set
2561: --
2562: hr_api.mandatory_arg_error
2563: (p_api_name => l_proc
2564: ,p_argument => 'effective_date'
2565: ,p_argument_value => p_effective_date
2566: );

Line 2568: hr_api.mandatory_arg_error

2564: ,p_argument => 'effective_date'
2565: ,p_argument_value => p_effective_date
2566: );
2567: --
2568: hr_api.mandatory_arg_error
2569: (p_api_name => l_proc
2570: ,p_argument => 'validation_start_date'
2571: ,p_argument_value => p_validation_start_date
2572: );

Line 2574: hr_api.mandatory_arg_error

2570: ,p_argument => 'validation_start_date'
2571: ,p_argument_value => p_validation_start_date
2572: );
2573: --
2574: hr_api.mandatory_arg_error
2575: (p_api_name => l_proc
2576: ,p_argument => 'validation_end_date'
2577: ,p_argument_value => p_validation_end_date
2578: );

Line 2597: nvl(hr_psf_shd.g_old_rec.location_id, hr_api.g_number) <>

2593: hr_utility.set_location('Entering:'|| l_proc, 30);
2594: end if;
2595: --
2596: if ((l_api_updating and
2597: nvl(hr_psf_shd.g_old_rec.location_id, hr_api.g_number) <>
2598: nvl(p_location_id, hr_api.g_number)) or
2599: (NOT l_api_updating))
2600: then
2601: --

Line 2598: nvl(p_location_id, hr_api.g_number)) or

2594: end if;
2595: --
2596: if ((l_api_updating and
2597: nvl(hr_psf_shd.g_old_rec.location_id, hr_api.g_number) <>
2598: nvl(p_location_id, hr_api.g_number)) or
2599: (NOT l_api_updating))
2600: then
2601: --
2602: if g_debug then

Line 2678: hr_api.mandatory_arg_error

2674: end if;
2675: --
2676: -- Check mandatory parameters have been set
2677: --
2678: hr_api.mandatory_arg_error
2679: (p_api_name => l_proc
2680: ,p_argument => 'position_definition_id'
2681: ,p_argument_value => p_position_definition_id
2682: );

Line 2684: hr_api.mandatory_arg_error

2680: ,p_argument => 'position_definition_id'
2681: ,p_argument_value => p_position_definition_id
2682: );
2683: --
2684: hr_api.mandatory_arg_error
2685: (p_api_name => l_proc
2686: ,p_argument => 'effective_date'
2687: ,p_argument_value => p_effective_date
2688: );

Line 2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>

2793: ,p_effective_date => p_effective_date
2794: ,p_object_version_number => p_object_version_number);
2795: --
2796: if ((l_api_updating and
2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>
2798: nvl(p_probation_period,hr_api.g_number)) or
2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>
2800: nvl(p_probation_period_unit_cd,hr_api.g_varchar2))) or
2801: (NOT l_api_updating)) then

Line 2798: nvl(p_probation_period,hr_api.g_number)) or

2794: ,p_object_version_number => p_object_version_number);
2795: --
2796: if ((l_api_updating and
2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>
2798: nvl(p_probation_period,hr_api.g_number)) or
2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>
2800: nvl(p_probation_period_unit_cd,hr_api.g_varchar2))) or
2801: (NOT l_api_updating)) then
2802: --

Line 2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>

2795: --
2796: if ((l_api_updating and
2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>
2798: nvl(p_probation_period,hr_api.g_number)) or
2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>
2800: nvl(p_probation_period_unit_cd,hr_api.g_varchar2))) or
2801: (NOT l_api_updating)) then
2802: --
2803: -- Check for values consistency

Line 2800: nvl(p_probation_period_unit_cd,hr_api.g_varchar2))) or

2796: if ((l_api_updating and
2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>
2798: nvl(p_probation_period,hr_api.g_number)) or
2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>
2800: nvl(p_probation_period_unit_cd,hr_api.g_varchar2))) or
2801: (NOT l_api_updating)) then
2802: --
2803: -- Check for values consistency
2804: --

Line 2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>

2905: ,p_effective_Date => p_effective_date
2906: ,p_object_version_number => p_object_version_number);
2907: --
2908: if ((l_api_updating and
2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
2910: nvl(p_time_normal_start,hr_api.g_varchar2) or
2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
2912: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
2913: (NOT l_api_updating)) then

Line 2910: nvl(p_time_normal_start,hr_api.g_varchar2) or

2906: ,p_object_version_number => p_object_version_number);
2907: --
2908: if ((l_api_updating and
2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
2910: nvl(p_time_normal_start,hr_api.g_varchar2) or
2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
2912: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
2913: (NOT l_api_updating)) then
2914: --

Line 2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>

2907: --
2908: if ((l_api_updating and
2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
2910: nvl(p_time_normal_start,hr_api.g_varchar2) or
2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
2912: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
2913: (NOT l_api_updating)) then
2914: --
2915: -- Check for values consistency

Line 2912: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or

2908: if ((l_api_updating and
2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
2910: nvl(p_time_normal_start,hr_api.g_varchar2) or
2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
2912: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
2913: (NOT l_api_updating)) then
2914: --
2915: -- Check for values consistency
2916: --

Line 2993: hr_api.mandatory_arg_error

2989: end if;
2990: --
2991: -- Check mandatory parameters have been set
2992: --
2993: hr_api.mandatory_arg_error
2994: (p_api_name => l_proc
2995: ,p_argument => 'validation_start_date'
2996: ,p_argument_value => p_validation_start_date
2997: );

Line 2999: hr_api.mandatory_arg_error

2995: ,p_argument => 'validation_start_date'
2996: ,p_argument_value => p_validation_start_date
2997: );
2998: --
2999: hr_api.mandatory_arg_error
3000: (p_api_name => l_proc
3001: ,p_argument => 'validation_end_date'
3002: ,p_argument_value => p_validation_end_date
3003: );

Line 3005: hr_api.mandatory_arg_error

3001: ,p_argument => 'validation_end_date'
3002: ,p_argument_value => p_validation_end_date
3003: );
3004: --
3005: hr_api.mandatory_arg_error
3006: (p_api_name => l_proc
3007: ,p_argument => 'effective_date'
3008: ,p_argument_value => p_effective_date
3009: );

Line 3029: nvl(hr_psf_shd.g_old_rec.position_transaction_id, hr_api.g_number) <>

3025: hr_utility.set_location(l_proc, 30);
3026: end if;
3027: --
3028: if ((l_api_updating and
3029: nvl(hr_psf_shd.g_old_rec.position_transaction_id, hr_api.g_number) <>
3030: nvl(p_position_transaction_id, hr_api.g_number)) or
3031: (NOT l_api_updating)) then
3032: if g_debug then
3033: hr_utility.set_location(l_proc, 40);

Line 3030: nvl(p_position_transaction_id, hr_api.g_number)) or

3026: end if;
3027: --
3028: if ((l_api_updating and
3029: nvl(hr_psf_shd.g_old_rec.position_transaction_id, hr_api.g_number) <>
3030: nvl(p_position_transaction_id, hr_api.g_number)) or
3031: (NOT l_api_updating)) then
3032: if g_debug then
3033: hr_utility.set_location(l_proc, 40);
3034: end if;

Line 3134: hr_api.mandatory_arg_error

3130: -- b) The supervisor_position_id value has changed
3131: --
3132: if p_supervisor_position_id is not null then
3133: --
3134: hr_api.mandatory_arg_error
3135: (p_api_name => l_proc
3136: ,p_argument => 'effective date'
3137: ,p_argument_value => p_effective_date);
3138: --

Line 3139: hr_api.mandatory_arg_error

3135: (p_api_name => l_proc
3136: ,p_argument => 'effective date'
3137: ,p_argument_value => p_effective_date);
3138: --
3139: hr_api.mandatory_arg_error
3140: (p_api_name => l_proc
3141: ,p_argument => 'validation start date'
3142: ,p_argument_value => p_validation_start_date);
3143: --

Line 3144: hr_api.mandatory_arg_error

3140: (p_api_name => l_proc
3141: ,p_argument => 'validation start date'
3142: ,p_argument_value => p_validation_start_date);
3143: --
3144: hr_api.mandatory_arg_error
3145: (p_api_name => l_proc
3146: ,p_argument => 'validation end date'
3147: ,p_argument_value => p_validation_end_date);
3148: --

Line 3260: hr_api.mandatory_arg_error

3256: -- b) The prior_position_id value has changed
3257: --
3258: if p_prior_position_id is not null then
3259: --
3260: hr_api.mandatory_arg_error
3261: (p_api_name => l_proc
3262: ,p_argument => 'effective date'
3263: ,p_argument_value => p_effective_date);
3264: --

Line 3265: hr_api.mandatory_arg_error

3261: (p_api_name => l_proc
3262: ,p_argument => 'effective date'
3263: ,p_argument_value => p_effective_date);
3264: --
3265: hr_api.mandatory_arg_error
3266: (p_api_name => l_proc
3267: ,p_argument => 'validation start date'
3268: ,p_argument_value => p_validation_start_date);
3269: --

Line 3270: hr_api.mandatory_arg_error

3266: (p_api_name => l_proc
3267: ,p_argument => 'validation start date'
3268: ,p_argument_value => p_validation_start_date);
3269: --
3270: hr_api.mandatory_arg_error
3271: (p_api_name => l_proc
3272: ,p_argument => 'validation end date'
3273: ,p_argument_value => p_validation_end_date);
3274: --

Line 3362: <> nvl(hr_psf_shd.g_old_rec.work_term_end_month_cd,hr_api.g_varchar2)

3358: ,p_object_version_number => p_object_version_number);
3359: --
3360: if (l_api_updating
3361: and p_work_term_end_month_cd
3362: <> nvl(hr_psf_shd.g_old_rec.work_term_end_month_cd,hr_api.g_varchar2)
3363: or not l_api_updating)
3364: and p_work_term_end_month_cd is not null then
3365: --
3366: -- check if value of lookup falls within lookup type.

Line 3368: if hr_api.not_exists_in_dt_hr_lookups

3364: and p_work_term_end_month_cd is not null then
3365: --
3366: -- check if value of lookup falls within lookup type.
3367: --
3368: if hr_api.not_exists_in_dt_hr_lookups
3369: (p_lookup_type => 'MONTH_CODE'
3370: ,p_lookup_code => p_work_term_end_month_cd
3371: ,p_validation_start_date => p_validation_start_date
3372: ,p_validation_end_date => p_validation_end_date

Line 3445: <> nvl(hr_psf_shd.g_old_rec.work_term_end_day_cd,hr_api.g_varchar2)

3441: ,p_object_version_number => p_object_version_number);
3442: --
3443: if (l_api_updating
3444: and p_work_term_end_day_cd
3445: <> nvl(hr_psf_shd.g_old_rec.work_term_end_day_cd,hr_api.g_varchar2)
3446: or not l_api_updating)
3447: and p_work_term_end_day_cd is not null then
3448: --
3449: -- check if value of lookup falls within lookup type.

Line 3451: if hr_api.not_exists_in_dt_hr_lookups

3447: and p_work_term_end_day_cd is not null then
3448: --
3449: -- check if value of lookup falls within lookup type.
3450: --
3451: if hr_api.not_exists_in_dt_hr_lookups
3452: (p_lookup_type => 'DAY_CODE'
3453: ,p_lookup_code => p_work_term_end_day_cd
3454: ,p_validation_start_date => p_validation_start_date
3455: ,p_validation_end_date => p_validation_end_date

Line 3493: hr_api.mandatory_arg_error

3489: l_proc := g_package||'chk_position_type';
3490: hr_utility.set_location('Entering:'||l_proc, 5);
3491: end if;
3492: --
3493: hr_api.mandatory_arg_error
3494: (p_api_name => l_proc
3495: ,p_argument => 'position type'
3496: ,p_argument_value => p_position_type);
3497: --

Line 3499: hr_api.mandatory_arg_error

3495: ,p_argument => 'position type'
3496: ,p_argument_value => p_position_type);
3497: --
3498: --
3499: hr_api.mandatory_arg_error
3500: (p_api_name => l_proc
3501: ,p_argument => 'validation start date'
3502: ,p_argument_value => p_validation_start_date);
3503: --

Line 3505: hr_api.mandatory_arg_error

3501: ,p_argument => 'validation start date'
3502: ,p_argument_value => p_validation_start_date);
3503: --
3504: --
3505: hr_api.mandatory_arg_error
3506: (p_api_name => l_proc
3507: ,p_argument => 'effective date'
3508: ,p_argument_value => p_effective_date);
3509: --

Line 3517: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)

3513: ,p_object_version_number => p_object_version_number);
3514: --
3515: if (l_api_updating
3516: and p_position_type
3517: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)
3518: or not l_api_updating)
3519: and p_position_type is not null then
3520: --
3521: -- check if value of lookup falls within lookup type.

Line 3523: if hr_api.not_exists_in_dt_hr_lookups

3519: and p_position_type is not null then
3520: --
3521: -- check if value of lookup falls within lookup type.
3522: --
3523: if hr_api.not_exists_in_dt_hr_lookups
3524: (p_lookup_type => 'POSITION_TYPE'
3525: ,p_lookup_code => p_position_type
3526: ,p_validation_start_date => p_validation_start_date
3527: ,p_validation_end_date => p_validation_end_date

Line 3599: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)

3595: ,p_object_version_number => p_object_version_number);
3596: --
3597: if (l_api_updating
3598: and p_work_period_type_cd
3599: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)
3600: or not l_api_updating)
3601: and p_work_period_type_cd is not null then
3602: --
3603: -- check if value of lookup falls within lookup type.

Line 3605: if hr_api.not_exists_in_dt_hr_lookups

3601: and p_work_period_type_cd is not null then
3602: --
3603: -- check if value of lookup falls within lookup type.
3604: --
3605: if hr_api.not_exists_in_dt_hr_lookups
3606: (p_lookup_type => 'YES_NO'
3607: ,p_lookup_code => p_work_period_type_cd
3608: ,p_validation_start_date => p_validation_start_date
3609: ,p_validation_end_date => p_validation_end_date

Line 3681: <> nvl(hr_psf_shd.g_old_rec.works_council_approval_flag,hr_api.g_varchar2)

3677: ,p_object_version_number => p_object_version_number);
3678: --
3679: if (l_api_updating
3680: and p_works_council_approval_flag
3681: <> nvl(hr_psf_shd.g_old_rec.works_council_approval_flag,hr_api.g_varchar2)
3682: or not l_api_updating)
3683: and p_works_council_approval_flag is not null then
3684: --
3685: -- check if value of lookup falls within lookup type.

Line 3687: if hr_api.not_exists_in_dt_hr_lookups

3683: and p_works_council_approval_flag is not null then
3684: --
3685: -- check if value of lookup falls within lookup type.
3686: --
3687: if hr_api.not_exists_in_dt_hr_lookups
3688: (p_lookup_type => 'YES_NO'
3689: ,p_lookup_code => p_works_council_approval_flag
3690: ,p_validation_start_date => p_validation_start_date
3691: ,p_validation_end_date => p_validation_end_date

Line 3764: <> nvl(hr_psf_shd.g_old_rec.term_start_month_cd,hr_api.g_varchar2)

3760: ,p_object_version_number => p_object_version_number);
3761: --
3762: if (l_api_updating
3763: and p_term_start_month_cd
3764: <> nvl(hr_psf_shd.g_old_rec.term_start_month_cd,hr_api.g_varchar2)
3765: or not l_api_updating)
3766: and p_term_start_month_cd is not null then
3767: --
3768: -- check if value of lookup falls within lookup type.

Line 3770: if hr_api.not_exists_in_dt_hr_lookups

3766: and p_term_start_month_cd is not null then
3767: --
3768: -- check if value of lookup falls within lookup type.
3769: --
3770: if hr_api.not_exists_in_dt_hr_lookups
3771: (p_lookup_type => 'MONTH_CODE'
3772: ,p_lookup_code => p_term_start_month_cd
3773: ,p_validation_start_date => p_validation_start_date
3774: ,p_validation_end_date => p_validation_end_date

Line 3847: <> nvl(hr_psf_shd.g_old_rec.term_start_day_cd,hr_api.g_varchar2)

3843: ,p_object_version_number => p_object_version_number);
3844: --
3845: if (l_api_updating
3846: and p_term_start_day_cd
3847: <> nvl(hr_psf_shd.g_old_rec.term_start_day_cd,hr_api.g_varchar2)
3848: or not l_api_updating)
3849: and p_term_start_day_cd is not null then
3850: --
3851: -- check if value of lookup falls within lookup type.

Line 3853: if hr_api.not_exists_in_dt_hr_lookups

3849: and p_term_start_day_cd is not null then
3850: --
3851: -- check if value of lookup falls within lookup type.
3852: --
3853: if hr_api.not_exists_in_dt_hr_lookups
3854: (p_lookup_type => 'DAY_CODE'
3855: ,p_lookup_code => p_term_start_day_cd
3856: ,p_validation_start_date => p_validation_start_date
3857: ,p_validation_end_date => p_validation_end_date

Line 3930: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)

3926: ,p_object_version_number => p_object_version_number);
3927: --
3928: if (l_api_updating
3929: and p_seasonal_flag
3930: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)
3931: or not l_api_updating)
3932: and p_seasonal_flag is not null then
3933: --
3934: -- check if value of lookup falls within lookup type.

Line 3936: if hr_api.not_exists_in_dt_hr_lookups

3932: and p_seasonal_flag is not null then
3933: --
3934: -- check if value of lookup falls within lookup type.
3935: --
3936: if hr_api.not_exists_in_dt_hr_lookups
3937: (p_lookup_type => 'YES_NO'
3938: ,p_lookup_code => p_seasonal_flag
3939: ,p_validation_start_date => p_validation_start_date
3940: ,p_validation_end_date => p_validation_end_date

Line 4012: <> nvl(hr_psf_shd.g_old_rec.review_flag,hr_api.g_varchar2)

4008: ,p_object_version_number => p_object_version_number);
4009: --
4010: if (l_api_updating
4011: and p_review_flag
4012: <> nvl(hr_psf_shd.g_old_rec.review_flag,hr_api.g_varchar2)
4013: or not l_api_updating)
4014: and p_review_flag is not null then
4015: --
4016: -- check if value of lookup falls within lookup type.

Line 4018: if hr_api.not_exists_in_dt_hr_lookups

4014: and p_review_flag is not null then
4015: --
4016: -- check if value of lookup falls within lookup type.
4017: --
4018: if hr_api.not_exists_in_dt_hr_lookups
4019: (p_lookup_type => 'YES_NO'
4020: ,p_lookup_code => p_review_flag
4021: ,p_validation_start_date => p_validation_start_date
4022: ,p_validation_end_date => p_validation_end_date

Line 4094: <> nvl(hr_psf_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2)

4090: ,p_object_version_number => p_object_version_number);
4091: --
4092: if (l_api_updating
4093: and p_replacement_required_flag
4094: <> nvl(hr_psf_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2)
4095: or not l_api_updating)
4096: and p_replacement_required_flag is not null then
4097: --
4098: -- check if value of lookup falls within lookup type.

Line 4100: if hr_api.not_exists_in_dt_hr_lookups

4096: and p_replacement_required_flag is not null then
4097: --
4098: -- check if value of lookup falls within lookup type.
4099: --
4100: if hr_api.not_exists_in_dt_hr_lookups
4101: (p_lookup_type => 'YES_NO'
4102: ,p_lookup_code => p_replacement_required_flag
4103: ,p_validation_start_date => p_validation_start_date
4104: ,p_validation_end_date => p_validation_end_date

Line 4176: <> nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2)

4172: ,p_object_version_number => p_object_version_number);
4173: --
4174: if (l_api_updating
4175: and p_probation_period_unit_cd
4176: <> nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2)
4177: or not l_api_updating)
4178: and p_probation_period_unit_cd is not null then
4179: --
4180: -- check if value of lookup falls within lookup type.

Line 4182: if hr_api.not_exists_in_dt_hr_lookups

4178: and p_probation_period_unit_cd is not null then
4179: --
4180: -- check if value of lookup falls within lookup type.
4181: --
4182: if hr_api.not_exists_in_dt_hr_lookups
4183: (p_lookup_type => 'FREQUENCY'
4184: ,p_lookup_code => p_probation_period_unit_cd
4185: ,p_validation_start_date => p_validation_start_date
4186: ,p_validation_end_date => p_validation_end_date

Line 4258: <> nvl(hr_psf_shd.g_old_rec.permit_recruitment_flag,hr_api.g_varchar2)

4254: ,p_object_version_number => p_object_version_number);
4255: --
4256: if (l_api_updating
4257: and p_permit_recruitment_flag
4258: <> nvl(hr_psf_shd.g_old_rec.permit_recruitment_flag,hr_api.g_varchar2)
4259: or not l_api_updating)
4260: and p_permit_recruitment_flag is not null then
4261: --
4262: -- check if value of lookup falls within lookup type.

Line 4264: if hr_api.not_exists_in_dt_hr_lookups

4260: and p_permit_recruitment_flag is not null then
4261: --
4262: -- check if value of lookup falls within lookup type.
4263: --
4264: if hr_api.not_exists_in_dt_hr_lookups
4265: (p_lookup_type => 'YES_NO'
4266: ,p_lookup_code => p_permit_recruitment_flag
4267: ,p_validation_start_date => p_validation_start_date
4268: ,p_validation_end_date => p_validation_end_date

Line 4340: <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)

4336: ,p_object_version_number => p_object_version_number);
4337: --
4338: if (l_api_updating
4339: and p_permanent_temporary_flag
4340: <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
4341: or not l_api_updating)
4342: and p_permanent_temporary_flag is not null then
4343: --
4344: -- check if value of lookup falls within lookup type.

Line 4346: if hr_api.not_exists_in_dt_hr_lookups

4342: and p_permanent_temporary_flag is not null then
4343: --
4344: -- check if value of lookup falls within lookup type.
4345: --
4346: if hr_api.not_exists_in_dt_hr_lookups
4347: (p_lookup_type => 'YES_NO'
4348: ,p_lookup_code => p_permanent_temporary_flag
4349: ,p_validation_start_date => p_validation_start_date
4350: ,p_validation_end_date => p_validation_end_date

Line 4422: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_month_cd,hr_api.g_varchar2)

4418: ,p_object_version_number => p_object_version_number);
4419: --
4420: if (l_api_updating
4421: and p_pay_term_end_month_cd
4422: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_month_cd,hr_api.g_varchar2)
4423: or not l_api_updating)
4424: and p_pay_term_end_month_cd is not null then
4425: --
4426: -- check if value of lookup falls within lookup type.

Line 4428: if hr_api.not_exists_in_dt_hr_lookups

4424: and p_pay_term_end_month_cd is not null then
4425: --
4426: -- check if value of lookup falls within lookup type.
4427: --
4428: if hr_api.not_exists_in_dt_hr_lookups
4429: (p_lookup_type => 'MONTH_CODE'
4430: ,p_lookup_code => p_pay_term_end_month_cd
4431: ,p_validation_start_date => p_validation_start_date
4432: ,p_validation_end_date => p_validation_end_date

Line 4504: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_day_cd,hr_api.g_varchar2)

4500: ,p_object_version_number => p_object_version_number);
4501: --
4502: if (l_api_updating
4503: and p_pay_term_end_day_cd
4504: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_day_cd,hr_api.g_varchar2)
4505: or not l_api_updating)
4506: and p_pay_term_end_day_cd is not null then
4507: --
4508: -- check if value of lookup falls within lookup type.

Line 4510: if hr_api.not_exists_in_dt_hr_lookups

4506: and p_pay_term_end_day_cd is not null then
4507: --
4508: -- check if value of lookup falls within lookup type.
4509: --
4510: if hr_api.not_exists_in_dt_hr_lookups
4511: (p_lookup_type => 'DAY_CODE'
4512: ,p_lookup_code => p_pay_term_end_day_cd
4513: ,p_validation_start_date => p_validation_start_date
4514: ,p_validation_end_date => p_validation_end_date

Line 4586: <> nvl(hr_psf_shd.g_old_rec.overlap_unit_cd,hr_api.g_varchar2)

4582: ,p_object_version_number => p_object_version_number);
4583: --
4584: if (l_api_updating
4585: and p_overlap_unit_cd
4586: <> nvl(hr_psf_shd.g_old_rec.overlap_unit_cd,hr_api.g_varchar2)
4587: or not l_api_updating)
4588: and p_overlap_unit_cd is not null then
4589: --
4590: -- check if value of lookup falls within lookup type.

Line 4592: if hr_api.not_exists_in_dt_hr_lookups

4588: and p_overlap_unit_cd is not null then
4589: --
4590: -- check if value of lookup falls within lookup type.
4591: --
4592: if hr_api.not_exists_in_dt_hr_lookups
4593: (p_lookup_type => 'FREQUENCY'
4594: ,p_lookup_code => p_overlap_unit_cd
4595: ,p_validation_start_date => p_validation_start_date
4596: ,p_validation_end_date => p_validation_end_date

Line 4668: <> nvl(hr_psf_shd.g_old_rec.bargaining_unit_cd,hr_api.g_varchar2)

4664: ,p_object_version_number => p_object_version_number);
4665: --
4666: if (l_api_updating
4667: and p_bargaining_unit_cd
4668: <> nvl(hr_psf_shd.g_old_rec.bargaining_unit_cd,hr_api.g_varchar2)
4669: or not l_api_updating)
4670: and p_bargaining_unit_cd is not null then
4671: --
4672: -- check if value of lookup falls within lookup type.

Line 4674: if hr_api.not_exists_in_dt_hr_lookups

4670: and p_bargaining_unit_cd is not null then
4671: --
4672: -- check if value of lookup falls within lookup type.
4673: --
4674: if hr_api.not_exists_in_dt_hr_lookups
4675: (p_lookup_type => 'BARGAINING_UNIT_CODE'
4676: ,p_lookup_code => p_bargaining_unit_cd
4677: ,p_validation_start_date => p_validation_start_date
4678: ,p_validation_end_date => p_validation_end_date

Line 4717: hr_api.mandatory_arg_error

4713: l_proc := g_package||'chk_fte';
4714: hr_utility.set_location('Entering:'||l_proc, 5);
4715: end if;
4716: --
4717: hr_api.mandatory_arg_error
4718: (p_api_name => l_proc
4719: ,p_argument => 'position type'
4720: ,p_argument_value => p_position_type);
4721: --

Line 4723: hr_api.mandatory_arg_error

4719: ,p_argument => 'position type'
4720: ,p_argument_value => p_position_type);
4721: --
4722: --
4723: hr_api.mandatory_arg_error
4724: (p_api_name => l_proc
4725: ,p_argument => 'validation start date'
4726: ,p_argument_value => p_validation_start_date);
4727: --

Line 4729: hr_api.mandatory_arg_error

4725: ,p_argument => 'validation start date'
4726: ,p_argument_value => p_validation_start_date);
4727: --
4728: --
4729: hr_api.mandatory_arg_error
4730: (p_api_name => l_proc
4731: ,p_argument => 'effective date'
4732: ,p_argument_value => p_effective_date);
4733: --

Line 4740: and ((p_fte <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number))

4736: ,p_effective_date => p_effective_date
4737: ,p_object_version_number => p_object_version_number);
4738: --
4739: if ((l_api_updating
4740: and ((p_fte <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number))
4741: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4742: hr_api.g_varchar2))))
4743: or not l_api_updating) then
4744: --

Line 4742: hr_api.g_varchar2))))

4738: --
4739: if ((l_api_updating
4740: and ((p_fte <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number))
4741: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4742: hr_api.g_varchar2))))
4743: or not l_api_updating) then
4744: --
4745: if p_position_type <> 'NONE' then
4746: if ( p_fte is null and p_position_type <> 'POOLED') then

Line 4781: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number),3);

4777: hr_utility.set_location('Entering:'||l_proc, 5);
4778: hr_utility.set_location('Entering:'||p_max_persons, 2);
4779:
4780: hr_utility.set_location('Entering:'||
4781: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number),3);
4782: end if;
4783: --
4784: hr_api.mandatory_arg_error
4785: (p_api_name => l_proc

Line 4784: hr_api.mandatory_arg_error

4780: hr_utility.set_location('Entering:'||
4781: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number),3);
4782: end if;
4783: --
4784: hr_api.mandatory_arg_error
4785: (p_api_name => l_proc
4786: ,p_argument => 'position type'
4787: ,p_argument_value => p_position_type);
4788: --

Line 4789: hr_api.mandatory_arg_error

4785: (p_api_name => l_proc
4786: ,p_argument => 'position type'
4787: ,p_argument_value => p_position_type);
4788: --
4789: hr_api.mandatory_arg_error
4790: (p_api_name => l_proc
4791: ,p_argument => 'effective date'
4792: ,p_argument_value => p_effective_date);
4793: --

Line 4800: and ((nvl(p_max_persons,hr_api.g_number) <>

4796: ,p_effective_date => p_effective_date
4797: ,p_object_version_number => p_object_version_number);
4798: --
4799: if ((l_api_updating
4800: and ((nvl(p_max_persons,hr_api.g_number) <>
4801: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number))
4802: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4803: hr_api.g_varchar2))))
4804: or not l_api_updating) then

Line 4801: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number))

4797: ,p_object_version_number => p_object_version_number);
4798: --
4799: if ((l_api_updating
4800: and ((nvl(p_max_persons,hr_api.g_number) <>
4801: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number))
4802: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4803: hr_api.g_varchar2))))
4804: or not l_api_updating) then
4805: --

Line 4803: hr_api.g_varchar2))))

4799: if ((l_api_updating
4800: and ((nvl(p_max_persons,hr_api.g_number) <>
4801: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number))
4802: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4803: hr_api.g_varchar2))))
4804: or not l_api_updating) then
4805: --
4806: if (p_position_type = 'SINGLE')
4807: and ((p_max_persons is NULL) or (p_max_persons <> 1 )) then

Line 4876: hr_api.mandatory_arg_error

4872: l_proc := 'chk_reserved_fte';
4873: hr_utility.set_location('Entering:'||l_proc, 5);
4874: end if;
4875: --
4876: hr_api.mandatory_arg_error
4877: (p_api_name => l_proc
4878: ,p_argument => 'position type'
4879: ,p_argument_value => p_position_type);
4880: --

Line 4882: hr_api.mandatory_arg_error

4878: ,p_argument => 'position type'
4879: ,p_argument_value => p_position_type);
4880: --
4881: --
4882: hr_api.mandatory_arg_error
4883: (p_api_name => l_proc
4884: ,p_argument => 'validation start date' ,p_argument_value => p_validation_start_date);
4885: --
4886: --

Line 4887: hr_api.mandatory_arg_error

4883: (p_api_name => l_proc
4884: ,p_argument => 'validation start date' ,p_argument_value => p_validation_start_date);
4885: --
4886: --
4887: hr_api.mandatory_arg_error
4888: (p_api_name => l_proc
4889: ,p_argument => 'effective date'
4890: ,p_argument_value => p_effective_date);
4891: --

Line 4900: <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number)

4896: --
4897:
4898: if (l_api_updating
4899: and p_fte
4900: <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number)
4901: ) then
4902: --
4903: for r2 in csr_valid_eff_date(p_position_id, p_validation_start_date, p_validation_end_date) loop
4904: if p_position_type ='SHARED' or p_position_type ='SINGLE' then

Line 5054: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)

5050: ,p_object_version_number => p_object_version_number);
5051:
5052: if (l_api_updating
5053: and p_seasonal_flag
5054: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)
5055: and (p_seasonal_flag='N' or p_seasonal_flag is null)) then
5056: open c_seasonal;
5057: fetch c_seasonal into l_dummy;
5058: if c_seasonal%found then

Line 5097: <> nvl(hr_psf_shd.g_old_rec.overlap_period,hr_api.g_number)

5093: ,p_object_version_number => p_object_version_number);
5094:
5095: if (l_api_updating
5096: and nvl(p_overlap_period,-1)
5097: <> nvl(hr_psf_shd.g_old_rec.overlap_period,hr_api.g_number)
5098: and p_overlap_period is null) then
5099: if g_debug then
5100: hr_utility.set_location('Checking for Overlap Dates in Position Extra Info:'||l_proc,20);
5101: end if;

Line 5190: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)

5186: ,p_effective_date => p_effective_date
5187: ,p_object_version_number => p_object_version_number);
5188:
5189: if (((l_api_updating and p_work_period_type_cd
5190: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)
5191: and nvl(p_WORK_PERIOD_TYPE_CD,'N') = 'Y') then
5192: if g_debug then
5193: hr_utility.set_location('Check permit_extended_pay:'||l_proc,10);
5194: end if;

Line 5318: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2))

5314: ,p_object_version_number => p_object_version_number);
5315: --
5316: if (l_api_updating
5317: and p_position_type
5318: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2))
5319: then
5320: --sqlpl
5321: -- check if value of lookup falls within lookup type.
5322: --

Line 5324: and (nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)

5320: --sqlpl
5321: -- check if value of lookup falls within lookup type.
5322: --
5323: if ((p_position_type = 'SINGLE')
5324: and (nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)
5325: <> 'SINGLE' )) then
5326: -- Start changes for bug 13519283
5327: if g_debug then
5328: hr_utility.set_location('Converting the position into Single Incumbent', 10);

Line 5449: (p_relief_position_id in number default hr_api.g_number,

5445: --
5446: -- {End Of Comments}
5447: -- ----------------------------------------------------------------------------
5448: Procedure dt_update_validate
5449: (p_relief_position_id in number default hr_api.g_number,
5450: p_successor_position_id in number default hr_api.g_number,
5451: p_supervisor_position_id in number default hr_api.g_number,
5452: p_pay_freq_payroll_id in number default hr_api.g_number,
5453: p_entry_grade_rule_id in number default hr_api.g_number,

Line 5450: p_successor_position_id in number default hr_api.g_number,

5446: -- {End Of Comments}
5447: -- ----------------------------------------------------------------------------
5448: Procedure dt_update_validate
5449: (p_relief_position_id in number default hr_api.g_number,
5450: p_successor_position_id in number default hr_api.g_number,
5451: p_supervisor_position_id in number default hr_api.g_number,
5452: p_pay_freq_payroll_id in number default hr_api.g_number,
5453: p_entry_grade_rule_id in number default hr_api.g_number,
5454: p_entry_step_id in number default hr_api.g_number,

Line 5451: p_supervisor_position_id in number default hr_api.g_number,

5447: -- ----------------------------------------------------------------------------
5448: Procedure dt_update_validate
5449: (p_relief_position_id in number default hr_api.g_number,
5450: p_successor_position_id in number default hr_api.g_number,
5451: p_supervisor_position_id in number default hr_api.g_number,
5452: p_pay_freq_payroll_id in number default hr_api.g_number,
5453: p_entry_grade_rule_id in number default hr_api.g_number,
5454: p_entry_step_id in number default hr_api.g_number,
5455: p_datetrack_mode in varchar2,

Line 5452: p_pay_freq_payroll_id in number default hr_api.g_number,

5448: Procedure dt_update_validate
5449: (p_relief_position_id in number default hr_api.g_number,
5450: p_successor_position_id in number default hr_api.g_number,
5451: p_supervisor_position_id in number default hr_api.g_number,
5452: p_pay_freq_payroll_id in number default hr_api.g_number,
5453: p_entry_grade_rule_id in number default hr_api.g_number,
5454: p_entry_step_id in number default hr_api.g_number,
5455: p_datetrack_mode in varchar2,
5456: p_validation_start_date in date,

Line 5453: p_entry_grade_rule_id in number default hr_api.g_number,

5449: (p_relief_position_id in number default hr_api.g_number,
5450: p_successor_position_id in number default hr_api.g_number,
5451: p_supervisor_position_id in number default hr_api.g_number,
5452: p_pay_freq_payroll_id in number default hr_api.g_number,
5453: p_entry_grade_rule_id in number default hr_api.g_number,
5454: p_entry_step_id in number default hr_api.g_number,
5455: p_datetrack_mode in varchar2,
5456: p_validation_start_date in date,
5457: p_validation_end_date in date) Is

Line 5454: p_entry_step_id in number default hr_api.g_number,

5450: p_successor_position_id in number default hr_api.g_number,
5451: p_supervisor_position_id in number default hr_api.g_number,
5452: p_pay_freq_payroll_id in number default hr_api.g_number,
5453: p_entry_grade_rule_id in number default hr_api.g_number,
5454: p_entry_step_id in number default hr_api.g_number,
5455: p_datetrack_mode in varchar2,
5456: p_validation_start_date in date,
5457: p_validation_end_date in date) Is
5458: --

Line 5471: hr_api.mandatory_arg_error

5467: end if;
5468: --
5469: -- Ensure that the p_datetrack_mode argument is not null
5470: --
5471: hr_api.mandatory_arg_error
5472: (p_api_name => l_proc,
5473: p_argument => 'datetrack_mode',
5474: p_argument_value => p_datetrack_mode);
5475: --

Line 5483: hr_api.mandatory_arg_error

5479: --
5480: --
5481: -- Ensure the arguments are not null
5482: --
5483: hr_api.mandatory_arg_error
5484: (p_api_name => l_proc,
5485: p_argument => 'validation_start_date',
5486: p_argument_value => p_validation_start_date);
5487: --

Line 5488: hr_api.mandatory_arg_error

5484: (p_api_name => l_proc,
5485: p_argument => 'validation_start_date',
5486: p_argument_value => p_validation_start_date);
5487: --
5488: hr_api.mandatory_arg_error
5489: (p_api_name => l_proc,
5490: p_argument => 'validation_end_date',
5491: p_argument_value => p_validation_end_date);
5492: --

Line 5497: If ((nvl(p_relief_position_id, hr_api.g_number) <> hr_api.g_number) and

5493: -- ##
5494: if g_debug then
5495: hr_utility.set_location(l_proc,20 );
5496: end if;
5497: If ((nvl(p_relief_position_id, hr_api.g_number) <> hr_api.g_number) and
5498: NOT (dt_api.check_min_max_dates
5499: (p_base_table_name => 'hr_all_positions_f',
5500: p_base_key_column => 'position_id',
5501: p_base_key_value => p_relief_position_id,

Line 5510: If ((nvl(p_successor_position_id, hr_api.g_number) <> hr_api.g_number) and

5506: End If;
5507: if g_debug then
5508: hr_utility.set_location(l_proc,30 );
5509: end if;
5510: If ((nvl(p_successor_position_id, hr_api.g_number) <> hr_api.g_number) and
5511: NOT (dt_api.check_min_max_dates
5512: (p_base_table_name => 'hr_all_positions_f',
5513: p_base_key_column => 'position_id',
5514: p_base_key_value => p_successor_position_id,

Line 5523: If ((nvl(p_supervisor_position_id, hr_api.g_number) <> hr_api.g_number) and

5519: End If;
5520: if g_debug then
5521: hr_utility.set_location(l_proc,40 );
5522: end if;
5523: If ((nvl(p_supervisor_position_id, hr_api.g_number) <> hr_api.g_number) and
5524: NOT (dt_api.check_min_max_dates
5525: (p_base_table_name => 'hr_all_positions_f',
5526: p_base_key_column => 'position_id',
5527: p_base_key_value => p_supervisor_position_id,

Line 5536: If ((nvl(p_pay_freq_payroll_id, hr_api.g_number) <> hr_api.g_number) and

5532: End If;
5533: if g_debug then
5534: hr_utility.set_location(l_proc,50 );
5535: end if;
5536: If ((nvl(p_pay_freq_payroll_id, hr_api.g_number) <> hr_api.g_number) and
5537: NOT (dt_api.check_min_max_dates
5538: (p_base_table_name => 'pay_all_payrolls_f',
5539: p_base_key_column => 'payroll_id',
5540: p_base_key_value => p_pay_freq_payroll_id,

Line 5549: If ((nvl(p_entry_step_id, hr_api.g_number) <> hr_api.g_number) and

5545: End If;
5546: if g_debug then
5547: hr_utility.set_location(l_proc,60 );
5548: end if;
5549: If ((nvl(p_entry_step_id, hr_api.g_number) <> hr_api.g_number) and
5550: NOT (dt_api.check_min_max_dates
5551: (p_base_table_name => 'per_spinal_point_steps_f',
5552: p_base_key_column => 'step_id',
5553: p_base_key_value => p_entry_step_id,

Line 5562: If ((nvl(p_entry_grade_rule_id, hr_api.g_number) <> hr_api.g_number) and

5558: End If;
5559: if g_debug then
5560: hr_utility.set_location(l_proc,70 );
5561: end if;
5562: If ((nvl(p_entry_grade_rule_id, hr_api.g_number) <> hr_api.g_number) and
5563: NOT (dt_api.check_min_max_dates
5564: (p_base_table_name => 'pay_grade_rules_f',
5565: p_base_key_column => 'grade_rule_id',
5566: p_base_key_value => p_entry_grade_rule_id,

Line 5652: hr_api.mandatory_arg_error

5648: end if;
5649: --
5650: -- Ensure that the p_datetrack_mode argument is not null
5651: --
5652: hr_api.mandatory_arg_error
5653: (p_api_name => l_proc,
5654: p_argument => 'datetrack_mode',
5655: p_argument_value => p_datetrack_mode);
5656: --

Line 5666: hr_api.mandatory_arg_error

5662: --
5663: --
5664: -- Ensure the arguments are not null
5665: --
5666: hr_api.mandatory_arg_error
5667: (p_api_name => l_proc,
5668: p_argument => 'validation_start_date',
5669: p_argument_value => p_validation_start_date);
5670: --

Line 5671: hr_api.mandatory_arg_error

5667: (p_api_name => l_proc,
5668: p_argument => 'validation_start_date',
5669: p_argument_value => p_validation_start_date);
5670: --
5671: hr_api.mandatory_arg_error
5672: (p_api_name => l_proc,
5673: p_argument => 'validation_end_date',
5674: p_argument_value => p_validation_end_date);
5675: --

Line 5676: hr_api.mandatory_arg_error

5672: (p_api_name => l_proc,
5673: p_argument => 'validation_end_date',
5674: p_argument_value => p_validation_end_date);
5675: --
5676: hr_api.mandatory_arg_error
5677: (p_api_name => l_proc,
5678: p_argument => 'position_id',
5679: p_argument_value => p_position_id);
5680: --

Line 5791: <> nvl(hr_psf_shd.g_old_rec.availability_status_id,hr_api.g_number))

5787: end if;
5788: if p_datetrack_mode = 'CORRECTION' then
5789: if (l_api_updating
5790: and p_availability_status_id
5791: <> nvl(hr_psf_shd.g_old_rec.availability_status_id,hr_api.g_number))
5792: then
5793: if g_debug then
5794: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5795: hr_utility.set_location('position id:'||p_position_id, 5);

Line 5841: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

5837: end if;
5838: --
5839: -- Call all supporting business operations
5840: --
5841: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5842: --
5843: if g_debug then
5844: hr_utility.set_location(l_proc, 6);
5845: end if;

Line 6497: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

6493: end if;
6494: --
6495: -- Call all supporting business operations
6496: --
6497: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
6498: --
6499: if g_debug then
6500: hr_utility.set_location('Entering:'||l_proc, 100);
6501: end if;

Line 7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

7817: --
7818: if (p_rec.position_id is null)
7819: or ((p_rec.position_id is not null)
7820: and
7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 7822: nvl(p_rec.information_category, hr_api.g_varchar2) or

7818: if (p_rec.position_id is null)
7819: or ((p_rec.position_id is not null)
7820: and
7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>

7819: or ((p_rec.position_id is not null)
7820: and
7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 7824: nvl(p_rec.information1, hr_api.g_varchar2) or

7820: and
7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>

7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 7826: nvl(p_rec.information2, hr_api.g_varchar2) or

7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>

7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 7828: nvl(p_rec.information3, hr_api.g_varchar2) or

7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>

7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 7830: nvl(p_rec.information4, hr_api.g_varchar2) or

7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>

7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 7832: nvl(p_rec.information5, hr_api.g_varchar2) or

7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>

7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 7834: nvl(p_rec.information6, hr_api.g_varchar2) or

7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>

7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 7836: nvl(p_rec.information7, hr_api.g_varchar2) or

7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>

7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 7838: nvl(p_rec.information8, hr_api.g_varchar2) or

7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>

7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 7840: nvl(p_rec.information9, hr_api.g_varchar2) or

7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>

7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 7842: nvl(p_rec.information10, hr_api.g_varchar2) or

7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>

7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 7844: nvl(p_rec.information11, hr_api.g_varchar2) or

7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>

7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 7846: nvl(p_rec.information12, hr_api.g_varchar2) or

7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>

7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 7848: nvl(p_rec.information13, hr_api.g_varchar2) or

7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>

7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 7850: nvl(p_rec.information14, hr_api.g_varchar2) or

7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>

7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 7852: nvl(p_rec.information15, hr_api.g_varchar2) or

7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>

7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 7854: nvl(p_rec.information16, hr_api.g_varchar2) or

7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>

7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 7856: nvl(p_rec.information17, hr_api.g_varchar2) or

7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>

7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 7858: nvl(p_rec.information18, hr_api.g_varchar2) or

7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or

Line 7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>

7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 7860: nvl(p_rec.information19, hr_api.g_varchar2) or

7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or

Line 7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>

7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 7862: nvl(p_rec.information20, hr_api.g_varchar2) or

7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or

Line 7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>

7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 7864: nvl(p_rec.information21, hr_api.g_varchar2) or

7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or

Line 7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>

7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 7866: nvl(p_rec.information22, hr_api.g_varchar2) or

7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or

Line 7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>

7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 7868: nvl(p_rec.information23, hr_api.g_varchar2) or

7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or

Line 7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>

7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 7870: nvl(p_rec.information24, hr_api.g_varchar2) or

7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or

Line 7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>

7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 7872: nvl(p_rec.information25, hr_api.g_varchar2) or

7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or

Line 7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>

7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 7874: nvl(p_rec.information26, hr_api.g_varchar2) or

7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or

Line 7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>

7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 7876: nvl(p_rec.information27, hr_api.g_varchar2) or

7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or

Line 7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>

7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 7878: nvl(p_rec.information28, hr_api.g_varchar2) or

7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7882: nvl(p_rec.information30, hr_api.g_varchar2))

Line 7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>

7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7882: nvl(p_rec.information30, hr_api.g_varchar2))
7883: then

Line 7880: nvl(p_rec.information29, hr_api.g_varchar2) or

7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7882: nvl(p_rec.information30, hr_api.g_varchar2))
7883: then
7884: --

Line 7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>

7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7882: nvl(p_rec.information30, hr_api.g_varchar2))
7883: then
7884: --
7885: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 7882: nvl(p_rec.information30, hr_api.g_varchar2))

7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7882: nvl(p_rec.information30, hr_api.g_varchar2))
7883: then
7884: --
7885: hr_dflex_utility.ins_or_upd_descflex_attribs
7886: (p_appl_short_name => 'PER'

Line 8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

8001: hr_utility.set_location('Entering:'||l_proc, 10);
8002: end if;
8003: --
8004: if ((p_rec.position_id is not null) and (
8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

8002: end if;
8003: --
8004: if ((p_rec.position_id is not null) and (
8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

8003: --
8004: if ((p_rec.position_id is not null) and (
8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or

8004: if ((p_rec.position_id is not null) and (
8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or

8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or

8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or

8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or

8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or

8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or

8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or

8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or

8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or

8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or

8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or

8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or

8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or

8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or

8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or

8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or

8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or

8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or

Line 8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or

8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or

8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or

Line 8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or

8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or

Line 8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or

8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or

Line 8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or

8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or

Line 8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or

8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or

Line 8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or

8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or

Line 8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or

8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or

Line 8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or

8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or

Line 8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or

8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))

Line 8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))
8067: or (p_rec.position_id is null) then

Line 8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or

8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))
8067: or (p_rec.position_id is null) then
8068: --

Line 8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))
8067: or (p_rec.position_id is null) then
8068: --
8069: -- Only execute the validation if absolutely necessary:

Line 8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))

8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))
8067: or (p_rec.position_id is null) then
8068: --
8069: -- Only execute the validation if absolutely necessary:
8070: -- a) During update, the structure column value or any

Line 8652: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)

8648: ,p_effective_date => p_effective_date
8649: ,p_object_version_number => p_object_version_number);
8650: --
8651: if ((l_api_updating and
8652: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8653: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8654: or not l_api_updating) then
8655: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8656: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then

Line 8653: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))

8649: ,p_object_version_number => p_object_version_number);
8650: --
8651: if ((l_api_updating and
8652: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8653: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8654: or not l_api_updating) then
8655: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8656: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then
8657: -- raise error as both flags are set to Y.