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

Line 150: hz_utility_pub.CREATED_BY,

146: 'IEX_ACCOUNT',
147: 'IEX_ACCOUNT',
148: 'U',
149: req_id,
150: hz_utility_pub.CREATED_BY,
151: hz_utility_pub.CREATION_DATE,
152: hz_utility_pub.LAST_UPDATE_LOGIN,
153: hz_utility_pub.LAST_UPDATE_DATE,
154: hz_utility_pub.LAST_UPDATED_BY);

Line 151: hz_utility_pub.CREATION_DATE,

147: 'IEX_ACCOUNT',
148: 'U',
149: req_id,
150: hz_utility_pub.CREATED_BY,
151: hz_utility_pub.CREATION_DATE,
152: hz_utility_pub.LAST_UPDATE_LOGIN,
153: hz_utility_pub.LAST_UPDATE_DATE,
154: hz_utility_pub.LAST_UPDATED_BY);
155: END IF;

Line 152: hz_utility_pub.LAST_UPDATE_LOGIN,

148: 'U',
149: req_id,
150: hz_utility_pub.CREATED_BY,
151: hz_utility_pub.CREATION_DATE,
152: hz_utility_pub.LAST_UPDATE_LOGIN,
153: hz_utility_pub.LAST_UPDATE_DATE,
154: hz_utility_pub.LAST_UPDATED_BY);
155: END IF;
156:

Line 153: hz_utility_pub.LAST_UPDATE_DATE,

149: req_id,
150: hz_utility_pub.CREATED_BY,
151: hz_utility_pub.CREATION_DATE,
152: hz_utility_pub.LAST_UPDATE_LOGIN,
153: hz_utility_pub.LAST_UPDATE_DATE,
154: hz_utility_pub.LAST_UPDATED_BY);
155: END IF;
156:
157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 154: hz_utility_pub.LAST_UPDATED_BY);

150: hz_utility_pub.CREATED_BY,
151: hz_utility_pub.CREATION_DATE,
152: hz_utility_pub.LAST_UPDATE_LOGIN,
153: hz_utility_pub.LAST_UPDATE_DATE,
154: hz_utility_pub.LAST_UPDATED_BY);
155: END IF;
156:
157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
158: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 244: hz_utility_pub.CREATED_BY,

240: 'IEX_ACCOUNT_SITE',
241: 'IEX_ACCOUNT_SITE',
242: 'U',
243: req_id,
244: hz_utility_pub.CREATED_BY,
245: hz_utility_pub.CREATION_DATE,
246: hz_utility_pub.LAST_UPDATE_LOGIN,
247: hz_utility_pub.LAST_UPDATE_DATE,
248: hz_utility_pub.LAST_UPDATED_BY);

Line 245: hz_utility_pub.CREATION_DATE,

241: 'IEX_ACCOUNT_SITE',
242: 'U',
243: req_id,
244: hz_utility_pub.CREATED_BY,
245: hz_utility_pub.CREATION_DATE,
246: hz_utility_pub.LAST_UPDATE_LOGIN,
247: hz_utility_pub.LAST_UPDATE_DATE,
248: hz_utility_pub.LAST_UPDATED_BY);
249: END IF;

Line 246: hz_utility_pub.LAST_UPDATE_LOGIN,

242: 'U',
243: req_id,
244: hz_utility_pub.CREATED_BY,
245: hz_utility_pub.CREATION_DATE,
246: hz_utility_pub.LAST_UPDATE_LOGIN,
247: hz_utility_pub.LAST_UPDATE_DATE,
248: hz_utility_pub.LAST_UPDATED_BY);
249: END IF;
250:

Line 247: hz_utility_pub.LAST_UPDATE_DATE,

243: req_id,
244: hz_utility_pub.CREATED_BY,
245: hz_utility_pub.CREATION_DATE,
246: hz_utility_pub.LAST_UPDATE_LOGIN,
247: hz_utility_pub.LAST_UPDATE_DATE,
248: hz_utility_pub.LAST_UPDATED_BY);
249: END IF;
250:
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 248: hz_utility_pub.LAST_UPDATED_BY);

