APPS.FUN_BAL_PKG dependencies on FUN_BAL_INTRA_INT_T

Line 90: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_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);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor
92: */
93: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
94: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.truncate_tables', 'end');

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

465: PROCEDURE ins_intra_int_t(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
466: cur_hdl int;
467: BEGIN
468: cur_hdl := dbms_sql.open_cursor;
469: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
470: dbms_sql.close_cursor(cur_hdl); -- close cursor
471: IF intra_int_count > 0 THEN
472: FORALL i IN intra_int_tab.first..intra_int_tab.last
473: INSERT INTO fun_bal_intra_int_t

Line 473: INSERT INTO fun_bal_intra_int_t

469: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_INT_T', dbms_sql.native);
470: dbms_sql.close_cursor(cur_hdl); -- close cursor
471: IF intra_int_count > 0 THEN
472: FORALL i IN intra_int_tab.first..intra_int_tab.last
473: INSERT INTO fun_bal_intra_int_t
474: VALUES intra_int_tab(i);
475: END IF;
476: END ins_intra_int_t;
477:

Line 551: -- INSERT INTO fun_bal_intra_int_t

547:
548: PROCEDURE ins_t_tables_intra_2_auto(intra_int_tab IN intra_int_tab_type, intra_int_count IN NUMBER) IS
549: PRAGMA AUTONOMOUS_TRANSACTION;
550: BEGIN
551: -- INSERT INTO fun_bal_intra_int_t
552: -- SELECT * FROM fun_bal_intra_int_gt;
553: ins_intra_int_t(intra_int_tab, intra_int_count);
554: COMMIT;
555: END ins_t_tables_intra_2_auto;