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_EXTRACT_BO_UTIL_PVT

Line 87: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

83: CONTACT_POINT_ID,
84: NULL, -- ORIG_SYSTEM,
85: NULL, -- ORIG_SYSTEM_REFERENCE,
86: STATUS,
87: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
88: OWNER_TABLE_ID,
89: PRIMARY_FLAG,
90: ATTRIBUTE_CATEGORY,
91: ATTRIBUTE1,

Line 115: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

111: CONTACT_POINT_PURPOSE,
112: PRIMARY_BY_PURPOSE,
113: PROGRAM_UPDATE_DATE,
114: CREATED_BY_MODULE,
115: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
116: CREATION_DATE,
117: LAST_UPDATE_DATE,
118: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
119: ACTUAL_CONTENT_SOURCE,

Line 118: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

114: CREATED_BY_MODULE,
115: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
116: CREATION_DATE,
117: LAST_UPDATE_DATE,
118: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
119: ACTUAL_CONTENT_SOURCE,
120: PHONE_CALLING_CALENDAR,
121: LAST_CONTACT_DT_TIME,
122: TIMEZONE_ID,

Line 135: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

131: NULL, --P_ACTION_TYPE,
132: ORIG_SYSTEM_REF_ID,
133: ORIG_SYSTEM,
134: ORIG_SYSTEM_REFERENCE,
135: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
136: OWNER_TABLE_ID,
137: STATUS,
138: REASON_CODE,
139: OLD_ORIG_SYSTEM_REFERENCE,

Line 144: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

140: START_DATE_ACTIVE,
141: END_DATE_ACTIVE,
142: PROGRAM_UPDATE_DATE,
143: CREATED_BY_MODULE,
144: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
145: CREATION_DATE,
146: LAST_UPDATE_DATE,
147: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
148: ATTRIBUTE_CATEGORY,

Line 147: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

143: CREATED_BY_MODULE,
144: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
145: CREATION_DATE,
146: LAST_UPDATE_DATE,
147: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
148: ATTRIBUTE_CATEGORY,
149: ATTRIBUTE1,
150: ATTRIBUTE2,
151: ATTRIBUTE3,

Line 199: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

195: REASON_CODE,
196: STATUS,
197: PROGRAM_UPDATE_DATE,
198: CREATED_BY_MODULE,
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

Line 202: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

198: CREATED_BY_MODULE,
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'

Line 377: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

373: CONTACT_POINT_ID,
374: NULL, -- ORIG_SYSTEM,
375: NULL, -- ORIG_SYSTEM_REFERENCE,
376: STATUS,
377: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
378: OWNER_TABLE_ID,
379: PRIMARY_FLAG,
380: ATTRIBUTE_CATEGORY,
381: ATTRIBUTE1,

Line 405: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

401: CONTACT_POINT_PURPOSE,
402: PRIMARY_BY_PURPOSE,
403: PROGRAM_UPDATE_DATE,
404: CREATED_BY_MODULE,
405: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
406: CREATION_DATE,
407: LAST_UPDATE_DATE,
408: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
409: ACTUAL_CONTENT_SOURCE,

Line 408: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

