DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on HR_CONTACT_EXTRA_INFO_API

Line 592: hr_contact_extra_info_api.create_contact_extra_info(

588: hr_utility.set_location('Entering : ' || c_proc, 10);
589: hr_utility.trace('status : ' || p_rec.status);
590: --
591: if p_rec.status = 'I' then
592: hr_contact_extra_info_api.create_contact_extra_info(
593: p_validate => false,
594: p_effective_date => p_rec.effective_date,
595: p_contact_relationship_id => p_rec.contact_relationship_id,
596: p_information_type => 'JP_ITAX_DEPENDENT',

Line 624: hr_contact_extra_info_api.update_contact_extra_info(

620: or changed(p_rec.occupation , p_rec.occupation_o)
621: or changed(p_rec.estimated_annual_income, p_rec.estimated_annual_income_o)
622: or changed(p_rec.disability_type , p_rec.disability_type_o)
623: or changed(p_rec.disability_details , p_rec.disability_details_o) then
624: hr_contact_extra_info_api.update_contact_extra_info(
625: p_validate => false,
626: p_effective_date => p_rec.effective_date,
627: p_datetrack_update_mode => p_rec.datetrack_update_mode,
628: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 656: hr_contact_extra_info_api.delete_contact_extra_info(

652: else
653: l_effective_date := p_rec.effective_date - 1;
654: end if;
655: --
656: hr_contact_extra_info_api.delete_contact_extra_info(
657: p_validate => false,
658: p_effective_date => l_effective_date,
659: p_datetrack_delete_mode => p_rec.datetrack_delete_mode,
660: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 691: hr_contact_extra_info_api.delete_contact_extra_info(

687: hr_utility.set_location('Entering : ' || c_proc, 10);
688: hr_utility.trace('status : ' || p_rec.status);
689: --
690: if p_rec.status = 'I' then
691: hr_contact_extra_info_api.delete_contact_extra_info(
692: p_validate => false,
693: p_effective_date => p_rec.effective_date,
694: p_datetrack_delete_mode => 'ZAP',
695: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 711: hr_contact_extra_info_api.update_contact_extra_info(

707: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
708: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
709: elsif p_rec.status = 'U' then
710: if p_rec.datetrack_update_mode = 'CORRECTION' then
711: hr_contact_extra_info_api.update_contact_extra_info(
712: p_validate => false,
713: p_effective_date => p_rec.effective_date,
714: p_datetrack_update_mode => p_rec.datetrack_update_mode,
715: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 748: hr_contact_extra_info_api.delete_contact_extra_info(

744: from per_contact_extra_info_f
745: where contact_extra_info_id = p_rec.contact_extra_info_id
746: and effective_end_date = p_rec.effective_date - 1;
747: --
748: hr_contact_extra_info_api.delete_contact_extra_info(
749: p_validate => false,
750: p_effective_date => p_rec.effective_date - 1,
751: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
752: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 772: hr_contact_extra_info_api.create_contact_extra_info(

768: --
769: -- Note EFFECTIVE_END_DATE/change_date/change_reason cannot be rollbacked
770: -- for ZAP case.
771: --
772: hr_contact_extra_info_api.create_contact_extra_info(
773: p_validate => false,
774: p_effective_date => p_rec.effective_date,
775: p_contact_relationship_id => p_rec.contact_relationship_id,
776: p_information_type => 'JP_ITAX_DEPENDENT',

Line 788: hr_contact_extra_info_api.delete_contact_extra_info(

784: p_object_version_number => p_rec.cei_object_version_number,
785: p_effective_start_date => l_esd,
786: p_effective_end_date => l_eed);
787: else
788: hr_contact_extra_info_api.delete_contact_extra_info(
789: p_validate => false,
790: p_effective_date => p_rec.effective_date - 1,
791: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
792: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 822: hr_contact_extra_info_api.create_contact_extra_info(

818: hr_utility.set_location('Entering : ' || c_proc, 10);
819: hr_utility.trace('status : ' || p_rec.status);
820: --
821: if p_rec.status = 'I' then
822: hr_contact_extra_info_api.create_contact_extra_info(
823: p_validate => false,
824: p_effective_date => p_rec.effective_date,
825: p_contact_relationship_id => p_rec.contact_relationship_id,
826: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',

Line 848: hr_contact_extra_info_api.update_contact_extra_info(

844: if p_rec.change_date is not null
845: or p_rec.change_reason is not null
846: or changed(p_rec.occupation , p_rec.occupation_o)
847: or changed(p_rec.oe_contact_relationship_id , p_rec.oe_contact_relationship_id_o) then
848: hr_contact_extra_info_api.update_contact_extra_info(
849: p_validate => false,
850: p_effective_date => p_rec.effective_date,
851: p_datetrack_update_mode => p_rec.datetrack_update_mode,
852: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 877: hr_contact_extra_info_api.delete_contact_extra_info(

873: else
874: l_effective_date := p_rec.effective_date - 1;
875: end if;
876: --
877: hr_contact_extra_info_api.delete_contact_extra_info(
878: p_validate => false,
879: p_effective_date => l_effective_date,
880: p_datetrack_delete_mode => p_rec.datetrack_delete_mode,
881: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 912: hr_contact_extra_info_api.delete_contact_extra_info(

908: hr_utility.set_location('Entering : ' || c_proc, 10);
909: hr_utility.trace('status : ' || p_rec.status);
910: --
911: if p_rec.status = 'I' then
912: hr_contact_extra_info_api.delete_contact_extra_info(
913: p_validate => false,
914: p_effective_date => p_rec.effective_date,
915: p_datetrack_delete_mode => 'ZAP',
916: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 932: hr_contact_extra_info_api.update_contact_extra_info(

928: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
929: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
930: elsif p_rec.status = 'U' then
931: if p_rec.datetrack_update_mode = 'CORRECTION' then
932: hr_contact_extra_info_api.update_contact_extra_info(
933: p_validate => false,
934: p_effective_date => p_rec.effective_date,
935: p_datetrack_update_mode => p_rec.datetrack_update_mode,
936: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 966: hr_contact_extra_info_api.delete_contact_extra_info(

962: from per_contact_extra_info_f
963: where contact_extra_info_id = p_rec.contact_extra_info_id
964: and effective_end_date = p_rec.effective_date - 1;
965: --
966: hr_contact_extra_info_api.delete_contact_extra_info(
967: p_validate => false,
968: p_effective_date => p_rec.effective_date - 1,
969: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
970: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 990: hr_contact_extra_info_api.create_contact_extra_info(

986: --
987: -- Note EFFECTIVE_END_DATE/change_date/change_reason cannot be rollbacked
988: -- for ZAP case.
989: --
990: hr_contact_extra_info_api.create_contact_extra_info(
991: p_validate => false,
992: p_effective_date => p_rec.effective_date,
993: p_contact_relationship_id => p_rec.contact_relationship_id,
994: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',

Line 1003: hr_contact_extra_info_api.delete_contact_extra_info(

999: p_object_version_number => p_rec.cei_object_version_number,
1000: p_effective_start_date => l_esd,
1001: p_effective_end_date => l_eed);
1002: else
1003: hr_contact_extra_info_api.delete_contact_extra_info(
1004: p_validate => false,
1005: p_effective_date => p_rec.effective_date - 1,
1006: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
1007: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1037: hr_contact_extra_info_api.create_contact_extra_info(

1033: hr_utility.set_location('Entering : ' || c_proc, 10);
1034: hr_utility.trace('status : ' || p_rec.status);
1035: --
1036: if p_rec.status = 'I' then
1037: hr_contact_extra_info_api.create_contact_extra_info(
1038: p_validate => false,
1039: p_effective_date => p_rec.effective_date,
1040: p_contact_relationship_id => p_rec.contact_relationship_id,
1041: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_PAY',

Line 1063: hr_contact_extra_info_api.update_contact_extra_info(

1059: or changed(p_rec.os_salary_payer_name , p_rec.os_salary_payer_name_o)
1060: or changed(p_rec.os_salary_payer_address, p_rec.os_salary_payer_address_o) then
1061: p_rec.status := 'U';
1062: --
1063: hr_contact_extra_info_api.update_contact_extra_info(
1064: p_validate => false,
1065: p_effective_date => p_rec.effective_date,
1066: p_datetrack_update_mode => p_rec.datetrack_update_mode,
1067: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1091: hr_contact_extra_info_api.delete_contact_extra_info(

1087: else
1088: l_effective_date := p_rec.effective_date - 1;
1089: end if;
1090: --
1091: hr_contact_extra_info_api.delete_contact_extra_info(
1092: p_validate => false,
1093: p_effective_date => l_effective_date,
1094: p_datetrack_delete_mode => p_rec.datetrack_delete_mode,
1095: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1126: hr_contact_extra_info_api.delete_contact_extra_info(

1122: hr_utility.set_location('Entering : ' || c_proc, 10);
1123: hr_utility.trace('status : ' || p_rec.status);
1124: --
1125: if p_rec.status = 'I' then
1126: hr_contact_extra_info_api.delete_contact_extra_info(
1127: p_validate => false,
1128: p_effective_date => p_rec.effective_date,
1129: p_datetrack_delete_mode => 'ZAP',
1130: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1146: hr_contact_extra_info_api.update_contact_extra_info(

1142: P_CONTACT_EXTRA_INFO_ID => p_rec.contact_extra_info_id,
1143: P_CEI_OBJECT_VERSION_NUMBER => p_rec.cei_object_version_number);
1144: elsif p_rec.status = 'U' then
1145: if p_rec.datetrack_update_mode = 'CORRECTION' then
1146: hr_contact_extra_info_api.update_contact_extra_info(
1147: p_validate => false,
1148: p_effective_date => p_rec.effective_date,
1149: p_datetrack_update_mode => p_rec.datetrack_update_mode,
1150: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1180: hr_contact_extra_info_api.delete_contact_extra_info(

1176: from per_contact_extra_info_f
1177: where contact_extra_info_id = p_rec.contact_extra_info_id
1178: and effective_end_date = p_rec.effective_date - 1;
1179: --
1180: hr_contact_extra_info_api.delete_contact_extra_info(
1181: p_validate => false,
1182: p_effective_date => p_rec.effective_date - 1,
1183: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
1184: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 1204: hr_contact_extra_info_api.create_contact_extra_info(

1200: --
1201: -- Note EFFECTIVE_END_DATE/change_date/change_reason cannot be rollbacked
1202: -- for ZAP case.
1203: --
1204: hr_contact_extra_info_api.create_contact_extra_info(
1205: p_validate => false,
1206: p_effective_date => p_rec.effective_date,
1207: p_contact_relationship_id => p_rec.contact_relationship_id,
1208: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_PAY',

Line 1218: hr_contact_extra_info_api.delete_contact_extra_info(

1214: p_object_version_number => p_rec.cei_object_version_number,
1215: p_effective_start_date => l_esd,
1216: p_effective_end_date => l_eed);
1217: else
1218: hr_contact_extra_info_api.delete_contact_extra_info(
1219: p_validate => false,
1220: p_effective_date => p_rec.effective_date - 1,
1221: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
1222: p_contact_extra_info_id => p_rec.contact_extra_info_id,

Line 3678: hr_contact_extra_info_api.delete_contact_extra_info(

3674: end if;
3675: --
3676: for l_rec in csr_dep(l_assact_rec.assignment_action_id) loop
3677: --
3678: hr_contact_extra_info_api.delete_contact_extra_info(
3679: p_validate => false,
3680: p_effective_date => p_expiry_date,
3681: p_datetrack_delete_mode => 'DELETE',
3682: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3697: hr_contact_extra_info_api.delete_contact_extra_info(

3693: end loop;
3694: --
3695: for l_rec in csr_dep_oe(l_assact_rec.assignment_action_id) loop
3696: --
3697: hr_contact_extra_info_api.delete_contact_extra_info(
3698: p_validate => false,
3699: p_effective_date => p_expiry_date,
3700: p_datetrack_delete_mode => 'DELETE',
3701: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3718: hr_contact_extra_info_api.delete_contact_extra_info(

3714: if to_number(to_char(l_assact_rec.effective_date,'YYYY')) < 2011 then
3715: --
3716: for l_rec in csr_dep_os(l_assact_rec.assignment_action_id) loop
3717: --
3718: hr_contact_extra_info_api.delete_contact_extra_info(
3719: p_validate => false,
3720: p_effective_date => p_expiry_date,
3721: p_datetrack_delete_mode => 'DELETE',
3722: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3939: hr_contact_extra_info_api.delete_contact_extra_info(

3935: end if;
3936: --
3937: for l_rec in csr_dep(l_assact_rec.assignment_action_id, l_assact_rec.expiry_date) loop
3938: --
3939: hr_contact_extra_info_api.delete_contact_extra_info(
3940: p_validate => false,
3941: p_effective_date => l_assact_rec.expiry_date,
3942: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
3943: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3958: hr_contact_extra_info_api.delete_contact_extra_info(

3954: end loop;
3955: --
3956: for l_rec in csr_dep_oe(l_assact_rec.assignment_action_id, l_assact_rec.expiry_date) loop
3957: --
3958: hr_contact_extra_info_api.delete_contact_extra_info(
3959: p_validate => false,
3960: p_effective_date => l_assact_rec.expiry_date,
3961: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
3962: p_contact_extra_info_id => l_rec.contact_extra_info_id,

Line 3979: hr_contact_extra_info_api.delete_contact_extra_info(

3975: if to_number(to_char(l_assact_rec.effective_date,'YYYY')) < 2011 then
3976: --
3977: for l_rec in csr_dep_os(l_assact_rec.assignment_action_id, l_assact_rec.expiry_date) loop
3978: --
3979: hr_contact_extra_info_api.delete_contact_extra_info(
3980: p_validate => false,
3981: p_effective_date => l_assact_rec.expiry_date,
3982: p_datetrack_delete_mode => 'DELETE_NEXT_CHANGE',
3983: p_contact_extra_info_id => l_rec.contact_extra_info_id,