DBA Data[Home] [Help]

APPS.FV_GTAS_GL_PKG dependencies on GL_JE_LINES

Line 375: -- Select all journal lines from gl_je_lines from the beginning of the year upto

371: Balancing or Accounting segment - '||SQLERRM;
372: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
373: END get_segment_names;
374: --------------------------------------------------------------------------------
375: -- Select all journal lines from gl_je_lines from the beginning of the year upto
376: -- the period being run, for all accounts existing in fv_gtas_fed_accounts and
377: -- all journal lines not existing in fv_gtas_line_balances.
378: -- Retreives party info like party type, eliminations dept, etc and insert into
379: -- fv_gtas_line_balances.

Line 395: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;

391: --l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
392: --l_project_accounting VARCHAR2(50):='Project Accounting';
393: TYPE t_ref_cur IS REF CURSOR ;
394: l_gl_lines_cur t_ref_cur ;
395: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
396: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
397: TYPE account_number_t IS TABLE OF fv_gtas_activity_balances.account_number%TYPE;
398: TYPE amount_t IS TABLE OF fv_gtas_activity_balances.amount%TYPE;
399: TYPE d_c_indicator_t IS TABLE OF fv_gtas_activity_balances.d_c_indicator%TYPE;

Line 396: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;

392: --l_project_accounting VARCHAR2(50):='Project Accounting';
393: TYPE t_ref_cur IS REF CURSOR ;
394: l_gl_lines_cur t_ref_cur ;
395: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
396: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
397: TYPE account_number_t IS TABLE OF fv_gtas_activity_balances.account_number%TYPE;
398: TYPE amount_t IS TABLE OF fv_gtas_activity_balances.amount%TYPE;
399: TYPE d_c_indicator_t IS TABLE OF fv_gtas_activity_balances.d_c_indicator%TYPE;
400: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;

Line 401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;

397: TYPE account_number_t IS TABLE OF fv_gtas_activity_balances.account_number%TYPE;
398: TYPE amount_t IS TABLE OF fv_gtas_activity_balances.amount%TYPE;
399: TYPE d_c_indicator_t IS TABLE OF fv_gtas_activity_balances.d_c_indicator%TYPE;
400: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;

Line 404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;

400: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
406: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
407: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
408: TYPE party_id_t IS TABLE OF fv_gtas_activity_balances.trading_partner_id%TYPE;

Line 405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;

401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
406: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
407: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
408: TYPE party_id_t IS TABLE OF fv_gtas_activity_balances.trading_partner_id%TYPE;
409: TYPE party_type_t IS TABLE OF fv_gtas_activity_balances.trading_partner_type%TYPE;

Line 407: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;

403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
406: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
407: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
408: TYPE party_id_t IS TABLE OF fv_gtas_activity_balances.trading_partner_id%TYPE;
409: TYPE party_type_t IS TABLE OF fv_gtas_activity_balances.trading_partner_type%TYPE;
410: TYPE party_name_t IS TABLE OF fv_gtas_activity_balances.trading_partner_name%TYPE;
411: TYPE agency_id_t IS TABLE OF VARCHAR2(3);

Line 574: FV_GTAS_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,

570: ';
571:
572: l_select_stmt :=
573: 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
574: FV_GTAS_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
575: glcc GL_CODE_COMBINATIONS_U1,
576: fgf FV_GTAS_FED_ACCOUNTS_U1) */ ' ||
577: l_select_stmt ||
578: ' FROM fv_gtas_header_id_gt ftt,

Line 580: gl_je_lines gjl,

576: fgf FV_GTAS_FED_ACCOUNTS_U1) */ ' ||
577: l_select_stmt ||
578: ' FROM fv_gtas_header_id_gt ftt,
579: gl_je_headers gjh,
580: gl_je_lines gjl,
581: (SELECT period_num, period_name
582: FROM gl_period_statuses ps
583: WHERE application_id = 101
584: AND ledger_id = :gbl_sob_id

Line 1595: FROM gl_je_lines je ,

1591: IS
1592: SELECT pc.customer_id party_id,
1593: NVL(ael.accounted_dr,0) - NVL(ael.accounted_cr,0) amount,
1594: xte.transaction_number
1595: FROM gl_je_lines je ,
1596: gl_import_references gir ,
1597: xla_ae_lines ael ,
1598: xla_ae_headers aeh ,
1599: pa_draft_revenues_all pdr,

Line 2041: l_temp_reference_2 gl_je_lines.reference_2%TYPE;

2037: l_select VARCHAR2(250);
2038: l_col_name all_tab_columns.column_name%TYPE;
2039: l_vendor_id ap_suppliers.vendor_id%TYPE;
2040: i INTEGER := 1;
2041: l_temp_reference_2 gl_je_lines.reference_2%TYPE;
2042:
2043: CURSOR projects_vendor_cur (p_ref1 IN VARCHAR2) IS
2044: SELECT e.vendor_id ven_id
2045: FROM gl_je_lines je ,

Line 2045: FROM gl_je_lines je ,

2041: l_temp_reference_2 gl_je_lines.reference_2%TYPE;
2042:
2043: CURSOR projects_vendor_cur (p_ref1 IN VARCHAR2) IS
2044: SELECT e.vendor_id ven_id
2045: FROM gl_je_lines je ,
2046: gl_je_headers jh ,
2047: pa_cost_distribution_lines_all cdl,
2048: pa_expenditure_items_all ei ,
2049: pa_expenditures_all e