404: CREATED_BY_MODULE,
405: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
406: CREATION_DATE,
407: LAST_UPDATE_DATE,
408: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
409: ACTUAL_CONTENT_SOURCE,
410: TELEX_NUMBER,
411: CAST(MULTISET (
412: SELECT HZ_ORIG_SYS_REF_OBJ(

Line 426: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

422: START_DATE_ACTIVE,
423: END_DATE_ACTIVE,
424: PROGRAM_UPDATE_DATE,
425: CREATED_BY_MODULE,
426: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
427: CREATION_DATE,
428: LAST_UPDATE_DATE,
429: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
430: ATTRIBUTE_CATEGORY,

Line 429: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

425: CREATED_BY_MODULE,
426: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
427: CREATION_DATE,
428: LAST_UPDATE_DATE,
429: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
430: ATTRIBUTE_CATEGORY,
431: ATTRIBUTE1,
432: ATTRIBUTE2,
433: ATTRIBUTE3,

Line 481: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

477: REASON_CODE,
478: STATUS,
479: PROGRAM_UPDATE_DATE,
480: CREATED_BY_MODULE,
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

Line 484: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

480: CREATED_BY_MODULE,
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'

Line 657: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

653: CONTACT_POINT_ID,
654: NULL, -- ORIG_SYSTEM,
655: NULL, -- ORIG_SYSTEM_REFERENCE,
656: STATUS,
657: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
658: OWNER_TABLE_ID,
659: PRIMARY_FLAG,
660: ATTRIBUTE_CATEGORY,
661: ATTRIBUTE1,

Line 685: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

681: CONTACT_POINT_PURPOSE,
682: PRIMARY_BY_PURPOSE,
683: PROGRAM_UPDATE_DATE,
684: CREATED_BY_MODULE,
685: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
686: CREATION_DATE,
687: LAST_UPDATE_DATE,
688: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
689: ACTUAL_CONTENT_SOURCE,

Line 688: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

684: CREATED_BY_MODULE,
685: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
686: CREATION_DATE,
687: LAST_UPDATE_DATE,
688: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
689: ACTUAL_CONTENT_SOURCE,
690: EMAIL_FORMAT,
691: EMAIL_ADDRESS,
692: CAST(MULTISET (

Line 707: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

703: START_DATE_ACTIVE,
704: END_DATE_ACTIVE,
705: PROGRAM_UPDATE_DATE,
706: CREATED_BY_MODULE,
707: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
708: CREATION_DATE,
709: LAST_UPDATE_DATE,
710: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
711: ATTRIBUTE_CATEGORY,

Line 710: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

706: CREATED_BY_MODULE,
707: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
708: CREATION_DATE,
709: LAST_UPDATE_DATE,
710: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
711: ATTRIBUTE_CATEGORY,
712: ATTRIBUTE1,
713: ATTRIBUTE2,
714: ATTRIBUTE3,

Line 762: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

758: REASON_CODE,
759: STATUS,
760: PROGRAM_UPDATE_DATE,
761: CREATED_BY_MODULE,
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

Line 765: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

761: CREATED_BY_MODULE,
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'

Line 940: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

936: CONTACT_POINT_ID,
937: NULL, -- ORIG_SYSTEM,
938: NULL, -- ORIG_SYSTEM_REFERENCE,
939: STATUS,
940: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
941: OWNER_TABLE_ID,
942: PRIMARY_FLAG,
943: ATTRIBUTE_CATEGORY,
944: ATTRIBUTE1,

Line 968: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

964: CONTACT_POINT_PURPOSE,
965: PRIMARY_BY_PURPOSE,
966: PROGRAM_UPDATE_DATE,
967: CREATED_BY_MODULE,
968: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
969: CREATION_DATE,
970: LAST_UPDATE_DATE,
971: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
972: ACTUAL_CONTENT_SOURCE,

Line 971: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

967: CREATED_BY_MODULE,
968: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
969: CREATION_DATE,
970: LAST_UPDATE_DATE,
971: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
972: ACTUAL_CONTENT_SOURCE,
973: WEB_TYPE,
974: URL,
975: CAST(MULTISET (

Line 990: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

986: START_DATE_ACTIVE,
987: END_DATE_ACTIVE,
988: PROGRAM_UPDATE_DATE,
989: CREATED_BY_MODULE,
990: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
991: CREATION_DATE,
992: LAST_UPDATE_DATE,
993: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
994: ATTRIBUTE_CATEGORY,

Line 993: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

989: CREATED_BY_MODULE,
990: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
991: CREATION_DATE,
992: LAST_UPDATE_DATE,
993: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
994: ATTRIBUTE_CATEGORY,
995: ATTRIBUTE1,
996: ATTRIBUTE2,
997: ATTRIBUTE3,

Line 1045: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1041: REASON_CODE,
1042: STATUS,
1043: PROGRAM_UPDATE_DATE,
1044: CREATED_BY_MODULE,
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

Line 1048: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

1044: CREATED_BY_MODULE,
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'

Line 1226: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

1222: CONTACT_POINT_ID,
1223: NULL, -- ORIG_SYSTEM,
1224: NULL, -- ORIG_SYSTEM_REFERENCE,
1225: STATUS,
1226: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
1227: OWNER_TABLE_ID,
1228: PRIMARY_FLAG,
1229: ATTRIBUTE_CATEGORY,
1230: ATTRIBUTE1,

Line 1254: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1250: CONTACT_POINT_PURPOSE,
1251: PRIMARY_BY_PURPOSE,
1252: PROGRAM_UPDATE_DATE,
1253: CREATED_BY_MODULE,
1254: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1255: CREATION_DATE,
1256: LAST_UPDATE_DATE,
1257: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1258: ACTUAL_CONTENT_SOURCE,

Line 1257: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1253: CREATED_BY_MODULE,
1254: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1255: CREATION_DATE,
1256: LAST_UPDATE_DATE,
1257: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1258: ACTUAL_CONTENT_SOURCE,
1259: EDI_TRANSACTION_HANDLING,
1260: EDI_ID_NUMBER,
1261: EDI_PAYMENT_METHOD,

Line 1282: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1278: START_DATE_ACTIVE,
1279: END_DATE_ACTIVE,
1280: PROGRAM_UPDATE_DATE,
1281: CREATED_BY_MODULE,
1282: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1283: CREATION_DATE,
1284: LAST_UPDATE_DATE,
1285: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1286: ATTRIBUTE_CATEGORY,

Line 1285: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1281: CREATED_BY_MODULE,
1282: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1283: CREATION_DATE,
1284: LAST_UPDATE_DATE,
1285: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1286: ATTRIBUTE_CATEGORY,
1287: ATTRIBUTE1,
1288: ATTRIBUTE2,
1289: ATTRIBUTE3,

Line 1337: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1333: REASON_CODE,
1334: STATUS,
1335: PROGRAM_UPDATE_DATE,
1336: CREATED_BY_MODULE,
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

Line 1340: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

1336: CREATED_BY_MODULE,
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'

Line 1514: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

1510: CONTACT_POINT_ID,
1511: NULL, -- ORIG_SYSTEM,
1512: NULL, -- ORIG_SYSTEM_REFERENCE,
1513: STATUS,
1514: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
1515: OWNER_TABLE_ID,
1516: PRIMARY_FLAG,
1517: ATTRIBUTE_CATEGORY,
1518: ATTRIBUTE1,

Line 1542: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1538: CONTACT_POINT_PURPOSE,
1539: PRIMARY_BY_PURPOSE,
1540: PROGRAM_UPDATE_DATE,
1541: CREATED_BY_MODULE,
1542: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1543: CREATION_DATE,
1544: LAST_UPDATE_DATE,
1545: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1546: ACTUAL_CONTENT_SOURCE,

Line 1545: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1541: CREATED_BY_MODULE,
1542: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1543: CREATION_DATE,
1544: LAST_UPDATE_DATE,
1545: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1546: ACTUAL_CONTENT_SOURCE,
1547: EFT_TRANSMISSION_PROGRAM_ID,
1548: EFT_PRINTING_PROGRAM_ID,
1549: EFT_USER_NUMBER,

Line 1557: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

1553: NULL, --P_ACTION_TYPE,
1554: ORIG_SYSTEM_REF_ID,
1555: ORIG_SYSTEM,
1556: ORIG_SYSTEM_REFERENCE,
1557: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
1558: OWNER_TABLE_ID,
1559: STATUS,
1560: REASON_CODE,
1561: OLD_ORIG_SYSTEM_REFERENCE,

Line 1566: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1562: START_DATE_ACTIVE,
1563: END_DATE_ACTIVE,
1564: PROGRAM_UPDATE_DATE,
1565: CREATED_BY_MODULE,
1566: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1567: CREATION_DATE,
1568: LAST_UPDATE_DATE,
1569: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1570: ATTRIBUTE_CATEGORY,

Line 1569: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1565: CREATED_BY_MODULE,
1566: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1567: CREATION_DATE,
1568: LAST_UPDATE_DATE,
1569: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1570: ATTRIBUTE_CATEGORY,
1571: ATTRIBUTE1,
1572: ATTRIBUTE2,
1573: ATTRIBUTE3,

Line 1621: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1617: REASON_CODE,
1618: STATUS,
1619: PROGRAM_UPDATE_DATE,
1620: CREATED_BY_MODULE,
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

Line 1624: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

1620: CREATED_BY_MODULE,
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'

Line 1799: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

1795: CONTACT_POINT_ID,
1796: NULL, -- ORIG_SYSTEM,
1797: NULL, -- ORIG_SYSTEM_REFERENCE,
1798: STATUS,
1799: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
1800: OWNER_TABLE_ID,
1801: PRIMARY_FLAG,
1802: ATTRIBUTE_CATEGORY,
1803: ATTRIBUTE1,

Line 1827: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1823: CONTACT_POINT_PURPOSE,
1824: PRIMARY_BY_PURPOSE,
1825: PROGRAM_UPDATE_DATE,
1826: CREATED_BY_MODULE,
1827: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1828: CREATION_DATE,
1829: LAST_UPDATE_DATE,
1830: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1831: ACTUAL_CONTENT_SOURCE,

Line 1830: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1826: CREATED_BY_MODULE,
1827: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1828: CREATION_DATE,
1829: LAST_UPDATE_DATE,
1830: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1831: ACTUAL_CONTENT_SOURCE,
1832: PHONE_CALLING_CALENDAR,
1833: LAST_CONTACT_DT_TIME,
1834: TIMEZONE_ID,

Line 1856: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1852: START_DATE_ACTIVE,
1853: END_DATE_ACTIVE,
1854: PROGRAM_UPDATE_DATE,
1855: CREATED_BY_MODULE,
1856: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1857: CREATION_DATE,
1858: LAST_UPDATE_DATE,
1859: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1860: ATTRIBUTE_CATEGORY,

Line 1859: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1855: CREATED_BY_MODULE,
1856: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1857: CREATION_DATE,
1858: LAST_UPDATE_DATE,
1859: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1860: ATTRIBUTE_CATEGORY,
1861: ATTRIBUTE1,
1862: ATTRIBUTE2,
1863: ATTRIBUTE3,

Line 1911: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1907: REASON_CODE,
1908: STATUS,
1909: PROGRAM_UPDATE_DATE,
1910: CREATED_BY_MODULE,
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

Line 1914: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

1910: CREATED_BY_MODULE,
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'

Line 2049: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(CONTACT_LEVEL_TABLE,CONTACT_LEVEL_TABLE_ID),

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),
2050: CONTACT_LEVEL_TABLE_ID,
2051: CONTACT_TYPE,
2052: PREFERENCE_CODE,
2053: PREFERENCE_TOPIC_TYPE,

Line 2069: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

2065: REASON_CODE,
2066: STATUS,
2067: PROGRAM_UPDATE_DATE,
2068: CREATED_BY_MODULE,
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

Line 2072: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

2068: CREATED_BY_MODULE,
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);