APPS.ARP_RECEIPTS_MAIN dependencies on AR_DISTRIBUTIONS

Line 442: | from the AR_DISTRIBUTIONS table.This routine deletes all records

438: | PROCEDURE Delete_RA
439: |
440: | DESCRIPTION
441: | Deletes accounting associated with a Receivable application id
442: | from the AR_DISTRIBUTIONS table.This routine deletes all records
443: | matching the input source_id. Note records from child table
444: | (AR_DISTRIBUTIONS) be deleted first.
445: |
446: | PARAMETERS

Line 444: | (AR_DISTRIBUTIONS) be deleted first.

440: | DESCRIPTION
441: | Deletes accounting associated with a Receivable application id
442: | from the AR_DISTRIBUTIONS table.This routine deletes all records
443: | matching the input source_id. Note records from child table
444: | (AR_DISTRIBUTIONS) be deleted first.
445: |
446: | PARAMETERS
447: | p_ae_deleted indicates whether records were deleted
448: | for source_id

Line 487: FROM ar_distributions ard

483: IF l_status = 'UNAPP' THEN
484:
485: SELECT ard.source_id_secondary
486: INTO g_ae_doc_rec.source_id_old
487: FROM ar_distributions ard
488: where ard.source_id = g_ae_doc_rec.source_id
489: and ard.source_table = 'RA';
490:
491: END IF;

Line 499: DELETE FROM AR_DISTRIBUTIONS

495: | if valid candidate for deletion |
496: +-------------------------------------------------------------------*/
497:
498: -- MRC Trigger Elimination:
499: DELETE FROM AR_DISTRIBUTIONS
500: WHERE source_id = g_ae_doc_rec.source_id
501: AND source_table = 'RA'
502: RETURNING line_id
503: BULK COLLECT INTO l_ar_dist_key_value_list;

Line 532: | Payment. Note record from child (AR_DISTRIBUTIONS) table must be

528: | PROCEDURE Delete_MCD
529: |
530: | DESCRIPTION
531: | Deletes accounting associated with a Miscellaneous Cash Receipt or
532: | Payment. Note record from child (AR_DISTRIBUTIONS) table must be
533: | deleted first.
534: |
535: | PARAMETERS
536: | p_ae_deleted indicates whether records were deleted

Line 548: FROM ar_distributions ard

544: WHERE mcd.cash_receipt_id = g_ae_doc_rec.document_id
545: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate not those reversed
546: AND mcd.posting_control_id = -3 --Not posted
547: AND EXISTS (SELECT 'x'
548: FROM ar_distributions ard
549: WHERE ard.source_id = mcd.misc_cash_distribution_id
550: AND ard.source_table = 'MCD');
551:
552: l_dummy VARCHAR2(1);

Line 566: DELETE FROM ar_distributions ard

562: l_dummy := 'N';
563:
564: FOR l_misc_rec IN del_misc_rec LOOP
565:
566: DELETE FROM ar_distributions ard
567: WHERE ard.source_id = l_misc_rec.misc_dist_id
568: AND ard.source_table = 'MCD'
569: RETURNING line_id
570: BULK COLLECT INTO l_ar_dist_key_value_list;

Line 609: | This procedure reverses the records in AR_DISTRIBUTIONS for a

605: |
606: | PROCEDURE Reverse_Receipt_CM
607: |
608: | DESCRIPTION
609: | This procedure reverses the records in AR_DISTRIBUTIONS for a
610: | Misc Cash Receipt, Cash Receipts and Credit Memo applications.
611: | There is a concept of caching used for UNAPP records, as if they
612: | are paired before Reversal they need to be paired after Reversal.
613: | In order for this caching to work, the APP, ACC and UNID records

Line 677: from ar_distributions ard,

673: ,'FINCHRG','ADDCHRG'
674: ,'ADDCTL')))) WHICH_BUCKET,
675: line_trx_type.type trx_type
676: --}
677: from ar_distributions ard,
678: ar_distributions adjsrctp,
679: --{ For CM APP on legacy from 11i
680: (SELECT tt.type type,
681: ctl.customer_trx_line_id customer_trx_line_id,

Line 678: ar_distributions adjsrctp,

674: ,'ADDCTL')))) WHICH_BUCKET,
675: line_trx_type.type trx_type
676: --}
677: from ar_distributions ard,
678: ar_distributions adjsrctp,
679: --{ For CM APP on legacy from 11i
680: (SELECT tt.type type,
681: ctl.customer_trx_line_id customer_trx_line_id,
682: ctl.line_type line_type

Line 744: from ar_distributions ard,

740: ,'FINCHRG','ADDCHRG'
741: ,'ADDCTL')))) WHICH_BUCKET,
742: line_trx_type.type trx_type
743: --}
744: from ar_distributions ard,
745: ar_receivable_applications app,
746: ar_distributions adjsrctp,
747: -- For CM APP on legacy from 11i
748: (SELECT tt.type type,

Line 746: ar_distributions adjsrctp,

742: line_trx_type.type trx_type
743: --}
744: from ar_distributions ard,
745: ar_receivable_applications app,
746: ar_distributions adjsrctp,
747: -- For CM APP on legacy from 11i
748: (SELECT tt.type type,
749: ctl.customer_trx_line_id customer_trx_line_id,
750: ctl.line_type line_type

Line 2544: from ar_distributions ard

2540: from ar_transaction_history th
2541: where th.customer_trx_id = p_app_rec.applied_customer_trx_id
2542: and th.event = 'MATURITY_DATE'
2543: and exists (select 'x'
2544: from ar_distributions ard
2545: where ard.source_id = th.transaction_history_id
2546: and ard.source_table = 'TH'))
2547: where receivable_application_id = p_app_rec.receivable_application_id;
2548:

Line 2777: from ar_distributions ard

2773: AND g_ae_sys_rec.sob_type = 'P'
2774: AND mcd.reversal_gl_date is null --so we create only new rate adjusted or new mcd records
2775: AND mcd.posting_control_id = -3
2776: AND not exists (select 'x'
2777: from ar_distributions ard
2778: where ard.source_id = mcd.misc_cash_distribution_id
2779: and ard.source_table = 'MCD')
2780: ORDER by misc_cash_distribution_id;
2781: --{BUG4301323

Line 2836: | building MISCCASH records in AR_DISTRIBUTIONS |

2832:
2833:
2834: /*-------------------------------------------------------------+
2835: | Get exchange rate and third part info from Cash Receipt for |
2836: | building MISCCASH records in AR_DISTRIBUTIONS |
2837: +-------------------------------------------------------------*/
2838: l_mcd_first_rec_id := '';
2839:
2840: l_ael_line_rec.source_table := 'MCD';