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 148: hz_utility_pub.CREATED_BY,

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

Line 149: hz_utility_pub.CREATION_DATE,

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

Line 150: hz_utility_pub.LAST_UPDATE_LOGIN,

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

Line 151: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 152: hz_utility_pub.LAST_UPDATED_BY);

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

Line 233: hz_utility_pub.CREATED_BY,

229: 'IEX_ACCOUNT_SITE',
230: 'IEX_ACCOUNT_SITE',
231: 'U',
232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY);

Line 234: hz_utility_pub.CREATION_DATE,

230: 'IEX_ACCOUNT_SITE',
231: 'U',
232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY);
238: END IF;

Line 235: hz_utility_pub.LAST_UPDATE_LOGIN,

231: 'U',
232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY);
238: END IF;
239:

Line 236: hz_utility_pub.LAST_UPDATE_DATE,

232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY);
238: END IF;
239:
240: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 237: hz_utility_pub.LAST_UPDATED_BY);

233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY);
238: END IF;
239:
240: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
241: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 314: hz_utility_pub.CREATED_BY,

310: 'IEX_BILLTO',
311: 'IEX_BILLTO',
312: 'U',
313: req_id,
314: hz_utility_pub.CREATED_BY,
315: hz_utility_pub.CREATION_DATE,
316: hz_utility_pub.LAST_UPDATE_LOGIN,
317: hz_utility_pub.LAST_UPDATE_DATE,
318: hz_utility_pub.LAST_UPDATED_BY);

Line 315: hz_utility_pub.CREATION_DATE,

311: 'IEX_BILLTO',
312: 'U',
313: req_id,
314: hz_utility_pub.CREATED_BY,
315: hz_utility_pub.CREATION_DATE,
316: hz_utility_pub.LAST_UPDATE_LOGIN,
317: hz_utility_pub.LAST_UPDATE_DATE,
318: hz_utility_pub.LAST_UPDATED_BY);
319: END IF;

Line 316: hz_utility_pub.LAST_UPDATE_LOGIN,

312: 'U',
313: req_id,
314: hz_utility_pub.CREATED_BY,
315: hz_utility_pub.CREATION_DATE,
316: hz_utility_pub.LAST_UPDATE_LOGIN,
317: hz_utility_pub.LAST_UPDATE_DATE,
318: hz_utility_pub.LAST_UPDATED_BY);
319: END IF;
320:

Line 317: hz_utility_pub.LAST_UPDATE_DATE,

313: req_id,
314: hz_utility_pub.CREATED_BY,
315: hz_utility_pub.CREATION_DATE,
316: hz_utility_pub.LAST_UPDATE_LOGIN,
317: hz_utility_pub.LAST_UPDATE_DATE,
318: hz_utility_pub.LAST_UPDATED_BY);
319: END IF;
320:
321: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 318: hz_utility_pub.LAST_UPDATED_BY);

314: hz_utility_pub.CREATED_BY,
315: hz_utility_pub.CREATION_DATE,
316: hz_utility_pub.LAST_UPDATE_LOGIN,
317: hz_utility_pub.LAST_UPDATE_DATE,
318: hz_utility_pub.LAST_UPDATED_BY);
319: END IF;
320:
321: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
322: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 479: hz_utility_pub.CREATED_BY,

475: 'ACCOUNT',
476: 'ACCOUNT',
477: 'U',
478: req_id,
479: hz_utility_pub.CREATED_BY,
480: hz_utility_pub.CREATION_DATE,
481: hz_utility_pub.LAST_UPDATE_LOGIN,
482: hz_utility_pub.LAST_UPDATE_DATE,
483: hz_utility_pub.LAST_UPDATED_BY);

Line 480: hz_utility_pub.CREATION_DATE,

476: 'ACCOUNT',
477: 'U',
478: req_id,
479: hz_utility_pub.CREATED_BY,
480: hz_utility_pub.CREATION_DATE,
481: hz_utility_pub.LAST_UPDATE_LOGIN,
482: hz_utility_pub.LAST_UPDATE_DATE,
483: hz_utility_pub.LAST_UPDATED_BY);
484: END IF;

Line 481: hz_utility_pub.LAST_UPDATE_LOGIN,

477: 'U',
478: req_id,
479: hz_utility_pub.CREATED_BY,
480: hz_utility_pub.CREATION_DATE,
481: hz_utility_pub.LAST_UPDATE_LOGIN,
482: hz_utility_pub.LAST_UPDATE_DATE,
483: hz_utility_pub.LAST_UPDATED_BY);
484: END IF;
485:

Line 482: hz_utility_pub.LAST_UPDATE_DATE,

478: req_id,
479: hz_utility_pub.CREATED_BY,
480: hz_utility_pub.CREATION_DATE,
481: hz_utility_pub.LAST_UPDATE_LOGIN,
482: hz_utility_pub.LAST_UPDATE_DATE,
483: hz_utility_pub.LAST_UPDATED_BY);
484: END IF;
485:
486: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 483: hz_utility_pub.LAST_UPDATED_BY);

479: hz_utility_pub.CREATED_BY,
480: hz_utility_pub.CREATION_DATE,
481: hz_utility_pub.LAST_UPDATE_LOGIN,
482: hz_utility_pub.LAST_UPDATE_DATE,
483: hz_utility_pub.LAST_UPDATED_BY);
484: END IF;
485:
486: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
487: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 566: hz_utility_pub.CREATED_BY,

562: 'BILL_TO',
563: 'BILL_TO',
564: 'U',
565: req_id,
566: hz_utility_pub.CREATED_BY,
567: hz_utility_pub.CREATION_DATE,
568: hz_utility_pub.LAST_UPDATE_LOGIN,
569: hz_utility_pub.LAST_UPDATE_DATE,
570: hz_utility_pub.LAST_UPDATED_BY);

Line 567: hz_utility_pub.CREATION_DATE,

563: 'BILL_TO',
564: 'U',
565: req_id,
566: hz_utility_pub.CREATED_BY,
567: hz_utility_pub.CREATION_DATE,
568: hz_utility_pub.LAST_UPDATE_LOGIN,
569: hz_utility_pub.LAST_UPDATE_DATE,
570: hz_utility_pub.LAST_UPDATED_BY);
571: END IF;

Line 568: hz_utility_pub.LAST_UPDATE_LOGIN,

564: 'U',
565: req_id,
566: hz_utility_pub.CREATED_BY,
567: hz_utility_pub.CREATION_DATE,
568: hz_utility_pub.LAST_UPDATE_LOGIN,
569: hz_utility_pub.LAST_UPDATE_DATE,
570: hz_utility_pub.LAST_UPDATED_BY);
571: END IF;
572:

Line 569: hz_utility_pub.LAST_UPDATE_DATE,

565: req_id,
566: hz_utility_pub.CREATED_BY,
567: hz_utility_pub.CREATION_DATE,
568: hz_utility_pub.LAST_UPDATE_LOGIN,
569: hz_utility_pub.LAST_UPDATE_DATE,
570: hz_utility_pub.LAST_UPDATED_BY);
571: END IF;
572:
573: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 570: hz_utility_pub.LAST_UPDATED_BY);

566: hz_utility_pub.CREATED_BY,
567: hz_utility_pub.CREATION_DATE,
568: hz_utility_pub.LAST_UPDATE_LOGIN,
569: hz_utility_pub.LAST_UPDATE_DATE,
570: hz_utility_pub.LAST_UPDATED_BY);
571: END IF;
572:
573: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
574: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 769: hz_utility_pub.CREATED_BY,

765: NUM_COL1_ORIG_LIST(I),
766: NUM_COL1_NEW_LIST(I),
767: 'U',
768: req_id,
769: hz_utility_pub.CREATED_BY,
770: hz_utility_pub.CREATION_DATE,
771: hz_utility_pub.LAST_UPDATE_LOGIN,
772: hz_utility_pub.LAST_UPDATE_DATE,
773: hz_utility_pub.LAST_UPDATED_BY);

Line 770: hz_utility_pub.CREATION_DATE,

766: NUM_COL1_NEW_LIST(I),
767: 'U',
768: req_id,
769: hz_utility_pub.CREATED_BY,
770: hz_utility_pub.CREATION_DATE,
771: hz_utility_pub.LAST_UPDATE_LOGIN,
772: hz_utility_pub.LAST_UPDATE_DATE,
773: hz_utility_pub.LAST_UPDATED_BY);
774: END IF;

Line 771: hz_utility_pub.LAST_UPDATE_LOGIN,

767: 'U',
768: req_id,
769: hz_utility_pub.CREATED_BY,
770: hz_utility_pub.CREATION_DATE,
771: hz_utility_pub.LAST_UPDATE_LOGIN,
772: hz_utility_pub.LAST_UPDATE_DATE,
773: hz_utility_pub.LAST_UPDATED_BY);
774: END IF;
775:

Line 772: hz_utility_pub.LAST_UPDATE_DATE,

768: req_id,
769: hz_utility_pub.CREATED_BY,
770: hz_utility_pub.CREATION_DATE,
771: hz_utility_pub.LAST_UPDATE_LOGIN,
772: hz_utility_pub.LAST_UPDATE_DATE,
773: hz_utility_pub.LAST_UPDATED_BY);
774: END IF;
775:
776: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 773: hz_utility_pub.LAST_UPDATED_BY);

769: hz_utility_pub.CREATED_BY,
770: hz_utility_pub.CREATION_DATE,
771: hz_utility_pub.LAST_UPDATE_LOGIN,
772: hz_utility_pub.LAST_UPDATE_DATE,
773: hz_utility_pub.LAST_UPDATED_BY);
774: END IF;
775:
776: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
777: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 859: hz_utility_pub.CREATED_BY,

855: 'IEX_ACCOUNT',
856: 'IEX_ACCOUNT',
857: 'U',
858: req_id,
859: hz_utility_pub.CREATED_BY,
860: hz_utility_pub.CREATION_DATE,
861: hz_utility_pub.LAST_UPDATE_LOGIN,
862: hz_utility_pub.LAST_UPDATE_DATE,
863: hz_utility_pub.LAST_UPDATED_BY);

Line 860: hz_utility_pub.CREATION_DATE,

856: 'IEX_ACCOUNT',
857: 'U',
858: req_id,
859: hz_utility_pub.CREATED_BY,
860: hz_utility_pub.CREATION_DATE,
861: hz_utility_pub.LAST_UPDATE_LOGIN,
862: hz_utility_pub.LAST_UPDATE_DATE,
863: hz_utility_pub.LAST_UPDATED_BY);
864: END IF;

Line 861: hz_utility_pub.LAST_UPDATE_LOGIN,

857: 'U',
858: req_id,
859: hz_utility_pub.CREATED_BY,
860: hz_utility_pub.CREATION_DATE,
861: hz_utility_pub.LAST_UPDATE_LOGIN,
862: hz_utility_pub.LAST_UPDATE_DATE,
863: hz_utility_pub.LAST_UPDATED_BY);
864: END IF;
865:

Line 862: hz_utility_pub.LAST_UPDATE_DATE,

858: req_id,
859: hz_utility_pub.CREATED_BY,
860: hz_utility_pub.CREATION_DATE,
861: hz_utility_pub.LAST_UPDATE_LOGIN,
862: hz_utility_pub.LAST_UPDATE_DATE,
863: hz_utility_pub.LAST_UPDATED_BY);
864: END IF;
865:
866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 863: hz_utility_pub.LAST_UPDATED_BY);

859: hz_utility_pub.CREATED_BY,
860: hz_utility_pub.CREATION_DATE,
861: hz_utility_pub.LAST_UPDATE_LOGIN,
862: hz_utility_pub.LAST_UPDATE_DATE,
863: hz_utility_pub.LAST_UPDATED_BY);
864: END IF;
865:
866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
867: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 955: hz_utility_pub.CREATED_BY,

951: 'IEX_BILLTO',
952: 'IEX_BILLTO',
953: 'U',
954: req_id,
955: hz_utility_pub.CREATED_BY,
956: hz_utility_pub.CREATION_DATE,
957: hz_utility_pub.LAST_UPDATE_LOGIN,
958: hz_utility_pub.LAST_UPDATE_DATE,
959: hz_utility_pub.LAST_UPDATED_BY);

Line 956: hz_utility_pub.CREATION_DATE,

952: 'IEX_BILLTO',
953: 'U',
954: req_id,
955: hz_utility_pub.CREATED_BY,
956: hz_utility_pub.CREATION_DATE,
957: hz_utility_pub.LAST_UPDATE_LOGIN,
958: hz_utility_pub.LAST_UPDATE_DATE,
959: hz_utility_pub.LAST_UPDATED_BY);
960: END IF;

Line 957: hz_utility_pub.LAST_UPDATE_LOGIN,

953: 'U',
954: req_id,
955: hz_utility_pub.CREATED_BY,
956: hz_utility_pub.CREATION_DATE,
957: hz_utility_pub.LAST_UPDATE_LOGIN,
958: hz_utility_pub.LAST_UPDATE_DATE,
959: hz_utility_pub.LAST_UPDATED_BY);
960: END IF;
961:

Line 958: hz_utility_pub.LAST_UPDATE_DATE,

954: req_id,
955: hz_utility_pub.CREATED_BY,
956: hz_utility_pub.CREATION_DATE,
957: hz_utility_pub.LAST_UPDATE_LOGIN,
958: hz_utility_pub.LAST_UPDATE_DATE,
959: hz_utility_pub.LAST_UPDATED_BY);
960: END IF;
961:
962: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 959: hz_utility_pub.LAST_UPDATED_BY);

955: hz_utility_pub.CREATED_BY,
956: hz_utility_pub.CREATION_DATE,
957: hz_utility_pub.LAST_UPDATE_LOGIN,
958: hz_utility_pub.LAST_UPDATE_DATE,
959: hz_utility_pub.LAST_UPDATED_BY);
960: END IF;
961:
962: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
963: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');

Line 1096: hz_utility_pub.CREATED_BY,

1092: NUM_COL1_ORIG_LIST(I),
1093: NUM_COL1_NEW_LIST(I),
1094: 'U',
1095: req_id,
1096: hz_utility_pub.CREATED_BY,
1097: hz_utility_pub.CREATION_DATE,
1098: hz_utility_pub.LAST_UPDATE_LOGIN,
1099: hz_utility_pub.LAST_UPDATE_DATE,
1100: hz_utility_pub.LAST_UPDATED_BY);

Line 1097: hz_utility_pub.CREATION_DATE,

1093: NUM_COL1_NEW_LIST(I),
1094: 'U',
1095: req_id,
1096: hz_utility_pub.CREATED_BY,
1097: hz_utility_pub.CREATION_DATE,
1098: hz_utility_pub.LAST_UPDATE_LOGIN,
1099: hz_utility_pub.LAST_UPDATE_DATE,
1100: hz_utility_pub.LAST_UPDATED_BY);
1101:

Line 1098: hz_utility_pub.LAST_UPDATE_LOGIN,

1094: 'U',
1095: req_id,
1096: hz_utility_pub.CREATED_BY,
1097: hz_utility_pub.CREATION_DATE,
1098: hz_utility_pub.LAST_UPDATE_LOGIN,
1099: hz_utility_pub.LAST_UPDATE_DATE,
1100: hz_utility_pub.LAST_UPDATED_BY);
1101:
1102: END IF;

Line 1099: hz_utility_pub.LAST_UPDATE_DATE,

1095: req_id,
1096: hz_utility_pub.CREATED_BY,
1097: hz_utility_pub.CREATION_DATE,
1098: hz_utility_pub.LAST_UPDATE_LOGIN,
1099: hz_utility_pub.LAST_UPDATE_DATE,
1100: hz_utility_pub.LAST_UPDATED_BY);
1101:
1102: END IF;
1103: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1100: hz_utility_pub.LAST_UPDATED_BY);

1096: hz_utility_pub.CREATED_BY,
1097: hz_utility_pub.CREATION_DATE,
1098: hz_utility_pub.LAST_UPDATE_LOGIN,
1099: hz_utility_pub.LAST_UPDATE_DATE,
1100: hz_utility_pub.LAST_UPDATED_BY);
1101:
1102: END IF;
1103: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1104: UPDATE IEX_PROMISE_DETAILS yt SET

Line 1290: hz_utility_pub.CREATED_BY,

1286: NUM_COL1_ORIG_LIST(I),
1287: NUM_COL1_NEW_LIST(I),
1288: 'U',
1289: req_id,
1290: hz_utility_pub.CREATED_BY,
1291: hz_utility_pub.CREATION_DATE,
1292: hz_utility_pub.LAST_UPDATE_LOGIN,
1293: hz_utility_pub.LAST_UPDATE_DATE,
1294: hz_utility_pub.LAST_UPDATED_BY);

Line 1291: hz_utility_pub.CREATION_DATE,

1287: NUM_COL1_NEW_LIST(I),
1288: 'U',
1289: req_id,
1290: hz_utility_pub.CREATED_BY,
1291: hz_utility_pub.CREATION_DATE,
1292: hz_utility_pub.LAST_UPDATE_LOGIN,
1293: hz_utility_pub.LAST_UPDATE_DATE,
1294: hz_utility_pub.LAST_UPDATED_BY);
1295:

Line 1292: hz_utility_pub.LAST_UPDATE_LOGIN,

1288: 'U',
1289: req_id,
1290: hz_utility_pub.CREATED_BY,
1291: hz_utility_pub.CREATION_DATE,
1292: hz_utility_pub.LAST_UPDATE_LOGIN,
1293: hz_utility_pub.LAST_UPDATE_DATE,
1294: hz_utility_pub.LAST_UPDATED_BY);
1295:
1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1293: hz_utility_pub.LAST_UPDATE_DATE,

1289: req_id,
1290: hz_utility_pub.CREATED_BY,
1291: hz_utility_pub.CREATION_DATE,
1292: hz_utility_pub.LAST_UPDATE_LOGIN,
1293: hz_utility_pub.LAST_UPDATE_DATE,
1294: hz_utility_pub.LAST_UPDATED_BY);
1295:
1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1297: IEX_DEBUG_PUB.logMessage('...done');

Line 1294: hz_utility_pub.LAST_UPDATED_BY);

1290: hz_utility_pub.CREATED_BY,
1291: hz_utility_pub.CREATION_DATE,
1292: hz_utility_pub.LAST_UPDATE_LOGIN,
1293: hz_utility_pub.LAST_UPDATE_DATE,
1294: hz_utility_pub.LAST_UPDATED_BY);
1295:
1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1297: IEX_DEBUG_PUB.logMessage('...done');
1298: END IF;

Line 1403: hz_utility_pub.CREATED_BY,

1399: NUM_COL2_ORIG_LIST(I),
1400: NUM_COL2_NEW_LIST(I),
1401: 'U',
1402: req_id,
1403: hz_utility_pub.CREATED_BY,
1404: hz_utility_pub.CREATION_DATE,
1405: hz_utility_pub.LAST_UPDATE_LOGIN,
1406: hz_utility_pub.LAST_UPDATE_DATE,
1407: hz_utility_pub.LAST_UPDATED_BY);

Line 1404: hz_utility_pub.CREATION_DATE,

1400: NUM_COL2_NEW_LIST(I),
1401: 'U',
1402: req_id,
1403: hz_utility_pub.CREATED_BY,
1404: hz_utility_pub.CREATION_DATE,
1405: hz_utility_pub.LAST_UPDATE_LOGIN,
1406: hz_utility_pub.LAST_UPDATE_DATE,
1407: hz_utility_pub.LAST_UPDATED_BY);
1408:

Line 1405: hz_utility_pub.LAST_UPDATE_LOGIN,

