[Home] [Help]
2237: ll_use_append boolean;
2238: ll_base_count number;
2239: begin
2240: ll_use_append:=true;
2241: if BSC_IM_UTILS.check_snapshot_log(x_base_tbl,BSC_APPS.bsc_apps_schema) then
2242: --see if the base table has any data
2243: --does_table_have_data will return 2 if the snapshot log has data, 0 if there is some error and
2244: --1 if there is no data
2245: ll_base_count:=BSC_IM_UTILS.does_table_have_data(x_base_tbl,null);
2241: if BSC_IM_UTILS.check_snapshot_log(x_base_tbl,BSC_APPS.bsc_apps_schema) then
2242: --see if the base table has any data
2243: --does_table_have_data will return 2 if the snapshot log has data, 0 if there is some error and
2244: --1 if there is no data
2245: ll_base_count:=BSC_IM_UTILS.does_table_have_data(x_base_tbl,null);
2246: if ll_base_count<>1 then
2247: ll_use_append:=false;--to be on the safe side
2248: end if;
2249: end if;