DBA Data[Home] [Help]

APPS.IBY_MERGE dependencies on HZ_ACCT_MERGE_UTIL

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

88: NULL;
89: ELSE
90: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
91: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBY_TRXN_SUMMARIES_ALL',FALSE);
92: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
93: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
94:
95: open merged_records;
96: LOOP

Line 111: num_col1_new_list(i) := hz_acct_merge_util.getdup_account(num_col1_orig_list(i));

107: IF merge_header_id_list.COUNT = 0 and l_last_fetch then
108: exit;
109: END IF;
110: FOR i in 1..merge_header_id_list.COUNT LOOP
111: num_col1_new_list(i) := hz_acct_merge_util.getdup_account(num_col1_orig_list(i));
112: num_col2_new_list(i) := hz_acct_merge_util.getdup_site(num_col2_orig_list(i));
113: num_col3_new_list(i) := hz_acct_merge_util.getdup_site_use(num_col3_orig_list(i));
114: /*
115: For a given Account and Site Combination, there can be a single Payer.

Line 112: num_col2_new_list(i) := hz_acct_merge_util.getdup_site(num_col2_orig_list(i));

108: exit;
109: END IF;
110: FOR i in 1..merge_header_id_list.COUNT LOOP
111: num_col1_new_list(i) := hz_acct_merge_util.getdup_account(num_col1_orig_list(i));
112: num_col2_new_list(i) := hz_acct_merge_util.getdup_site(num_col2_orig_list(i));
113: num_col3_new_list(i) := hz_acct_merge_util.getdup_site_use(num_col3_orig_list(i));
114: /*
115: For a given Account and Site Combination, there can be a single Payer.
116: Get the Payer Id for both the duplicate and Target Account

Line 113: num_col3_new_list(i) := hz_acct_merge_util.getdup_site_use(num_col3_orig_list(i));

109: END IF;
110: FOR i in 1..merge_header_id_list.COUNT LOOP
111: num_col1_new_list(i) := hz_acct_merge_util.getdup_account(num_col1_orig_list(i));
112: num_col2_new_list(i) := hz_acct_merge_util.getdup_site(num_col2_orig_list(i));
113: num_col3_new_list(i) := hz_acct_merge_util.getdup_site_use(num_col3_orig_list(i));
114: /*
115: For a given Account and Site Combination, there can be a single Payer.
116: Get the Payer Id for both the duplicate and Target Account
117: */

Line 833: hz_acct_merge_util.load_set(set_num, req_id);

829: NULL;
830: ELSE
831: arp_message.set_name('AR','AR_UPDATING_TABLE');
832: arp_message.set_token('TABLE_NAME','IBY_EXTERNAL_PAYERS_ALL',FALSE);
833: hz_acct_merge_util.load_set(set_num, req_id);
834: l_profile_val := fnd_profile.value('HZ_AUDIT_ACCT_MERGE');
835:
836: open merged_records;
837: LOOP

Line 851: num_col1_new_list(i) := hz_acct_merge_util.getdup_account(num_col1_orig_list(i));

847: IF merge_header_id_list.COUNT = 0 and l_last_fetch then
848: exit;
849: END IF;
850: FOR I in 1..merge_header_id_list.COUNT LOOP
851: num_col1_new_list(i) := hz_acct_merge_util.getdup_account(num_col1_orig_list(i));
852: num_col2_new_list(i) := hz_acct_merge_util.getdup_site_use(num_col2_orig_list(i));
853: /*
854: For a given Account and Site Combination, there can be a single Payer.
855: Get the Payer Id for both the duplicate and Target Account

Line 852: num_col2_new_list(i) := hz_acct_merge_util.getdup_site_use(num_col2_orig_list(i));

848: exit;
849: END IF;
850: FOR I in 1..merge_header_id_list.COUNT LOOP
851: num_col1_new_list(i) := hz_acct_merge_util.getdup_account(num_col1_orig_list(i));
852: num_col2_new_list(i) := hz_acct_merge_util.getdup_site_use(num_col2_orig_list(i));
853: /*
854: For a given Account and Site Combination, there can be a single Payer.
855: Get the Payer Id for both the duplicate and Target Account
856: */