1401: 'U',
1402: req_id,
1403: hz_utility_pub.CREATED_BY,
1404: hz_utility_pub.CREATION_DATE,
1405: hz_utility_pub.LAST_UPDATE_LOGIN,
1406: hz_utility_pub.LAST_UPDATE_DATE,
1407: hz_utility_pub.LAST_UPDATED_BY);
1408:
1409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1406: hz_utility_pub.LAST_UPDATE_DATE,

1402: req_id,
1403: hz_utility_pub.CREATED_BY,
1404: hz_utility_pub.CREATION_DATE,
1405: hz_utility_pub.LAST_UPDATE_LOGIN,
1406: hz_utility_pub.LAST_UPDATE_DATE,
1407: hz_utility_pub.LAST_UPDATED_BY);
1408:
1409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1410: IEX_DEBUG_PUB.logMessage('...done');

Line 1407: hz_utility_pub.LAST_UPDATED_BY);

1403: hz_utility_pub.CREATED_BY,
1404: hz_utility_pub.CREATION_DATE,
1405: hz_utility_pub.LAST_UPDATE_LOGIN,
1406: hz_utility_pub.LAST_UPDATE_DATE,
1407: hz_utility_pub.LAST_UPDATED_BY);
1408:
1409: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1410: IEX_DEBUG_PUB.logMessage('...done');
1411: END IF;

Line 1739: last_update_date = hz_utility_pub.last_update_date,

1735: IF v_merged_to_id IS NULL THEN
1736: -- Duplicate Does Not exist. Therefore transfer
1737: UPDATE IEX_DELINQUENCIES_ALL
1738: SET party_cust_id = p_To_FK_id,
1739: last_update_date = hz_utility_pub.last_update_date,
1740: last_updated_by = hz_utility_pub.user_id,
1741: last_update_login = hz_utility_pub.last_update_login,
1742: --request_id = hz_utility_pub.request_id,
1743: --program_application_id = hz_utility_pub.program_application_id,

Line 1740: last_updated_by = hz_utility_pub.user_id,

1736: -- Duplicate Does Not exist. Therefore transfer
1737: UPDATE IEX_DELINQUENCIES_ALL
1738: SET party_cust_id = p_To_FK_id,
1739: last_update_date = hz_utility_pub.last_update_date,
1740: last_updated_by = hz_utility_pub.user_id,
1741: last_update_login = hz_utility_pub.last_update_login,
1742: --request_id = hz_utility_pub.request_id,
1743: --program_application_id = hz_utility_pub.program_application_id,
1744: program_id = hz_utility_pub.program_id

Line 1741: last_update_login = hz_utility_pub.last_update_login,

1737: UPDATE IEX_DELINQUENCIES_ALL
1738: SET party_cust_id = p_To_FK_id,
1739: last_update_date = hz_utility_pub.last_update_date,
1740: last_updated_by = hz_utility_pub.user_id,
1741: last_update_login = hz_utility_pub.last_update_login,
1742: --request_id = hz_utility_pub.request_id,
1743: --program_application_id = hz_utility_pub.program_application_id,
1744: program_id = hz_utility_pub.program_id
1745: --program_update_date = sysdate

Line 1742: --request_id = hz_utility_pub.request_id,

1738: SET party_cust_id = p_To_FK_id,
1739: last_update_date = hz_utility_pub.last_update_date,
1740: last_updated_by = hz_utility_pub.user_id,
1741: last_update_login = hz_utility_pub.last_update_login,
1742: --request_id = hz_utility_pub.request_id,
1743: --program_application_id = hz_utility_pub.program_application_id,
1744: program_id = hz_utility_pub.program_id
1745: --program_update_date = sysdate
1746: WHERE delinquency_id = p_from_id;

Line 1743: --program_application_id = hz_utility_pub.program_application_id,