244: hz_utility_pub.CREATED_BY,
245: hz_utility_pub.CREATION_DATE,
246: hz_utility_pub.LAST_UPDATE_LOGIN,
247: hz_utility_pub.LAST_UPDATE_DATE,
248: hz_utility_pub.LAST_UPDATED_BY);
249: END IF;
250:
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
252: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 333: hz_utility_pub.CREATED_BY,

329: 'IEX_BILLTO',
330: 'IEX_BILLTO',
331: 'U',
332: req_id,
333: hz_utility_pub.CREATED_BY,
334: hz_utility_pub.CREATION_DATE,
335: hz_utility_pub.LAST_UPDATE_LOGIN,
336: hz_utility_pub.LAST_UPDATE_DATE,
337: hz_utility_pub.LAST_UPDATED_BY);

Line 334: hz_utility_pub.CREATION_DATE,

330: 'IEX_BILLTO',
331: 'U',
332: req_id,
333: hz_utility_pub.CREATED_BY,
334: hz_utility_pub.CREATION_DATE,
335: hz_utility_pub.LAST_UPDATE_LOGIN,
336: hz_utility_pub.LAST_UPDATE_DATE,
337: hz_utility_pub.LAST_UPDATED_BY);
338: END IF;

Line 335: hz_utility_pub.LAST_UPDATE_LOGIN,

331: 'U',
332: req_id,
333: hz_utility_pub.CREATED_BY,
334: hz_utility_pub.CREATION_DATE,
335: hz_utility_pub.LAST_UPDATE_LOGIN,
336: hz_utility_pub.LAST_UPDATE_DATE,
337: hz_utility_pub.LAST_UPDATED_BY);
338: END IF;
339:

Line 336: hz_utility_pub.LAST_UPDATE_DATE,

332: req_id,
333: hz_utility_pub.CREATED_BY,
334: hz_utility_pub.CREATION_DATE,
335: hz_utility_pub.LAST_UPDATE_LOGIN,
336: hz_utility_pub.LAST_UPDATE_DATE,
337: hz_utility_pub.LAST_UPDATED_BY);
338: END IF;
339:
340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 337: hz_utility_pub.LAST_UPDATED_BY);

333: hz_utility_pub.CREATED_BY,
334: hz_utility_pub.CREATION_DATE,
335: hz_utility_pub.LAST_UPDATE_LOGIN,
336: hz_utility_pub.LAST_UPDATE_DATE,
337: hz_utility_pub.LAST_UPDATED_BY);
338: END IF;
339:
340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
341: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 524: hz_utility_pub.CREATED_BY,

520: 'ACCOUNT',
521: 'ACCOUNT',
522: 'U',
523: req_id,
524: hz_utility_pub.CREATED_BY,
525: hz_utility_pub.CREATION_DATE,
526: hz_utility_pub.LAST_UPDATE_LOGIN,
527: hz_utility_pub.LAST_UPDATE_DATE,
528: hz_utility_pub.LAST_UPDATED_BY);

Line 525: hz_utility_pub.CREATION_DATE,

521: 'ACCOUNT',
522: 'U',
523: req_id,
524: hz_utility_pub.CREATED_BY,
525: hz_utility_pub.CREATION_DATE,
526: hz_utility_pub.LAST_UPDATE_LOGIN,
527: hz_utility_pub.LAST_UPDATE_DATE,
528: hz_utility_pub.LAST_UPDATED_BY);
529: END IF;

Line 526: hz_utility_pub.LAST_UPDATE_LOGIN,

522: 'U',
523: req_id,
524: hz_utility_pub.CREATED_BY,
525: hz_utility_pub.CREATION_DATE,
526: hz_utility_pub.LAST_UPDATE_LOGIN,
527: hz_utility_pub.LAST_UPDATE_DATE,
528: hz_utility_pub.LAST_UPDATED_BY);
529: END IF;
530:

Line 527: hz_utility_pub.LAST_UPDATE_DATE,

523: req_id,
524: hz_utility_pub.CREATED_BY,
525: hz_utility_pub.CREATION_DATE,
526: hz_utility_pub.LAST_UPDATE_LOGIN,
527: hz_utility_pub.LAST_UPDATE_DATE,
528: hz_utility_pub.LAST_UPDATED_BY);
529: END IF;
530:
531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 528: hz_utility_pub.LAST_UPDATED_BY);

