APPS.FUN_BAL_PKG dependencies on FUN_BAL_LINES_T

Line 85: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', 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);
89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);

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

370: PROCEDURE ins_lines_t(lines_tab IN lines_tab_type, lines_count IN NUMBER) IS
371: cur_hdl int;
372: BEGIN
373: cur_hdl := dbms_sql.open_cursor;
374: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
375: dbms_sql.close_cursor(cur_hdl); -- close cursor
376: IF lines_count > 0 THEN
377: FORALL i IN lines_tab.first..lines_tab.last
378: INSERT INTO fun_bal_lines_t

Line 378: INSERT INTO fun_bal_lines_t

374: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
375: dbms_sql.close_cursor(cur_hdl); -- close cursor
376: IF lines_count > 0 THEN
377: FORALL i IN lines_tab.first..lines_tab.last
378: INSERT INTO fun_bal_lines_t
379: VALUES lines_tab(i);
380: END IF;
381: END ins_lines_t;
382:

Line 508: INSERT INTO fun_bal_lines_t

504: ins_errors_t(errors_tab, errors_count);
505: /*
506: INSERT INTO fun_bal_headers_t
507: SELECT * FROM fun_bal_headers_gt;
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