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_GTAS_GL_PKG dependencies on FV_GTAS_ACTIVITY_BALANCES

Line 24: party_id fv_gtas_activity_balances.trading_partner_id%TYPE,

20: TYPE party_info_rec
21: IS
22: RECORD
23: (
24: party_id fv_gtas_activity_balances.trading_partner_id%TYPE,
25: party_type fv_gtas_activity_balances.trading_partner_type%TYPE,
26: agency_id fv_gtas_activity_balances.trading_partner_agency_id%TYPE,
27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,
28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,

Line 25: party_type fv_gtas_activity_balances.trading_partner_type%TYPE,

21: IS
22: RECORD
23: (
24: party_id fv_gtas_activity_balances.trading_partner_id%TYPE,
25: party_type fv_gtas_activity_balances.trading_partner_type%TYPE,
26: agency_id fv_gtas_activity_balances.trading_partner_agency_id%TYPE,
27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,
28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,
29: reported_status VARCHAR2(1),

Line 26: agency_id fv_gtas_activity_balances.trading_partner_agency_id%TYPE,

22: RECORD
23: (
24: party_id fv_gtas_activity_balances.trading_partner_id%TYPE,
25: party_type fv_gtas_activity_balances.trading_partner_type%TYPE,
26: agency_id fv_gtas_activity_balances.trading_partner_agency_id%TYPE,
27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,
28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,
29: reported_status VARCHAR2(1),
30: record_category fv_gtas_activity_balances.record_category%TYPE,

Line 27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,

23: (
24: party_id fv_gtas_activity_balances.trading_partner_id%TYPE,
25: party_type fv_gtas_activity_balances.trading_partner_type%TYPE,
26: agency_id fv_gtas_activity_balances.trading_partner_agency_id%TYPE,
27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,
28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,
29: reported_status VARCHAR2(1),
30: record_category fv_gtas_activity_balances.record_category%TYPE,
31: fed_nonfed_code fv_gtas_activity_balances.fed_non_fed%TYPE,

Line 28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,

24: party_id fv_gtas_activity_balances.trading_partner_id%TYPE,
25: party_type fv_gtas_activity_balances.trading_partner_type%TYPE,
26: agency_id fv_gtas_activity_balances.trading_partner_agency_id%TYPE,
27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,
28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,
29: reported_status VARCHAR2(1),
30: record_category fv_gtas_activity_balances.record_category%TYPE,
31: fed_nonfed_code fv_gtas_activity_balances.fed_non_fed%TYPE,
32: party_line_amount NUMBER,

Line 30: record_category fv_gtas_activity_balances.record_category%TYPE,

26: agency_id fv_gtas_activity_balances.trading_partner_agency_id%TYPE,
27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,
28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,
29: reported_status VARCHAR2(1),
30: record_category fv_gtas_activity_balances.record_category%TYPE,
31: fed_nonfed_code fv_gtas_activity_balances.fed_non_fed%TYPE,
32: party_line_amount NUMBER,
33: doc_num xla_transaction_entities.transaction_number%TYPE);
34: TYPE party_info_table

Line 31: fed_nonfed_code fv_gtas_activity_balances.fed_non_fed%TYPE,

27: main_account fv_gtas_activity_balances.trading_partner_main_account%TYPE,
28: party_name fv_gtas_activity_balances.trading_partner_name%TYPE,
29: reported_status VARCHAR2(1),
30: record_category fv_gtas_activity_balances.record_category%TYPE,
31: fed_nonfed_code fv_gtas_activity_balances.fed_non_fed%TYPE,
32: party_line_amount NUMBER,
33: doc_num xla_transaction_entities.transaction_number%TYPE);
34: TYPE party_info_table
35: IS TABLE OF party_info_rec INDEX BY BINARY_INTEGER;

Line 397: TYPE account_number_t IS TABLE OF fv_gtas_activity_balances.account_number%TYPE;

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;
401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;

Line 398: TYPE amount_t IS TABLE OF fv_gtas_activity_balances.amount%TYPE;

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;
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;

Line 399: TYPE d_c_indicator_t IS TABLE OF fv_gtas_activity_balances.d_c_indicator%TYPE;

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;
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;

Line 408: TYPE party_id_t IS TABLE OF fv_gtas_activity_balances.trading_partner_id%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);
412: TYPE fed_nonfed_code_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;

Line 409: TYPE party_type_t IS TABLE OF fv_gtas_activity_balances.trading_partner_type%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);
412: TYPE fed_nonfed_code_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
413: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);

Line 410: TYPE party_name_t IS TABLE OF fv_gtas_activity_balances.trading_partner_name%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);
412: TYPE fed_nonfed_code_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
413: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
414: TYPE record_category_t IS TABLE OF fv_gtas_activity_balances.record_category%TYPE;

Line 414: TYPE record_category_t IS TABLE OF fv_gtas_activity_balances.record_category%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);
412: TYPE fed_nonfed_code_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
413: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
414: TYPE record_category_t IS TABLE OF fv_gtas_activity_balances.record_category%TYPE;
415: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
416: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);
417: TYPE je_batch_id_t IS TABLE OF gl_je_headers.je_batch_id%TYPE;
418: TYPE authority_type_flag_t IS TABLE OF VARCHAR2(1);

Line 428: fv_gtas_activity_balances.trading_partner_main_account%TYPE;

424: TYPE authority_type_code_t IS TABLE OF fv_gtas_attributes.authority_type1%TYPE;
425: TYPE budget_impact_ind_t IS TABLE OF fv_gtas_attributes.bud_impact_ind1%TYPE;
426: TYPE doc_num_t IS TABLE OF fv_gtas_exceptions.doc_num%TYPE;
427: TYPE main_account_t IS TABLE OF
428: fv_gtas_activity_balances.trading_partner_main_account%TYPE;
429:
430:
431: ccid_list ccid_t;
432: sob_id_list sob_id_t;

Line 959: INTO fv_gtas_activity_balances

955:
956: FORALL i IN je_header_id_list_2.first .. je_header_id_list_2.last
957: INSERT
958: --INTO fv_gtas_line_balances
959: INTO fv_gtas_activity_balances
960: (
961: ccid ,
962: period_num ,
963: set_of_books_id ,

Line 2827: log(l_module_name, 'Deleting from fv_gtas_activity_balances');

2823: l_module_name VARCHAR2(80) := g_module_name||'DELETE_PRIOR_GTAS_ACTIVITY';
2824: BEGIN
2825: log(l_module_name, 'Begin '||l_module_name);
2826: BEGIN
2827: log(l_module_name, 'Deleting from fv_gtas_activity_balances');
2828: DELETE FROM fv_gtas_activity_balances
2829: WHERE period_year = gbl_period_year
2830: AND set_of_books_id = gbl_sob_id;
2831: log(l_module_name, 'Deleted : '||sql%rowcount||' row/s.');

Line 2828: DELETE FROM fv_gtas_activity_balances

2824: BEGIN
2825: log(l_module_name, 'Begin '||l_module_name);
2826: BEGIN
2827: log(l_module_name, 'Deleting from fv_gtas_activity_balances');
2828: DELETE FROM fv_gtas_activity_balances
2829: WHERE period_year = gbl_period_year
2830: AND set_of_books_id = gbl_sob_id;
2831: log(l_module_name, 'Deleted : '||sql%rowcount||' row/s.');
2832: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2833: log(l_module_name, 'No rows found to dete from fv_gtas_activity_balances.');

2829: WHERE period_year = gbl_period_year
2830: AND set_of_books_id = gbl_sob_id;
2831: log(l_module_name, 'Deleted : '||sql%rowcount||' row/s.');
2832: EXCEPTION WHEN NO_DATA_FOUND THEN
2833: log(l_module_name, 'No rows found to dete from fv_gtas_activity_balances.');
2834: END;
2835:
2836: BEGIN
2837: log(l_module_name, 'Deleting from fv_gtas_processed_je_hdrs');