APPS.IEX_WF_BAN_STATUS_PUB dependencies on HZ_CONTACT_PREFERENCE_V2PUB

Line 794: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;

790: l_party_id NUMBER;
791: l_o_party_id NUMBER;
792: l_p_party_id NUMBER;
793:
794: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;
795:
796: CURSOR C_DO_PARTY(p_person_id NUMBER) IS
797: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
798: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'

Line 888: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (

884: l_contact_preference_rec.PREFERENCE_START_DATE := sysdate;
885: l_contact_preference_rec.STATUS := 'A';
886: l_contact_preference_rec.CREATED_BY_MODULE := 'IEX';
887:
888: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (
889: p_init_msg_list => l_init_msg_list,
890: p_contact_preference_id => l_contact_preference_id,
891: x_contact_preference_rec => l_contact_preference_rec,
892: x_return_status => l_return_status,

Line 903: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference (

899: --and l_contact_preference_rec.CONTACT_TYPE = 'CONTACT' THEN
900: null;
901: ELSE
902: -- update contact_preference_type
903: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference (
904: p_init_msg_list => l_init_msg_list,
905: p_contact_preference_rec => l_contact_preference_rec,
906: p_object_version_number => l_object_version_number,
907: x_return_status => l_return_status,

Line 947: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference (

943: l_contact_preference_rec.PREFERENCE_START_DATE := sysdate;
944: l_contact_preference_rec.STATUS := 'A';
945: l_contact_preference_rec.CREATED_BY_MODULE := 'IEX';
946:
947: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference (
948: p_init_msg_list => l_init_msg_list,
949: p_contact_preference_rec => l_contact_preference_rec,
950: x_contact_preference_id => o_contact_preference_id,
951: x_return_status => l_return_status,

Line 971: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (

967: END LOOP;
968: CLOSE C_PARTY;
969:
970: /*
971: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (
972: p_init_msg_list => l_init_msg_list,
973: p_contact_preference_id => l_contact_preference_id,
974: x_contact_preference_rec => l_contact_preference_rec,
975: x_return_status => l_return_status,