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

Line 175: SELECT HZ_CONTACT_PREF_OBJ(

171: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
172: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
173: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
174: CAST(MULTISET (
175: SELECT HZ_CONTACT_PREF_OBJ(
176: P_ACTION_TYPE,
177: NULL, -- COMMON_OBJ_ID
178: CONTACT_PREFERENCE_ID,
179: 'PHONE',

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 457: SELECT HZ_CONTACT_PREF_OBJ(

453: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
454: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
455: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
456: CAST(MULTISET (
457: SELECT HZ_CONTACT_PREF_OBJ(
458: P_ACTION_TYPE,
459: NULL, -- COMMON_OBJ_ID
460: CONTACT_PREFERENCE_ID,
461: 'TLX',

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 738: SELECT HZ_CONTACT_PREF_OBJ(

734: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
735: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
736: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
737: CAST(MULTISET (
738: SELECT HZ_CONTACT_PREF_OBJ(
739: P_ACTION_TYPE,
740: NULL, -- COMMON_OBJ_ID
741: CONTACT_PREFERENCE_ID,
742: 'EMAIL',

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 1021: SELECT HZ_CONTACT_PREF_OBJ(

1017: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1018: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1019: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1020: CAST(MULTISET (
1021: SELECT HZ_CONTACT_PREF_OBJ(
1022: P_ACTION_TYPE,
1023: NULL, -- COMMON_OBJ_ID
1024: CONTACT_PREFERENCE_ID,
1025: 'WEB',

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 1313: SELECT HZ_CONTACT_PREF_OBJ(

1309: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1310: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1311: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1312: CAST(MULTISET (
1313: SELECT HZ_CONTACT_PREF_OBJ(
1314: P_ACTION_TYPE,
1315: NULL, -- COMMON_OBJ_ID
1316: CONTACT_PREFERENCE_ID,
1317: 'EDI',

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 1597: SELECT HZ_CONTACT_PREF_OBJ(

1593: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1594: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1595: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1596: CAST(MULTISET (
1597: SELECT HZ_CONTACT_PREF_OBJ(
1598: P_ACTION_TYPE,
1599: NULL, -- COMMON_OBJ_ID
1600: CONTACT_PREFERENCE_ID,
1601: 'EFT',

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 1887: SELECT HZ_CONTACT_PREF_OBJ(

1883: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1884: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1885: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1886: CAST(MULTISET (
1887: SELECT HZ_CONTACT_PREF_OBJ(
1888: P_ACTION_TYPE,
1889: NULL, -- COMMON_OBJ_ID
1890: CONTACT_PREFERENCE_ID,
1891: 'SMS',

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 2045: select HZ_CONTACT_PREF_OBJ(

2041: i BINARY_INTEGER := 1;
2042: l_debug_prefix VARCHAR2(30) := '';
2043:
2044: cursor c1 is
2045: select HZ_CONTACT_PREF_OBJ(
2046: P_ACTION_TYPE,
2047: NULL, -- COMMON_OBJ_ID
2048: CONTACT_PREFERENCE_ID,
2049: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(CONTACT_LEVEL_TABLE,CONTACT_LEVEL_TABLE_ID),

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;