[Home] [Help]
427: update_current_crh_record( l_crh_rec_old, p_reversal_gl_date,
428: p_reversal_date, l_crh_rec.cash_receipt_history_id );
429: --
430:
431: -- Insert opposing Journal Entries into ar_distributions to
432: -- back out NOCOPY all existing entries belong to this cash receipt
433: --
434: insert_reversal_dist_rec( p_cr_id,l_crh_rec.cash_receipt_history_id );
435: --
708: | PROCEDURE |
709: | insert_reversal_dist_rec |
710: | |
711: | DESCRIPTION |
712: | Prepare the ar_distributions record for insertion into AR_DISTRIBUTIONs|
713: | table |
714: | |
715: | SCOPE - PRIVATE |
716: | |
715: | SCOPE - PRIVATE |
716: | |
717: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
718: | arp_distributions_pkg.insert_p - Insert table handler for |
719: | AR_DISTRIBUTIONS table |
720: | |
721: | ARGUMENTS : IN: |
722: | p_crh_id - Cash receipt history id |
723: | OUT: |
734: | third_pary_sub_id. |
735: | |
736: | 27-Jun-02 D.Jancis Modified for mrc trigger replacement. |
737: | added call to ar_mrc_engine2 for processing|
738: | ar_distributions inserts. |
739: +===========================================================================*/
740: PROCEDURE insert_reversal_dist_rec(
741: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
742: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
740: PROCEDURE insert_reversal_dist_rec(
741: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
742: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
743: --
744: l_dist_rec ar_distributions%ROWTYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE; /* added for VAT */
746: l_crh_rec ar_cash_receipt_history%ROWTYPE; /* added for VAT */
747: --
748: CURSOR ar_dist_C(
753: nvl(SUM( nvl(dist.AMOUNT_DR,0)),0) -
754: nvl(SUM( nvl(dist.AMOUNT_CR,0) ),0) amount_cr,
755: nvl(SUM( nvl(dist.ACCTD_AMOUNT_DR,0) ),0) -
756: nvl(SUM( nvl(dist.ACCTD_AMOUNT_CR,0) ),0) acctd_amount_cr
757: FROM ar_distributions dist,
758: ar_cash_receipt_history crh
759: WHERE dist.source_id = crh.cash_receipt_history_id
760: AND crh.cash_receipt_id = p_cr_id
761: ANd dist.source_table = 'CRH'
822: mrc engine */
823:
824: ar_mrc_engine2.maintain_mrc_data2(
825: p_event_mode => 'INSERT',
826: p_table_name => 'AR_DISTRIBUTIONS',
827: p_mode => 'SINGLE',
828: p_key_value => l_dist_rec.line_id,
829: p_row_info => l_dist_rec);
830: