APPS.IBE_CUSTOMER_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 16: * -creates a row in HZ_CONTACT_PREFERENCES if no row exists for party_id

12: *PROCEDURE:
13: * setOptInOutPreference
14: *DESCRIPTION:
15: * -calls HZ_CONTACT_PREFERENCE_V2PUB to update the preference code
16: * -creates a row in HZ_CONTACT_PREFERENCES if no row exists for party_id
17: */
18: PROCEDURE setOptInOutPreference(
19: p_party_id IN NUMBER,
20: p_preference IN VARCHAR2,

Line 61: From hz_contact_preferences

57: --begin set/create contact preferences
58: BEGIN
59: SELECT contact_preference_id, last_update_date, object_version_number
60: INTO l_id, l_date, l_obj_ver
61: From hz_contact_preferences
62: WHERE contact_level_table='HZ_PARTIES'
63: AND contact_level_table_id=p_party_id;
64: --update reason_code if record found
65: l_contact_preference_rec.contact_preference_id := l_id;