APPS.MRPP_CMERGE_FCST dependencies on HZ_CUSTOMER_MERGE_LOG

Line 100: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

96: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
97: END LOOP;
98: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
99: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
100: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
101: MERGE_LOG_ID,
102: TABLE_NAME,
103: MERGE_HEADER_ID,
104: PRIMARY_KEY_ID,

Line 118: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

114: CREATION_DATE,
115: LAST_UPDATE_LOGIN,
116: LAST_UPDATE_DATE,
117: LAST_UPDATED_BY
118: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
119: 'MRP_FORECAST_DATES',
120: MERGE_HEADER_ID_LIST(I),
121: PRIMARY_KEY_ID_LIST(I),
122: NUM_COL1_ORIG_LIST(I),

Line 267: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

263: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
264: END LOOP;
265: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
266: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
267: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
268: MERGE_LOG_ID,
269: TABLE_NAME,
270: MERGE_HEADER_ID,
271: PRIMARY_KEY1,

Line 286: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

282: CREATION_DATE,
283: LAST_UPDATE_LOGIN,
284: LAST_UPDATE_DATE,
285: LAST_UPDATED_BY
286: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
287: 'MRP_FORECAST_DESIGNATORS',
288: MERGE_HEADER_ID_LIST(I),
289: PRIMARY_KEY1_LIST(I),
290: PRIMARY_KEY2_LIST(I),

Line 431: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

427: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
428: END LOOP;
429: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
430: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
431: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
432: MERGE_LOG_ID,
433: TABLE_NAME,
434: MERGE_HEADER_ID,
435: PRIMARY_KEY_ID,

Line 449: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

445: CREATION_DATE,
446: LAST_UPDATE_LOGIN,
447: LAST_UPDATE_DATE,
448: LAST_UPDATED_BY
449: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
450: 'MRP_FORECAST_UPDATES',
451: MERGE_HEADER_ID_LIST(I),
452: PRIMARY_KEY_ID_LIST(I),
453: NUM_COL1_ORIG_LIST(I),

Line 624: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

620: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
621: END LOOP;
622: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
623: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
624: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
625: MERGE_LOG_ID,
626: TABLE_NAME,
627: MERGE_HEADER_ID,
628: PRIMARY_KEY_ID,

Line 648: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

644: CREATION_DATE,
645: LAST_UPDATE_LOGIN,
646: LAST_UPDATE_DATE,
647: LAST_UPDATED_BY
648: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
649: 'MRP_SALES_ORDER_UPDATES',
650: MERGE_HEADER_ID_LIST(I),
651: PRIMARY_KEY_ID_LIST(I),
652: NUM_COL1_ORIG_LIST(I),

Line 919: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 935: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

931: CREATION_DATE,
932: LAST_UPDATE_LOGIN,
933: LAST_UPDATE_DATE,
934: LAST_UPDATED_BY
935: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
936: 'MRP_SR_ASSIGNMENTS',
937: MERGE_HEADER_ID_LIST(I),
938: PRIMARY_KEY_ID_LIST(I),
939: NUM_COL1_ORIG_LIST(I),