DBA Data[Home] [Help]

APPS.FUN_BAL_PKG dependencies on FUN_BAL_INTRA_BSV_MAP_T

Line 88: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_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);
91: dbms_sql.close_cursor(cur_hdl); -- close cursor
92: */

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

451: PROCEDURE ins_intra_le_bsv_map_t(le_bsv_map_tab IN intra_le_bsv_map_tab_type, intra_le_bsv_map_count IN NUMBER) IS
452: cur_hdl int;
453: BEGIN
454: cur_hdl := dbms_sql.open_cursor;
455: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
456: dbms_sql.close_cursor(cur_hdl); -- close cursor
457: IF intra_le_bsv_map_count > 0 THEN
458: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last
459: INSERT INTO fun_bal_intra_bsv_map_t

Line 459: INSERT INTO fun_bal_intra_bsv_map_t

455: dbms_sql.parse(cur_hdl, 'TRUNCATE TABLE ' || g_fun_schema || '.FUN_BAL_INTRA_BSV_MAP_T', dbms_sql.native);
456: dbms_sql.close_cursor(cur_hdl); -- close cursor
457: IF intra_le_bsv_map_count > 0 THEN
458: FORALL i IN le_bsv_map_tab.first..le_bsv_map_tab.last
459: INSERT INTO fun_bal_intra_bsv_map_t
460: VALUES le_bsv_map_tab(i);
461: END IF;
462: END ins_intra_le_bsv_map_t;
463: