DBA Data[Home] [Help]

APPS.FUN_BAL_PKG dependencies on FUN_BAL_INTER_INT_T

Line 89: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_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);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor
92: */
93: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

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

436: PROCEDURE ins_inter_int_t(inter_int_tab IN inter_int_tab_type, inter_int_count IN NUMBER) IS
437: cur_hdl int;
438: BEGIN
439: cur_hdl := dbms_sql.open_cursor;
440: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTER_INT_T', dbms_sql.native);
441: dbms_sql.close_cursor(cur_hdl); -- close cursor
442:
443: IF inter_int_count > 0 THEN
444: FORALL i IN inter_int_tab.first..inter_int_tab.last

Line 445: INSERT INTO fun_bal_inter_int_t

441: dbms_sql.close_cursor(cur_hdl); -- close cursor
442:
443: IF inter_int_count > 0 THEN
444: FORALL i IN inter_int_tab.first..inter_int_tab.last
445: INSERT INTO fun_bal_inter_int_t
446: VALUES inter_int_tab(i);
447:
448: END IF;
449: END ins_inter_int_t;