eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EXTRACT_CONT_POINT_BO_PVT dependencies on HZ_CONTACT_PREF_OBJ_TBL

Line 205: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))

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
208: AND OWNER_TABLE_ID = P_PARENT_ID)
209: OR (P_PHONE_ID IS NOT NULL AND CONTACT_POINT_ID = P_PHONE_ID));

Line 487: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))

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
490: AND OWNER_TABLE_ID = P_PARENT_ID)
491: OR (P_TELEX_ID IS NOT NULL AND CONTACT_POINT_ID = P_TELEX_ID));

Line 768: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))

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
771: AND OWNER_TABLE_ID = P_PARENT_ID)
772: OR (P_EMAIL_ID IS NOT NULL AND CONTACT_POINT_ID = P_EMAIL_ID));

Line 1051: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))

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
1054: AND OWNER_TABLE_ID = P_PARENT_ID)
1055: OR (P_WEB_ID IS NOT NULL AND CONTACT_POINT_ID = P_WEB_ID));

Line 1343: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))

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
1346: AND OWNER_TABLE_ID = P_PARENT_ID)
1347: OR (P_EDI_ID IS NOT NULL AND CONTACT_POINT_ID = P_EDI_ID));

Line 1627: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))

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
1630: AND OWNER_TABLE_ID = P_PARENT_ID)
1631: OR (P_EFT_ID IS NOT NULL AND CONTACT_POINT_ID = P_EFT_ID));

Line 1917: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))

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
1920: AND OWNER_TABLE_ID = P_PARENT_ID)
1921: OR (P_SMS_ID IS NOT NULL AND CONTACT_POINT_ID = P_SMS_ID));

Line 2036: x_cont_pref_objs OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,

2032: p_cont_level_table_id IN NUMBER,
2033: p_cont_level_table IN VARCHAR2,
2034: p_contact_type IN VARCHAR2,
2035: p_action_type IN VARCHAR2 := NULL,
2036: x_cont_pref_objs OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,
2037: x_return_status OUT NOCOPY VARCHAR2,
2038: x_msg_count OUT NOCOPY NUMBER,
2039: x_msg_data OUT NOCOPY VARCHAR2
2040: ) is

Line 2095: x_cont_pref_objs := HZ_CONTACT_PREF_OBJ_TBL();

2091: p_prefix=>l_debug_prefix,
2092: p_msg_level=>fnd_log.level_procedure);
2093: END IF;
2094:
2095: x_cont_pref_objs := HZ_CONTACT_PREF_OBJ_TBL();
2096:
2097: open c1;
2098: fetch c1 BULK COLLECT into x_cont_pref_objs;
2099: close c1;