DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARATC 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_INTERIM_CASH_RECEIPTS',
98: MERGE_HEADER_ID_LIST(I),
99: PRIMARY_KEY_ID_LIST(I),
100: NUM_COL1_ORIG_LIST(I),

Line 209: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

205: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
206: END LOOP;
207: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
208: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
209: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
210: MERGE_LOG_ID,
211: TABLE_NAME,
212: MERGE_HEADER_ID,
213: PRIMARY_KEY1,

Line 224: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

220: CREATION_DATE,
221: LAST_UPDATE_LOGIN,
222: LAST_UPDATE_DATE,
223: LAST_UPDATED_BY
224: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
225: 'AR_INTERIM_CASH_RECEIPT_LINES',
226: MERGE_HEADER_ID_LIST(I),
227: PRIMARY_KEY1_LIST(I),
228: PRIMARY_KEY2_LIST(I),