APPS.FUN_BAL_PKG dependencies on FUN_BAL_LINES_T

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

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

319: PROCEDURE ins_lines_t(lines_tab IN lines_tab_type, lines_count IN NUMBER) IS
320: cur_hdl int;
321: BEGIN
322: cur_hdl := dbms_sql.open_cursor;
323: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
324: dbms_sql.close_cursor(cur_hdl); -- close cursor
325: IF lines_count > 0 THEN
326: FORALL i IN lines_tab.first..lines_tab.last
327: INSERT INTO fun_bal_lines_t

Line 327: INSERT INTO fun_bal_lines_t

323: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_LINES_T', dbms_sql.native);
324: dbms_sql.close_cursor(cur_hdl); -- close cursor
325: IF lines_count > 0 THEN
326: FORALL i IN lines_tab.first..lines_tab.last
327: INSERT INTO fun_bal_lines_t
328: VALUES lines_tab(i);
329: END IF;
330: END ins_lines_t;
331:

Line 456: INSERT INTO fun_bal_lines_t

452: ins_errors_t(errors_tab, errors_count);
453: /*
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