[Home] [Help]
77: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
78: END LOOP;
79: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
80: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
81: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
82: MERGE_LOG_ID,
83: TABLE_NAME,
84: MERGE_HEADER_ID,
85: PRIMARY_KEY_ID,
93: CREATION_DATE,
94: LAST_UPDATE_LOGIN,
95: LAST_UPDATE_DATE,
96: LAST_UPDATED_BY
97: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
98: 'AR_CUSTOMER_CALL_TOPICS',
99: MERGE_HEADER_ID_LIST(I),
100: PRIMARY_KEY_ID_LIST(I),
101: NUM_COL1_ORIG_LIST(I),
208: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
209: END LOOP;
210: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
211: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
212: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
213: MERGE_LOG_ID,
214: TABLE_NAME,
215: MERGE_HEADER_ID,
216: PRIMARY_KEY_ID,
224: CREATION_DATE,
225: LAST_UPDATE_LOGIN,
226: LAST_UPDATE_DATE,
227: LAST_UPDATED_BY
228: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
229: 'AR_CUSTOMER_CALLS',
230: MERGE_HEADER_ID_LIST(I),
231: PRIMARY_KEY_ID_LIST(I),
232: NUM_COL1_ORIG_LIST(I),
341: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
342: END LOOP;
343: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
344: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
345: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
346: MERGE_LOG_ID,
347: TABLE_NAME,
348: MERGE_HEADER_ID,
349: PRIMARY_KEY_ID,
357: CREATION_DATE,
358: LAST_UPDATE_LOGIN,
359: LAST_UPDATE_DATE,
360: LAST_UPDATED_BY
361: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
362: 'AR_STATEMENTS_HISTORY',
363: MERGE_HEADER_ID_LIST(I),
364: PRIMARY_KEY_ID_LIST(I),
365: NUM_COL1_ORIG_LIST(I),