DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on HR_CONTACT_EXTRA_INFO_API

Line 572: hr_contact_extra_info_api.create_contact_extra_info(

568: hr_utility.set_location('Entering : ' || c_proc, 10);
569: hr_utility.trace('status : ' || p_rec.status);
570: --
571: if p_rec.status = 'I' then
572: hr_contact_extra_info_api.create_contact_extra_info(
573: p_validate => false,
574: p_effective_date => p_rec.effective_date,
575: p_contact_relationship_id => p_rec.contact_relationship_id,
576: p_information_type => 'JP_ITAX_DEPENDENT',

Line 604: hr_contact_extra_info_api.update_contact_extra_info(

600: or changed(p_rec.occupation , p_rec.occupation_o)
601: or changed(p_rec.estimated_annual_income, p_rec.estimated_annual_income_o)
602: or changed(p_rec.disability_type , p_rec.disability_type_o)
603: or changed(p_rec.disability_details , p_rec.disability_details_o) then
604: hr_contact_extra_info_api.update_contact_extra_info(
605: p_validate => false,
606: p_effective_date => p_rec.effective_date,
607: p_datetrack_update_mode => p_rec.datetrack_update_mode,
608: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 636: hr_contact_extra_info_api.delete_contact_extra_info(

632: else
633: l_effective_date := p_rec.effective_date - 1;
634: end if;
635: --
636: hr_contact_extra_info_api.delete_contact_extra_info(
637: p_validate => false,
638: p_effective_date => l_effective_date,
639: p_datetrack_delete_mode => p_rec.datetrack_delete_mode,
640: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 671: hr_contact_extra_info_api.delete_contact_extra_info(

667: hr_utility.set_location('Entering : ' || c_proc, 10);
668: hr_utility.trace('status : ' || p_rec.status);
669: --
670: if p_rec.status = 'I' then
671: hr_contact_extra_info_api.delete_contact_extra_info(
672: p_validate => false,
673: p_effective_date => p_rec.effective_date,
674: p_datetrack_delete_mode => 'ZAP',
675: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 691: hr_contact_extra_info_api.update_contact_extra_info(

687: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
688: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
689: elsif p_rec.status = 'U' then
690: if p_rec.datetrack_update_mode = 'CORRECTION' then
691: hr_contact_extra_info_api.update_contact_extra_info(
692: p_validate => false,
693: p_effective_date => p_rec.effective_date,
694: p_datetrack_update_mode => p_rec.datetrack_update_mode,
695: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 728: hr_contact_extra_info_api.delete_contact_extra_info(

724: from per_contact_extra_info_f
725: where contact_extra_info_id = p_rec.contact_extra_info_id
726: and effective_end_date = p_rec.effective_date - 1;
727: --
728: hr_contact_extra_info_api.delete_contact_extra_info(
729: p_validate => false,
730: p_effective_date => p_rec.effective_date - 1,
731: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
732: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 752: hr_contact_extra_info_api.create_contact_extra_info(

748: --
749: -- Note EFFECTIVE_END_DATE/change_date/change_reason cannot be rollbacked
750: -- for ZAP case.
751: --
752: hr_contact_extra_info_api.create_contact_extra_info(
753: p_validate => false,
754: p_effective_date => p_rec.effective_date,
755: p_contact_relationship_id => p_rec.contact_relationship_id,
756: p_information_type => 'JP_ITAX_DEPENDENT',

Line 768: hr_contact_extra_info_api.delete_contact_extra_info(

764: p_object_version_number => p_rec.cei_object_version_number,
765: p_effective_start_date => l_esd,
766: p_effective_end_date => l_eed);
767: else
768: hr_contact_extra_info_api.delete_contact_extra_info(
769: p_validate => false,
770: p_effective_date => p_rec.effective_date - 1,
771: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
772: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 802: hr_contact_extra_info_api.create_contact_extra_info(

798: hr_utility.set_location('Entering : ' || c_proc, 10);
799: hr_utility.trace('status : ' || p_rec.status);
800: --
801: if p_rec.status = 'I' then
802: hr_contact_extra_info_api.create_contact_extra_info(
803: p_validate => false,
804: p_effective_date => p_rec.effective_date,
805: p_contact_relationship_id => p_rec.contact_relationship_id,
806: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',

Line 828: hr_contact_extra_info_api.update_contact_extra_info(

824: if p_rec.change_date is not null
825: or p_rec.change_reason is not null
826: or changed(p_rec.occupation , p_rec.occupation_o)
827: or changed(p_rec.oe_contact_relationship_id , p_rec.oe_contact_relationship_id_o) then
828: hr_contact_extra_info_api.update_contact_extra_info(
829: p_validate => false,
830: p_effective_date => p_rec.effective_date,
831: p_datetrack_update_mode => p_rec.datetrack_update_mode,
832: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 857: hr_contact_extra_info_api.delete_contact_extra_info(

853: else
854: l_effective_date := p_rec.effective_date - 1;
855: end if;
856: --
857: hr_contact_extra_info_api.delete_contact_extra_info(
858: p_validate => false,
859: p_effective_date => l_effective_date,
860: p_datetrack_delete_mode => p_rec.datetrack_delete_mode,
861: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 892: hr_contact_extra_info_api.delete_contact_extra_info(

888: hr_utility.set_location('Entering : ' || c_proc, 10);
889: hr_utility.trace('status : ' || p_rec.status);
890: --
891: if p_rec.status = 'I' then
892: hr_contact_extra_info_api.delete_contact_extra_info(
893: p_validate => false,
894: p_effective_date => p_rec.effective_date,
895: p_datetrack_delete_mode => 'ZAP',
896: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 912: hr_contact_extra_info_api.update_contact_extra_info(

908: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
909: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
910: elsif p_rec.status = 'U' then
911: if p_rec.datetrack_update_mode = 'CORRECTION' then
912: hr_contact_extra_info_api.update_contact_extra_info(
913: p_validate => false,
914: p_effective_date => p_rec.effective_date,
915: p_datetrack_update_mode => p_rec.datetrack_update_mode,
916: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 946: hr_contact_extra_info_api.delete_contact_extra_info(

942: from per_contact_extra_info_f
943: where contact_extra_info_id = p_rec.contact_extra_info_id
944: and effective_end_date = p_rec.effective_date - 1;
945: --
946: hr_contact_extra_info_api.delete_contact_extra_info(
947: p_validate => false,
948: p_effective_date => p_rec.effective_date - 1,
949: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
950: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 970: hr_contact_extra_info_api.create_contact_extra_info(

966: --
967: -- Note EFFECTIVE_END_DATE/change_date/change_reason cannot be rollbacked
968: -- for ZAP case.
969: --
970: hr_contact_extra_info_api.create_contact_extra_info(
971: p_validate => false,
972: p_effective_date => p_rec.effective_date,
973: p_contact_relationship_id => p_rec.contact_relationship_id,
974: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',

Line 983: hr_contact_extra_info_api.delete_contact_extra_info(

979: p_object_version_number => p_rec.cei_object_version_number,
980: p_effective_start_date => l_esd,
981: p_effective_end_date => l_eed);
982: else
983: hr_contact_extra_info_api.delete_contact_extra_info(
984: p_validate => false,
985: p_effective_date => p_rec.effective_date - 1,
986: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
987: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1017: hr_contact_extra_info_api.create_contact_extra_info(

1013: hr_utility.set_location('Entering : ' || c_proc, 10);
1014: hr_utility.trace('status : ' || p_rec.status);
1015: --
1016: if p_rec.status = 'I' then
1017: hr_contact_extra_info_api.create_contact_extra_info(
1018: p_validate => false,
1019: p_effective_date => p_rec.effective_date,
1020: p_contact_relationship_id => p_rec.contact_relationship_id,
1021: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_PAY',

Line 1043: hr_contact_extra_info_api.update_contact_extra_info(

1039: or changed(p_rec.os_salary_payer_name , p_rec.os_salary_payer_name_o)
1040: or changed(p_rec.os_salary_payer_address, p_rec.os_salary_payer_address_o) then
1041: p_rec.status := 'U';
1042: --
1043: hr_contact_extra_info_api.update_contact_extra_info(
1044: p_validate => false,
1045: p_effective_date => p_rec.effective_date,
1046: p_datetrack_update_mode => p_rec.datetrack_update_mode,
1047: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1071: hr_contact_extra_info_api.delete_contact_extra_info(

1067: else
1068: l_effective_date := p_rec.effective_date - 1;
1069: end if;
1070: --
1071: hr_contact_extra_info_api.delete_contact_extra_info(
1072: p_validate => false,
1073: p_effective_date => l_effective_date,
1074: p_datetrack_delete_mode => p_rec.datetrack_delete_mode,
1075: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1106: hr_contact_extra_info_api.delete_contact_extra_info(

1102: hr_utility.set_location('Entering : ' || c_proc, 10);
1103: hr_utility.trace('status : ' || p_rec.status);
1104: --
1105: if p_rec.status = 'I' then
1106: hr_contact_extra_info_api.delete_contact_extra_info(
1107: p_validate => false,
1108: p_effective_date => p_rec.effective_date,
1109: p_datetrack_delete_mode => 'ZAP',
1110: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1126: hr_contact_extra_info_api.update_contact_extra_info(

1122: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1123: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
1124: elsif p_rec.status = 'U' then
1125: if p_rec.datetrack_update_mode = 'CORRECTION' then
1126: hr_contact_extra_info_api.update_contact_extra_info(
1127: p_validate => false,
1128: p_effective_date => p_rec.effective_date,
1129: p_datetrack_update_mode => p_rec.datetrack_update_mode,
1130: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1160: hr_contact_extra_info_api.delete_contact_extra_info(

1156: from per_contact_extra_info_f
1157: where contact_extra_info_id = p_rec.contact_extra_info_id
1158: and effective_end_date = p_rec.effective_date - 1;
1159: --
1160: hr_contact_extra_info_api.delete_contact_extra_info(
1161: p_validate => false,
1162: p_effective_date => p_rec.effective_date - 1,
1163: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
1164: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1184: hr_contact_extra_info_api.create_contact_extra_info(

1180: --
1181: -- Note EFFECTIVE_END_DATE/change_date/change_reason cannot be rollbacked
1182: -- for ZAP case.
1183: --
1184: hr_contact_extra_info_api.create_contact_extra_info(
1185: p_validate => false,
1186: p_effective_date => p_rec.effective_date,
1187: p_contact_relationship_id => p_rec.contact_relationship_id,
1188: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_PAY',

Line 1198: hr_contact_extra_info_api.delete_contact_extra_info(

1194: p_object_version_number => p_rec.cei_object_version_number,
1195: p_effective_start_date => l_esd,
1196: p_effective_end_date => l_eed);
1197: else
1198: hr_contact_extra_info_api.delete_contact_extra_info(
1199: p_validate => false,
1200: p_effective_date => p_rec.effective_date - 1,
1201: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
1202: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 2833: hr_contact_extra_info_api.delete_contact_extra_info(

2829: P_EE_OBJECT_VERSION_NUMBER => l_rec.ee_object_version_number);
2830: end loop;
2831: --
2832: for l_rec in csr_dep(l_assact_rec.assignment_action_id) loop
2833: hr_contact_extra_info_api.delete_contact_extra_info(
2834: p_validate => false,
2835: p_effective_date => p_expiry_date,
2836: p_datetrack_delete_mode => 'DELETE',
2837: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 2850: hr_contact_extra_info_api.delete_contact_extra_info(

2846: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
2847: end loop;
2848: --
2849: for l_rec in csr_dep_oe(l_assact_rec.assignment_action_id) loop
2850: hr_contact_extra_info_api.delete_contact_extra_info(
2851: p_validate => false,
2852: p_effective_date => p_expiry_date,
2853: p_datetrack_delete_mode => 'DELETE',
2854: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 2867: hr_contact_extra_info_api.delete_contact_extra_info(

2863: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
2864: end loop;
2865: --
2866: for l_rec in csr_dep_os(l_assact_rec.assignment_action_id) loop
2867: hr_contact_extra_info_api.delete_contact_extra_info(
2868: p_validate => false,
2869: p_effective_date => p_expiry_date,
2870: p_datetrack_delete_mode => 'DELETE',
2871: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3029: hr_contact_extra_info_api.delete_contact_extra_info(

3025: P_EE_OBJECT_VERSION_NUMBER => l_rec.ee_object_version_number);
3026: end loop;
3027: --
3028: for l_rec in csr_dep(l_assact_rec.assignment_action_id, l_assact_rec.expiry_date) loop
3029: hr_contact_extra_info_api.delete_contact_extra_info(
3030: p_validate => false,
3031: p_effective_date => l_assact_rec.expiry_date,
3032: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
3033: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3046: hr_contact_extra_info_api.delete_contact_extra_info(

3042: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
3043: end loop;
3044: --
3045: for l_rec in csr_dep_oe(l_assact_rec.assignment_action_id, l_assact_rec.expiry_date) loop
3046: hr_contact_extra_info_api.delete_contact_extra_info(
3047: p_validate => false,
3048: p_effective_date => l_assact_rec.expiry_date,
3049: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
3050: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3063: hr_contact_extra_info_api.delete_contact_extra_info(

3059: P_CEI_OBJECT_VERSION_NUMBER => l_rec.cei_object_version_number);
3060: end loop;
3061: --
3062: for l_rec in csr_dep_os(l_assact_rec.assignment_action_id, l_assact_rec.expiry_date) loop
3063: hr_contact_extra_info_api.delete_contact_extra_info(
3064: p_validate => false,
3065: p_effective_date => l_assact_rec.expiry_date,
3066: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
3067: p_contact_extra_info_id => l_rec.contact_extra_info_id,