APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on AR_DISTRIBUTIONS

Line 11: --PROCEDURE create_mfar_distributions;

7: g_run_acctd_tot NUMBER := 0;
8:
9: PROCEDURE create_cash_distributions;
10:
11: --PROCEDURE create_mfar_distributions;
12:
13:
14:
15: PROCEDURE local_log

Line 1227: ar_distributions ard,

1223: , NULL -- tax_link_id
1224: , NULL -- tax_inc_flag
1225: , ard.line_id -- ref_line_id
1226: FROM ar_adjustments adj,
1227: ar_distributions ard,
1228: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1229: MAX(to_currency) invoice_currency_code
1230: FROM ra_ar_gt
1231: WHERE gt_id = p_gt_id

Line 1513: ar_distributions_all ard,

1509: , NULL -- tax_link_id
1510: , NULL -- tax_inc_flag
1511: , ard.line_id -- ref_line_id
1512: FROM ar_adjustments_all adj,
1513: ar_distributions_all ard,
1514: ar_system_parameters_all ars,
1515: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1516: MAX(to_currency) invoice_currency_code
1517: FROM ra_ar_gt

Line 1985: -- FROM ar_distributions_all

1981: -- we are proposing no tied by to original line
1982: -- in new transaction the ref_line_id will be present
1983: -- (SELECT MAX(line_id) line_id,
1984: -- source_id source_id
1985: -- FROM ar_distributions_all
1986: -- WHERE source_table = 'ADJ'
1987: -- GROUP BY source_id) ard,
1988: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1989: MAX(to_currency) invoice_currency_code

Line 2463: -- Mfar post might be obsolete as AR will migrate all MFAR data into ar_distributions

2459: IF l_cash_post = 'Y' THEN
2460: create_cash_distributions;
2461: END IF;
2462:
2463: -- Mfar post might be obsolete as AR will migrate all MFAR data into ar_distributions
2464: -- As all MFAR data into ar_distributions
2465: -- l_mfar_post := is_mfar_post;
2466: -- IF l_mfar_post = 'Y' THEN
2467: -- create_mfar_distributions;

Line 2464: -- As all MFAR data into ar_distributions

2460: create_cash_distributions;
2461: END IF;
2462:
2463: -- Mfar post might be obsolete as AR will migrate all MFAR data into ar_distributions
2464: -- As all MFAR data into ar_distributions
2465: -- l_mfar_post := is_mfar_post;
2466: -- IF l_mfar_post = 'Y' THEN
2467: -- create_mfar_distributions;
2468: -- END IF;

Line 2467: -- create_mfar_distributions;

2463: -- Mfar post might be obsolete as AR will migrate all MFAR data into ar_distributions
2464: -- As all MFAR data into ar_distributions
2465: -- l_mfar_post := is_mfar_post;
2466: -- IF l_mfar_post = 'Y' THEN
2467: -- create_mfar_distributions;
2468: -- END IF;
2469:
2470:
2471: log('create_distributions -');

Line 2640: PROCEDURE create_mfar_distributions

2636:
2637:
2638:
2639: /*
2640: PROCEDURE create_mfar_distributions
2641: IS
2642: l_sob_id NUMBER;
2643: l_accounting_method ar_system_parameters.accounting_method%TYPE;
2644: l_create_acct VARCHAR2(1) := 'Y';

Line 2728: log('create_mfar_distributions +');

2724: end_process_stop EXCEPTION;
2725:
2726: BEGIN
2727:
2728: log('create_mfar_distributions +');
2729:
2730:
2731: DELETE FROM ra_ar_gt;
2732:

Line 2802: log('create_mfar_distributions -');

2798:
2799: -- Stamping the MFAR applications
2800: stamping_11i_mfar_app_post;
2801:
2802: log('create_mfar_distributions -');
2803: EXCEPTION
2804: WHEN OTHERS THEN
2805: log( 'EXCEPTION OTHERS Create_mfar_distributions: '||SQLERRM);
2806: RAISE;

Line 2805: log( 'EXCEPTION OTHERS Create_mfar_distributions: '||SQLERRM);

2801:
2802: log('create_mfar_distributions -');
2803: EXCEPTION
2804: WHEN OTHERS THEN
2805: log( 'EXCEPTION OTHERS Create_mfar_distributions: '||SQLERRM);
2806: RAISE;
2807: END Create_mfar_distributions;
2808: */
2809:

Line 2807: END Create_mfar_distributions;

2803: EXCEPTION
2804: WHEN OTHERS THEN
2805: log( 'EXCEPTION OTHERS Create_mfar_distributions: '||SQLERRM);
2806: RAISE;
2807: END Create_mfar_distributions;
2808: */
2809:
2810:
2811: