APPS.FUN_BAL_PKG dependencies on FUN_BAL_HEADERS_T

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

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

356: cur_hdl int;
357: BEGIN
358:
359: cur_hdl := dbms_sql.open_cursor;
360: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
361: dbms_sql.close_cursor(cur_hdl); -- close cursor
362: IF headers_count > 0 THEN
363: FORALL i IN headers_tab.first..headers_tab.last
364: INSERT INTO fun_bal_headers_t

Line 364: INSERT INTO fun_bal_headers_t

360: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_HEADERS_T', dbms_sql.native);
361: dbms_sql.close_cursor(cur_hdl); -- close cursor
362: IF headers_count > 0 THEN
363: FORALL i IN headers_tab.first..headers_tab.last
364: INSERT INTO fun_bal_headers_t
365: VALUES headers_tab(i);
366: END IF;
367: END ins_headers_t;
368:

Line 506: INSERT INTO fun_bal_headers_t

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