153: NULL;
154: ELSE
155: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
156: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
157: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
158: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
159: --cursor to get
160: open merged_records;
161: LOOP
273: NULL;
274: ELSE
275: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
276: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
277: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
278: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
279: --cursor to get
280: open merged_records;
281: LOOP
292: exit;
293: END IF;
294: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
295: --get
296: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
297: --fix for 2935845
298: if customer_type = 'CUSTOMER_ORG' then
299: --B2B, partyID stays the same
300: NUM_COL2_NEW_LIST(I) := NUM_COL2_ORIG_LIST(I);
433: NULL;
434: ELSE
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_ACTIVE_QUOTES',FALSE);
437: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
438: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
439:
440: open C_ACTIVE_QUOTE_FROM;
441: loop
584: NULL;
585: ELSE
586: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
587: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
588: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
589: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
590:
591: --retrieve
592: Open C_SHARED_QUOTE_FROM;