72: ELSE
73: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
74: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_account_allocations',FALSE);
75: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
76: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
77:
78: open merged_records;
79: LOOP
80: FETCH merged_records BULK COLLECT INTO
219: ELSE
220: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
221: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines',FALSE);
222: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
223: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
224:
225: open merged_records;
226: LOOP
227: FETCH merged_records BULK COLLECT INTO
363: ELSE
364: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
365: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines_hist',FALSE);
366: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
367: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
368:
369: open merged_records;
370: LOOP
371: FETCH merged_records BULK COLLECT INTO
539: ELSE
540: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
541: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims',FALSE);
542: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
543: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
544:
545: open merged_records;
546: LOOP
547: FETCH merged_records BULK COLLECT INTO
743: ELSE
744: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
745: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims_history',FALSE);
746: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
747: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
748:
749: open merged_records;
750: LOOP
751: FETCH merged_records BULK COLLECT INTO
907: ELSE
908: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
909: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_code_conversions',FALSE);
910: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
911: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
912:
913: open merged_records;
914: LOOP
915: FETCH merged_records BULK COLLECT INTO
1047: ELSE
1048: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1049: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_daily_facts',FALSE);
1050: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1051: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1052:
1053: open merged_records;
1054: LOOP
1055: FETCH merged_records BULK COLLECT INTO
1194: ELSE
1195: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1196: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_funds_utilized_all_b',FALSE);
1197: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1198: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1199:
1200: open merged_records;
1201: LOOP
1202: FETCH merged_records BULK COLLECT INTO
1344: ELSE
1345: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1346: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_activity_customers',FALSE);
1347: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1348: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1349:
1350: open merged_records;
1351: LOOP
1352: FETCH merged_records BULK COLLECT INTO
1481: ELSE
1482: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1483: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_offers',FALSE);
1484: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1485: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1486:
1487: open merged_records;
1488: LOOP
1489: FETCH merged_records BULK COLLECT INTO
1623: ELSE
1624: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1625: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_request_headers_all_b',FALSE);
1626: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1627: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1628:
1629: open merged_records;
1630: LOOP
1631: FETCH merged_records BULK COLLECT INTO
1774: ELSE
1775: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1776: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_retail_price_points',FALSE);
1777: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1778: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1779:
1780: open merged_records;
1781: LOOP
1782: FETCH merged_records BULK COLLECT INTO
1915: ELSE
1916: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1917: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_trd_prfls',FALSE);
1918: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1919: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1920:
1921: open merged_records;
1922: LOOP
1923: FETCH merged_records BULK COLLECT INTO