524: hz_utility_pub.CREATED_BY,
525: hz_utility_pub.CREATION_DATE,
526: hz_utility_pub.LAST_UPDATE_LOGIN,
527: hz_utility_pub.LAST_UPDATE_DATE,
528: hz_utility_pub.LAST_UPDATED_BY);
529: END IF;
530:
531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
532: IEX_DEBUG_PUB.logMessage('Merging mergerecord1 : ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 633: hz_utility_pub.CREATED_BY,

629: 'BILL_TO',
630: 'BILL_TO',
631: 'U',
632: req_id,
633: hz_utility_pub.CREATED_BY,
634: hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN,
636: hz_utility_pub.LAST_UPDATE_DATE,
637: hz_utility_pub.LAST_UPDATED_BY);

Line 634: hz_utility_pub.CREATION_DATE,

630: 'BILL_TO',
631: 'U',
632: req_id,
633: hz_utility_pub.CREATED_BY,
634: hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN,
636: hz_utility_pub.LAST_UPDATE_DATE,
637: hz_utility_pub.LAST_UPDATED_BY);
638: END IF;

Line 635: hz_utility_pub.LAST_UPDATE_LOGIN,

631: 'U',
632: req_id,
633: hz_utility_pub.CREATED_BY,
634: hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN,
636: hz_utility_pub.LAST_UPDATE_DATE,
637: hz_utility_pub.LAST_UPDATED_BY);
638: END IF;
639:

Line 636: hz_utility_pub.LAST_UPDATE_DATE,

632: req_id,
633: hz_utility_pub.CREATED_BY,
634: hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN,
636: hz_utility_pub.LAST_UPDATE_DATE,
637: hz_utility_pub.LAST_UPDATED_BY);
638: END IF;
639:
640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 637: hz_utility_pub.LAST_UPDATED_BY);

633: hz_utility_pub.CREATED_BY,
634: hz_utility_pub.CREATION_DATE,
635: hz_utility_pub.LAST_UPDATE_LOGIN,
636: hz_utility_pub.LAST_UPDATE_DATE,
637: hz_utility_pub.LAST_UPDATED_BY);
638: END IF;
639:
640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
641: IEX_DEBUG_PUB.logMessage('Merging merge_record2' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 850: hz_utility_pub.CREATED_BY,

846: NUM_COL1_ORIG_LIST(I),
847: NUM_COL1_NEW_LIST(I),
848: 'U',
849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY);

Line 851: hz_utility_pub.CREATION_DATE,

847: NUM_COL1_NEW_LIST(I),
848: 'U',
849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY);
855: END IF;

Line 852: hz_utility_pub.LAST_UPDATE_LOGIN,

848: 'U',
849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY);
855: END IF;
856:

Line 853: hz_utility_pub.LAST_UPDATE_DATE,

849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY);
855: END IF;
856:
857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 854: hz_utility_pub.LAST_UPDATED_BY);

850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY);
855: END IF;
856:
857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
858: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 949: hz_utility_pub.CREATED_BY,

945: 'IEX_ACCOUNT',
946: 'IEX_ACCOUNT',
947: 'U',
948: req_id,
949: hz_utility_pub.CREATED_BY,
950: hz_utility_pub.CREATION_DATE,
951: hz_utility_pub.LAST_UPDATE_LOGIN,
952: hz_utility_pub.LAST_UPDATE_DATE,
953: hz_utility_pub.LAST_UPDATED_BY);

Line 950: hz_utility_pub.CREATION_DATE,

946: 'IEX_ACCOUNT',
947: 'U',
948: req_id,
949: hz_utility_pub.CREATED_BY,
950: hz_utility_pub.CREATION_DATE,
951: hz_utility_pub.LAST_UPDATE_LOGIN,
952: hz_utility_pub.LAST_UPDATE_DATE,
953: hz_utility_pub.LAST_UPDATED_BY);
954: END IF;

Line 951: hz_utility_pub.LAST_UPDATE_LOGIN,

947: 'U',
948: req_id,
949: hz_utility_pub.CREATED_BY,
950: hz_utility_pub.CREATION_DATE,
951: hz_utility_pub.LAST_UPDATE_LOGIN,
952: hz_utility_pub.LAST_UPDATE_DATE,
953: hz_utility_pub.LAST_UPDATED_BY);
954: END IF;
955:

