IF (:KFA010FBU_QF.DEPT_CODE IS NULL) THEN
GO_ITEM('KFA010FBU_QF.DEPT_CODE');
ELSIF (:KFA010FBU_QF.CATEGORY1 IS NULL) THEN
GO_ITEM('KFA010FBU_QF.CATEGORY1');
ELSE
:parameter.G_query_find := 'TRUE';
go_block('CONTROL');
execute_trigger('QUERY_FIND');
END IF;
GO_ITEM('KFA010FBU_QF.DEPT_CODE');
ELSIF (:KFA010FBU_QF.CATEGORY1 IS NULL) THEN
GO_ITEM('KFA010FBU_QF.CATEGORY1');
ELSE
:parameter.G_query_find := 'TRUE';
go_block('CONTROL');
execute_trigger('QUERY_FIND');
END IF;
全站熱搜