[Home] [Help]
359: p_effective_start_date => l_esd,
360: p_effective_end_date => l_eed,
361: p_create_warning => l_warning);
362: --
363: pay_jp_def_api.update_entry(
364: P_VALIDATE => false,
365: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
366: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
367: P_ELEMENT_ENTRY_ID => p_rec.element_entry_id,
421: p_update_warning => l_warning);
422: --
423: p_rec.status := 'U';
424: --
425: pay_jp_def_api.update_entry(
426: P_VALIDATE => false,
427: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
428: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
429: P_STATUS => p_rec.status,
461: --
462: p_rec.element_entry_id := null;
463: p_rec.ee_object_version_number := null;
464: --
465: pay_jp_def_api.update_entry(
466: P_VALIDATE => false,
467: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
468: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
469: P_ELEMENT_ENTRY_ID => p_rec.element_entry_id,
544: end if;
545: --
546: p_rec.status := 'Q';
547: --
548: pay_jp_def_api.update_entry(
549: P_VALIDATE => false,
550: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
551: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
552: P_STATUS => p_rec.status,
586: p_object_version_number => p_rec.cei_object_version_number,
587: p_effective_start_date => l_esd,
588: p_effective_end_date => l_eed);
589: --
590: pay_jp_def_api.update_dep(
591: P_VALIDATE => false,
592: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
593: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
594: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
618: p_effective_end_date => l_eed);
619: --
620: p_rec.status := 'U';
621: --
622: pay_jp_def_api.update_dep(
623: P_VALIDATE => false,
624: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
625: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
626: P_STATUS => p_rec.status,
642: p_effective_start_date => l_esd,
643: p_effective_end_date => l_eed);
644: --
645: if p_rec.datetrack_delete_mode <> 'ZAP' then
646: pay_jp_def_api.update_dep(
647: P_VALIDATE => false,
648: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
649: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
650: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
679: --
680: p_rec.contact_extra_info_id := null;
681: p_rec.cei_object_version_number := null;
682: --
683: pay_jp_def_api.update_dep(
684: P_VALIDATE => false,
685: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
686: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
687: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
736: end if;
737: --
738: p_rec.status := 'Q';
739: --
740: pay_jp_def_api.update_dep(
741: P_VALIDATE => false,
742: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
743: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
744: P_STATUS => p_rec.status,
774: p_effective_start_date => l_esd,
775: p_effective_end_date => l_eed);
776: end if;
777: --
778: pay_jp_def_api.update_dep(
779: P_VALIDATE => false,
780: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
781: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
782: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
813: p_object_version_number => p_rec.cei_object_version_number,
814: p_effective_start_date => l_esd,
815: p_effective_end_date => l_eed);
816: --
817: pay_jp_def_api.update_dep_oe(
818: P_VALIDATE => false,
819: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
820: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
821: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
839: p_effective_end_date => l_eed);
840: --
841: p_rec.status := 'U';
842: --
843: pay_jp_def_api.update_dep_oe(
844: P_VALIDATE => false,
845: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
846: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
847: P_STATUS => p_rec.status,
863: p_effective_start_date => l_esd,
864: p_effective_end_date => l_eed);
865: --
866: if p_rec.datetrack_delete_mode <> 'ZAP' then
867: pay_jp_def_api.update_dep(
868: P_VALIDATE => false,
869: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
870: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
871: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
900: --
901: p_rec.contact_extra_info_id := null;
902: p_rec.cei_object_version_number := null;
903: --
904: pay_jp_def_api.update_dep_oe(
905: P_VALIDATE => false,
906: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
907: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
908: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
954: end if;
955: --
956: p_rec.status := 'Q';
957: --
958: pay_jp_def_api.update_dep_oe(
959: P_VALIDATE => false,
960: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
961: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
962: P_STATUS => p_rec.status,
989: p_effective_start_date => l_esd,
990: p_effective_end_date => l_eed);
991: end if;
992: --
993: pay_jp_def_api.update_dep_oe(
994: P_VALIDATE => false,
995: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
996: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
997: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1027: p_object_version_number => p_rec.cei_object_version_number,
1028: p_effective_start_date => l_esd,
1029: p_effective_end_date => l_eed);
1030: --
1031: pay_jp_def_api.update_dep_os(
1032: P_VALIDATE => false,
1033: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
1034: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
1035: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1053: p_effective_end_date => l_eed);
1054: --
1055: p_rec.status := 'U';
1056: --
1057: pay_jp_def_api.update_dep_os(
1058: P_VALIDATE => false,
1059: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
1060: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
1061: P_STATUS => p_rec.status,
1077: p_effective_start_date => l_esd,
1078: p_effective_end_date => l_eed);
1079: --
1080: if p_rec.datetrack_delete_mode <> 'ZAP' then
1081: pay_jp_def_api.update_dep(
1082: P_VALIDATE => false,
1083: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
1084: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
1085: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
1114: --
1115: p_rec.contact_extra_info_id := null;
1116: p_rec.cei_object_version_number := null;
1117: --
1118: pay_jp_def_api.update_dep_os(
1119: P_VALIDATE => false,
1120: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
1121: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
1122: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1168: end if;
1169: --
1170: p_rec.status := 'Q';
1171: --
1172: pay_jp_def_api.update_dep_os(
1173: P_VALIDATE => false,
1174: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
1175: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
1176: P_STATUS => p_rec.status,
1204: p_effective_start_date => l_esd,
1205: p_effective_end_date => l_eed);
1206: end if;
1207: --
1208: pay_jp_def_api.update_dep_os(
1209: P_VALIDATE => false,
1210: P_ACTION_INFORMATION_ID => p_rec.action_information_id,
1211: P_OBJECT_VERSION_NUMBER => p_rec.object_version_number,
1212: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1596: l_entry_rec.num_svr_disableds_lt_o := fnd_number.canonical_to_number(l_rec.screen_entry_value);
1597: end if;
1598: end loop;
1599: --
1600: pay_jp_def_api.create_entry(
1601: P_ASSIGNMENT_ACTION_ID => l_assact_rec.assignment_action_id,
1602: P_ASSIGNMENT_ID => l_assact_rec.assignment_id,
1603: P_EFFECTIVE_DATE => l_assact_rec.effective_date,
1604: P_STATUS => l_entry_rec.status,
1648: l_emp_rec.widow_type := '3';
1649: end if;
1650: l_emp_rec.working_student_type := nvl(l_entry_rec.working_student_type_o, '0');
1651: --
1652: pay_jp_def_api.create_emp(
1653: P_ASSIGNMENT_ACTION_ID => l_assact_rec.assignment_action_id,
1654: P_ASSIGNMENT_ID => l_assact_rec.assignment_id,
1655: P_EFFECTIVE_DATE => l_assact_rec.effective_date,
1656: P_LAST_NAME_KANA => l_emp_rec.last_name_kana,
1681: --
1682: -- JP_DEF_DEP
1683: --
1684: for l_rec in csr_dep(l_person_id, l_assact_rec.effective_date) loop
1685: pay_jp_def_api.create_dep(
1686: P_ASSIGNMENT_ACTION_ID => l_assact_rec.assignment_action_id,
1687: P_ASSIGNMENT_ID => l_assact_rec.assignment_id,
1688: P_EFFECTIVE_DATE => l_assact_rec.effective_date,
1689: P_STATUS => 'Q',
1718: --
1719: -- JP_DEF_DEP_OE
1720: --
1721: for l_rec in csr_dep_oe(l_person_id, l_assact_rec.effective_date) loop
1722: pay_jp_def_api.create_dep_oe(
1723: p_assignment_action_id => l_assact_rec.assignment_action_id,
1724: P_ASSIGNMENT_ID => l_assact_rec.assignment_id,
1725: P_EFFECTIVE_DATE => l_assact_rec.effective_date,
1726: P_STATUS => 'Q',
1752: --
1753: -- JP_DEF_DEP_OS
1754: --
1755: for l_rec in csr_dep_os(l_person_id, l_assact_rec.effective_date) loop
1756: pay_jp_def_api.create_dep_os(
1757: p_assignment_action_id => l_assact_rec.assignment_action_id,
1758: P_ASSIGNMENT_ID => l_assact_rec.assignment_id,
1759: P_EFFECTIVE_DATE => l_assact_rec.effective_date,
1760: P_STATUS => 'Q',
1781: end loop;
1782: --
1783: l_assact_rec.transaction_status := 'N';
1784: --
1785: pay_jp_def_api.update_assact(
1786: P_VALIDATE => false,
1787: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
1788: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
1789: P_TRANSACTION_STATUS => l_assact_rec.transaction_status);
1937: end if;
1938: end if;
1939: end loop;
1940: --
1941: pay_jp_def_api.update_entry(
1942: P_VALIDATE => false,
1943: P_ACTION_INFORMATION_ID => l_entry_rec.action_information_id,
1944: P_OBJECT_VERSION_NUMBER => l_entry_rec.object_version_number,
1945: P_DISABILITY_TYPE => l_entry_rec.disability_type,
1959: l_assact_rec.transaction_status := 'F';
1960: l_assact_rec.finalized_date := l_submission_date;
1961: l_assact_rec.finalized_by := fnd_global.user_id;
1962: --
1963: pay_jp_def_api.update_assact(
1964: P_VALIDATE => false,
1965: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
1966: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
1967: P_TRANSACTION_STATUS => l_assact_rec.transaction_status,
2038: l_assact_rec.transaction_status := 'U';
2039: l_assact_rec.finalized_date := null;
2040: l_assact_rec.finalized_by := null;
2041: --
2042: pay_jp_def_api.update_assact(
2043: P_VALIDATE => false,
2044: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
2045: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
2046: P_TRANSACTION_STATUS => l_assact_rec.transaction_status,
2111: l_assact_rec.transaction_status := 'N';
2112: l_assact_rec.finalized_date := null;
2113: l_assact_rec.finalized_by := null;
2114: --
2115: pay_jp_def_api.update_assact(
2116: P_VALIDATE => false,
2117: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
2118: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
2119: P_TRANSACTION_STATUS => l_assact_rec.transaction_status,
2176: end if;
2177: --
2178: l_assact_rec.transaction_status := 'A';
2179: --
2180: pay_jp_def_api.update_assact(
2181: P_VALIDATE => false,
2182: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
2183: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
2184: P_TRANSACTION_STATUS => l_assact_rec.transaction_status);
2412: end if;
2413: --
2414: l_assact_rec.transfer_status := 'T';
2415: --
2416: pay_jp_def_api.update_assact(
2417: P_VALIDATE => false,
2418: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
2419: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
2420: P_TRANSFER_STATUS => l_assact_rec.transfer_status);
2682: end if;
2683: --
2684: l_assact_rec.transfer_status := 'U';
2685: --
2686: pay_jp_def_api.update_assact(
2687: P_VALIDATE => false,
2688: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
2689: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
2690: P_TRANSFER_STATUS => l_assact_rec.transfer_status);
2821: p_effective_start_date => l_esd,
2822: p_effective_end_date => l_eed,
2823: p_delete_warning => l_warning);
2824: --
2825: pay_jp_def_api.update_entry(
2826: P_VALIDATE => false,
2827: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
2828: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
2829: P_EE_OBJECT_VERSION_NUMBER => l_rec.ee_object_version_number);
2838: p_object_version_number => l_rec.cei_object_version_number,
2839: p_effective_start_date => l_esd,
2840: p_effective_end_date => l_eed);
2841: --
2842: pay_jp_def_api.update_dep(
2843: P_VALIDATE => false,
2844: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
2845: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
2846: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
2855: p_object_version_number => l_rec.cei_object_version_number,
2856: p_effective_start_date => l_esd,
2857: p_effective_end_date => l_eed);
2858: --
2859: pay_jp_def_api.update_dep_oe(
2860: P_VALIDATE => false,
2861: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
2862: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
2863: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
2872: p_object_version_number => l_rec.cei_object_version_number,
2873: p_effective_start_date => l_esd,
2874: p_effective_end_date => l_eed);
2875: --
2876: pay_jp_def_api.update_dep_os(
2877: P_VALIDATE => false,
2878: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
2879: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
2880: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
2884: --
2885: l_assact_rec.transfer_status := 'E';
2886: l_assact_rec.expiry_date := p_expiry_date;
2887: --
2888: pay_jp_def_api.update_assact(
2889: P_VALIDATE => false,
2890: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
2891: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
2892: P_TRANSFER_STATUS => l_assact_rec.transfer_status,
3017: p_effective_start_date => l_esd,
3018: p_effective_end_date => l_eed,
3019: p_delete_warning => l_warning);
3020: --
3021: pay_jp_def_api.update_entry(
3022: P_VALIDATE => false,
3023: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
3024: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
3025: P_EE_OBJECT_VERSION_NUMBER => l_rec.ee_object_version_number);
3034: p_object_version_number => l_rec.cei_object_version_number,
3035: p_effective_start_date => l_esd,
3036: p_effective_end_date => l_eed);
3037: --
3038: pay_jp_def_api.update_dep(
3039: P_VALIDATE => false,
3040: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
3041: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
3042: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
3051: p_object_version_number => l_rec.cei_object_version_number,
3052: p_effective_start_date => l_esd,
3053: p_effective_end_date => l_eed);
3054: --
3055: pay_jp_def_api.update_dep_oe(
3056: P_VALIDATE => false,
3057: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
3058: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
3059: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
3068: p_object_version_number => l_rec.cei_object_version_number,
3069: p_effective_start_date => l_esd,
3070: p_effective_end_date => l_eed);
3071: --
3072: pay_jp_def_api.update_dep_os(
3073: P_VALIDATE => false,
3074: P_ACTION_INFORMATION_ID => l_rec.action_information_id,
3075: P_OBJECT_VERSION_NUMBER => l_rec.object_version_number,
3076: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
3080: --
3081: l_assact_rec.transfer_status := 'T';
3082: l_assact_rec.expiry_date := null;
3083: --
3084: pay_jp_def_api.update_assact(
3085: P_VALIDATE => false,
3086: P_ACTION_INFORMATION_ID => l_assact_rec.action_information_id,
3087: P_OBJECT_VERSION_NUMBER => l_assact_rec.object_version_number,
3088: P_TRANSFER_STATUS => l_assact_rec.transfer_status,