APPS.FV_GTAS_GL_PKG dependencies on FV_GTAS_EXCEPTIONS

Line 386: l_exception_category fv_gtas_exceptions.exception_category%TYPE;

382: IS
383: l_module_name VARCHAR2(200);
384: l_select_stmt VARCHAR2(20000);
385: l_last_fetch BOOLEAN;
386: l_exception_category fv_gtas_exceptions.exception_category%TYPE;
387: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
388: l_budget_impact_indicator VARCHAR2(1);
389: l_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
390: l_dummy_num NUMBER;

Line 426: TYPE doc_num_t IS TABLE OF fv_gtas_exceptions.doc_num%TYPE;

422: TYPE sgl_account_number_list_t IS TABLE OF fv_gtas_fed_accounts.sgl_account_number%TYPE;
423: --TYPE fed_nonfed_code_list_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%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:

Line 1103: l_exception_category fv_gtas_exceptions.exception_category%TYPE;

1099: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
1100: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
1101: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
1102: l_authority_type_found VARCHAR2(1);
1103: l_exception_category fv_gtas_exceptions.exception_category%TYPE;
1104: l_module_name VARCHAR2(200) := g_module_name||'GET_AUTHORITY_TYPE_CODE';
1105: l_auth_select VARCHAR2(200);
1106: l_auth_type_code_count NUMBER;
1107: l_be_doc_num xla_transaction_entities.transaction_number%TYPE;

Line 1290: DELETE FROM fv_gtas_exceptions

1286:
1287: BEGIN
1288: log(l_module_name, 'Begin: '||l_module_name);
1289:
1290: DELETE FROM fv_gtas_exceptions
1291: WHERE set_of_books_id = gbl_sob_id
1292: AND period_year = gbl_period_year;
1293: --AND record_category = 'EXCEPTION';
1294: log(l_module_name, 'Deleted Exception Rows.');

Line 1329: INSERT INTO fv_gtas_exceptions

1325: END IF;
1326: */
1327: log(l_module_name, '******p_account_number: '||p_account_number);
1328: log(l_module_name, 'p_sgl_account_number: '||p_sgl_account_number);
1329: INSERT INTO fv_gtas_exceptions
1330: (set_of_books_id, fund_value, period_year, period_num, account_number,
1331: sgl_acct_num,
1332: je_source, je_category,
1333: je_header_id, je_line_num, amount, ccid,

Line 2878: FROM fv_gtas_exceptions

2874: log(l_module_name, 'Begin '||l_module_name);
2875:
2876: SELECT COUNT(*)
2877: INTO l_exception_count
2878: FROM fv_gtas_exceptions
2879: WHERE set_of_books_id = gbl_sob_id
2880: AND period_year = gbl_period_year;
2881: log(l_module_name, 'Exception Count: '||l_exception_count);
2882: