APPS.OKS_HZ_MERGE_PUB dependencies on HZ_ACCT_MERGE_UTIL

Line 149: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);

145: BEGIN
146: --CK new code with logging
147: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
149: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
150: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
151:
152: open merged_records;
153: LOOP

Line 167: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

163: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
164: exit;
165: END IF;
166: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
167: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
168: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
169: END LOOP;
170: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
171: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 168: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

164: exit;
165: END IF;
166: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
167: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
168: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
169: END LOOP;
170: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
171: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
172: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 359: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);

355: BEGIN
356: --ck new code with logging
357: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
358: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
359: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
360: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
361: open merged_records;
362: LOOP
363: FETCH merged_records BULK COLLECT INTO

Line 376: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

372: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
373: exit;
374: END IF;
375: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
376: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
377: NUM_COL4_NEW_LIST(I) := NUM_COL4_ORIG_LIST(I);
378: END LOOP;
379: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
380: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 452: -- NUM_COL1_NEW_LIST_QUOTE(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST_QUOTE(I));

448: IF MERGE_HEADER_ID_LIST_QUOTE.COUNT = 0 and l_last_fetch then
449: exit;
450: END IF;
451: FOR I in 1..MERGE_HEADER_ID_LIST_QUOTE.COUNT LOOP
452: -- NUM_COL1_NEW_LIST_QUOTE(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST_QUOTE(I));
453: NUM_COL1_NEW_LIST_QUOTE(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST_QUOTE(I));
454: NUM_COL2_NEW_LIST_QUOTE(I) := NUM_COL2_ORIG_LIST_QUOTE(I);
455: END LOOP;
456: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 453: NUM_COL1_NEW_LIST_QUOTE(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST_QUOTE(I));

449: exit;
450: END IF;
451: FOR I in 1..MERGE_HEADER_ID_LIST_QUOTE.COUNT LOOP
452: -- NUM_COL1_NEW_LIST_QUOTE(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST_QUOTE(I));
453: NUM_COL1_NEW_LIST_QUOTE(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST_QUOTE(I));
454: NUM_COL2_NEW_LIST_QUOTE(I) := NUM_COL2_ORIG_LIST_QUOTE(I);
455: END LOOP;
456: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
457: FORALL I in 1..MERGE_HEADER_ID_LIST_QUOTE.COUNT