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.OTAP_CMERGE dependencies on HZ_UTILITY_PUB

Line 103: hz_utility_pub.CREATED_BY,

99: NUM_COL1_ORIG_LIST(I),
100: NUM_COL1_NEW_LIST(I),
101: 'U',
102: req_id,
103: hz_utility_pub.CREATED_BY,
104: hz_utility_pub.CREATION_DATE,
105: hz_utility_pub.LAST_UPDATE_LOGIN,
106: hz_utility_pub.LAST_UPDATE_DATE,
107: hz_utility_pub.LAST_UPDATED_BY

Line 104: hz_utility_pub.CREATION_DATE,

100: NUM_COL1_NEW_LIST(I),
101: 'U',
102: req_id,
103: hz_utility_pub.CREATED_BY,
104: hz_utility_pub.CREATION_DATE,
105: hz_utility_pub.LAST_UPDATE_LOGIN,
106: hz_utility_pub.LAST_UPDATE_DATE,
107: hz_utility_pub.LAST_UPDATED_BY
108: );

Line 105: hz_utility_pub.LAST_UPDATE_LOGIN,

101: 'U',
102: req_id,
103: hz_utility_pub.CREATED_BY,
104: hz_utility_pub.CREATION_DATE,
105: hz_utility_pub.LAST_UPDATE_LOGIN,
106: hz_utility_pub.LAST_UPDATE_DATE,
107: hz_utility_pub.LAST_UPDATED_BY
108: );
109:

Line 106: hz_utility_pub.LAST_UPDATE_DATE,

102: req_id,
103: hz_utility_pub.CREATED_BY,
104: hz_utility_pub.CREATION_DATE,
105: hz_utility_pub.LAST_UPDATE_LOGIN,
106: hz_utility_pub.LAST_UPDATE_DATE,
107: hz_utility_pub.LAST_UPDATED_BY
108: );
109:
110: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 107: hz_utility_pub.LAST_UPDATED_BY

103: hz_utility_pub.CREATED_BY,
104: hz_utility_pub.CREATION_DATE,
105: hz_utility_pub.LAST_UPDATE_LOGIN,
106: hz_utility_pub.LAST_UPDATE_DATE,
107: hz_utility_pub.LAST_UPDATED_BY
108: );
109:
110: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
111: UPDATE OTA_BOOKING_DEALS yt SET

Line 271: hz_utility_pub.CREATED_BY,

267: NUM_COL4_ORIG_LIST(I),
268: NUM_COL4_NEW_LIST(I),
269: 'U',
270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY

Line 272: hz_utility_pub.CREATION_DATE,

268: NUM_COL4_NEW_LIST(I),
269: 'U',
270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );

Line 273: hz_utility_pub.LAST_UPDATE_LOGIN,

269: 'U',
270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );
277:

Line 274: hz_utility_pub.LAST_UPDATE_DATE,

270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );
277:
278: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 275: hz_utility_pub.LAST_UPDATED_BY

271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );
277:
278: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
279: UPDATE OTA_DELEGATE_BOOKINGS yt SET

Line 459: hz_utility_pub.CREATED_BY,

455: VCHAR_COL1_ORIG_LIST(I),
456: VCHAR_COL1_NEW_LIST(I),
457: 'U',
458: req_id,
459: hz_utility_pub.CREATED_BY,
460: hz_utility_pub.CREATION_DATE,
461: hz_utility_pub.LAST_UPDATE_LOGIN,
462: hz_utility_pub.LAST_UPDATE_DATE,
463: hz_utility_pub.LAST_UPDATED_BY

Line 460: hz_utility_pub.CREATION_DATE,

456: VCHAR_COL1_NEW_LIST(I),
457: 'U',
458: req_id,
459: hz_utility_pub.CREATED_BY,
460: hz_utility_pub.CREATION_DATE,
461: hz_utility_pub.LAST_UPDATE_LOGIN,
462: hz_utility_pub.LAST_UPDATE_DATE,
463: hz_utility_pub.LAST_UPDATED_BY
464: );

Line 461: hz_utility_pub.LAST_UPDATE_LOGIN,

