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
162: FETCH merged_records BULK COLLECT INTO
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
282: FETCH merged_records BULK COLLECT INTO
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
442: --get active quote for
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;
593: Loop