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 4875: hr_api.mandatory_arg_error

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

Line 4881: hr_api.mandatory_arg_error

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

Line 4886: hr_api.mandatory_arg_error

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

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

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

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

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

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

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

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

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

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

5268: ,p_object_version_number => p_object_version_number);
5269: --
5270: if (l_api_updating
5271: and p_position_type
5272: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2))
5273: then
5274: --
5275: -- check if value of lookup falls within lookup type.
5276: --

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

5274: --
5275: -- check if value of lookup falls within lookup type.
5276: --
5277: if ((p_position_type = 'SINGLE')
5278: and (nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)
5279: <> 'SINGLE' )) then
5280: open c_no_assignments(p_position_id, p_effective_date);
5281: fetch c_no_assignments into l_no_assignments;
5282: close c_no_assignments;

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

5328: --
5329: -- {End Of Comments}
5330: -- ----------------------------------------------------------------------------
5331: Procedure dt_update_validate
5332: (p_relief_position_id in number default hr_api.g_number,
5333: p_successor_position_id in number default hr_api.g_number,
5334: p_supervisor_position_id in number default hr_api.g_number,
5335: p_pay_freq_payroll_id in number default hr_api.g_number,
5336: p_entry_grade_rule_id in number default hr_api.g_number,

Line 5333: p_successor_position_id in number default hr_api.g_number,

5329: -- {End Of Comments}
5330: -- ----------------------------------------------------------------------------
5331: Procedure dt_update_validate
5332: (p_relief_position_id in number default hr_api.g_number,
5333: p_successor_position_id in number default hr_api.g_number,
5334: p_supervisor_position_id in number default hr_api.g_number,
5335: p_pay_freq_payroll_id in number default hr_api.g_number,
5336: p_entry_grade_rule_id in number default hr_api.g_number,
5337: p_entry_step_id in number default hr_api.g_number,

Line 5334: p_supervisor_position_id in number default hr_api.g_number,

5330: -- ----------------------------------------------------------------------------
5331: Procedure dt_update_validate
5332: (p_relief_position_id in number default hr_api.g_number,
5333: p_successor_position_id in number default hr_api.g_number,
5334: p_supervisor_position_id in number default hr_api.g_number,
5335: p_pay_freq_payroll_id in number default hr_api.g_number,
5336: p_entry_grade_rule_id in number default hr_api.g_number,
5337: p_entry_step_id in number default hr_api.g_number,
5338: p_datetrack_mode in varchar2,

Line 5335: p_pay_freq_payroll_id in number default hr_api.g_number,

5331: Procedure dt_update_validate
5332: (p_relief_position_id in number default hr_api.g_number,
5333: p_successor_position_id in number default hr_api.g_number,
5334: p_supervisor_position_id in number default hr_api.g_number,
5335: p_pay_freq_payroll_id in number default hr_api.g_number,
5336: p_entry_grade_rule_id in number default hr_api.g_number,
5337: p_entry_step_id in number default hr_api.g_number,
5338: p_datetrack_mode in varchar2,
5339: p_validation_start_date in date,

Line 5336: p_entry_grade_rule_id in number default hr_api.g_number,

5332: (p_relief_position_id in number default hr_api.g_number,
5333: p_successor_position_id in number default hr_api.g_number,
5334: p_supervisor_position_id in number default hr_api.g_number,
5335: p_pay_freq_payroll_id in number default hr_api.g_number,
5336: p_entry_grade_rule_id in number default hr_api.g_number,
5337: p_entry_step_id in number default hr_api.g_number,
5338: p_datetrack_mode in varchar2,
5339: p_validation_start_date in date,
5340: p_validation_end_date in date) Is

Line 5337: p_entry_step_id in number default hr_api.g_number,

5333: p_successor_position_id in number default hr_api.g_number,
5334: p_supervisor_position_id in number default hr_api.g_number,
5335: p_pay_freq_payroll_id in number default hr_api.g_number,
5336: p_entry_grade_rule_id in number default hr_api.g_number,
5337: p_entry_step_id in number default hr_api.g_number,
5338: p_datetrack_mode in varchar2,
5339: p_validation_start_date in date,
5340: p_validation_end_date in date) Is
5341: --

Line 5354: hr_api.mandatory_arg_error

5350: end if;
5351: --
5352: -- Ensure that the p_datetrack_mode argument is not null
5353: --
5354: hr_api.mandatory_arg_error
5355: (p_api_name => l_proc,
5356: p_argument => 'datetrack_mode',
5357: p_argument_value => p_datetrack_mode);
5358: --

Line 5366: hr_api.mandatory_arg_error

5362: --
5363: --
5364: -- Ensure the arguments are not null
5365: --
5366: hr_api.mandatory_arg_error
5367: (p_api_name => l_proc,
5368: p_argument => 'validation_start_date',
5369: p_argument_value => p_validation_start_date);
5370: --

Line 5371: hr_api.mandatory_arg_error

5367: (p_api_name => l_proc,
5368: p_argument => 'validation_start_date',
5369: p_argument_value => p_validation_start_date);
5370: --
5371: hr_api.mandatory_arg_error
5372: (p_api_name => l_proc,
5373: p_argument => 'validation_end_date',
5374: p_argument_value => p_validation_end_date);
5375: --

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

5376: -- ##
5377: if g_debug then
5378: hr_utility.set_location(l_proc,20 );
5379: end if;
5380: If ((nvl(p_relief_position_id, hr_api.g_number) <> hr_api.g_number) and
5381: NOT (dt_api.check_min_max_dates
5382: (p_base_table_name => 'hr_all_positions_f',
5383: p_base_key_column => 'position_id',
5384: p_base_key_value => p_relief_position_id,

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

5389: End If;
5390: if g_debug then
5391: hr_utility.set_location(l_proc,30 );
5392: end if;
5393: If ((nvl(p_successor_position_id, hr_api.g_number) <> hr_api.g_number) and
5394: NOT (dt_api.check_min_max_dates
5395: (p_base_table_name => 'hr_all_positions_f',
5396: p_base_key_column => 'position_id',
5397: p_base_key_value => p_successor_position_id,

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

5402: End If;
5403: if g_debug then
5404: hr_utility.set_location(l_proc,40 );
5405: end if;
5406: If ((nvl(p_supervisor_position_id, hr_api.g_number) <> hr_api.g_number) and
5407: NOT (dt_api.check_min_max_dates
5408: (p_base_table_name => 'hr_all_positions_f',
5409: p_base_key_column => 'position_id',
5410: p_base_key_value => p_supervisor_position_id,

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

5415: End If;
5416: if g_debug then
5417: hr_utility.set_location(l_proc,50 );
5418: end if;
5419: If ((nvl(p_pay_freq_payroll_id, hr_api.g_number) <> hr_api.g_number) and
5420: NOT (dt_api.check_min_max_dates
5421: (p_base_table_name => 'pay_all_payrolls_f',
5422: p_base_key_column => 'payroll_id',
5423: p_base_key_value => p_pay_freq_payroll_id,

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

5428: End If;
5429: if g_debug then
5430: hr_utility.set_location(l_proc,60 );
5431: end if;
5432: If ((nvl(p_entry_step_id, hr_api.g_number) <> hr_api.g_number) and
5433: NOT (dt_api.check_min_max_dates
5434: (p_base_table_name => 'per_spinal_point_steps_f',
5435: p_base_key_column => 'step_id',
5436: p_base_key_value => p_entry_step_id,

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

5441: End If;
5442: if g_debug then
5443: hr_utility.set_location(l_proc,70 );
5444: end if;
5445: If ((nvl(p_entry_grade_rule_id, hr_api.g_number) <> hr_api.g_number) and
5446: NOT (dt_api.check_min_max_dates
5447: (p_base_table_name => 'pay_grade_rules_f',
5448: p_base_key_column => 'grade_rule_id',
5449: p_base_key_value => p_entry_grade_rule_id,

Line 5535: hr_api.mandatory_arg_error

5531: end if;
5532: --
5533: -- Ensure that the p_datetrack_mode argument is not null
5534: --
5535: hr_api.mandatory_arg_error
5536: (p_api_name => l_proc,
5537: p_argument => 'datetrack_mode',
5538: p_argument_value => p_datetrack_mode);
5539: --

Line 5549: hr_api.mandatory_arg_error

5545: --
5546: --
5547: -- Ensure the arguments are not null
5548: --
5549: hr_api.mandatory_arg_error
5550: (p_api_name => l_proc,
5551: p_argument => 'validation_start_date',
5552: p_argument_value => p_validation_start_date);
5553: --

Line 5554: hr_api.mandatory_arg_error

5550: (p_api_name => l_proc,
5551: p_argument => 'validation_start_date',
5552: p_argument_value => p_validation_start_date);
5553: --
5554: hr_api.mandatory_arg_error
5555: (p_api_name => l_proc,
5556: p_argument => 'validation_end_date',
5557: p_argument_value => p_validation_end_date);
5558: --

Line 5559: hr_api.mandatory_arg_error

5555: (p_api_name => l_proc,
5556: p_argument => 'validation_end_date',
5557: p_argument_value => p_validation_end_date);
5558: --
5559: hr_api.mandatory_arg_error
5560: (p_api_name => l_proc,
5561: p_argument => 'position_id',
5562: p_argument_value => p_position_id);
5563: --

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

5670: end if;
5671: if p_datetrack_mode = 'CORRECTION' then
5672: if (l_api_updating
5673: and p_availability_status_id
5674: <> nvl(hr_psf_shd.g_old_rec.availability_status_id,hr_api.g_number))
5675: then
5676: if g_debug then
5677: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5678: hr_utility.set_location('position id:'||p_position_id, 5);

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

5720: end if;
5721: --
5722: -- Call all supporting business operations
5723: --
5724: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5725: --
5726: if g_debug then
5727: hr_utility.set_location(l_proc, 6);
5728: end if;

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

6376: end if;
6377: --
6378: -- Call all supporting business operations
6379: --
6380: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
6381: --
6382: if g_debug then
6383: hr_utility.set_location('Entering:'||l_proc, 100);
6384: end if;

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

7690: --
7691: if (p_rec.position_id is null)
7692: or ((p_rec.position_id is not null)
7693: and
7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

7691: if (p_rec.position_id is null)
7692: or ((p_rec.position_id is not null)
7693: and
7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or

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

7692: or ((p_rec.position_id is not null)
7693: and
7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

7693: and
7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or

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

7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or

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

7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or

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

7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or

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

7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or

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

7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or

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

7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or

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

7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or

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

7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or

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

7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>

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

7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or

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

7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or

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

7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or

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

7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or

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

7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or

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

7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or

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

7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or

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

7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or

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

7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or

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

7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>

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

7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or

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

7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>

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

7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or

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

7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>

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

7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or

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

7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>

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

7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or

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

7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>

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

7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or

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

7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>

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

7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or

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

7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>

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

7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or

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

7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>

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

7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or

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

7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>

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

7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or

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

7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>

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

7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7755: nvl(p_rec.information30, hr_api.g_varchar2))

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

7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7755: nvl(p_rec.information30, hr_api.g_varchar2))
7756: then

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

7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7755: nvl(p_rec.information30, hr_api.g_varchar2))
7756: then
7757: --

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

7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7755: nvl(p_rec.information30, hr_api.g_varchar2))
7756: then
7757: --
7758: hr_dflex_utility.ins_or_upd_descflex_attribs

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

7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7755: nvl(p_rec.information30, hr_api.g_varchar2))
7756: then
7757: --
7758: hr_dflex_utility.ins_or_upd_descflex_attribs
7759: (p_appl_short_name => 'PER'

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

7874: hr_utility.set_location('Entering:'||l_proc, 10);
7875: end if;
7876: --
7877: if ((p_rec.position_id is not null) and (
7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

7875: end if;
7876: --
7877: if ((p_rec.position_id is not null) and (
7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

7876: --
7877: if ((p_rec.position_id is not null) and (
7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

7877: if ((p_rec.position_id is not null) and (
7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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

7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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

7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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

7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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

7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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

7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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

7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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

7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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

7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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

7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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

7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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

7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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

7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7939: nvl(p_rec.attribute30, hr_api.g_varchar2)))

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

7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7939: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7940: or (p_rec.position_id is null) then

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

7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7939: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7940: or (p_rec.position_id is null) then
7941: --

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

7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7939: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7940: or (p_rec.position_id is null) then
7941: --
7942: -- Only execute the validation if absolutely necessary:

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

7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7939: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7940: or (p_rec.position_id is null) then
7941: --
7942: -- Only execute the validation if absolutely necessary:
7943: -- a) During update, the structure column value or any

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

8521: ,p_effective_date => p_effective_date
8522: ,p_object_version_number => p_object_version_number);
8523: --
8524: if ((l_api_updating and
8525: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8526: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8527: or not l_api_updating) then
8528: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8529: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then

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

8522: ,p_object_version_number => p_object_version_number);
8523: --
8524: if ((l_api_updating and
8525: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8526: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8527: or not l_api_updating) then
8528: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8529: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then
8530: -- raise error as both flags are set to Y.