Task definition blocking task
d'Task definition für dr Blocking Task
[task definition 1.0]
task definition rbsc$task_blocking (13201)
/*
-------------------------------------------------------------------------------------------------------------
Bank:
Business Area:
Description: Task definition to show objects having a block code set
-------------------------------------------------------------------------------------------------------------
ID Date Name, Company Issue Affected BUs, Description
-------------------------------------------------------------------------------------------------------------
001
-------------------------------------------------------------------------------------------------------------
*/
report (online batch)
naming
dfltlang "Blocked objects"
descn "Show objects having a block code set"
hira "910"
coverpage false
lock_templates false
datamart "rbsc$blocking" (no_override)
context null (no_override)
single_login true (no_override)
procedure rbsc$blocking.do_layout
separator
style "main_sep"
label "LABEL.LAYOUT"
---- LAYOUT ----
i_layout_list_id list of code obj_task_layout_v
where "meta_out_id=13201"
mandatory
label "LABEL.LAYOUT"
descn "Layout used to format the result"
--------------------------------------------------------------------------
-- SELECTION
--------------------------------------------------------------------------
separator
style "main_sep"
label "LABEL.SEL"
--------------------------------------------------------------------------
i_bu_id bp
where "id in (select obj_id from obj_bp_bu)"
label "LABEL.BU"
descn "Include objects of specified business unit"
--------------------------------------------------------------------------
i_obj_status_id code code_const
where "id in (701,702)"
descn "Includes only active (open) or inactive (closed) objects. Default is both, active and inactive objects"
label "LABEL.STATUS"
--------------------------------------------------------------------------
-- OBJECT TYPE
--------------------------------------------------------------------------
separator
style "sub_sep"
label "LABEL.OBJ_TYPE"
--------------------------------------------------------------------------
i_obj_type_list_id list of code code_obj_type
label "LABEL.OBJ_TYPE.S"
descn "Include objects having given types"
--------------------------------------------------------------------------
i_obj_sub_type_incl_id list of code code_obj_sub_type_v
label "LABEL.OBJ_SUB_TYPE_INCL.S"
descn "Include objects having given sub-type"
--------------------------------------------------------------------------
i_obj_sub_type_excl_id list of code code_obj_sub_type_v
label "LABEL.OBJ_SUB_TYPE_EXCL.S"
descn "Exclude objects having given sub type"
--------------------------------------------------------------------------
-- BLOCKING
--------------------------------------------------------------------------
separator
style "sub_sep"
label "LABEL.BLOCK"
--------------------------------------------------------------------------
i_block_incl_id list of code code_block
where "obj_type_id is not null"
label "LABEL.BLOCK_INCL.S"
descn "Include object(s) having given block code(s)"
--------------------------------------------------------------------------
i_block_excl_id list of code code_block
where "obj_type_id is not null"
label "LABEL.BLOCK_EXCL.S"
descn "Exclude object(s) having given block code(s)"
end procedure
end task definition
