APPS.FUN_BAL_PKG dependencies on FUN_BAL_HEADERS_T

Line 54: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', 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);
58: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);

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

305: cur_hdl int;
306: BEGIN
307:
308: cur_hdl := dbms_sql.open_cursor;
309: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
310: dbms_sql.close_cursor(cur_hdl); -- close cursor
311: IF headers_count > 0 THEN
312: FORALL i IN headers_tab.first..headers_tab.last
313: INSERT INTO fun_bal_headers_t

Line 313: INSERT INTO fun_bal_headers_t

309: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
310: dbms_sql.close_cursor(cur_hdl); -- close cursor
311: IF headers_count > 0 THEN
312: FORALL i IN headers_tab.first..headers_tab.last
313: INSERT INTO fun_bal_headers_t
314: VALUES headers_tab(i);
315: END IF;
316: END ins_headers_t;
317:

Line 454: INSERT INTO fun_bal_headers_t

450: ins_lines_t(lines_tab, lines_count);
451: ins_results_t(results_tab, results_count);
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