APPS.FUN_BAL_PKG dependencies on FUN_BAL_ERRORS_T

Line 84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);

80: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
81: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
82: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
83: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
84: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
86: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
87: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);
88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);

Line 400: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);

396: PROCEDURE ins_errors_t(errors_tab IN errors_tab_type, errors_count IN NUMBER) IS
397: cur_hdl int;
398: BEGIN
399: cur_hdl := dbms_sql.open_cursor;
400: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
401: dbms_sql.close_cursor(cur_hdl); -- close cursor
402: IF errors_count > 0 THEN
403: FORALL i IN errors_tab.first..errors_tab.last
404: INSERT INTO fun_bal_errors_t

Line 404: INSERT INTO fun_bal_errors_t

400: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
401: dbms_sql.close_cursor(cur_hdl); -- close cursor
402: IF errors_count > 0 THEN
403: FORALL i IN errors_tab.first..errors_tab.last
404: INSERT INTO fun_bal_errors_t
405: VALUES errors_tab(i);
406: END IF;
407: END ins_errors_t;
408:

Line 512: INSERT INTO fun_bal_errors_t

508: INSERT INTO fun_bal_lines_t
509: SELECT * FROM fun_bal_lines_gt;
510: INSERT INTO fun_bal_results_t
511: SELECT * FROM fun_bal_results_gt;
512: INSERT INTO fun_bal_errors_t
513: SELECT * FROM fun_bal_errors_gt;
514: */
515: COMMIT;
516: END ins_t_tables_final_auto;