APPS.ARP_RECEIPTS_MAIN dependencies on AR_DISTRIBUTIONS

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

448: | PROCEDURE Delete_RA
449: |
450: | DESCRIPTION
451: | Deletes accounting associated with a Receivable application id
452: | from the AR_DISTRIBUTIONS table.This routine deletes all records
453: | matching the input source_id. Note records from child table
454: | (AR_DISTRIBUTIONS) be deleted first.
455: |
456: | PARAMETERS

Line 454: | (AR_DISTRIBUTIONS) be deleted first.

450: | DESCRIPTION
451: | Deletes accounting associated with a Receivable application id
452: | from the AR_DISTRIBUTIONS table.This routine deletes all records
453: | matching the input source_id. Note records from child table
454: | (AR_DISTRIBUTIONS) be deleted first.
455: |
456: | PARAMETERS
457: | p_ae_deleted indicates whether records were deleted
458: | for source_id

Line 497: FROM ar_distributions ard

493: IF l_status = 'UNAPP' THEN
494:
495: SELECT ard.source_id_secondary
496: INTO g_ae_doc_rec.source_id_old
497: FROM ar_distributions ard
498: where ard.source_id = g_ae_doc_rec.source_id
499: and ard.source_table = 'RA';
500:
501: END IF;

Line 509: DELETE FROM AR_DISTRIBUTIONS

505: | if valid candidate for deletion |
506: +-------------------------------------------------------------------*/
507:
508: -- MRC Trigger Elimination:
509: DELETE FROM AR_DISTRIBUTIONS
510: WHERE source_id = g_ae_doc_rec.source_id
511: AND source_table = 'RA';
512:
513: IF PG_DEBUG in ('Y', 'C') THEN

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

536: | PROCEDURE Delete_MCD
537: |
538: | DESCRIPTION
539: | Deletes accounting associated with a Miscellaneous Cash Receipt or
540: | Payment. Note record from child (AR_DISTRIBUTIONS) table must be
541: | deleted first.
542: |
543: | PARAMETERS
544: | p_ae_deleted indicates whether records were deleted

Line 556: FROM ar_distributions ard

552: WHERE mcd.cash_receipt_id = g_ae_doc_rec.document_id
553: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate not those reversed
554: AND mcd.posting_control_id = -3 --Not posted
555: AND EXISTS (SELECT 'x'
556: FROM ar_distributions ard
557: WHERE ard.source_id = mcd.misc_cash_distribution_id
558: AND ard.source_table = 'MCD');
559:
560: l_dummy VARCHAR2(1);

Line 574: DELETE FROM ar_distributions ard

570: l_dummy := 'N';
571:
572: FOR l_misc_rec IN del_misc_rec LOOP
573:
574: DELETE FROM ar_distributions ard
575: WHERE ard.source_id = l_misc_rec.misc_dist_id
576: AND ard.source_table = 'MCD'
577: RETURNING line_id
578: BULK COLLECT INTO l_ar_dist_key_value_list;

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

613: |
614: | PROCEDURE Reverse_Receipt_CM
615: |
616: | DESCRIPTION
617: | This procedure reverses the records in AR_DISTRIBUTIONS for a
618: | Misc Cash Receipt, Cash Receipts and Credit Memo applications.
619: | There is a concept of caching used for UNAPP records, as if they
620: | are paired before Reversal they need to be paired after Reversal.
621: | In order for this caching to work, the APP, ACC and UNID records

Line 691: from ar_distributions ard,

687: ,'ADJADJ_CHRG','ADDCHRG'
688: ,'ADDCTL')))) WHICH_BUCKET,
689: line_trx_type.type trx_type
690: --}
691: from ar_distributions ard,
692: ar_distributions adjsrctp,
693: ar_receivable_applications app,
694: --{ For CM APP on legacy from 11i
695: (SELECT tt.type type,

Line 692: ar_distributions adjsrctp,

688: ,'ADDCTL')))) WHICH_BUCKET,
689: line_trx_type.type trx_type
690: --}
691: from ar_distributions ard,
692: ar_distributions adjsrctp,
693: ar_receivable_applications app,
694: --{ For CM APP on legacy from 11i
695: (SELECT tt.type type,
696: ctl.customer_trx_line_id customer_trx_line_id,

Line 763: from ar_distributions ard,

759: ,'ADJADJ_CHRG','ADDCHRG'
760: ,'ADDCTL')))) WHICH_BUCKET,
761: line_trx_type.type trx_type
762: --}
763: from ar_distributions ard,
764: ar_receivable_applications app,
765: ar_distributions adjsrctp,
766: -- For CM APP on legacy from 11i
767: (SELECT tt.type type,

Line 765: ar_distributions adjsrctp,

761: line_trx_type.type trx_type
762: --}
763: from ar_distributions ard,
764: ar_receivable_applications app,
765: ar_distributions adjsrctp,
766: -- For CM APP on legacy from 11i
767: (SELECT tt.type type,
768: ctl.customer_trx_line_id customer_trx_line_id,
769: ctl.line_type line_type

Line 2797: from ar_distributions ard

2793: from ar_transaction_history th
2794: where th.customer_trx_id = p_app_rec.applied_customer_trx_id
2795: and th.event = 'MATURITY_DATE'
2796: and exists (select 'x'
2797: from ar_distributions ard
2798: where ard.source_id = th.transaction_history_id
2799: and ard.source_table = 'TH'))
2800: where receivable_application_id = p_app_rec.receivable_application_id;
2801:

Line 3056: from ar_distributions ard

3052: AND g_ae_sys_rec.sob_type = 'P'
3053: AND mcd.reversal_gl_date is null --so we create only new rate adjusted or new mcd records
3054: AND mcd.posting_control_id = -3
3055: AND not exists (select 'x'
3056: from ar_distributions ard
3057: where ard.source_id = mcd.misc_cash_distribution_id
3058: and ard.source_table = 'MCD')
3059: ORDER by misc_cash_distribution_id;
3060: --{BUG4301323

Line 3115: | building MISCCASH records in AR_DISTRIBUTIONS |

3111:
3112:
3113: /*-------------------------------------------------------------+
3114: | Get exchange rate and third part info from Cash Receipt for |
3115: | building MISCCASH records in AR_DISTRIBUTIONS |
3116: +-------------------------------------------------------------*/
3117: l_mcd_first_rec_id := '';
3118:
3119: l_ael_line_rec.source_table := 'MCD';