APPS.WSH_CUST_MERGE dependencies on HZ_ACCT_MERGE_UTIL

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

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

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

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

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

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

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

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

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

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

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

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

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

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