APPS.FUN_BAL_PKG dependencies on FUN_BAL_RESULTS_T

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

47: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_GT', dbms_sql.native);
48: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LE_BSV_MAP_GT', dbms_sql.native);
49: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_GT', dbms_sql.native);
50: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_GT', dbms_sql.native);
51: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
52: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_ERRORS_T', dbms_sql.native);
53: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
55: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_BSV_MAP_T', dbms_sql.native);

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

332: PROCEDURE ins_results_t(results_tab IN results_tab_type, results_count IN NUMBER) IS
333: cur_hdl int;
334: BEGIN
335: cur_hdl := dbms_sql.open_cursor;
336: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
337: dbms_sql.close_cursor(cur_hdl); -- close cursor
338: IF results_count > 0 THEN
339: FORALL i IN results_tab.first..results_tab.last
340: INSERT INTO fun_bal_results_t

Line 340: INSERT INTO fun_bal_results_t

336: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_RESULTS_T', dbms_sql.native);
337: dbms_sql.close_cursor(cur_hdl); -- close cursor
338: IF results_count > 0 THEN
339: FORALL i IN results_tab.first..results_tab.last
340: INSERT INTO fun_bal_results_t
341: VALUES results_tab(i);
342: END IF;
343: END ins_results_t;
344:

Line 458: INSERT INTO fun_bal_results_t

454: INSERT INTO fun_bal_headers_t
455: SELECT * FROM fun_bal_headers_gt;
456: INSERT INTO fun_bal_lines_t
457: SELECT * FROM fun_bal_lines_gt;
458: INSERT INTO fun_bal_results_t
459: SELECT * FROM fun_bal_results_gt;
460: INSERT INTO fun_bal_errors_t
461: SELECT * FROM fun_bal_errors_gt;
462: */