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_FACTS1_GL_PKG dependencies on GL_JE_LINES

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

424: WHEN OTHERS THEN
425: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);
426: END log;
427: --------------------------------------------------------------------------------
428: -- Select all journal lines from gl_je_lines from the beginning of the year upto
429: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
430: -- all journal lines not existing in fv_facts1_line_balances.
431: -- Retreives party info like party type, eliminations dept, etc and insert into
432: -- fv_facts1_line_balances.

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

440:
441: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
442: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
443: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;

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

441: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
442: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
443: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;

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

442: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
443: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;

Line 447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;

443: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;

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

446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;
454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;

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

452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;
454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;
459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
460: TYPE g_ng_indicator_t IS TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;

Line 611: gl_je_lines gjl,

607: WHERE application_id = 101
608: AND ledger_id = :gbl_sob_id
609: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
610: AND period_year = :gbl_period_year ) gps,
611: gl_je_lines gjl,
612: gl_je_headers gjh
613: WHERE fff.jc_flag = ''N''
614: AND fff.set_of_books_id = :gbl_sob_id
615: AND fff.fiscal_year = :gbl_period_year

Line 639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,

635: else
636:
637:
638: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
640: glcc GL_CODE_COMBINATIONS_U1,
641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
642: ' FROM fv_facts1_header_id_gt ftt
643: , gl_je_headers gjh

Line 644: , gl_je_lines gjl

640: glcc GL_CODE_COMBINATIONS_U1,
641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
642: ' FROM fv_facts1_header_id_gt ftt
643: , gl_je_headers gjh
644: , gl_je_lines gjl
645: , (SELECT period_num
646: , period_name
647: FROM gl_period_statuses ps
648: WHERE application_id = 101

Line 989: --l_reference_2 gl_je_lines.reference_1%TYPE;

985: l_elim_dept VARCHAR2(6);
986:
987: l_govt_non_govt_ind VARCHAR2(1);
988:
989: --l_reference_2 gl_je_lines.reference_1%TYPE;
990: --l_reference_5 gl_je_lines.reference_1%TYPE;
991: --l_reference_7 gl_je_lines.reference_1%TYPE;
992:
993: l_be_trx_id NUMBER;

Line 990: --l_reference_5 gl_je_lines.reference_1%TYPE;

986:
987: l_govt_non_govt_ind VARCHAR2(1);
988:
989: --l_reference_2 gl_je_lines.reference_1%TYPE;
990: --l_reference_5 gl_je_lines.reference_1%TYPE;
991: --l_reference_7 gl_je_lines.reference_1%TYPE;
992:
993: l_be_trx_id NUMBER;
994:

Line 991: --l_reference_7 gl_je_lines.reference_1%TYPE;

987: l_govt_non_govt_ind VARCHAR2(1);
988:
989: --l_reference_2 gl_je_lines.reference_1%TYPE;
990: --l_reference_5 gl_je_lines.reference_1%TYPE;
991: --l_reference_7 gl_je_lines.reference_1%TYPE;
992:
993: l_be_trx_id NUMBER;
994:
995: party_info_tab party_info_table;