eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_SLA_PROCESSING_PKG dependencies on XLA_EVENTS_GT

Line 250: p_event_info IN xla_events_gt%ROWTYPE,

246:
247:
248: FUNCTION get_account_valid_status
249: (
250: p_event_info IN xla_events_gt%ROWTYPE,
251: p_fv_extract_rec IN OUT NOCOPY fv_extract_rec
252: )
253: RETURN BOOLEAN
254:

Line 1609: FROM xla_events_gt xgt ,gl_ledgers gl

1605:
1606:
1607: CURSOR c_ledger_info( p_event_id NUMBER ) IS
1608: SELECT chart_of_accounts_id coaid, gl.Ledger_id ledger_id
1609: FROM xla_events_gt xgt ,gl_ledgers gl
1610: WHERE gl.ledger_id = xgt.ledger_id
1611: AND xgt.application_id = p_application_id
1612: AND xgt.event_id = p_event_id;
1613:

Line 2147: FROM xla_events_gt xgt ,gl_ledgers gl

2143: l_procedure_name VARCHAR2(100):='.CST_EXTRACT';
2144:
2145: CURSOR c_ledger_info( p_event_id NUMBER ) IS
2146: SELECT chart_of_accounts_id coaid, gl.Ledger_id ledger_id
2147: FROM xla_events_gt xgt ,gl_ledgers gl
2148: WHERE gl.ledger_id = xgt.ledger_id
2149: AND xgt.application_id = p_application_id
2150: AND xgt.event_id = p_event_id;
2151:

Line 2171: FROM xla_events_gt

2167: AND pod.po_distribution_id = p_po_distribution_id;
2168:
2169: CURSOR c_get_event_code(p_event_id NUMBER) IS
2170: SELECT event_type_code
2171: FROM xla_events_gt
2172: WHERE event_id = p_event_id;
2173:
2174: CURSOR c_get_gl_fiscal_year(p_ledger_id NUMBER, p_gl_date DATE) IS
2175: SELECT period_year, period_name

Line 2453: FROM xla_events_gt xgt ,gl_ledgers gl

2449: l_procedure_name VARCHAR2(100):='.AP_EXTRACT';
2450:
2451: CURSOR c_ledger_info( p_event_id NUMBER ) IS
2452: SELECT chart_of_accounts_id coaid, gl.Ledger_id ledger_id
2453: FROM xla_events_gt xgt ,gl_ledgers gl
2454: WHERE gl.ledger_id = xgt.ledger_id
2455: AND xgt.application_id = p_application_id
2456: AND xgt.event_id = p_event_id;
2457:

Line 2461: XLA_EVENTS_GT xlagt

2457:
2458: CURSOR c_ap_invoice_details IS
2459: SELECT apinvdt.*
2460: FROM AP_EXTRACT_INVOICE_DTLS_BC_V apinvdt,
2461: XLA_EVENTS_GT xlagt
2462: where apinvdt.event_id = xlagt.event_id;
2463:
2464: CURSOR c_ap_invoice_header(p_event_id number) IS
2465: SELECT apinvhd.*

Line 2467: XLA_EVENTS_GT xlagt

2463:
2464: CURSOR c_ap_invoice_header(p_event_id number) IS
2465: SELECT apinvhd.*
2466: FROM AP_INVOICE_EXTRACT_HEADER_V apinvhd,
2467: XLA_EVENTS_GT xlagt
2468: where apinvhd.event_id = xlagt.event_id;
2469:
2470: CURSOR c_ap_payment_details IS
2471: SELECT appaydd.*

Line 2473: xla_events_gt xlagt

2469:
2470: CURSOR c_ap_payment_details IS
2471: SELECT appaydd.*
2472: FROM AP_PAYMENT_EXTRACT_DETAILS_V appaydd,
2473: xla_events_gt xlagt
2474: where appaydd.event_id = xlagt.event_id;
2475:
2476: CURSOR c_ap_payment_header(p_event_id NUMBER) IS
2477: SELECT appayhd.*

Line 2479: xla_events_gt xlagt

2475:
2476: CURSOR c_ap_payment_header(p_event_id NUMBER) IS
2477: SELECT appayhd.*
2478: FROM AP_PAYMENT_EXTRACT_HEADER_V appayhd,
2479: xla_events_gt xlagt
2480: where appayhd.event_id = xlagt.event_id;
2481:
2482: CURSOR c_po_dist_info(p_po_distribution_id NUMBER) IS
2483: SELECT *

Line 2489: FROM xla_events_gt

2485: WHERE pod.po_distribution_id = p_po_distribution_id;
2486:
2487: CURSOR c_get_event_code(p_event_id NUMBER) IS
2488: SELECT event_type_code
2489: FROM xla_events_gt
2490: WHERE event_id = p_event_id;
2491:
2492: CURSOR c_get_gl_fiscal_year(p_ledger_id NUMBER, p_gl_date DATE) IS
2493: SELECT period_year, period_name

Line 2533: FOR xla_rec in (select * from XLA_EVENTS_GT) loop

2529: END IF;
2530:
2531: l_index:=0;
2532: --Process invoice events
2533: FOR xla_rec in (select * from XLA_EVENTS_GT) loop
2534: trace (C_STATE_LEVEL, l_procedure_name, 'line_number='||xla_rec.line_number);
2535: trace (C_STATE_LEVEL, l_procedure_name, 'entity_id='||xla_rec.entity_id);
2536: trace (C_STATE_LEVEL, l_procedure_name, 'application_id='||xla_rec.application_id);
2537: trace (C_STATE_LEVEL, l_procedure_name, 'transaction_number='||xla_rec.transaction_number);

Line 2940: FROM xla_events_gt

2936:
2937: /* Get the events type information from XLA_EVENTS for application AR */
2938: CURSOR cur_ar_event_type IS
2939: SELECT event_type_code
2940: FROM xla_events_gt
2941: WHERE application_id = p_application_id
2942: GROUP BY event_type_code;
2943:
2944: /* Get the Event Information */

Line 2947: SELECT * FROM xla_events_gt;

2943:
2944: /* Get the Event Information */
2945: CURSOR cur_ar_event_info
2946: IS
2947: SELECT * FROM xla_events_gt;
2948:
2949: /* Get the Fund Category for the Invoice Default Receivable Account */
2950: CURSOR cur_ar_get_fund_catg (p_set_of_books_id NUMBER,
2951: p_fund_value VARCHAR2)

Line 3046: l_ar_event_type xla_events_gt.event_type_code%TYPE;

3042: AND trxobj.line_number = p_line_number;
3043:
3044: l_fv_extract_detail fv_ref_detail;
3045: empty_fv_extract_detail fv_ref_detail; -- empty table declaration
3046: l_ar_event_type xla_events_gt.event_type_code%TYPE;
3047: l_ar_inv_extract_details cur_ar_inv_extract_details%ROWTYPE;
3048: l_ar_rct_extract_details cur_ar_rct_extract_details%ROWTYPE;
3049: l_misc_rct_extract_details cur_misc_rct_extract_details%ROWTYPE;
3050: l_fund_value fv_extract_detail_gt.fund_value%TYPE;