[Home] [Help]
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);
59: dbms_sql.close_cursor(cur_hdl); -- close cursor
60: */
61: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.truncate_tables', 'end');
413: PROCEDURE ins_intra_int_t(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
414: cur_hdl int;
415: BEGIN
416: cur_hdl := dbms_sql.open_cursor;
417: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
418: dbms_sql.close_cursor(cur_hdl); -- close cursor
419: IF intra_int_count > 0 THEN
420: FORALL i IN intra_int_tab.first..intra_int_tab.last
421: INSERT INTO fun_bal_intra_int_t
417: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
418: dbms_sql.close_cursor(cur_hdl); -- close cursor
419: IF intra_int_count > 0 THEN
420: FORALL i IN intra_int_tab.first..intra_int_tab.last
421: INSERT INTO fun_bal_intra_int_t
422: VALUES intra_int_tab(i);
423: END IF;
424: END ins_intra_int_t;
425:
495:
496: PROCEDURE ins_t_tables_intra_2_auto(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
497: PRAGMA AUTONOMOUS_TRANSACTION;
498: BEGIN
499: -- INSERT INTO fun_bal_intra_int_t
500: -- SELECT * FROM fun_bal_intra_int_gt;
501: ins_intra_int_t(intra_int_tab, intra_int_count);
502: COMMIT;
503: END ins_t_tables_intra_2_auto;