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 122: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 138: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

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

Line 207: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

203: END LOOP;
204:
205: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
206: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
207: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
208: MERGE_LOG_ID,
209: TABLE_NAME,
210: MERGE_HEADER_ID,
211: PRIMARY_KEY_ID,

Line 223: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

219: CREATION_DATE,
220: LAST_UPDATE_LOGIN,
221: LAST_UPDATE_DATE,
222: LAST_UPDATED_BY) VALUES
223: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
224: 'IEX_SCORE_HISTORIES',
225: MERGE_HEADER_ID_LIST(I),
226: PRIMARY_KEY_ID_LIST(I),
227: NUM_COL1_ORIG_LIST(I),

Line 288: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

284: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
285: END LOOP;
286: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
287: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
288: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
289: MERGE_LOG_ID,
290: TABLE_NAME,
291: MERGE_HEADER_ID,
292: PRIMARY_KEY_ID,

Line 304: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

300: CREATION_DATE,
301: LAST_UPDATE_LOGIN,
302: LAST_UPDATE_DATE,
303: LAST_UPDATED_BY) VALUES
304: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
305: 'IEX_SCORE_HISTORIES',
306: MERGE_HEADER_ID_LIST(I),
307: PRIMARY_KEY_ID_LIST(I),
308: NUM_COL3_ORIG_LIST(I),

Line 452: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

448: END LOOP;
449:
450: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
451: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
452: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
453: MERGE_LOG_ID,
454: TABLE_NAME,
455: MERGE_HEADER_ID,
456: PRIMARY_KEY_ID,

Line 469: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

465: LAST_UPDATE_LOGIN,
466: LAST_UPDATE_DATE,
467: LAST_UPDATED_BY)
468: VALUES
469: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
470: 'IEX_DUNNINGS',
471: MERGE_HEADER_ID_LIST(I),
472: PRIMARY_KEY_ID_LIST(I),
473: NUM_COL1_ORIG_LIST(I),

Line 539: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

535: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I)); -- 5874874 gnramasa 25-Apr-2007
536: END LOOP;
537: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
538: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
539: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
540: MERGE_LOG_ID,
541: TABLE_NAME,
542: MERGE_HEADER_ID,
543: PRIMARY_KEY_ID,

Line 556: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

552: LAST_UPDATE_LOGIN,
553: LAST_UPDATE_DATE,
554: LAST_UPDATED_BY)
555: VALUES
556: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
557: 'IEX_DUNNINGS',
558: MERGE_HEADER_ID_LIST(I),
559: PRIMARY_KEY_ID_LIST(I),
560: NUM_COL2_ORIG_LIST(I),

Line 746: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

742: END LOOP;
743:
744: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
745: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
746: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
747: MERGE_LOG_ID,
748: TABLE_NAME,
749: MERGE_HEADER_ID,
750: PRIMARY_KEY_ID,

Line 761: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

757: LAST_UPDATE_LOGIN,
758: LAST_UPDATE_DATE,
759: LAST_UPDATED_BY)
760: VALUES
761: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
762: 'IEX_STRATEGIES',
763: MERGE_HEADER_ID_LIST(I),
764: PRIMARY_KEY_ID_LIST(I),
765: NUM_COL1_ORIG_LIST(I),

Line 832: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

828: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
829: END LOOP;
830: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
831: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
832: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
833: MERGE_LOG_ID,
834: TABLE_NAME,
835: MERGE_HEADER_ID,
836: PRIMARY_KEY_ID,

Line 849: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

845: LAST_UPDATE_LOGIN,
846: LAST_UPDATE_DATE,
847: LAST_UPDATED_BY)
848: VALUES
849: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
850: 'IEX_STRATEGIES',
851: MERGE_HEADER_ID_LIST(I),
852: PRIMARY_KEY_ID_LIST(I),
853: NUM_COL2_ORIG_LIST(I),

Line 928: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

924: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
925: END LOOP;
926: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
927: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
928: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
929: MERGE_LOG_ID,
930: TABLE_NAME,
931: MERGE_HEADER_ID,
932: PRIMARY_KEY_ID,

Line 945: HZ_CUSTOMER_MERGE_LOG_s.nextval,

941: LAST_UPDATE_LOGIN,
942: LAST_UPDATE_DATE,
943: LAST_UPDATED_BY)
944: VALUES (
945: HZ_CUSTOMER_MERGE_LOG_s.nextval,
946: 'IEX_STRATEGIES',
947: MERGE_HEADER_ID_LIST(I),
948: PRIMARY_KEY_ID_LIST(I),
949: NUM_COL3_ORIG_LIST(I),

Line 1073: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1069: END LOOP;
1070:
1071: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1072: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1073: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1074: MERGE_LOG_ID,
1075: TABLE_NAME,
1076: MERGE_HEADER_ID,
1077: PRIMARY_KEY_ID,

Line 1088: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

1084: LAST_UPDATE_LOGIN,
1085: LAST_UPDATE_DATE,
1086: LAST_UPDATED_BY)
1087: VALUES
1088: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1089: 'IEX_PROMISE_DETAILS',
1090: MERGE_HEADER_ID_LIST(I),
1091: PRIMARY_KEY_ID_LIST(I),
1092: NUM_COL1_ORIG_LIST(I),

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

1260: END LOOP;
1261:
1262: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1264: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1265: END IF;
1266: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1267: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1268: MERGE_LOG_ID,

Line 1267: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1264: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1265: END IF;
1266: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1267: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1268: MERGE_LOG_ID,
1269: TABLE_NAME,
1270: MERGE_HEADER_ID,
1271: PRIMARY_KEY_ID,

Line 1282: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

1278: LAST_UPDATE_LOGIN,
1279: LAST_UPDATE_DATE,
1280: LAST_UPDATED_BY)
1281: VALUES
1282: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1283: 'IEX_DELINQUENCIES_ALL',
1284: MERGE_HEADER_ID_LIST(I),
1285: PRIMARY_KEY_ID_LIST(I),
1286: NUM_COL1_ORIG_LIST(I),

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

1372:
1373: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1374:
1375: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1376: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1377: END IF;
1378:
1379: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1380: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1380: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1376: IEX_DEBUG_PUB.logMessage('Inserting into HZ_CUSTOMER_MERGE_LOG...');
1377: END IF;
1378:
1379: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1380: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1381: MERGE_LOG_ID,
1382: TABLE_NAME,
1383: MERGE_HEADER_ID,
1384: PRIMARY_KEY_ID,

Line 1395: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

1391: LAST_UPDATE_LOGIN,
1392: LAST_UPDATE_DATE,
1393: LAST_UPDATED_BY)
1394: VALUES
1395: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1396: 'IEX_DELINQUENCIES_ALL',
1397: MERGE_HEADER_ID_LIST(I),
1398: PRIMARY_KEY_ID_LIST(I),
1399: NUM_COL2_ORIG_LIST(I),