457: 'U',
458: req_id,
459: hz_utility_pub.CREATED_BY,
460: hz_utility_pub.CREATION_DATE,
461: hz_utility_pub.LAST_UPDATE_LOGIN,
462: hz_utility_pub.LAST_UPDATE_DATE,
463: hz_utility_pub.LAST_UPDATED_BY
464: );
465:

Line 462: hz_utility_pub.LAST_UPDATE_DATE,

458: req_id,
459: hz_utility_pub.CREATED_BY,
460: hz_utility_pub.CREATION_DATE,
461: hz_utility_pub.LAST_UPDATE_LOGIN,
462: hz_utility_pub.LAST_UPDATE_DATE,
463: hz_utility_pub.LAST_UPDATED_BY
464: );
465:
466: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 463: hz_utility_pub.LAST_UPDATED_BY

459: hz_utility_pub.CREATED_BY,
460: hz_utility_pub.CREATION_DATE,
461: hz_utility_pub.LAST_UPDATE_LOGIN,
462: hz_utility_pub.LAST_UPDATE_DATE,
463: hz_utility_pub.LAST_UPDATED_BY
464: );
465:
466: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
467: UPDATE OTA_FINANCE_HEADERS yt SET

Line 705: , hz_utility_pub.CREATED_BY

701: , l_evt_assoc_rec.PERSON_ID
702: , l_evt_assoc_rec.PARTY_ID
703: , l_evt_assoc_rec.LEARNING_PATH_ID
704: , l_evt_assoc_rec.ORGANIZATION_ID
705: , hz_utility_pub.CREATED_BY
706: , hz_utility_pub.CREATION_DATE
707: , hz_utility_pub.LAST_UPDATE_LOGIN
708: , hz_utility_pub.LAST_UPDATE_DATE
709: , hz_utility_pub.LAST_UPDATED_BY

Line 706: , hz_utility_pub.CREATION_DATE

702: , l_evt_assoc_rec.PARTY_ID
703: , l_evt_assoc_rec.LEARNING_PATH_ID
704: , l_evt_assoc_rec.ORGANIZATION_ID
705: , hz_utility_pub.CREATED_BY
706: , hz_utility_pub.CREATION_DATE
707: , hz_utility_pub.LAST_UPDATE_LOGIN
708: , hz_utility_pub.LAST_UPDATE_DATE
709: , hz_utility_pub.LAST_UPDATED_BY
710: );

Line 707: , hz_utility_pub.LAST_UPDATE_LOGIN

703: , l_evt_assoc_rec.LEARNING_PATH_ID
704: , l_evt_assoc_rec.ORGANIZATION_ID
705: , hz_utility_pub.CREATED_BY
706: , hz_utility_pub.CREATION_DATE
707: , hz_utility_pub.LAST_UPDATE_LOGIN
708: , hz_utility_pub.LAST_UPDATE_DATE
709: , hz_utility_pub.LAST_UPDATED_BY
710: );
711: --Purge the "Merge From" record

Line 708: , hz_utility_pub.LAST_UPDATE_DATE

704: , l_evt_assoc_rec.ORGANIZATION_ID
705: , hz_utility_pub.CREATED_BY
706: , hz_utility_pub.CREATION_DATE
707: , hz_utility_pub.LAST_UPDATE_LOGIN
708: , hz_utility_pub.LAST_UPDATE_DATE
709: , hz_utility_pub.LAST_UPDATED_BY
710: );
711: --Purge the "Merge From" record
712: DELETE OTA_EVENT_ASSOCIATIONS

Line 709: , hz_utility_pub.LAST_UPDATED_BY

705: , hz_utility_pub.CREATED_BY
706: , hz_utility_pub.CREATION_DATE
707: , hz_utility_pub.LAST_UPDATE_LOGIN
708: , hz_utility_pub.LAST_UPDATE_DATE
709: , hz_utility_pub.LAST_UPDATED_BY
710: );
711: --Purge the "Merge From" record
712: DELETE OTA_EVENT_ASSOCIATIONS
713: WHERE EVENT_ASSOCIATION_ID=PRIMARY_KEY_ID1_LIST(I)

Line 747: hz_utility_pub.CREATED_BY,

743: NUM_COL1_ORIG_LIST(I),
744: NUM_COL1_NEW_LIST(I),
745: 'U',
746: req_id,
747: hz_utility_pub.CREATED_BY,
748: hz_utility_pub.CREATION_DATE,
749: hz_utility_pub.LAST_UPDATE_LOGIN,
750: hz_utility_pub.LAST_UPDATE_DATE,
751: hz_utility_pub.LAST_UPDATED_BY

Line 748: hz_utility_pub.CREATION_DATE,

744: NUM_COL1_NEW_LIST(I),
745: 'U',
746: req_id,
747: hz_utility_pub.CREATED_BY,
748: hz_utility_pub.CREATION_DATE,
749: hz_utility_pub.LAST_UPDATE_LOGIN,
750: hz_utility_pub.LAST_UPDATE_DATE,
751: hz_utility_pub.LAST_UPDATED_BY
752: );

Line 749: hz_utility_pub.LAST_UPDATE_LOGIN,

745: 'U',
746: req_id,
747: hz_utility_pub.CREATED_BY,
748: hz_utility_pub.CREATION_DATE,
749: hz_utility_pub.LAST_UPDATE_LOGIN,
750: hz_utility_pub.LAST_UPDATE_DATE,
751: hz_utility_pub.LAST_UPDATED_BY
752: );
753: END IF;

Line 750: hz_utility_pub.LAST_UPDATE_DATE,

746: req_id,
747: hz_utility_pub.CREATED_BY,
748: hz_utility_pub.CREATION_DATE,
749: hz_utility_pub.LAST_UPDATE_LOGIN,
750: hz_utility_pub.LAST_UPDATE_DATE,
751: hz_utility_pub.LAST_UPDATED_BY
752: );
753: END IF;
754: CLOSE csr_duplicate_record;

Line 751: hz_utility_pub.LAST_UPDATED_BY

747: hz_utility_pub.CREATED_BY,
748: hz_utility_pub.CREATION_DATE,
749: hz_utility_pub.LAST_UPDATE_LOGIN,
750: hz_utility_pub.LAST_UPDATE_DATE,
751: hz_utility_pub.LAST_UPDATED_BY
752: );
753: END IF;
754: CLOSE csr_duplicate_record;
755: END LOOP;

Line 903: hz_utility_pub.CREATED_BY,

899: NUM_COL1_ORIG_LIST(I),
900: NUM_COL1_NEW_LIST(I),
901: 'U',
902: req_id,
903: hz_utility_pub.CREATED_BY,
904: hz_utility_pub.CREATION_DATE,
905: hz_utility_pub.LAST_UPDATE_LOGIN,
906: hz_utility_pub.LAST_UPDATE_DATE,
907: hz_utility_pub.LAST_UPDATED_BY

Line 904: hz_utility_pub.CREATION_DATE,

900: NUM_COL1_NEW_LIST(I),
901: 'U',
902: req_id,
903: hz_utility_pub.CREATED_BY,
904: hz_utility_pub.CREATION_DATE,
905: hz_utility_pub.LAST_UPDATE_LOGIN,
906: hz_utility_pub.LAST_UPDATE_DATE,
907: hz_utility_pub.LAST_UPDATED_BY
908: );

Line 905: hz_utility_pub.LAST_UPDATE_LOGIN,

901: 'U',
902: req_id,
903: hz_utility_pub.CREATED_BY,
904: hz_utility_pub.CREATION_DATE,
905: hz_utility_pub.LAST_UPDATE_LOGIN,
906: hz_utility_pub.LAST_UPDATE_DATE,
907: hz_utility_pub.LAST_UPDATED_BY
908: );
909:

Line 906: hz_utility_pub.LAST_UPDATE_DATE,

902: req_id,
903: hz_utility_pub.CREATED_BY,
904: hz_utility_pub.CREATION_DATE,
905: hz_utility_pub.LAST_UPDATE_LOGIN,
906: hz_utility_pub.LAST_UPDATE_DATE,
907: hz_utility_pub.LAST_UPDATED_BY
908: );
909:
910: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 907: hz_utility_pub.LAST_UPDATED_BY

903: hz_utility_pub.CREATED_BY,
904: hz_utility_pub.CREATION_DATE,
905: hz_utility_pub.LAST_UPDATE_LOGIN,
906: hz_utility_pub.LAST_UPDATE_DATE,
907: hz_utility_pub.LAST_UPDATED_BY
908: );
909:
910: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
911: UPDATE OTA_NOTRNG_HISTORIES yt SET