APPS.ARP_CMERGE_ARTRX dependencies on HZ_CUSTOMER_MERGE_LOG

Line 80: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

76: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
77: END LOOP;
78: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
79: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
80: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
81: MERGE_LOG_ID,
82: TABLE_NAME,
83: MERGE_HEADER_ID,
84: PRIMARY_KEY_ID,

Line 96: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

92: CREATION_DATE,
93: LAST_UPDATE_LOGIN,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY
96: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
97: 'AR_CASH_RECEIPTS',
98: MERGE_HEADER_ID_LIST(I),
99: PRIMARY_KEY_ID_LIST(I),
100: NUM_COL1_ORIG_LIST(I),

Line 211: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

207: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
208: END LOOP;
209: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
210: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
211: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
212: MERGE_LOG_ID,
213: TABLE_NAME,
214: MERGE_HEADER_ID,
215: PRIMARY_KEY_ID,

Line 227: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

223: CREATION_DATE,
224: LAST_UPDATE_LOGIN,
225: LAST_UPDATE_DATE,
226: LAST_UPDATED_BY
227: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
228: 'AR_PAYMENT_SCHEDULES',
229: MERGE_HEADER_ID_LIST(I),
230: PRIMARY_KEY_ID_LIST(I),
231: NUM_COL1_ORIG_LIST(I),

Line 402: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

398: NUM_COL8_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL8_ORIG_LIST(I));
399: END LOOP;
400: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
401: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
402: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
403: MERGE_LOG_ID,
404: TABLE_NAME,
405: MERGE_HEADER_ID,
406: PRIMARY_KEY_ID,

Line 430: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

426: CREATION_DATE,
427: LAST_UPDATE_LOGIN,
428: LAST_UPDATE_DATE,
429: LAST_UPDATED_BY
430: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
431: 'RA_CUSTOMER_TRX',
432: MERGE_HEADER_ID_LIST(I),
433: PRIMARY_KEY_ID_LIST(I),
434: NUM_COL1_ORIG_LIST(I),

Line 704: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

700:
701: /*Additional change for ra_interface_lines under bug2447449*/
702: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
703: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
704: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
705: MERGE_LOG_ID,
706: TABLE_NAME,
707: MERGE_HEADER_ID,
708: PRIMARY_KEY1,

Line 736: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

732: CREATION_DATE,
733: LAST_UPDATE_LOGIN,
734: LAST_UPDATE_DATE,
735: LAST_UPDATED_BY
736: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
737: 'RA_INTERFACE_LINES',
738: MERGE_HEADER_ID_LIST(I),
739: PRIMARY_KEY1_LIST(I),
740: NUM_COL1_ORIG_LIST(I),

Line 871: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

867: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
868: END LOOP;
869: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
870: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
871: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
872: MERGE_LOG_ID,
873: TABLE_NAME,
874: MERGE_HEADER_ID,
875: PRIMARY_KEY_ID,

Line 887: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

883: CREATION_DATE,
884: LAST_UPDATE_LOGIN,
885: LAST_UPDATE_DATE,
886: LAST_UPDATED_BY
887: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
888: 'AR_DISTRIBUTIONS',
889: MERGE_HEADER_ID_LIST(I),
890: PRIMARY_KEY_ID_LIST(I),
891: NUM_COL1_ORIG_LIST(I),