APPS.GMS_CMERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 130: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

126: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL6_ORIG_LIST(I));
127: END LOOP;
128: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
129: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
130: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
131: MERGE_LOG_ID,
132: TABLE_NAME,
133: MERGE_HEADER_ID,
134: PRIMARY_KEY_ID,

Line 154: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

150: CREATION_DATE,
151: LAST_UPDATE_LOGIN,
152: LAST_UPDATE_DATE,
153: LAST_UPDATED_BY
154: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
155: 'GMS_AWARDS',
156: MERGE_HEADER_ID_LIST(I),
157: PRIMARY_KEY_ID_LIST(I),
158: NUM_COL1_ORIG_LIST(I),

Line 297: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

293: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
294: END LOOP;
295: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
296: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
297: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
298: MERGE_LOG_ID,
299: TABLE_NAME,
300: MERGE_HEADER_ID,
301: PRIMARY_KEY1,

Line 314: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

310: CREATION_DATE,
311: LAST_UPDATE_LOGIN,
312: LAST_UPDATE_DATE,
313: LAST_UPDATED_BY
314: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
315: 'GMS_AWARDS_CONTACTS',
316: MERGE_HEADER_ID_LIST(I),
317: PRIMARY_KEY1_LIST(I),
318: PRIMARY_KEY2_LIST(I),

Line 430: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 444: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

440: CREATION_DATE,
441: LAST_UPDATE_LOGIN,
442: LAST_UPDATE_DATE,
443: LAST_UPDATED_BY
444: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
445: 'GMS_REPORTS',
446: MERGE_HEADER_ID_LIST(I),
447: PRIMARY_KEY_ID_LIST(I),
448: NUM_COL1_ORIG_LIST(I),

Line 554: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

550: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
551: END LOOP;
552: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
553: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
554: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
555: MERGE_LOG_ID,
556: TABLE_NAME,
557: MERGE_HEADER_ID,
558: PRIMARY_KEY_ID,

Line 568: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

564: CREATION_DATE,
565: LAST_UPDATE_LOGIN,
566: LAST_UPDATE_DATE,
567: LAST_UPDATED_BY
568: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
569: 'GMS_DEFAULT_REPORTS',
570: MERGE_HEADER_ID_LIST(I),
571: PRIMARY_KEY_ID_LIST(I),
572: NUM_COL1_ORIG_LIST(I),