APPS.ARP_PROCESS_MISC_RECEIPTS2 dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 231: | ar_misc_cash_distributions. Called |

227: | MODIFICATION HISTORY |
228: | |
229: | 25-OCT-95 OSTEINME created |
230: | 18-Sep-01 Debbie Jancis Modified for MRC trigger removal for |
231: | ar_misc_cash_distributions. Called |
232: | ar mrc engine for processing. |
233: | 21-Jan-02 Rahna Kader Modified delete_misc_receipt procedure |
234: | for deleting records in |
235: | ar_misc_cash_distributions table in cash |

Line 235: | ar_misc_cash_distributions table in cash |

231: | ar_misc_cash_distributions. Called |
232: | ar mrc engine for processing. |
233: | 21-Jan-02 Rahna Kader Modified delete_misc_receipt procedure |
234: | for deleting records in |
235: | ar_misc_cash_distributions table in cash |
236: | basis accounting.Refer Bug2189383 for details|
237: +===========================================================================*/
238:
239: PROCEDURE delete_misc_receipt(

Line 280: FROM ar_misc_cash_distributions mcd

276:
277: IF l_accounting_method ='CASH' THEN
278: SELECT count(mcd.misc_cash_distribution_id)
279: INTO l_count
280: FROM ar_misc_cash_distributions mcd
281: WHERE mcd.cash_receipt_id = p_cash_receipt_id
282: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
283: AND mcd.posting_control_id = -3 ; --Not posted
284: ELSE

Line 287: FROM ar_misc_cash_distributions mcd

283: AND mcd.posting_control_id = -3 ; --Not posted
284: ELSE
285: SELECT count(mcd.misc_cash_distribution_id)
286: INTO l_count
287: FROM ar_misc_cash_distributions mcd
288: WHERE mcd.cash_receipt_id = p_cash_receipt_id
289: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
290: AND mcd.posting_control_id = -3 --Not posted
291: AND EXISTS (SELECT 'x'

Line 301: FROM ar_misc_cash_distributions mcd

297:
298: --begin bug5655154
299: SELECT count(mcd.misc_cash_distribution_id)
300: INTO l_dist_cnt
301: FROM ar_misc_cash_distributions mcd
302: WHERE mcd.cash_receipt_id = p_cash_receipt_id
303: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
304: AND mcd.posting_control_id = -3 --Not posted
305: AND EXISTS (SELECT 'x'

Line 313: FROM ar_misc_cash_distributions mcd

309:
310: IF l_dist_cnt = 0 and l_accounting_method = 'CASH' THEN
311: SELECT count(mcd.misc_cash_distribution_id)
312: INTO l_count
313: FROM ar_misc_cash_distributions mcd
314: WHERE mcd.cash_receipt_id = p_cash_receipt_id
315: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
316: AND mcd.posting_control_id = -3 ; --Not posted
317: ELSE

Line 382: -- delete all AR_MISC_CASH distributions records created for

378: p_table_name => 'AR_DISTRIBUTIONS',
379: p_mode => 'BATCH',
380: p_key_value_list => l_ar_dist_key_value_list);
381:
382: -- delete all AR_MISC_CASH distributions records created for
383: -- this receipt:
384: IF PG_DEBUG in ('Y', 'C') THEN
385: arp_standard.debug('delete_misc_receipt: ' || ' Delete MISC_CASH_DISTRIBUTION');
386: END IF;

Line 394: DELETE AR_MISC_CASH_DISTRIBUTIONS

390: | misc cash distribution id for |
391: | for use in the MRC engine |
392: +--------------------------------*/
393:
394: DELETE AR_MISC_CASH_DISTRIBUTIONS
395: WHERE cash_receipt_id = p_cash_receipt_id
396: RETURNING misc_cash_distribution_id
397: BULK COLLECT INTO l_misc_cash_key_value_list;
398:

Line 406: p_table_name => 'AR_MISC_CASH_DISTRIBUTIONS',

402: +---------------------------------*/
403:
404: ar_mrc_engine.maintain_mrc_data(
405: p_event_mode => 'DELETE',
406: p_table_name => 'AR_MISC_CASH_DISTRIBUTIONS',
407: p_mode => 'BATCH',
408: p_key_value_list => l_misc_cash_key_value_list);
409:
410: