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 1335: ar_distributions ard,

1331: , ard.line_id -- ref_line_id
1332: , decode(adj.type, 'TAX', nvl(ard.tax_code_id, taxx.vat_tax_id), taxx.vat_tax_id)
1333: , decode(adj.type, 'TAX', nvl(ard.location_segment_id, taxx.location_segment_id), taxx.location_segment_id)
1334: FROM ar_adjustments adj,
1335: ar_distributions ard,
1336: ( select customer_trx_id, vat_tax_id, location_segment_id
1337: from ra_customer_trx_lines
1338: where customer_trx_id = p_trx_id
1339: and line_type = 'LINE'

Line 1711: ar_distributions_all ard,

1707: , ard.line_id -- ref_line_id
1708: , ard.tax_code_id
1709: , ard.location_segment_id
1710: FROM ar_adjustments_all adj,
1711: ar_distributions_all ard,
1712: ar_system_parameters_all ars,
1713: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1714: MAX(to_currency) invoice_currency_code
1715: FROM ra_ar_gt

Line 2183: -- FROM ar_distributions_all

2179: -- we are proposing no tied by to original line
2180: -- in new transaction the ref_line_id will be present
2181: -- (SELECT MAX(line_id) line_id,
2182: -- source_id source_id
2183: -- FROM ar_distributions_all
2184: -- WHERE source_table = 'ADJ'
2185: -- GROUP BY source_id) ard,
2186: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
2187: MAX(to_currency) invoice_currency_code

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

2678: IF l_cash_post = 'Y' THEN
2679: create_cash_distributions;
2680: END IF;
2681:
2682: -- Mfar post might be obsolete as AR will migrate all MFAR data into ar_distributions
2683: -- As all MFAR data into ar_distributions
2684: -- l_mfar_post := is_mfar_post;
2685: -- IF l_mfar_post = 'Y' THEN
2686: -- create_mfar_distributions;

Line 2683: -- As all MFAR data into ar_distributions

2679: create_cash_distributions;
2680: END IF;
2681:
2682: -- Mfar post might be obsolete as AR will migrate all MFAR data into ar_distributions
2683: -- As all MFAR data into ar_distributions
2684: -- l_mfar_post := is_mfar_post;
2685: -- IF l_mfar_post = 'Y' THEN
2686: -- create_mfar_distributions;
2687: -- END IF;

Line 2686: -- create_mfar_distributions;

2682: -- Mfar post might be obsolete as AR will migrate all MFAR data into ar_distributions
2683: -- As all MFAR data into ar_distributions
2684: -- l_mfar_post := is_mfar_post;
2685: -- IF l_mfar_post = 'Y' THEN
2686: -- create_mfar_distributions;
2687: -- END IF;
2688:
2689:
2690: log('create_distributions -');

Line 2859: PROCEDURE create_mfar_distributions

2855:
2856:
2857:
2858: /*
2859: PROCEDURE create_mfar_distributions
2860: IS
2861: l_sob_id NUMBER;
2862: l_accounting_method ar_system_parameters.accounting_method%TYPE;
2863: l_create_acct VARCHAR2(1) := 'Y';

Line 2947: log('create_mfar_distributions +');

2943: end_process_stop EXCEPTION;
2944:
2945: BEGIN
2946:
2947: log('create_mfar_distributions +');
2948:
2949:
2950: DELETE FROM ra_ar_gt;
2951:

Line 3021: log('create_mfar_distributions -');

3017:
3018: -- Stamping the MFAR applications
3019: stamping_11i_mfar_app_post;
3020:
3021: log('create_mfar_distributions -');
3022: EXCEPTION
3023: WHEN OTHERS THEN
3024: log( 'EXCEPTION OTHERS Create_mfar_distributions: '||SQLERRM);
3025: RAISE;

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

3020:
3021: log('create_mfar_distributions -');
3022: EXCEPTION
3023: WHEN OTHERS THEN
3024: log( 'EXCEPTION OTHERS Create_mfar_distributions: '||SQLERRM);
3025: RAISE;
3026: END Create_mfar_distributions;
3027: */
3028:

Line 3026: END Create_mfar_distributions;

3022: EXCEPTION
3023: WHEN OTHERS THEN
3024: log( 'EXCEPTION OTHERS Create_mfar_distributions: '||SQLERRM);
3025: RAISE;
3026: END Create_mfar_distributions;
3027: */
3028:
3029:
3030: