40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_ptx_shd.api_updating
47: (p_position_transaction_id => p_position_transaction_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_position_transaction_id;
75: --
76: -- ----------------------------------------------------------------------------
112: where a.organization_id = p_organization_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_ptx_shd.api_updating
119: (p_position_transaction_id => p_position_transaction_id,
120: p_object_version_number => p_object_version_number);
144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_organization_id;
151: --
152: -- ----------------------------------------------------------------------------
188: where a.position_definition_id = p_position_definition_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_ptx_shd.api_updating
195: (p_position_transaction_id => p_position_transaction_id,
196: p_object_version_number => p_object_version_number);
220: close c1;
221: --
222: end if;
223: --
224: hr_utility.set_location('Leaving:'||l_proc,10);
225: --
226: End chk_position_definition_id;
227: --
228: -- ----------------------------------------------------------------------------
264: where a.job_id = p_job_id;
265: --
266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_ptx_shd.api_updating
271: (p_position_transaction_id => p_position_transaction_id,
272: p_object_version_number => p_object_version_number);
296: close c1;
297: --
298: end if;
299: --
300: hr_utility.set_location('Leaving:'||l_proc,10);
301: --
302: End chk_job_id;
303: --
304: -- ----------------------------------------------------------------------------
340: where a.location_id = p_location_id;
341: --
342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc,5);
345: --
346: l_api_updating := pqh_ptx_shd.api_updating
347: (p_position_transaction_id => p_position_transaction_id,
348: p_object_version_number => p_object_version_number);
372: close c1;
373: --
374: end if;
375: --
376: hr_utility.set_location('Leaving:'||l_proc,10);
377: --
378: End chk_location_id;
379: --
380: -- ----------------------------------------------------------------------------
416: where a.shared_type_id = p_availability_status_id;
417: --
418: Begin
419: --
420: hr_utility.set_location('Entering:'||l_proc,5);
421: --
422: l_api_updating := pqh_ptx_shd.api_updating
423: (p_position_transaction_id => p_position_transaction_id,
424: p_object_version_number => p_object_version_number);
448: close c1;
449: --
450: end if;
451: --
452: hr_utility.set_location('Leaving:'||l_proc,10);
453: --
454: End chk_availability_status_id;
455: --
456: -- ----------------------------------------------------------------------------
492: where a.grade_id = p_entry_grade_id;
493: --
494: Begin
495: --
496: hr_utility.set_location('Entering:'||l_proc,5);
497: --
498: l_api_updating := pqh_ptx_shd.api_updating
499: (p_position_transaction_id => p_position_transaction_id,
500: p_object_version_number => p_object_version_number);
524: close c1;
525: --
526: end if;
527: --
528: hr_utility.set_location('Leaving:'||l_proc,10);
529: --
530: End chk_entry_grade_id;
531: --
532: -- ----------------------------------------------------------------------------
564: l_api_updating boolean;
565: --
566: Begin
567: --
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: l_api_updating := pqh_ptx_shd.api_updating
571: (p_position_transaction_id => p_position_transaction_id,
572: p_object_version_number => p_object_version_number);
585: p_effective_date => p_effective_date) then
586: --
587: -- raise error as does not exist as lookup
588: --
589: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
590: hr_utility.raise_error;
591: --
592: end if;
593: --
586: --
587: -- raise error as does not exist as lookup
588: --
589: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
590: hr_utility.raise_error;
591: --
592: end if;
593: --
594: end if;
592: end if;
593: --
594: end if;
595: --
596: hr_utility.set_location('Leaving:'||l_proc,10);
597: --
598: end chk_work_term_end_month_cd;
599: --
600: -- ----------------------------------------------------------------------------
632: l_api_updating boolean;
633: --
634: Begin
635: --
636: hr_utility.set_location('Entering:'||l_proc, 5);
637: --
638: l_api_updating := pqh_ptx_shd.api_updating
639: (p_position_transaction_id => p_position_transaction_id,
640: p_object_version_number => p_object_version_number);
653: p_effective_date => p_effective_date) then
654: --
655: -- raise error as does not exist as lookup
656: --
657: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
658: hr_utility.raise_error;
659: --
660: end if;
661: --
654: --
655: -- raise error as does not exist as lookup
656: --
657: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
658: hr_utility.raise_error;
659: --
660: end if;
661: --
662: end if;
660: end if;
661: --
662: end if;
663: --
664: hr_utility.set_location('Leaving:'||l_proc,10);
665: --
666: end chk_work_term_end_day_cd;
667: --
668: -- ----------------------------------------------------------------------------
700: l_api_updating boolean;
701: --
702: Begin
703: --
704: hr_utility.set_location('Entering:'||l_proc, 5);
705: --
706: l_api_updating := pqh_ptx_shd.api_updating
707: (p_position_transaction_id => p_position_transaction_id,
708: p_object_version_number => p_object_version_number);
721: p_effective_date => p_effective_date) then
722: --
723: -- raise error as does not exist as lookup
724: --
725: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
726: hr_utility.raise_error;
727: --
728: end if;
729: --
722: --
723: -- raise error as does not exist as lookup
724: --
725: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
726: hr_utility.raise_error;
727: --
728: end if;
729: --
730: end if;
728: end if;
729: --
730: end if;
731: --
732: hr_utility.set_location('Leaving:'||l_proc,10);
733: --
734: end chk_work_period_type_cd;
735: --
736: -- ----------------------------------------------------------------------------
768: l_api_updating boolean;
769: --
770: Begin
771: --
772: hr_utility.set_location('Entering:'||l_proc, 5);
773: --
774: l_api_updating := pqh_ptx_shd.api_updating
775: (p_position_transaction_id => p_position_transaction_id,
776: p_object_version_number => p_object_version_number);
789: p_effective_date => p_effective_date) then
790: --
791: -- raise error as does not exist as lookup
792: --
793: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
794: hr_utility.raise_error;
795: --
796: end if;
797: --
790: --
791: -- raise error as does not exist as lookup
792: --
793: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
794: hr_utility.raise_error;
795: --
796: end if;
797: --
798: end if;
796: end if;
797: --
798: end if;
799: --
800: hr_utility.set_location('Leaving:'||l_proc,10);
801: --
802: end chk_works_council_approval_flg;
803: --
804: -- ----------------------------------------------------------------------------
836: l_api_updating boolean;
837: --
838: Begin
839: --
840: hr_utility.set_location('Entering:'||l_proc, 5);
841: --
842: l_api_updating := pqh_ptx_shd.api_updating
843: (p_position_transaction_id => p_position_transaction_id,
844: p_object_version_number => p_object_version_number);
857: p_effective_date => p_effective_date) then
858: --
859: -- raise error as does not exist as lookup
860: --
861: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
862: hr_utility.raise_error;
863: --
864: end if;
865: --
858: --
859: -- raise error as does not exist as lookup
860: --
861: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
862: hr_utility.raise_error;
863: --
864: end if;
865: --
866: end if;
864: end if;
865: --
866: end if;
867: --
868: hr_utility.set_location('Leaving:'||l_proc,10);
869: --
870: end chk_term_start_month_cd;
871: --
872: -- ----------------------------------------------------------------------------
904: l_api_updating boolean;
905: --
906: Begin
907: --
908: hr_utility.set_location('Entering:'||l_proc, 5);
909: --
910: l_api_updating := pqh_ptx_shd.api_updating
911: (p_position_transaction_id => p_position_transaction_id,
912: p_object_version_number => p_object_version_number);
925: p_effective_date => p_effective_date) then
926: --
927: -- raise error as does not exist as lookup
928: --
929: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
930: hr_utility.raise_error;
931: --
932: end if;
933: --
926: --
927: -- raise error as does not exist as lookup
928: --
929: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
930: hr_utility.raise_error;
931: --
932: end if;
933: --
934: end if;
932: end if;
933: --
934: end if;
935: --
936: hr_utility.set_location('Leaving:'||l_proc,10);
937: --
938: end chk_term_start_day_cd;
939: --
940: -- ----------------------------------------------------------------------------
972: l_api_updating boolean;
973: --
974: Begin
975: --
976: hr_utility.set_location('Entering:'||l_proc, 5);
977: --
978: l_api_updating := pqh_ptx_shd.api_updating
979: (p_position_transaction_id => p_position_transaction_id,
980: p_object_version_number => p_object_version_number);
993: p_effective_date => p_effective_date) then
994: --
995: -- raise error as does not exist as lookup
996: --
997: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
998: hr_utility.raise_error;
999: --
1000: end if;
1001: --
994: --
995: -- raise error as does not exist as lookup
996: --
997: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
998: hr_utility.raise_error;
999: --
1000: end if;
1001: --
1002: end if;
1000: end if;
1001: --
1002: end if;
1003: --
1004: hr_utility.set_location('Leaving:'||l_proc,10);
1005: --
1006: end chk_seasonal_flag;
1007: --
1008: -- ----------------------------------------------------------------------------
1048: and position_transaction_id <> p_position_transaction_id
1049: and transaction_status not in ('TERMINATE', 'APPLIED', 'REJECT');
1050: Begin
1051: --
1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: l_api_updating := pqh_ptx_shd.api_updating
1055: (p_position_transaction_id => p_position_transaction_id,
1056: p_object_version_number => p_object_version_number);
1069: p_effective_date => p_effective_date) then
1070: --
1071: -- raise error as does not exist as lookup
1072: --
1073: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1074: hr_utility.raise_error;
1075: --
1076: end if;
1077: --
1070: --
1071: -- raise error as does not exist as lookup
1072: --
1073: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1074: hr_utility.raise_error;
1075: --
1076: end if;
1077: --
1078: if p_position_id is not null then
1079: open c_position_transactions(p_position_id);
1080: fetch c_position_transactions into l_dummy;
1081: --
1082: if c_position_transactions%found then
1083: hr_utility.set_message(8302,'PQH_PTX_EXISTS_CANT_REVIEW');
1084: hr_utility.raise_error;
1085: end if;
1086: end if;
1087: end if;
1080: fetch c_position_transactions into l_dummy;
1081: --
1082: if c_position_transactions%found then
1083: hr_utility.set_message(8302,'PQH_PTX_EXISTS_CANT_REVIEW');
1084: hr_utility.raise_error;
1085: end if;
1086: end if;
1087: end if;
1088: --
1085: end if;
1086: end if;
1087: end if;
1088: --
1089: hr_utility.set_location('Leaving:'||l_proc,10);
1090: --
1091: end chk_review_flag;
1092: --
1093: -- -------------------------------------------------------------------
1127: l_api_updating boolean;
1128: --
1129: Begin
1130: --
1131: hr_utility.set_location('Entering:'||l_proc, 5);
1132: --
1133: l_api_updating := pqh_ptx_shd.api_updating
1134: (p_position_transaction_id => p_position_transaction_id,
1135: p_object_version_number => p_object_version_number);
1148: p_effective_date => p_effective_date) then
1149: --
1150: -- raise error as does not exist as lookup
1151: --
1152: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1153: hr_utility.raise_error;
1154: --
1155: end if;
1156: --
1149: --
1150: -- raise error as does not exist as lookup
1151: --
1152: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1153: hr_utility.raise_error;
1154: --
1155: end if;
1156: --
1157: end if;
1155: end if;
1156: --
1157: end if;
1158: --
1159: hr_utility.set_location('Leaving:'||l_proc,10);
1160: --
1161: end chk_replacement_required_flag;
1162: --
1163: -- ----------------------------------------------------------------------------
1195: l_api_updating boolean;
1196: --
1197: Begin
1198: --
1199: hr_utility.set_location('Entering:'||l_proc, 5);
1200: --
1201: l_api_updating := pqh_ptx_shd.api_updating
1202: (p_position_transaction_id => p_position_transaction_id,
1203: p_object_version_number => p_object_version_number);
1216: p_effective_date => p_effective_date) then
1217: --
1218: -- raise error as does not exist as lookup
1219: --
1220: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1221: hr_utility.raise_error;
1222: --
1223: end if;
1224: --
1217: --
1218: -- raise error as does not exist as lookup
1219: --
1220: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1221: hr_utility.raise_error;
1222: --
1223: end if;
1224: --
1225: end if;
1223: end if;
1224: --
1225: end if;
1226: --
1227: hr_utility.set_location('Leaving:'||l_proc,10);
1228: --
1229: end chk_probation_period_unit_cd;
1230: --
1231: -- ----------------------------------------------------------------------------
1263: l_api_updating boolean;
1264: --
1265: Begin
1266: --
1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: --
1269: l_api_updating := pqh_ptx_shd.api_updating
1270: (p_position_transaction_id => p_position_transaction_id,
1271: p_object_version_number => p_object_version_number);
1284: p_effective_date => p_effective_date) then
1285: --
1286: -- raise error as does not exist as lookup
1287: --
1288: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1289: hr_utility.raise_error;
1290: --
1291: end if;
1292: --
1285: --
1286: -- raise error as does not exist as lookup
1287: --
1288: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1289: hr_utility.raise_error;
1290: --
1291: end if;
1292: --
1293: end if;
1291: end if;
1292: --
1293: end if;
1294: --
1295: hr_utility.set_location('Leaving:'||l_proc,10);
1296: --
1297: end chk_permit_recruitment_flag;
1298: --
1299: -- ----------------------------------------------------------------------------
1331: l_api_updating boolean;
1332: --
1333: Begin
1334: --
1335: hr_utility.set_location('Entering:'||l_proc, 5);
1336: --
1337: l_api_updating := pqh_ptx_shd.api_updating
1338: (p_position_transaction_id => p_position_transaction_id,
1339: p_object_version_number => p_object_version_number);
1352: p_effective_date => p_effective_date) then
1353: --
1354: -- raise error as does not exist as lookup
1355: --
1356: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1357: hr_utility.raise_error;
1358: --
1359: end if;
1360: --
1353: --
1354: -- raise error as does not exist as lookup
1355: --
1356: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1357: hr_utility.raise_error;
1358: --
1359: end if;
1360: --
1361: end if;
1359: end if;
1360: --
1361: end if;
1362: --
1363: hr_utility.set_location('Leaving:'||l_proc,10);
1364: --
1365: end chk_permanent_temporary_flag;
1366: --
1367: -- ----------------------------------------------------------------------------
1399: l_api_updating boolean;
1400: --
1401: Begin
1402: --
1403: hr_utility.set_location('Entering:'||l_proc, 5);
1404: --
1405: l_api_updating := pqh_ptx_shd.api_updating
1406: (p_position_transaction_id => p_position_transaction_id,
1407: p_object_version_number => p_object_version_number);
1420: p_effective_date => p_effective_date) then
1421: --
1422: -- raise error as does not exist as lookup
1423: --
1424: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1425: hr_utility.raise_error;
1426: --
1427: end if;
1428: --
1421: --
1422: -- raise error as does not exist as lookup
1423: --
1424: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1425: hr_utility.raise_error;
1426: --
1427: end if;
1428: --
1429: end if;
1427: end if;
1428: --
1429: end if;
1430: --
1431: hr_utility.set_location('Leaving:'||l_proc,10);
1432: --
1433: end chk_pay_term_end_month_cd;
1434: --
1435: -- ----------------------------------------------------------------------------
1467: l_api_updating boolean;
1468: --
1469: Begin
1470: --
1471: hr_utility.set_location('Entering:'||l_proc, 5);
1472: --
1473: l_api_updating := pqh_ptx_shd.api_updating
1474: (p_position_transaction_id => p_position_transaction_id,
1475: p_object_version_number => p_object_version_number);
1488: p_effective_date => p_effective_date) then
1489: --
1490: -- raise error as does not exist as lookup
1491: --
1492: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1493: hr_utility.raise_error;
1494: --
1495: end if;
1496: --
1489: --
1490: -- raise error as does not exist as lookup
1491: --
1492: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1493: hr_utility.raise_error;
1494: --
1495: end if;
1496: --
1497: end if;
1495: end if;
1496: --
1497: end if;
1498: --
1499: hr_utility.set_location('Leaving:'||l_proc,10);
1500: --
1501: end chk_pay_term_end_day_cd;
1502: --
1503: -- ----------------------------------------------------------------------------
1535: l_api_updating boolean;
1536: --
1537: Begin
1538: --
1539: hr_utility.set_location('Entering:'||l_proc, 5);
1540: --
1541: l_api_updating := pqh_ptx_shd.api_updating
1542: (p_position_transaction_id => p_position_transaction_id,
1543: p_object_version_number => p_object_version_number);
1556: p_effective_date => p_effective_date) then
1557: --
1558: -- raise error as does not exist as lookup
1559: --
1560: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1561: hr_utility.raise_error;
1562: --
1563: end if;
1564: --
1557: --
1558: -- raise error as does not exist as lookup
1559: --
1560: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1561: hr_utility.raise_error;
1562: --
1563: end if;
1564: --
1565: end if;
1563: end if;
1564: --
1565: end if;
1566: --
1567: hr_utility.set_location('Leaving:'||l_proc,10);
1568: --
1569: end chk_overlap_unit_cd;
1570: --
1571: -- ----------------------------------------------------------------------------
1603: l_api_updating boolean;
1604: --
1605: Begin
1606: --
1607: hr_utility.set_location('Entering:'||l_proc, 5);
1608: --
1609: l_api_updating := pqh_ptx_shd.api_updating
1610: (p_position_transaction_id => p_position_transaction_id,
1611: p_object_version_number => p_object_version_number);
1624: p_effective_date => p_effective_date) then
1625: --
1626: -- raise error as does not exist as lookup
1627: --
1628: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1629: hr_utility.raise_error;
1630: --
1631: end if;
1632: --
1625: --
1626: -- raise error as does not exist as lookup
1627: --
1628: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1629: hr_utility.raise_error;
1630: --
1631: end if;
1632: --
1633: end if;
1631: end if;
1632: --
1633: end if;
1634: --
1635: hr_utility.set_location('Leaving:'||l_proc,10);
1636: --
1637: end chk_bargaining_unit_cd;
1638: --
1639: -- ----------------------------------------------------------------------------
1651: --
1652: l_proc varchar2(30):='chk_extended_flag';
1653: Begin
1654: --
1655: hr_utility.set_location('Entering:'||l_proc, 5);
1656: --
1657: if p_work_period_type_cd = 'Y' then
1658: /*
1659: if p_pay_term_end_day_cd is null or
1660: p_pay_term_end_month_cd is null or
1661: p_work_term_end_day_cd is null or
1662: p_work_term_end_month_cd is null then
1663: --
1664: hr_utility.set_message(800,'HR_PAY_WORK_TERM_MUST_BE_ENTR');
1665: hr_utility.raise_error;
1666: */
1667: if (( (p_pay_term_end_day_cd is null and
1668: p_pay_term_end_month_cd is not null) or
1661: p_work_term_end_day_cd is null or
1662: p_work_term_end_month_cd is null then
1663: --
1664: hr_utility.set_message(800,'HR_PAY_WORK_TERM_MUST_BE_ENTR');
1665: hr_utility.raise_error;
1666: */
1667: if (( (p_pay_term_end_day_cd is null and
1668: p_pay_term_end_month_cd is not null) or
1669: (p_pay_term_end_day_cd is not null and
1672: p_term_start_month_cd is not null) or
1673: (p_term_start_day_cd is not null and
1674: p_term_start_month_cd is null))) then
1675: --
1676: hr_utility.set_message(800,'HR_INVALID_PAY_TERM');
1677: hr_utility.raise_error;
1678: end if;
1679: if ( (p_work_term_end_day_cd is null and
1680: p_work_term_end_month_cd is not null) or
1673: (p_term_start_day_cd is not null and
1674: p_term_start_month_cd is null))) then
1675: --
1676: hr_utility.set_message(800,'HR_INVALID_PAY_TERM');
1677: hr_utility.raise_error;
1678: end if;
1679: if ( (p_work_term_end_day_cd is null and
1680: p_work_term_end_month_cd is not null) or
1681: (p_work_term_end_day_cd is not null and
1680: p_work_term_end_month_cd is not null) or
1681: (p_work_term_end_day_cd is not null and
1682: p_work_term_end_month_cd is null)) then
1683: --
1684: hr_utility.set_message(800,'HR_INVALID_WORK_TERM');
1685: hr_utility.raise_error;
1686: end if;
1687: else
1688: if p_pay_term_end_day_cd is not null or
1681: (p_work_term_end_day_cd is not null and
1682: p_work_term_end_month_cd is null)) then
1683: --
1684: hr_utility.set_message(800,'HR_INVALID_WORK_TERM');
1685: hr_utility.raise_error;
1686: end if;
1687: else
1688: if p_pay_term_end_day_cd is not null or
1689: p_pay_term_end_month_cd is not null or
1691: p_term_start_month_cd is not null or
1692: p_work_term_end_day_cd is not null or
1693: p_work_term_end_month_cd is not null then
1694: --
1695: hr_utility.set_message(800,'HR_PAY_WORK_TERM_MUST_BE_NULL');
1696: hr_utility.raise_error;
1697: end if;
1698: end if;
1699: --
1692: p_work_term_end_day_cd is not null or
1693: p_work_term_end_month_cd is not null then
1694: --
1695: hr_utility.set_message(800,'HR_PAY_WORK_TERM_MUST_BE_NULL');
1696: hr_utility.raise_error;
1697: end if;
1698: end if;
1699: --
1700: end chk_extended_pay;
1712: where position_transaction_id = p_position_transaction_id
1713: and information_type = 'PER_FAMILY'
1714: and information3 in ('ACADEMIC','FACULTY');
1715: begin
1716: hr_utility.set_location('Entering:'||l_proc,10);
1717: if p_position_transaction_id is not null then
1718: open c1;
1719: fetch c1 into l_position_family;
1720: if c1%found then
1717: if p_position_transaction_id is not null then
1718: open c1;
1719: fetch c1 into l_position_family;
1720: if c1%found then
1721: hr_utility.set_location('Academic/Faculty Position Extra info Found:'||l_proc,10);
1722: close c1;
1723: return true;
1724: else
1725: close c1;
1722: close c1;
1723: return true;
1724: else
1725: close c1;
1726: hr_utility.set_location('Academic/Faculty Position Extra info not Found:'||l_proc,10);
1727: return false;
1728: end if;
1729: else
1730: return(false);
1728: end if;
1729: else
1730: return(false);
1731: end if;
1732: hr_utility.set_location('Leaving:'||l_proc,20);
1733: end;
1734:
1735: --
1736: -- ----------------------------------------------------------------------------
1744: l_proc varchar2(100):='chk_extended_pay_permit';
1745: l_api_updating boolean;
1746: l_permit_extended_pay boolean;
1747: begin
1748: hr_utility.set_location('Entering:'||l_proc,10);
1749: l_api_updating := pqh_ptx_shd.api_updating
1750: (p_position_transaction_id => p_position_transaction_id
1751: ,p_object_version_number => p_object_version_number);
1752:
1752:
1753: if (((l_api_updating and p_work_period_type_cd
1754: <> nvl(pqh_ptx_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)
1755: and nvl(p_WORK_PERIOD_TYPE_CD,'N') = 'Y') then
1756: hr_utility.set_location('Check permit_extended_pay:'||l_proc,10);
1757: l_permit_extended_pay := permit_extended_pay(p_position_transaction_id => p_position_transaction_id);
1758: hr_utility.set_location('Checking permit_extended_pay complete:'||l_proc,10);
1759: if (l_permit_extended_pay = false) then
1760: --Position family is neither Academic nor Faculty, so Extended pay cannot be permitted.
1754: <> nvl(pqh_ptx_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)
1755: and nvl(p_WORK_PERIOD_TYPE_CD,'N') = 'Y') then
1756: hr_utility.set_location('Check permit_extended_pay:'||l_proc,10);
1757: l_permit_extended_pay := permit_extended_pay(p_position_transaction_id => p_position_transaction_id);
1758: hr_utility.set_location('Checking permit_extended_pay complete:'||l_proc,10);
1759: if (l_permit_extended_pay = false) then
1760: --Position family is neither Academic nor Faculty, so Extended pay cannot be permitted.
1761: fnd_message.set_name(800,'HR_INV_EXTD_PAY_PERMIT');
1762: fnd_message.raise_error;
1761: fnd_message.set_name(800,'HR_INV_EXTD_PAY_PERMIT');
1762: fnd_message.raise_error;
1763: end if;
1764: end if;
1765: hr_utility.set_location('Leaving:'||l_proc,20);
1766: end;
1767: --
1768: --
1769: -- ----------------------------------------------------------------------------
1790: l_api_updating boolean;
1791: begin
1792:
1793: --
1794: hr_utility.set_location('Entering:'||l_proc,5);
1795: --
1796: l_api_updating := pqh_ptx_shd.api_updating
1797: (p_position_transaction_id => p_position_transaction_id,
1798: p_object_version_number => p_object_version_number);
1803: or not l_api_updating) and
1804: date_effective is not null then
1805: --
1806: if current_org_prop_end_date < date_effective then
1807: hr_utility.set_message('800','PER_INVALID_ORG_PROP_END_DATE');
1808: hr_utility.raise_error;
1809: end if;
1810: --
1811: if current_job_prop_end_date < date_effective then
1804: date_effective is not null then
1805: --
1806: if current_org_prop_end_date < date_effective then
1807: hr_utility.set_message('800','PER_INVALID_ORG_PROP_END_DATE');
1808: hr_utility.raise_error;
1809: end if;
1810: --
1811: if current_job_prop_end_date < date_effective then
1812: hr_utility.set_message('800','PER_INVALID_JOB_PROP_END_DATE');
1808: hr_utility.raise_error;
1809: end if;
1810: --
1811: if current_job_prop_end_date < date_effective then
1812: hr_utility.set_message('800','PER_INVALID_JOB_PROP_END_DATE');
1813: hr_utility.raise_error;
1814: end if;
1815:
1816: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (
1809: end if;
1810: --
1811: if current_job_prop_end_date < date_effective then
1812: hr_utility.set_message('800','PER_INVALID_JOB_PROP_END_DATE');
1813: hr_utility.raise_error;
1814: end if;
1815:
1816: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (
1817: position_id
1817: position_id
1818: ,availability_status_id
1819: ,p_effective_date ) ;
1820: if avail_status_prop_end_date < nvl(l_avail_status_start_date,date_effective) then
1821: hr_utility.set_message('800','PER_INVALID_STATUS_PROP_END_DT');
1822: hr_utility.raise_error;
1823: end if;
1824:
1825: if earliest_hire_date < date_effective then
1818: ,availability_status_id
1819: ,p_effective_date ) ;
1820: if avail_status_prop_end_date < nvl(l_avail_status_start_date,date_effective) then
1821: hr_utility.set_message('800','PER_INVALID_STATUS_PROP_END_DT');
1822: hr_utility.raise_error;
1823: end if;
1824:
1825: if earliest_hire_date < date_effective then
1826: hr_utility.set_message('800','PER_INVALID_EARLIEST_HIRE_DATE');
1822: hr_utility.raise_error;
1823: end if;
1824:
1825: if earliest_hire_date < date_effective then
1826: hr_utility.set_message('800','PER_INVALID_EARLIEST_HIRE_DATE');
1827: hr_utility.raise_error;
1828: end if;
1829: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1830: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1823: end if;
1824:
1825: if earliest_hire_date < date_effective then
1826: hr_utility.set_message('800','PER_INVALID_EARLIEST_HIRE_DATE');
1827: hr_utility.raise_error;
1828: end if;
1829: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1830: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1831: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1826: hr_utility.set_message('800','PER_INVALID_EARLIEST_HIRE_DATE');
1827: hr_utility.raise_error;
1828: end if;
1829: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1830: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1831: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1832: hr_utility.raise_error;
1833: end if;
1834: if proposed_date_for_layoff <= date_effective then
1827: hr_utility.raise_error;
1828: end if;
1829: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1830: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1831: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1832: hr_utility.raise_error;
1833: end if;
1834: if proposed_date_for_layoff <= date_effective then
1835: hr_utility.set_message('800','PER_INVALID_PROP_DT_FOR_LAYOFF');
1828: end if;
1829: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1830: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1831: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1832: hr_utility.raise_error;
1833: end if;
1834: if proposed_date_for_layoff <= date_effective then
1835: hr_utility.set_message('800','PER_INVALID_PROP_DT_FOR_LAYOFF');
1836: hr_utility.raise_error;
1831: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1832: hr_utility.raise_error;
1833: end if;
1834: if proposed_date_for_layoff <= date_effective then
1835: hr_utility.set_message('800','PER_INVALID_PROP_DT_FOR_LAYOFF');
1836: hr_utility.raise_error;
1837: end if;
1838: end if;
1839: --
1832: hr_utility.raise_error;
1833: end if;
1834: if proposed_date_for_layoff <= date_effective then
1835: hr_utility.set_message('800','PER_INVALID_PROP_DT_FOR_LAYOFF');
1836: hr_utility.raise_error;
1837: end if;
1838: end if;
1839: --
1840: if (l_api_updating
1843: or not l_api_updating) and
1844: current_org_prop_end_date is not null then
1845: --
1846: if current_org_prop_end_date < date_effective then
1847: hr_utility.set_message('800','PER_INVALID_ORG_PROP_END_DATE');
1848: hr_utility.raise_error;
1849: end if;
1850: end if;
1851: --
1844: current_org_prop_end_date is not null then
1845: --
1846: if current_org_prop_end_date < date_effective then
1847: hr_utility.set_message('800','PER_INVALID_ORG_PROP_END_DATE');
1848: hr_utility.raise_error;
1849: end if;
1850: end if;
1851: --
1852: if (l_api_updating
1855: or not l_api_updating) and
1856: current_job_prop_end_date is not null then
1857: --
1858: if current_job_prop_end_date < date_effective then
1859: hr_utility.set_message('800','PER_INVALID_JOB_PROP_END_DATE');
1860: hr_utility.raise_error;
1861: end if;
1862: end if;
1863: --
1856: current_job_prop_end_date is not null then
1857: --
1858: if current_job_prop_end_date < date_effective then
1859: hr_utility.set_message('800','PER_INVALID_JOB_PROP_END_DATE');
1860: hr_utility.raise_error;
1861: end if;
1862: end if;
1863: --
1864: if (l_api_updating
1871: position_id
1872: ,availability_status_id
1873: ,p_effective_date ) ;
1874: if avail_status_prop_end_date < nvl(l_avail_status_start_date,date_effective) then
1875: hr_utility.set_message('800','PER_INVALID_STATUS_PROP_END_DT');
1876: hr_utility.raise_error;
1877: end if;
1878: end if;
1879: --
1872: ,availability_status_id
1873: ,p_effective_date ) ;
1874: if avail_status_prop_end_date < nvl(l_avail_status_start_date,date_effective) then
1875: hr_utility.set_message('800','PER_INVALID_STATUS_PROP_END_DT');
1876: hr_utility.raise_error;
1877: end if;
1878: end if;
1879: --
1880: if (l_api_updating
1883: or not l_api_updating) and
1884: earliest_hire_date is not null then
1885: --
1886: if earliest_hire_date < date_effective then
1887: hr_utility.set_message('800','PER_INVALID_EARLIEST_HIRE_DATE');
1888: hr_utility.raise_error;
1889: end if;
1890: --
1891: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1884: earliest_hire_date is not null then
1885: --
1886: if earliest_hire_date < date_effective then
1887: hr_utility.set_message('800','PER_INVALID_EARLIEST_HIRE_DATE');
1888: hr_utility.raise_error;
1889: end if;
1890: --
1891: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1892: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1888: hr_utility.raise_error;
1889: end if;
1890: --
1891: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1892: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1893: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1894: hr_utility.raise_error;
1895: end if;
1896: end if;
1889: end if;
1890: --
1891: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1892: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1893: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1894: hr_utility.raise_error;
1895: end if;
1896: end if;
1897: --
1890: --
1891: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1892: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1893: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1894: hr_utility.raise_error;
1895: end if;
1896: end if;
1897: --
1898: if (l_api_updating
1901: or not l_api_updating) and
1902: fill_by_date is not null then
1903: --
1904: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1905: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1906: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1907: hr_utility.raise_error;
1908: end if;
1909: end if;
1902: fill_by_date is not null then
1903: --
1904: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1905: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1906: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1907: hr_utility.raise_error;
1908: end if;
1909: end if;
1910: --
1903: --
1904: if fill_by_date < nvl(earliest_hire_date, date_effective) then
1905: hr_utility.set_message('800','PER_INVALID_FILL_BY_DATE');
1906: hr_utility.set_message_token('VALID_DATE',nvl(earliest_hire_date, date_effective));
1907: hr_utility.raise_error;
1908: end if;
1909: end if;
1910: --
1911: if (l_api_updating
1914: or not l_api_updating) and
1915: fill_by_date is not null then
1916: --
1917: if proposed_date_for_layoff <= date_effective then
1918: hr_utility.set_message('800','PER_INVALID_PROP_DT_FOR_LAYOFF');
1919: hr_utility.raise_error;
1920: end if;
1921: end if;
1922: end chk_end_dates;
1915: fill_by_date is not null then
1916: --
1917: if proposed_date_for_layoff <= date_effective then
1918: hr_utility.set_message('800','PER_INVALID_PROP_DT_FOR_LAYOFF');
1919: hr_utility.raise_error;
1920: end if;
1921: end if;
1922: end chk_end_dates;
1923: --
1949: open c_seasonal;
1950: fetch c_seasonal into l_dummy;
1951: if c_seasonal%found then
1952: close c_seasonal;
1953: hr_utility.set_message(800,'HR_INV_SEASONAL_FLAG');
1954: hr_utility.raise_error;
1955: end if;
1956: close c_seasonal;
1957: end if;
1950: fetch c_seasonal into l_dummy;
1951: if c_seasonal%found then
1952: close c_seasonal;
1953: hr_utility.set_message(800,'HR_INV_SEASONAL_FLAG');
1954: hr_utility.raise_error;
1955: end if;
1956: close c_seasonal;
1957: end if;
1958: end;
1972: from pqh_ptx_extra_info
1973: where position_transaction_id = p_position_transaction_id
1974: and information_type = 'PER_OVERLAP';
1975: begin
1976: hr_utility.set_location('Entering:'||l_proc,10);
1977: l_api_updating := pqh_ptx_shd.api_updating
1978: (p_position_transaction_id => p_position_transaction_id
1979: ,p_object_version_number => p_object_version_number);
1980:
1981: if (l_api_updating
1982: and nvl(p_overlap_period,-1)
1983: <> nvl(pqh_ptx_shd.g_old_rec.overlap_period,hr_api.g_number)
1984: and p_overlap_period is null) then
1985: hr_utility.set_location('Checking for Overlap Dates in Position Extra Info:'||l_proc,20);
1986: open c_overlap;
1987: fetch c_overlap into l_dummy;
1988: hr_utility.set_location('Checked for Overlap Dates in Position Extra Info:'||l_proc,30);
1989: if c_overlap%found then
1984: and p_overlap_period is null) then
1985: hr_utility.set_location('Checking for Overlap Dates in Position Extra Info:'||l_proc,20);
1986: open c_overlap;
1987: fetch c_overlap into l_dummy;
1988: hr_utility.set_location('Checked for Overlap Dates in Position Extra Info:'||l_proc,30);
1989: if c_overlap%found then
1990: hr_utility.set_location('Overlap Dates Found in Position Extra Info:'||l_proc,40);
1991: close c_overlap;
1992: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');
1986: open c_overlap;
1987: fetch c_overlap into l_dummy;
1988: hr_utility.set_location('Checked for Overlap Dates in Position Extra Info:'||l_proc,30);
1989: if c_overlap%found then
1990: hr_utility.set_location('Overlap Dates Found in Position Extra Info:'||l_proc,40);
1991: close c_overlap;
1992: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');
1993: hr_utility.raise_error;
1994: end if;
1988: hr_utility.set_location('Checked for Overlap Dates in Position Extra Info:'||l_proc,30);
1989: if c_overlap%found then
1990: hr_utility.set_location('Overlap Dates Found in Position Extra Info:'||l_proc,40);
1991: close c_overlap;
1992: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');
1993: hr_utility.raise_error;
1994: end if;
1995: hr_utility.set_location('Overlap Dates not Found in Position Extra Info:'||l_proc,40);
1996: close c_overlap;
1989: if c_overlap%found then
1990: hr_utility.set_location('Overlap Dates Found in Position Extra Info:'||l_proc,40);
1991: close c_overlap;
1992: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');
1993: hr_utility.raise_error;
1994: end if;
1995: hr_utility.set_location('Overlap Dates not Found in Position Extra Info:'||l_proc,40);
1996: close c_overlap;
1997: end if;
1991: close c_overlap;
1992: hr_utility.set_message(800,'HR_INV_OVERLAP_PERIOD');
1993: hr_utility.raise_error;
1994: end if;
1995: hr_utility.set_location('Overlap Dates not Found in Position Extra Info:'||l_proc,40);
1996: close c_overlap;
1997: end if;
1998: hr_utility.set_location('Leaving:'||l_proc,20);
1999: end;
1994: end if;
1995: hr_utility.set_location('Overlap Dates not Found in Position Extra Info:'||l_proc,40);
1996: close c_overlap;
1997: end if;
1998: hr_utility.set_location('Leaving:'||l_proc,20);
1999: end;
2000: --
2001: --
2002: -- ----------------------------------------------------------------------------
2007: --
2008: l_proc varchar2(72) := g_package||'insert_validate';
2009: --
2010: Begin
2011: hr_utility.set_location('Entering:'||l_proc, 5);
2012: --
2013: -- Call all supporting business operations
2014: --
2015: chk_position_transaction_id
2178: );
2179: */
2180: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2181: --
2182: hr_utility.set_location(' Leaving:'||l_proc, 10);
2183: End insert_validate;
2184: --
2185: -- ----------------------------------------------------------------------------
2186: -- |---------------------------< update_validate >----------------------------|
2190: --
2191: l_proc varchar2(72) := g_package||'update_validate';
2192: --
2193: Begin
2194: hr_utility.set_location('Entering:'||l_proc, 5);
2195: --
2196: -- Call all supporting business operations
2197: --
2198: chk_position_transaction_id
2357: (p_position_transaction_id => p_rec.position_transaction_id
2358: ,p_seasonal_flag => p_rec.seasonal_flag
2359: ,p_object_version_number => p_rec.object_version_number);
2360: --
2361: hr_utility.set_location(l_proc, 480);
2362: --
2363: chk_overlap_poi
2364: (p_position_transaction_id => p_rec.position_transaction_id
2365: ,p_overlap_period => p_rec.overlap_period
2367: --
2368: */
2369: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2370: --
2371: hr_utility.set_location(' Leaving:'||l_proc, 10);
2372: End update_validate;
2373: --
2374: -- ----------------------------------------------------------------------------
2375: -- |---------------------------< delete_validate >----------------------------|
2379: --
2380: l_proc varchar2(72) := g_package||'delete_validate';
2381: --
2382: Begin
2383: hr_utility.set_location('Entering:'||l_proc, 5);
2384: --
2385: -- Call all supporting business operations
2386: --
2387: hr_utility.set_location(' Leaving:'||l_proc, 10);
2383: hr_utility.set_location('Entering:'||l_proc, 5);
2384: --
2385: -- Call all supporting business operations
2386: --
2387: hr_utility.set_location(' Leaving:'||l_proc, 10);
2388: End delete_validate;
2389: --
2390: --
2391: -- ---------------------------------------------------------------------------
2410: l_proc varchar2(72) := g_package||'return_legislation_code';
2411: --
2412: begin
2413: --
2414: hr_utility.set_location('Entering:'|| l_proc, 10);
2415: --
2416: -- Ensure that all the mandatory parameter are not null
2417: --
2418: hr_api.mandatory_arg_error(p_api_name => l_proc,
2428: close csr_leg_code;
2429: --
2430: -- The primary key is invalid therefore we must error
2431: --
2432: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2433: hr_utility.raise_error;
2434: --
2435: end if;
2436: --
2429: --
2430: -- The primary key is invalid therefore we must error
2431: --
2432: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2433: hr_utility.raise_error;
2434: --
2435: end if;
2436: --
2437: close csr_leg_code;
2435: end if;
2436: --
2437: close csr_leg_code;
2438: --
2439: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2440: --
2441: return l_legislation_code;
2442: --
2443: end return_legislation_code;