Line 952: hz_utility_pub.LAST_UPDATE_DATE,

948: req_id,
949: hz_utility_pub.CREATED_BY,
950: hz_utility_pub.CREATION_DATE,
951: hz_utility_pub.LAST_UPDATE_LOGIN,
952: hz_utility_pub.LAST_UPDATE_DATE,
953: hz_utility_pub.LAST_UPDATED_BY);
954: END IF;
955:
956: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 953: hz_utility_pub.LAST_UPDATED_BY);

949: hz_utility_pub.CREATED_BY,
950: hz_utility_pub.CREATION_DATE,
951: hz_utility_pub.LAST_UPDATE_LOGIN,
952: hz_utility_pub.LAST_UPDATE_DATE,
953: hz_utility_pub.LAST_UPDATED_BY);
954: END IF;
955:
956: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
957: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 1060: hz_utility_pub.CREATED_BY,

1056: 'IEX_BILLTO',
1057: 'IEX_BILLTO',
1058: 'U',
1059: req_id,
1060: hz_utility_pub.CREATED_BY,
1061: hz_utility_pub.CREATION_DATE,
1062: hz_utility_pub.LAST_UPDATE_LOGIN,
1063: hz_utility_pub.LAST_UPDATE_DATE,
1064: hz_utility_pub.LAST_UPDATED_BY);

Line 1061: hz_utility_pub.CREATION_DATE,

1057: 'IEX_BILLTO',
1058: 'U',
1059: req_id,
1060: hz_utility_pub.CREATED_BY,
1061: hz_utility_pub.CREATION_DATE,
1062: hz_utility_pub.LAST_UPDATE_LOGIN,
1063: hz_utility_pub.LAST_UPDATE_DATE,
1064: hz_utility_pub.LAST_UPDATED_BY);
1065: END IF;

Line 1062: hz_utility_pub.LAST_UPDATE_LOGIN,

1058: 'U',
1059: req_id,
1060: hz_utility_pub.CREATED_BY,
1061: hz_utility_pub.CREATION_DATE,
1062: hz_utility_pub.LAST_UPDATE_LOGIN,
1063: hz_utility_pub.LAST_UPDATE_DATE,
1064: hz_utility_pub.LAST_UPDATED_BY);
1065: END IF;
1066:

Line 1063: hz_utility_pub.LAST_UPDATE_DATE,

1059: req_id,
1060: hz_utility_pub.CREATED_BY,
1061: hz_utility_pub.CREATION_DATE,
1062: hz_utility_pub.LAST_UPDATE_LOGIN,
1063: hz_utility_pub.LAST_UPDATE_DATE,
1064: hz_utility_pub.LAST_UPDATED_BY);
1065: END IF;
1066:
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1064: hz_utility_pub.LAST_UPDATED_BY);

1060: hz_utility_pub.CREATED_BY,
1061: hz_utility_pub.CREATION_DATE,
1062: hz_utility_pub.LAST_UPDATE_LOGIN,
1063: hz_utility_pub.LAST_UPDATE_DATE,
1064: hz_utility_pub.LAST_UPDATED_BY);
1065: END IF;
1066:
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 1213: hz_utility_pub.CREATED_BY,

1209: NUM_COL1_ORIG_LIST(I),
1210: NUM_COL1_NEW_LIST(I),
1211: 'U',
1212: req_id,
1213: hz_utility_pub.CREATED_BY,
1214: hz_utility_pub.CREATION_DATE,
1215: hz_utility_pub.LAST_UPDATE_LOGIN,
1216: hz_utility_pub.LAST_UPDATE_DATE,
1217: hz_utility_pub.LAST_UPDATED_BY);

Line 1214: hz_utility_pub.CREATION_DATE,

1210: NUM_COL1_NEW_LIST(I),
1211: 'U',
1212: req_id,
1213: hz_utility_pub.CREATED_BY,
1214: hz_utility_pub.CREATION_DATE,
1215: hz_utility_pub.LAST_UPDATE_LOGIN,
1216: hz_utility_pub.LAST_UPDATE_DATE,
1217: hz_utility_pub.LAST_UPDATED_BY);
1218:

Line 1215: hz_utility_pub.LAST_UPDATE_LOGIN,

