[Home] [Help]
74:
75: PROCEDURE Init_Curr_Details
76: (p_sob_id IN NUMBER,
77: p_org_id IN NUMBER,
78: x_accounting_method IN OUT NOCOPY ar_system_parameters.accounting_method%TYPE)
79: IS
80: BEGIN
81: log('Init_Curr_Details +');
82: SELECT sob.set_of_books_id,
96: g_ae_sys_rec.gain_cc_id,
97: g_ae_sys_rec.loss_cc_id,
98: g_ae_sys_rec.round_cc_id,
99: x_accounting_method
100: FROM ar_system_parameters_all sysp,
101: gl_sets_of_books sob,
102: fnd_currencies c
103: WHERE sysp.org_id = p_org_id
104: AND sob.set_of_books_id = sysp.set_of_books_id --would be the row returned from multi org view
640: , NULL -- tax_link_id
641: , NULL -- tax_inc_flag
642: FROM xla_events_gt evt,
643: ar_receivable_applications_all app,
644: ar_system_parameters_all ars,
645: ra_customer_trx_all trx,
646: ra_customer_trx_lines_all ctl,
647: ra_cust_trx_line_gl_dist_all ctlgd
648: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
673: inv.set_of_books_id
674: FROM xla_events_gt evt,
675: ar_receivable_applications_all app,
676: ra_customer_trx_all inv,
677: ar_system_parameters_all ars
678: WHERE evt.event_type_code
679: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
680: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
681: 'CM_CREATE' ,'CM_UPDATE' )
694: inv.set_of_books_id
695: FROM xla_events_gt evt,
696: ar_receivable_applications_all app,
697: ra_customer_trx_all inv,
698: ar_system_parameters_all ars
699: WHERE evt.event_type_code
700: IN ( 'CM_CREATE' ,'CM_UPDATE' )
701: AND evt.event_id = app.event_id
702: AND app.customer_trx_id = inv.customer_trx_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
1518: GROUP BY ref_customer_trx_id, to_currency) trx
1975: , NULL -- tax_link_id
1976: , NULL -- tax_inc_flag
1977: , NULL -- ref_line_id
1978: FROM ar_adjustments_all adj,
1979: ar_system_parameters_all ars,
1980: -- For performance this sql is not nec as for legacy data
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,
2422: CURSOR c1 IS
2423: SELECT app.receivable_application_id
2424: FROM xla_events_gt evt,
2425: ar_receivable_applications_all app,
2426: ar_system_parameters_all ars
2427: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
2428: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
2429: 'CM_CREATE' ,'CM_UPDATE')
2430: AND evt.event_id = app.event_id
2485:
2486: PROCEDURE create_cash_distributions
2487: IS
2488: l_sob_id NUMBER;
2489: l_accounting_method ar_system_parameters.accounting_method%TYPE;
2490: l_create_acct VARCHAR2(1) := 'Y';
2491: l_gt_id NUMBER := 0;
2492:
2493: CURSOR c_app IS
2493: CURSOR c_app IS
2494: SELECT app.*
2495: FROM xla_events_gt evt,
2496: ar_receivable_applications_all app,
2497: ar_system_parameters_all ars
2498: WHERE evt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2499: 'RECP_RATE_ADJUST' ,'RECP_REVERSE',
2500: 'CM_CREATE' ,'CM_UPDATE' )
2501: AND evt.event_id = app.event_id
2516: CURSOR c_cm_from_app IS
2517: SELECT app.*
2518: FROM xla_events_gt evt,
2519: ar_receivable_applications_all app,
2520: ar_system_parameters_all ars
2521: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2522: AND evt.event_id = app.event_id
2523: AND app.status = 'APP'
2524: AND app.upgrade_method IS NULL
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';
2645: l_gt_id NUMBER := 0;
2646:
2647: CURSOR c_app IS