[Home] [Help]
656: ard.tax_group_code_id tax_group_code_id,
657: ard.tax_code_id tax_code_id,
658: ard.code_combination_id code_combination_id';
659:
660: from1_stmt VARCHAR2(150) := ' from ar_distributions ard,
661: ar_receivable_applications app
662: where ';
663:
664: where1_stmt VARCHAR2(3000) := ' app.applied_customer_trx_id = :p_customer_trx_id
692: nvl(ard.taxable_accounted_cr,0)) <> 0))';
693:
694: -- Get the Reconciliation entries created for Adjustments
695:
696: from2_stmt VARCHAR2(150) := ' from ar_distributions ard,
697: ar_adjustments adj
698: where ';
699:
700: where2_stmt VARCHAR2(3000) := ' adj.customer_trx_id = :p_customer_trx_id
737: ard.tax_code_id tax_code_id,
738: ard.code_combination_id code_combination_id';
739:
740: from3_stmt VARCHAR2(150) := 'from ra_customer_trx_lines ctl,
741: ar_distributions ard
742: where ';
743:
744: where3_stmt VARCHAR2(3000) := ' ctl.br_ref_customer_trx_id = :p_customer_trx_id
745: and :p_calling_point IN (''TRAN'', ''BLTR'')
794: ard.tax_group_code_id tax_group_code_id,
795: ard.tax_code_id tax_code_id,
796: ard.code_combination_id code_combination_id ';
797:
798: from4_stmt VARCHAR2(100) := ' from ar_distributions ard
799: where ';
800:
801: where4_stmt VARCHAR2(3000) := ' ard.source_id_secondary = :p_customer_trx_line_id
802: and :p_calling_point = ''BILL''
2306: sum(nvl(ard.taxable_entered_dr,0) * -1 +
2307: nvl(ard.taxable_entered_cr,0)) taxable_amount ,
2308: sum(nvl(ard.taxable_accounted_dr,0) * -1 +
2309: nvl(ard.taxable_accounted_cr,0)) taxable_acctd_amount
2310: from ar_distributions ard,
2311: ar_receivable_applications app
2312: where p_ae_sys_rec.sob_type = 'P'
2313: and app.applied_customer_trx_id = p_customer_trx_id
2314: and p_calling_point IN ('TRAN', 'BLTR')
2340: sum(nvl(ard.taxable_entered_dr,0) * -1 +
2341: nvl(ard.taxable_entered_cr,0)) taxable_amount ,
2342: sum(nvl(ard.taxable_accounted_dr,0) * -1 +
2343: nvl(ard.taxable_accounted_cr,0)) taxable_acctd_amount
2344: from ar_distributions ard,
2345: ar_adjustments adj
2346: where p_ae_sys_rec.sob_type = 'P'
2347: and adj.customer_trx_id = p_customer_trx_id
2348: and p_calling_point IN ('TRAN', 'BLTR')
2377: nvl(ard.taxable_entered_cr,0)) taxable_amount ,
2378: sum(nvl(ard.taxable_accounted_dr,0) * -1 +
2379: nvl(ard.taxable_accounted_cr,0)) taxable_acctd_amount
2380: from ra_customer_trx_lines ctl,
2381: ar_distributions ard
2382: where p_ae_sys_rec.sob_type = 'P'
2383: and ctl.br_ref_customer_trx_id = p_customer_trx_id
2384: and p_calling_point IN ('TRAN', 'BLTR')
2385: and ard.source_id_secondary = ctl.customer_trx_line_id
2408: sum(nvl(ard.taxable_entered_dr,0) * -1 +
2409: nvl(ard.taxable_entered_cr,0)) taxable_amount ,
2410: sum(nvl(ard.taxable_accounted_dr,0) * -1 +
2411: nvl(ard.taxable_accounted_cr,0)) taxable_acctd_amount
2412: from ar_distributions ard
2413: where p_ae_sys_rec.sob_type = 'P'
2414: and ard.source_id_secondary = p_br_cust_trx_line_id
2415: and p_calling_point = 'BILL'
2416: and ard.source_table_secondary = 'CTL'
2720: arp_standard.debug('Process_Recon: ' || 'Start caching physically created tax accounting entries due to past activity');
2721: END IF;
2722:
2723: /*---------------------------------------------------------------------------------+
2724: |Cache the deferred tax accounting entries physically created in ar_distributions |
2725: |due to activity on the bill. |
2726: +---------------------------------------------------------------------------------*/
2727: FOR l_inv_nr IN get_def_tax_acct LOOP
2728:
2762: l_cached := TRUE;
2763:
2764: END IF;
2765:
2766: END LOOP; --for activity table from ar_distributions
2767:
2768: END IF; --activity table exists for already cached entries
2769:
2770: /*---------------------------------------------------------------------------------+
2767:
2768: END IF; --activity table exists for already cached entries
2769:
2770: /*---------------------------------------------------------------------------------+
2771: |If an entry is not already cached when retrieved from ar_distributions then cache|
2772: +---------------------------------------------------------------------------------*/
2773: IF (NOT l_cached) THEN
2774:
2775: IF PG_DEBUG in ('Y', 'C') THEN
2893: l_cached := TRUE;
2894:
2895: END IF;
2896:
2897: END LOOP; --for activity table from ar_distributions
2898:
2899: END IF; --activity table exists for already cached entries
2900:
2901: /*---------------------------------------------------------------------------------+
2898:
2899: END IF; --activity table exists for already cached entries
2900:
2901: /*---------------------------------------------------------------------------------+
2902: |If an entry is not already cached when retrieved from ar_distributions then cache|
2903: +---------------------------------------------------------------------------------*/
2904: IF ((NOT l_cached)
2905: AND ((p_calling_point = 'TRAN')
2906: OR ((p_calling_point IN ('BILL', 'BLTR'))
2953: END IF; --entries exist in the global accounting table for a activity
2954:
2955: /*------------------------------------------------------------------------------------------+
2956: |Reconcile the simulated application accounting for deferred tax for the shadow adjustment |
2957: |accounting with that of the physically stored accounting entries in ar_distributions, due |
2958: |to activity on the Bill |
2959: +------------------------------------------------------------------------------------------*/
2960: IF PG_DEBUG in ('Y', 'C') THEN
2961: arp_standard.debug('Process_Recon: ' || 'Reconciling original accounting with the activity accounting ');
3177:
3178: END IF; --no matching condition
3179:
3180: /*---------------------------------------------------------------------------------+
3181: |Build the ar distributions accounting record for cache into the global accounting|
3182: |table. |
3183: +---------------------------------------------------------------------------------*/
3184: IF (l_cre_rec) THEN --set other attributes of accounting lines reconciliation entry
3185:
3593: SELECT MAX(code_combination_id)
3594: INTO l_collected_ccid
3595: FROM
3596: (SELECT ard.code_combination_id
3597: FROM ar_distributions ard
3598: WHERE ard.source_table = 'RA'
3599: AND source_id IN (SELECT receivable_application_id
3600: FROM ar_receivable_applications
3601: WHERE applied_customer_trx_id = p_customer_trx_id)
3603: AND source_type = 'TAX'
3604: AND source_type_secondary = 'PAYMENT'
3605: UNION
3606: SELECT ard.code_combination_id
3607: FROM ar_distributions ard
3608: WHERE ard.source_table = 'ADJ'
3609: AND source_id IN (SELECT adjustment_id
3610: FROM ar_adjustments
3611: WHERE customer_trx_id = p_customer_trx_id