APPS.WSH_CUST_MERGE dependencies on HZ_ACCT_MERGE_UTIL

Line 3360: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

3356: NULL;
3357: ELSE
3358: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3359: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_BATCHES',FALSE);
3360: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3361: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3362:
3363: open merged_records;
3364: LOOP

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

3373: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
3374: exit;
3375: END IF;
3376: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
3377: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3378: END LOOP;
3379: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3380: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3381: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 3504: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

3500: NULL;
3501: ELSE
3502: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_CALENDAR_ASSIGNMENTS',FALSE);
3504: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3505: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3506:
3507: open merged_records;
3508: LOOP

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

3518: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
3519: exit;
3520: END IF;
3521: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
3522: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3523: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
3524: END LOOP;
3525: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3526: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

3519: exit;
3520: END IF;
3521: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
3522: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3523: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
3524: END LOOP;
3525: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3526: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3527: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 3653: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

3649: NULL;
3650: ELSE
3651: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3652: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_RULES',FALSE);
3653: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3654: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3655:
3656: open merged_records;
3657: LOOP

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

3666: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
3667: exit;
3668: END IF;
3669: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
3670: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3671: END LOOP;
3672: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3673: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3674: INSERT INTO HZ_CUSTOMER_MERGE_LOG (