1211: 'U',
1212: req_id,
1213: hz_utility_pub.CREATED_BY,
1214: hz_utility_pub.CREATION_DATE,
1215: hz_utility_pub.LAST_UPDATE_LOGIN,
1216: hz_utility_pub.LAST_UPDATE_DATE,
1217: hz_utility_pub.LAST_UPDATED_BY);
1218:
1219: END IF;

Line 1216: hz_utility_pub.LAST_UPDATE_DATE,

1212: req_id,
1213: hz_utility_pub.CREATED_BY,
1214: hz_utility_pub.CREATION_DATE,
1215: hz_utility_pub.LAST_UPDATE_LOGIN,
1216: hz_utility_pub.LAST_UPDATE_DATE,
1217: hz_utility_pub.LAST_UPDATED_BY);
1218:
1219: END IF;
1220: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1217: hz_utility_pub.LAST_UPDATED_BY);

1213: hz_utility_pub.CREATED_BY,
1214: hz_utility_pub.CREATION_DATE,
1215: hz_utility_pub.LAST_UPDATE_LOGIN,
1216: hz_utility_pub.LAST_UPDATE_DATE,
1217: hz_utility_pub.LAST_UPDATED_BY);
1218:
1219: END IF;
1220: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1221: UPDATE IEX_PROMISE_DETAILS yt SET

Line 1412: hz_utility_pub.CREATED_BY,

1408: NUM_COL1_ORIG_LIST(I),
1409: NUM_COL1_NEW_LIST(I),
1410: 'U',
1411: req_id,
1412: hz_utility_pub.CREATED_BY,
1413: hz_utility_pub.CREATION_DATE,
1414: hz_utility_pub.LAST_UPDATE_LOGIN,
1415: hz_utility_pub.LAST_UPDATE_DATE,
1416: hz_utility_pub.LAST_UPDATED_BY);

Line 1413: hz_utility_pub.CREATION_DATE,

1409: NUM_COL1_NEW_LIST(I),
1410: 'U',
1411: req_id,
1412: hz_utility_pub.CREATED_BY,
1413: hz_utility_pub.CREATION_DATE,
1414: hz_utility_pub.LAST_UPDATE_LOGIN,
1415: hz_utility_pub.LAST_UPDATE_DATE,
1416: hz_utility_pub.LAST_UPDATED_BY);
1417:

Line 1414: hz_utility_pub.LAST_UPDATE_LOGIN,

1410: 'U',
1411: req_id,
1412: hz_utility_pub.CREATED_BY,
1413: hz_utility_pub.CREATION_DATE,
1414: hz_utility_pub.LAST_UPDATE_LOGIN,
1415: hz_utility_pub.LAST_UPDATE_DATE,
1416: hz_utility_pub.LAST_UPDATED_BY);
1417:
1418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1415: hz_utility_pub.LAST_UPDATE_DATE,

1411: req_id,
1412: hz_utility_pub.CREATED_BY,
1413: hz_utility_pub.CREATION_DATE,
1414: hz_utility_pub.LAST_UPDATE_LOGIN,
1415: hz_utility_pub.LAST_UPDATE_DATE,
1416: hz_utility_pub.LAST_UPDATED_BY);
1417:
1418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1419: IEX_DEBUG_PUB.logMessage('...done');

Line 1416: hz_utility_pub.LAST_UPDATED_BY);

1412: hz_utility_pub.CREATED_BY,
1413: hz_utility_pub.CREATION_DATE,
1414: hz_utility_pub.LAST_UPDATE_LOGIN,
1415: hz_utility_pub.LAST_UPDATE_DATE,
1416: hz_utility_pub.LAST_UPDATED_BY);
1417:
1418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1419: IEX_DEBUG_PUB.logMessage('...done');
1420: END IF;

Line 1525: hz_utility_pub.CREATED_BY,

1521: NUM_COL2_ORIG_LIST(I),
1522: NUM_COL2_NEW_LIST(I),
1523: 'U',
1524: req_id,
1525: hz_utility_pub.CREATED_BY,
1526: hz_utility_pub.CREATION_DATE,
1527: hz_utility_pub.LAST_UPDATE_LOGIN,
1528: hz_utility_pub.LAST_UPDATE_DATE,
1529: hz_utility_pub.LAST_UPDATED_BY);

Line 1526: hz_utility_pub.CREATION_DATE,

1522: NUM_COL2_NEW_LIST(I),
1523: 'U',
1524: req_id,
1525: hz_utility_pub.CREATED_BY,
1526: hz_utility_pub.CREATION_DATE,
1527: hz_utility_pub.LAST_UPDATE_LOGIN,
1528: hz_utility_pub.LAST_UPDATE_DATE,
1529: hz_utility_pub.LAST_UPDATED_BY);
1530:

Line 1527: hz_utility_pub.LAST_UPDATE_LOGIN,

1523: 'U',
1524: req_id,
1525: hz_utility_pub.CREATED_BY,
1526: hz_utility_pub.CREATION_DATE,
1527: hz_utility_pub.LAST_UPDATE_LOGIN,
1528: hz_utility_pub.LAST_UPDATE_DATE,
1529: hz_utility_pub.LAST_UPDATED_BY);
1530:
1531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1528: hz_utility_pub.LAST_UPDATE_DATE,

1524: req_id,
1525: hz_utility_pub.CREATED_BY,
1526: hz_utility_pub.CREATION_DATE,
1527: hz_utility_pub.LAST_UPDATE_LOGIN,
1528: hz_utility_pub.LAST_UPDATE_DATE,
1529: hz_utility_pub.LAST_UPDATED_BY);
1530:
1531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1532: IEX_DEBUG_PUB.logMessage('...done');

Line 1529: hz_utility_pub.LAST_UPDATED_BY);

1525: hz_utility_pub.CREATED_BY,
1526: hz_utility_pub.CREATION_DATE,
1527: hz_utility_pub.LAST_UPDATE_LOGIN,
1528: hz_utility_pub.LAST_UPDATE_DATE,
1529: hz_utility_pub.LAST_UPDATED_BY);
1530:
1531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1532: IEX_DEBUG_PUB.logMessage('...done');
1533: END IF;

Line 1861: last_update_date = hz_utility_pub.last_update_date,

1857: IF v_merged_to_id IS NULL THEN
1858: -- Duplicate Does Not exist. Therefore transfer
1859: UPDATE IEX_DELINQUENCIES_ALL
1860: SET party_cust_id = p_To_FK_id,
1861: last_update_date = hz_utility_pub.last_update_date,
1862: last_updated_by = hz_utility_pub.user_id,
1863: last_update_login = hz_utility_pub.last_update_login,
1864: --request_id = hz_utility_pub.request_id,
1865: --program_application_id = hz_utility_pub.program_application_id,

Line 1862: last_updated_by = hz_utility_pub.user_id,

1858: -- Duplicate Does Not exist. Therefore transfer
1859: UPDATE IEX_DELINQUENCIES_ALL
1860: SET party_cust_id = p_To_FK_id,
1861: last_update_date = hz_utility_pub.last_update_date,
1862: last_updated_by = hz_utility_pub.user_id,
1863: last_update_login = hz_utility_pub.last_update_login,
1864: --request_id = hz_utility_pub.request_id,
1865: --program_application_id = hz_utility_pub.program_application_id,
1866: program_id = hz_utility_pub.program_id

Line 1863: last_update_login = hz_utility_pub.last_update_login,

1859: UPDATE IEX_DELINQUENCIES_ALL
1860: SET party_cust_id = p_To_FK_id,
1861: last_update_date = hz_utility_pub.last_update_date,
1862: last_updated_by = hz_utility_pub.user_id,
1863: last_update_login = hz_utility_pub.last_update_login,
1864: --request_id = hz_utility_pub.request_id,
1865: --program_application_id = hz_utility_pub.program_application_id,
1866: program_id = hz_utility_pub.program_id
1867: --program_update_date = sysdate

Line 1864: --request_id = hz_utility_pub.request_id,

1860: SET party_cust_id = p_To_FK_id,
1861: last_update_date = hz_utility_pub.last_update_date,
1862: last_updated_by = hz_utility_pub.user_id,
1863: last_update_login = hz_utility_pub.last_update_login,
1864: --request_id = hz_utility_pub.request_id,
1865: --program_application_id = hz_utility_pub.program_application_id,
1866: program_id = hz_utility_pub.program_id
1867: --program_update_date = sysdate
1868: WHERE delinquency_id = p_from_id;

Line 1865: --program_application_id = hz_utility_pub.program_application_id,

