DBA Data[Home] [Help]

APPS.FUN_CUSTOMERMERGE_PKG dependencies on HZ_ACCT_MERGE_UTIL

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

58: NULL;
59: ELSE
60: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
61: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FUN_NET_CUSTOMERS_ALL',FALSE);
62: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
63:
64: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
65:
66: OPEN merged_records;

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

78: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
79: exit;
80: END IF;
81: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
82: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
83: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
84: NUM_COL3_NEW_LIST(I) := NUM_COL3_ORIG_LIST(I);
85: END LOOP;
86: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

79: exit;
80: END IF;
81: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
82: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
83: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
84: NUM_COL3_NEW_LIST(I) := NUM_COL3_ORIG_LIST(I);
85: END LOOP;
86: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
87: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT