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.

[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_EXTRACT_BO_UTIL_PVT

Line 18: object_type := HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(p_table_name,p_table_id);

14: FROM hz_contact_points
15: WHERE contact_point_id = p_table_id;
16: BEGIN
17: object_type := NULL;
18: object_type := HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(p_table_name,p_table_id);
19:
20: IF object_type IS null THEN
21: IF p_table_name = 'HZ_CONTACT_POINTS' THEN
22: OPEN get_contact_point_type;

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

368: NULL,
369: ORIG_SYSTEM_REF_ID,
370: ORIG_SYSTEM,
371: ORIG_SYSTEM_REFERENCE,
372: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
373: OWNER_TABLE_ID,
374: STATUS,
375: REASON_CODE,
376: OLD_ORIG_SYSTEM_REFERENCE,

Line 381: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

377: START_DATE_ACTIVE,
378: END_DATE_ACTIVE,
379: PROGRAM_UPDATE_DATE,
380: CREATED_BY_MODULE,
381: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
382: CREATION_DATE,
383: LAST_UPDATE_DATE,
384: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
385: ATTRIBUTE_CATEGORY,

Line 384: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

380: CREATED_BY_MODULE,
381: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
382: CREATION_DATE,
383: LAST_UPDATE_DATE,
384: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
385: ATTRIBUTE_CATEGORY,
386: ATTRIBUTE1,
387: ATTRIBUTE2,
388: ATTRIBUTE3,

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

417: NULL,
418: ORIG_SYSTEM_REF_ID,
419: ORIG_SYSTEM,
420: ORIG_SYSTEM_REFERENCE,
421: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
422: OWNER_TABLE_ID,
423: STATUS,
424: REASON_CODE,
425: OLD_ORIG_SYSTEM_REFERENCE,

Line 430: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

426: START_DATE_ACTIVE,
427: END_DATE_ACTIVE,
428: PROGRAM_UPDATE_DATE,
429: CREATED_BY_MODULE,
430: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
431: CREATION_DATE,
432: LAST_UPDATE_DATE,
433: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
434: ATTRIBUTE_CATEGORY,

Line 433: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

429: CREATED_BY_MODULE,
430: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
431: CREATION_DATE,
432: LAST_UPDATE_DATE,
433: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
434: ATTRIBUTE_CATEGORY,
435: ATTRIBUTE1,
436: ATTRIBUTE2,
437: ATTRIBUTE3,

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

466: NULL,
467: ORIG_SYSTEM_REF_ID,
468: ORIG_SYSTEM,
469: ORIG_SYSTEM_REFERENCE,
470: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
471: OWNER_TABLE_ID,
472: STATUS,
473: REASON_CODE,
474: OLD_ORIG_SYSTEM_REFERENCE,

Line 479: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

475: START_DATE_ACTIVE,
476: END_DATE_ACTIVE,
477: PROGRAM_UPDATE_DATE,
478: CREATED_BY_MODULE,
479: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
480: CREATION_DATE,
481: LAST_UPDATE_DATE,
482: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
483: ATTRIBUTE_CATEGORY,

Line 482: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

478: CREATED_BY_MODULE,
479: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
480: CREATION_DATE,
481: LAST_UPDATE_DATE,
482: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
483: ATTRIBUTE_CATEGORY,
484: ATTRIBUTE1,
485: ATTRIBUTE2,
486: ATTRIBUTE3,

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

516: NULL,
517: ORIG_SYSTEM_REF_ID,
518: ORIG_SYSTEM,
519: ORIG_SYSTEM_REFERENCE,
520: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
521: OWNER_TABLE_ID,
522: STATUS,
523: REASON_CODE,
524: OLD_ORIG_SYSTEM_REFERENCE,

Line 529: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

525: START_DATE_ACTIVE,
526: END_DATE_ACTIVE,
527: PROGRAM_UPDATE_DATE,
528: CREATED_BY_MODULE,
529: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
530: CREATION_DATE,
531: LAST_UPDATE_DATE,
532: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
533: ATTRIBUTE_CATEGORY,

Line 532: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

528: CREATED_BY_MODULE,
529: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
530: CREATION_DATE,
531: LAST_UPDATE_DATE,
532: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
533: ATTRIBUTE_CATEGORY,
534: ATTRIBUTE1,
535: ATTRIBUTE2,
536: ATTRIBUTE3,