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.CSC_ACCOUNT_MERGE_PKG dependencies on HZ_CUSTOMER_MERGE_LOG

Line 116: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

112: -- NUM_COL1_NEW_LIST(I) := NUM_COL1_ORIG_LIST(I);
113: -- END LOOP;
114: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
115: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
116: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
117: MERGE_LOG_ID,
118: TABLE_NAME,
119: MERGE_HEADER_ID,
120: NUM_COL1_ORIG,

Line 131: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

127: CREATION_DATE,
128: LAST_UPDATE_LOGIN,
129: LAST_UPDATE_DATE,
130: LAST_UPDATED_BY
131: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
132: 'CSC_CUSTOMERS',
133: MERGE_HEADER_ID_LIST(I),
134: NUM_COL1_ORIG_LIST(I),
135: NUM_COL1_NEW_LIST(I),

Line 233: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

229: -- NUM_COL1_NEW_LIST(I) := NUM_COL1_ORIG_LIST(I);
230: -- END LOOP;
231: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
232: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
233: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
234: MERGE_LOG_ID,
235: TABLE_NAME,
236: MERGE_HEADER_ID,
237: NUM_COL1_ORIG,

Line 246: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

242: CREATION_DATE,
243: LAST_UPDATE_LOGIN,
244: LAST_UPDATE_DATE,
245: LAST_UPDATED_BY
246: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
247: 'CSC_CUSTOMERS_AUDIT_HIST',
248: MERGE_HEADER_ID_LIST(I),
249: NUM_COL1_ORIG_LIST(I),
250: NUM_COL1_NEW_LIST(I),

Line 353: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

349: -- NUM_COL1_NEW_LIST(I) := NUM_COL1_ORIG_LIST(I);
350: -- END LOOP;
351: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
352: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
353: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
354: MERGE_LOG_ID,
355: TABLE_NAME,
356: MERGE_HEADER_ID,
357: NUM_COL1_ORIG,

Line 368: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

364: CREATION_DATE,
365: LAST_UPDATE_LOGIN,
366: LAST_UPDATE_DATE,
367: LAST_UPDATED_BY
368: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
369: 'CSC_CUSTOMIZED_PLANS',
370: MERGE_HEADER_ID_LIST(I),
371: NUM_COL1_ORIG_LIST(I),
372: NUM_COL1_NEW_LIST(I),

Line 485: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

481: -- NUM_COL1_NEW_LIST(I) := NUM_COL1_ORIG_LIST(I);
482: -- END LOOP;
483: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
484: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
485: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
486: MERGE_LOG_ID,
487: TABLE_NAME,
488: MERGE_HEADER_ID,
489: PRIMARY_KEY_ID,

Line 501: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

497: CREATION_DATE,
498: LAST_UPDATE_LOGIN,
499: LAST_UPDATE_DATE,
500: LAST_UPDATED_BY
501: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
502: 'CSC_CUST_PLANS',
503: MERGE_HEADER_ID_LIST(I),
504: PRIMARY_KEY_ID_LIST(I),
505: NUM_COL1_ORIG_LIST(I),

Line 641: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

637: -- NUM_COL1_NEW_LIST(I) := NUM_COL1_ORIG_LIST(I);
638: -- END LOOP;
639: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
640: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
641: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
642: MERGE_LOG_ID,
643: TABLE_NAME,
644: MERGE_HEADER_ID,
645: PRIMARY_KEY_ID,

Line 657: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

653: CREATION_DATE,
654: LAST_UPDATE_LOGIN,
655: LAST_UPDATE_DATE,
656: LAST_UPDATED_BY
657: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
658: 'CSC_CUST_PLANS_AUDIT',
659: MERGE_HEADER_ID_LIST(I),
660: PRIMARY_KEY_ID_LIST(I),
661: NUM_COL1_ORIG_LIST(I),