APPS.HZ_EXTRACT_CONT_POINT_BO_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 27: Contact Preference N Y HZ_CONTACT_PREFERENCES

23:
24: Embedded BO Mandatory Multiple Logical API Procedure Comments
25:
26: Contact Point Y N HZ_CONTACT_POINTS
27: Contact Preference N Y HZ_CONTACT_PREFERENCES
28:
29: */
30:
31:

Line 203: FROM HZ_CONTACT_PREFERENCES CPREF

199: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
200: CREATION_DATE,
201: LAST_UPDATE_DATE,
202: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
203: FROM HZ_CONTACT_PREFERENCES CPREF
204: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
205: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
206: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'PHONE'
207: AND ((P_PHONE_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME

Line 485: FROM HZ_CONTACT_PREFERENCES CPREF

481: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
482: CREATION_DATE,
483: LAST_UPDATE_DATE,
484: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
485: FROM HZ_CONTACT_PREFERENCES CPREF
486: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
487: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
488: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'TLX'
489: AND ((P_TELEX_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME

Line 766: FROM HZ_CONTACT_PREFERENCES CPREF

762: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
763: CREATION_DATE,
764: LAST_UPDATE_DATE,
765: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
766: FROM HZ_CONTACT_PREFERENCES CPREF
767: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
768: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
769: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EMAIL'
770: AND ((P_EMAIL_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME

Line 1049: FROM HZ_CONTACT_PREFERENCES CPREF

1045: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1046: CREATION_DATE,
1047: LAST_UPDATE_DATE,
1048: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1049: FROM HZ_CONTACT_PREFERENCES CPREF
1050: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1051: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1052: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'WEB'
1053: AND ((P_WEB_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME

Line 1341: FROM HZ_CONTACT_PREFERENCES CPREF

1337: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1338: CREATION_DATE,
1339: LAST_UPDATE_DATE,
1340: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1341: FROM HZ_CONTACT_PREFERENCES CPREF
1342: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1343: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1344: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EDI'
1345: AND ((P_EDI_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME

Line 1625: FROM HZ_CONTACT_PREFERENCES CPREF

1621: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1622: CREATION_DATE,
1623: LAST_UPDATE_DATE,
1624: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1625: FROM HZ_CONTACT_PREFERENCES CPREF
1626: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1627: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1628: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EFT'
1629: AND ((P_EFT_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME

Line 1915: FROM HZ_CONTACT_PREFERENCES CPREF

1911: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1912: CREATION_DATE,
1913: LAST_UPDATE_DATE,
1914: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1915: FROM HZ_CONTACT_PREFERENCES CPREF
1916: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1917: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1918: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'SMS'
1919: AND ((P_SMS_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME

Line 2073: from hz_contact_preferences

2069: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
2070: CREATION_DATE,
2071: LAST_UPDATE_DATE,
2072: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
2073: from hz_contact_preferences
2074: where contact_level_table = p_cont_level_table
2075: and contact_level_table_id = p_cont_level_table_id
2076: and contact_type = nvl(p_contact_type, contact_type);
2077: