APPS.IEX_WF_BAN_STATUS_PUB dependencies on HZ_CONTACT_PREFERENCE_V2PUB

Line 520: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;

516: l_party_id NUMBER;
517: l_o_party_id NUMBER;
518: l_p_party_id NUMBER;
519:
520: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;
521:
522: CURSOR C_DO_PARTY(p_person_id NUMBER) IS
523: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
524: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'

Line 614: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (

610: l_contact_preference_rec.PREFERENCE_START_DATE := sysdate;
611: l_contact_preference_rec.STATUS := 'A';
612: l_contact_preference_rec.CREATED_BY_MODULE := 'IEX';
613:
614: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (
615: p_init_msg_list => l_init_msg_list,
616: p_contact_preference_id => l_contact_preference_id,
617: x_contact_preference_rec => l_contact_preference_rec,
618: x_return_status => l_return_status,

Line 629: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference (

625: --and l_contact_preference_rec.CONTACT_TYPE = 'CONTACT' THEN
626: null;
627: ELSE
628: -- update contact_preference_type
629: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference (
630: p_init_msg_list => l_init_msg_list,
631: p_contact_preference_rec => l_contact_preference_rec,
632: p_object_version_number => l_object_version_number,
633: x_return_status => l_return_status,

Line 673: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference (

669: l_contact_preference_rec.PREFERENCE_START_DATE := sysdate;
670: l_contact_preference_rec.STATUS := 'A';
671: l_contact_preference_rec.CREATED_BY_MODULE := 'IEX';
672:
673: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference (
674: p_init_msg_list => l_init_msg_list,
675: p_contact_preference_rec => l_contact_preference_rec,
676: x_contact_preference_id => o_contact_preference_id,
677: x_return_status => l_return_status,

Line 697: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (

693: END LOOP;
694: CLOSE C_PARTY;
695:
696: /*
697: HZ_CONTACT_PREFERENCE_V2PUB.get_contact_preference_rec (
698: p_init_msg_list => l_init_msg_list,
699: p_contact_preference_id => l_contact_preference_id,
700: x_contact_preference_rec => l_contact_preference_rec,
701: x_return_status => l_return_status,