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_CUSTOMER_MERGE_LOG

Line 124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

120: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
121: END LOOP;
122: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
123: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
125: MERGE_LOG_ID,
126: TABLE_NAME,
127: MERGE_HEADER_ID,
128: PRIMARY_KEY_ID,

Line 140: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

136: CREATION_DATE,
137: LAST_UPDATE_LOGIN,
138: LAST_UPDATE_DATE,
139: LAST_UPDATED_BY) VALUES
140: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
141: 'IEX_SCORE_HISTORIES',
142: MERGE_HEADER_ID_LIST(I),
143: PRIMARY_KEY_ID_LIST(I),
144: NUM_COL1_ORIG_LIST(I),

Line 218: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

214: END LOOP;
215:
216: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
217: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
218: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
219: MERGE_LOG_ID,
220: TABLE_NAME,
221: MERGE_HEADER_ID,
222: PRIMARY_KEY_ID,

Line 234: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

230: CREATION_DATE,
231: LAST_UPDATE_LOGIN,
232: LAST_UPDATE_DATE,
233: LAST_UPDATED_BY) VALUES
234: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
235: 'IEX_SCORE_HISTORIES',
236: MERGE_HEADER_ID_LIST(I),
237: PRIMARY_KEY_ID_LIST(I),
238: NUM_COL1_ORIG_LIST(I),

Line 307: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

303: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
304: END LOOP;
305: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
306: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
307: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
308: MERGE_LOG_ID,
309: TABLE_NAME,
310: MERGE_HEADER_ID,
311: PRIMARY_KEY_ID,

Line 323: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

319: CREATION_DATE,
320: LAST_UPDATE_LOGIN,
321: LAST_UPDATE_DATE,
322: LAST_UPDATED_BY) VALUES
323: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
324: 'IEX_SCORE_HISTORIES',
325: MERGE_HEADER_ID_LIST(I),
326: PRIMARY_KEY_ID_LIST(I),
327: NUM_COL3_ORIG_LIST(I),

Line 497: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

493:
494: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
495: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
496:
497: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
498: MERGE_LOG_ID,
499: TABLE_NAME,
500: MERGE_HEADER_ID,
501: PRIMARY_KEY_ID,

Line 514: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

510: LAST_UPDATE_LOGIN,
511: LAST_UPDATE_DATE,
512: LAST_UPDATED_BY)
513: VALUES
514: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
515: 'IEX_DUNNINGS',
516: MERGE_HEADER_ID_LIST(I),
517: PRIMARY_KEY_ID_LIST(I),
518: NUM_COL1_ORIG_LIST(I),

Line 606: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

602:
603: END LOOP;
604: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
605: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
606: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
607: MERGE_LOG_ID,
608: TABLE_NAME,
609: MERGE_HEADER_ID,
610: PRIMARY_KEY_ID,

Line 623: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

619: LAST_UPDATE_LOGIN,
620: LAST_UPDATE_DATE,
621: LAST_UPDATED_BY)
622: VALUES
623: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
624: 'IEX_DUNNINGS',
625: MERGE_HEADER_ID_LIST(I),
626: PRIMARY_KEY_ID_LIST(I),
627: NUM_COL2_ORIG_LIST(I),

Line 827: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

823: END LOOP;
824:
825: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
826: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
827: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
828: MERGE_LOG_ID,
829: TABLE_NAME,
830: MERGE_HEADER_ID,
831: PRIMARY_KEY_ID,

Line 842: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

838: LAST_UPDATE_LOGIN,
839: LAST_UPDATE_DATE,
840: LAST_UPDATED_BY)
841: VALUES
842: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
843: 'IEX_STRATEGIES',
844: MERGE_HEADER_ID_LIST(I),
845: PRIMARY_KEY_ID_LIST(I),
846: NUM_COL1_ORIG_LIST(I),

Line 922: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

918: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
919: END LOOP;
920: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
921: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
922: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
923: MERGE_LOG_ID,
924: TABLE_NAME,
925: MERGE_HEADER_ID,
926: PRIMARY_KEY_ID,

Line 939: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

935: LAST_UPDATE_LOGIN,
936: LAST_UPDATE_DATE,
937: LAST_UPDATED_BY)
938: VALUES
939: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
940: 'IEX_STRATEGIES',
941: MERGE_HEADER_ID_LIST(I),
942: PRIMARY_KEY_ID_LIST(I),
943: NUM_COL2_ORIG_LIST(I),

Line 1033: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1029: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1030: END LOOP;
1031: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1032: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1033: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1034: MERGE_LOG_ID,
1035: TABLE_NAME,
1036: MERGE_HEADER_ID,
1037: PRIMARY_KEY_ID,

Line 1050: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1046: LAST_UPDATE_LOGIN,
1047: LAST_UPDATE_DATE,
1048: LAST_UPDATED_BY)
1049: VALUES (
1050: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1051: 'IEX_STRATEGIES',
1052: MERGE_HEADER_ID_LIST(I),
1053: PRIMARY_KEY_ID_LIST(I),
1054: NUM_COL3_ORIG_LIST(I),

Line 1190: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1186: END LOOP;
1187:
1188: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1189: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1190: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1191: MERGE_LOG_ID,
1192: TABLE_NAME,
1193: MERGE_HEADER_ID,
1194: PRIMARY_KEY_ID,

Line 1205: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

1201: LAST_UPDATE_LOGIN,
1202: LAST_UPDATE_DATE,
1203: LAST_UPDATED_BY)
1204: VALUES
1205: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1206: 'IEX_PROMISE_DETAILS',
1207: MERGE_HEADER_ID_LIST(I),
1208: PRIMARY_KEY_ID_LIST(I),
1209: NUM_COL1_ORIG_LIST(I),

Line 1386: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');

1382: END LOOP;
1383:
1384: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1386: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1387: END IF;
1388: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1389: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1390: MERGE_LOG_ID,

Line 1389: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1386: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1387: END IF;
1388: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1389: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1390: MERGE_LOG_ID,
1391: TABLE_NAME,
1392: MERGE_HEADER_ID,
1393: PRIMARY_KEY_ID,

Line 1404: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

1400: LAST_UPDATE_LOGIN,
1401: LAST_UPDATE_DATE,
1402: LAST_UPDATED_BY)
1403: VALUES
1404: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1405: 'IEX_DELINQUENCIES_ALL',
1406: MERGE_HEADER_ID_LIST(I),
1407: PRIMARY_KEY_ID_LIST(I),
1408: NUM_COL1_ORIG_LIST(I),

Line 1498: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');

1494:
1495: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1496:
1497: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1498: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1499: END IF;
1500:
1501: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1502: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1502: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1498: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1499: END IF;
1500:
1501: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1502: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1503: MERGE_LOG_ID,
1504: TABLE_NAME,
1505: MERGE_HEADER_ID,
1506: PRIMARY_KEY_ID,

Line 1517: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

1513: LAST_UPDATE_LOGIN,
1514: LAST_UPDATE_DATE,
1515: LAST_UPDATED_BY)
1516: VALUES
1517: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1518: 'IEX_DELINQUENCIES_ALL',
1519: MERGE_HEADER_ID_LIST(I),
1520: PRIMARY_KEY_ID_LIST(I),
1521: NUM_COL2_ORIG_LIST(I),