1861: last_update_date = hz_utility_pub.last_update_date,
1862: last_updated_by = hz_utility_pub.user_id,
1863: last_update_login = hz_utility_pub.last_update_login,
1864: --request_id = hz_utility_pub.request_id,
1865: --program_application_id = hz_utility_pub.program_application_id,
1866: program_id = hz_utility_pub.program_id
1867: --program_update_date = sysdate
1868: WHERE delinquency_id = p_from_id;
1869: RETURN;

Line 1866: program_id = hz_utility_pub.program_id

1862: last_updated_by = hz_utility_pub.user_id,
1863: last_update_login = hz_utility_pub.last_update_login,
1864: --request_id = hz_utility_pub.request_id,
1865: --program_application_id = hz_utility_pub.program_application_id,
1866: program_id = hz_utility_pub.program_id
1867: --program_update_date = sysdate
1868: WHERE delinquency_id = p_from_id;
1869: RETURN;
1870:

Line 1878: last_update_date = hz_utility_pub.last_update_date,

1874: /* Duplicate Exists. Therefore Merge */
1875: /*
1876: UPDATE IEX_DELINQUENCIES_ALL
1877: SET STATUS = 'CLOSED',
1878: last_update_date = hz_utility_pub.last_update_date,
1879: last_updated_by = hz_utility_pub.user_id,
1880: last_update_login = hz_utility_pub.last_update_login,
1881: --request_id = hz_utility_pub.request_id,
1882: --program_application_id = hz_utility_pub.program_application_id,

Line 1879: last_updated_by = hz_utility_pub.user_id,

1875: /*
1876: UPDATE IEX_DELINQUENCIES_ALL
1877: SET STATUS = 'CLOSED',
1878: last_update_date = hz_utility_pub.last_update_date,
1879: last_updated_by = hz_utility_pub.user_id,
1880: last_update_login = hz_utility_pub.last_update_login,
1881: --request_id = hz_utility_pub.request_id,
1882: --program_application_id = hz_utility_pub.program_application_id,
1883: program_id = hz_utility_pub.program_id

Line 1880: last_update_login = hz_utility_pub.last_update_login,

1876: UPDATE IEX_DELINQUENCIES_ALL
1877: SET STATUS = 'CLOSED',
1878: last_update_date = hz_utility_pub.last_update_date,
1879: last_updated_by = hz_utility_pub.user_id,
1880: last_update_login = hz_utility_pub.last_update_login,
1881: --request_id = hz_utility_pub.request_id,
1882: --program_application_id = hz_utility_pub.program_application_id,
1883: program_id = hz_utility_pub.program_id
1884: --program_update_date = sysdate

Line 1881: --request_id = hz_utility_pub.request_id,

1877: SET STATUS = 'CLOSED',
1878: last_update_date = hz_utility_pub.last_update_date,
1879: last_updated_by = hz_utility_pub.user_id,
1880: last_update_login = hz_utility_pub.last_update_login,
1881: --request_id = hz_utility_pub.request_id,
1882: --program_application_id = hz_utility_pub.program_application_id,
1883: program_id = hz_utility_pub.program_id
1884: --program_update_date = sysdate
1885: WHERE delinquency_id = p_from_id;

Line 1882: --program_application_id = hz_utility_pub.program_application_id,

1878: last_update_date = hz_utility_pub.last_update_date,
1879: last_updated_by = hz_utility_pub.user_id,
1880: last_update_login = hz_utility_pub.last_update_login,
1881: --request_id = hz_utility_pub.request_id,
1882: --program_application_id = hz_utility_pub.program_application_id,
1883: program_id = hz_utility_pub.program_id
1884: --program_update_date = sysdate
1885: WHERE delinquency_id = p_from_id;
1886: p_to_id := v_merged_to_id;

Line 1883: program_id = hz_utility_pub.program_id

1879: last_updated_by = hz_utility_pub.user_id,
1880: last_update_login = hz_utility_pub.last_update_login,
1881: --request_id = hz_utility_pub.request_id,
1882: --program_application_id = hz_utility_pub.program_application_id,
1883: program_id = hz_utility_pub.program_id
1884: --program_update_date = sysdate
1885: WHERE delinquency_id = p_from_id;
1886: p_to_id := v_merged_to_id;
1887: