APPS.AR_MCC_MERGE dependencies on HZ_CREDIT_USAGES

Line 109: -- HZ_CREDIT_USAGES for the corresponding customer Ids in

105: -- set_number IN NUMBER Set Number
106: -- process_mode IN VARCHAR2 Process mode of the called
107: -- program
108: -- COMMENT : This procedure deletes the records from the table
109: -- HZ_CREDIT_USAGES for the corresponding customer Ids in
110: -- RA_CUSTOMER_MERGES
111: --=========================================================================
112: PROCEDURE Customer_Merge
113: ( req_id IN NUMBER

Line 145: -- cursor to lock the rows in hz_credit_usages

141: RA_CUSTOMER_MERGES
142: WHERE duplicate_id = c_duplicate_id;
143:
144:
145: -- cursor to lock the rows in hz_credit_usages
146: CURSOR check_credit_usage_cur IS
147: SELECT credit_usage_id
148: FROM
149: HZ_CREDIT_USAGES

Line 149: HZ_CREDIT_USAGES

145: -- cursor to lock the rows in hz_credit_usages
146: CURSOR check_credit_usage_cur IS
147: SELECT credit_usage_id
148: FROM
149: HZ_CREDIT_USAGES
150: WHERE cust_acct_profile_amt_id IN
151: (SELECT cust_acct_profile_amt_id
152: FROM HZ_CUST_PROFILE_AMTS
153: WHERE cust_account_id IN

Line 165: hz_credit_usages.credit_usage_id%TYPE;

161: -- ====================================
162: -- Variables for BULK COLLECT operation
163: -- ====================================
164: TYPE credit_usage_tab IS TABLE OF
165: hz_credit_usages.credit_usage_id%TYPE;
166:
167: TYPE credit_profile_amt_tab IS TABLE OF
168: hz_credit_usages.credit_profile_amt_id%TYPE;
169:

Line 168: hz_credit_usages.credit_profile_amt_id%TYPE;

164: TYPE credit_usage_tab IS TABLE OF
165: hz_credit_usages.credit_usage_id%TYPE;
166:
167: TYPE credit_profile_amt_tab IS TABLE OF
168: hz_credit_usages.credit_profile_amt_id%TYPE;
169:
170: TYPE cust_acct_profile_amt_tab IS TABLE OF
171: hz_credit_usages.cust_acct_profile_amt_id%TYPE;
172:

Line 171: hz_credit_usages.cust_acct_profile_amt_id%TYPE;

167: TYPE credit_profile_amt_tab IS TABLE OF
168: hz_credit_usages.credit_profile_amt_id%TYPE;
169:
170: TYPE cust_acct_profile_amt_tab IS TABLE OF
171: hz_credit_usages.cust_acct_profile_amt_id%TYPE;
172:
173: TYPE profile_class_amount_tab IS TABLE OF
174: hz_credit_usages.profile_class_amount_id%TYPE;
175:

Line 174: hz_credit_usages.profile_class_amount_id%TYPE;

170: TYPE cust_acct_profile_amt_tab IS TABLE OF
171: hz_credit_usages.cust_acct_profile_amt_id%TYPE;
172:
173: TYPE profile_class_amount_tab IS TABLE OF
174: hz_credit_usages.profile_class_amount_id%TYPE;
175:
176: TYPE credit_usage_rule_set_tab IS TABLE OF
177: hz_credit_usages.credit_usage_rule_set_id%TYPE;
178:

Line 177: hz_credit_usages.credit_usage_rule_set_id%TYPE;

173: TYPE profile_class_amount_tab IS TABLE OF
174: hz_credit_usages.profile_class_amount_id%TYPE;
175:
176: TYPE credit_usage_rule_set_tab IS TABLE OF
177: hz_credit_usages.credit_usage_rule_set_id%TYPE;
178:
179:
180: l_credit_usage_ids credit_usage_tab;
181: l_credit_profile_amt_ids credit_profile_amt_tab;

Line 226: arp_message.set_token('TABLE_NAME', 'HZ_CREDIT_USAGES', FALSE);

222: );
223:
224: IF process_mode = 'LOCK' THEN
225: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
226: arp_message.set_token('TABLE_NAME', 'HZ_CREDIT_USAGES', FALSE);
227:
228: open check_credit_usage_cur;
229: close check_credit_usage_cur;
230:

Line 233: ,'Rows locked from HZ_CREDIT_USAGES'

229: close check_credit_usage_cur;
230:
231: AR_MCC_MERGE.Log
232: (AR_MCC_MERGE.G_LOG_EVENT
233: ,'Rows locked from HZ_CREDIT_USAGES'
234: );
235: ELSE
236: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()+');
237:

Line 275: FROM HZ_CREDIT_USAGES

271: , l_credit_profile_amt_ids
272: , l_cust_acct_profile_amt_ids
273: , l_profile_class_amount_ids
274: , l_credit_usage_rule_set_ids
275: FROM HZ_CREDIT_USAGES
276: WHERE cust_acct_profile_amt_id IN
277: (SELECT cust_acct_profile_amt_id
278: FROM HZ_CUST_PROFILE_AMTS
279: WHERE cust_account_id = l_duplicate_id );

Line 321: , 'HZ_CREDIT_USAGES'

317: , last_updated_by
318: )
319: VALUES
320: ( HZ_CUSTOMER_MERGE_LOG_S.nextval
321: , 'HZ_CREDIT_USAGES'
322: , l_customer_merge_header_id
323: , l_credit_usage_ids(l_usage_idx)
324: , l_credit_profile_amt_ids(l_usage_idx)
325: , l_cust_acct_profile_amt_ids(l_usage_idx)

Line 351: FROM HZ_CREDIT_USAGES

347: IF l_delete_flag = 'Y' THEN
348: -- Delete the records in full
349: FORALL l_usage_idx IN l_min_usage_idx .. l_max_usage_idx
350: DELETE
351: FROM HZ_CREDIT_USAGES
352: WHERE credit_usage_id = l_credit_usage_ids(l_usage_idx);
353:
354: -- number of rows deleted
355: -- summation of all %bulk_rowcount