[Home] [Help]
695: NULL;
696: ELSE
697: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
698: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FND_ATTACHED_DOCUMENTS',FALSE);
699: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
700: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
701:
702: open merged_records;
703:
712: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
713: exit;
714: END IF;
715: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
716: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
717: END LOOP;
718: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
719: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
720: INSERT INTO HZ_CUSTOMER_MERGE_LOG (