1739: last_update_date = hz_utility_pub.last_update_date,
1740: last_updated_by = hz_utility_pub.user_id,
1741: last_update_login = hz_utility_pub.last_update_login,
1742: --request_id = hz_utility_pub.request_id,
1743: --program_application_id = hz_utility_pub.program_application_id,
1744: program_id = hz_utility_pub.program_id
1745: --program_update_date = sysdate
1746: WHERE delinquency_id = p_from_id;
1747: RETURN;

Line 1744: program_id = hz_utility_pub.program_id

1740: last_updated_by = hz_utility_pub.user_id,
1741: last_update_login = hz_utility_pub.last_update_login,
1742: --request_id = hz_utility_pub.request_id,
1743: --program_application_id = hz_utility_pub.program_application_id,
1744: program_id = hz_utility_pub.program_id
1745: --program_update_date = sysdate
1746: WHERE delinquency_id = p_from_id;
1747: RETURN;
1748:

Line 1756: last_update_date = hz_utility_pub.last_update_date,

1752: /* Duplicate Exists. Therefore Merge */
1753: /*
1754: UPDATE IEX_DELINQUENCIES_ALL
1755: SET STATUS = 'CLOSED',
1756: last_update_date = hz_utility_pub.last_update_date,
1757: last_updated_by = hz_utility_pub.user_id,
1758: last_update_login = hz_utility_pub.last_update_login,
1759: --request_id = hz_utility_pub.request_id,
1760: --program_application_id = hz_utility_pub.program_application_id,

Line 1757: last_updated_by = hz_utility_pub.user_id,

1753: /*
1754: UPDATE IEX_DELINQUENCIES_ALL
1755: SET STATUS = 'CLOSED',
1756: last_update_date = hz_utility_pub.last_update_date,
1757: last_updated_by = hz_utility_pub.user_id,
1758: last_update_login = hz_utility_pub.last_update_login,
1759: --request_id = hz_utility_pub.request_id,
1760: --program_application_id = hz_utility_pub.program_application_id,
1761: program_id = hz_utility_pub.program_id

Line 1758: last_update_login = hz_utility_pub.last_update_login,

1754: UPDATE IEX_DELINQUENCIES_ALL
1755: SET STATUS = 'CLOSED',
1756: last_update_date = hz_utility_pub.last_update_date,
1757: last_updated_by = hz_utility_pub.user_id,
1758: last_update_login = hz_utility_pub.last_update_login,
1759: --request_id = hz_utility_pub.request_id,
1760: --program_application_id = hz_utility_pub.program_application_id,
1761: program_id = hz_utility_pub.program_id
1762: --program_update_date = sysdate

Line 1759: --request_id = hz_utility_pub.request_id,

1755: SET STATUS = 'CLOSED',
1756: last_update_date = hz_utility_pub.last_update_date,
1757: last_updated_by = hz_utility_pub.user_id,
1758: last_update_login = hz_utility_pub.last_update_login,
1759: --request_id = hz_utility_pub.request_id,
1760: --program_application_id = hz_utility_pub.program_application_id,
1761: program_id = hz_utility_pub.program_id
1762: --program_update_date = sysdate
1763: WHERE delinquency_id = p_from_id;

Line 1760: --program_application_id = hz_utility_pub.program_application_id,

1756: last_update_date = hz_utility_pub.last_update_date,
1757: last_updated_by = hz_utility_pub.user_id,
1758: last_update_login = hz_utility_pub.last_update_login,
1759: --request_id = hz_utility_pub.request_id,
1760: --program_application_id = hz_utility_pub.program_application_id,
1761: program_id = hz_utility_pub.program_id
1762: --program_update_date = sysdate
1763: WHERE delinquency_id = p_from_id;
1764: p_to_id := v_merged_to_id;

Line 1761: program_id = hz_utility_pub.program_id

1757: last_updated_by = hz_utility_pub.user_id,
1758: last_update_login = hz_utility_pub.last_update_login,
1759: --request_id = hz_utility_pub.request_id,
1760: --program_application_id = hz_utility_pub.program_application_id,
1761: program_id = hz_utility_pub.program_id
1762: --program_update_date = sysdate
1763: WHERE delinquency_id = p_from_id;
1764: p_to_id := v_merged_to_id;
1765: