77: NULL;
78: ELSE
79: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
80: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OE_AGREEMENTS_B',FALSE);
81: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
82: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
83:
84: open merged_records;
85: LOOP
95: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
96: exit;
97: END IF;
98: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
99: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
100: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
101: END LOOP;
102: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
103: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
96: exit;
97: END IF;
98: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
99: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
100: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
101: END LOOP;
102: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
103: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
104: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
306: NULL;
307: ELSE
308: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
309: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','QP_QUALIFIERS',FALSE);
310: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
311: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
312:
313: open merged_records;
314: LOOP
330: --Modified code for bug fix 3649761
331: IF (QUALIFIER_CONTEXT_LIST(I) = 'CUSTOMER' AND
332: QUALIFIER_ATTRIBUTE_LIST(I) = 'QUALIFIER_ATTRIBUTE2') --Customer Name
333: THEN
334: VCHAR_COL1_NEW_LIST(I) := to_char(HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(to_number(VCHAR_COL1_ORIG_LIST(I))));
335: --check for duplicate smbalara 8203178 / 8399386
336: Check_Duplicate(PRIMARY_KEY_ID_LIST(I),VCHAR_COL1_NEW_LIST(I));
337:
338: VCHAR_COL2_ORIG_LIST(I) := NULL;
346: (QUALIFIER_CONTEXT_LIST(I) = 'CUSTOMER' AND
347: QUALIFIER_ATTRIBUTE_LIST(I) = 'QUALIFIER_ATTRIBUTE14') --Bill To
348: )
349: THEN
350: VCHAR_COL2_NEW_LIST(I) := to_char(HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(to_number(VCHAR_COL2_ORIG_LIST(I))));
351:
352: --check for duplicate smbalara 8203178 / 8399386
353: Check_Duplicate(PRIMARY_KEY_ID_LIST(I),VCHAR_COL2_NEW_LIST(I));
354: