969:
970:
971: for i in 1..g_total_budget_years loop
972:
973: insert into psb_ws_columns_i(
974: EXPORT_ID,
975: EXPORT_WORKSHEET_TYPE,
976: COLUMN_NUMBER,
977: BUDGET_YEAR_ID,
1013: IF g_pos_ws_cols(i).budget_year_id IS NULL THEN
1014: EXIT;
1015:
1016: END IF;
1017: insert into psb_ws_columns_i(
1018: EXPORT_ID,
1019: EXPORT_WORKSHEET_TYPE,
1020: COLUMN_NUMBER,
1021: COLUMN_TYPE,
3369:
3370: DELETE FROM psb_ws_line_balances_i
3371: WHERE export_id = p_export_id;
3372:
3373: DELETE FROM psb_ws_columns_i
3374: WHERE export_id = p_export_id;
3375:
3376: DELETE FROM psb_worksheets_i
3377: WHERE export_id = p_export_id;