Cut Off Task - Task Def
E Task, wo duet es CSV parse und Orders via pl/sql generiere
[task definition 1.0]
/*
-------------------------------------------------------------------------------------------------------------
Bank : RBSC Coutts Bank Ltd.
Business Area : Business Applications Team
Description : This task is used to upload cutoff times via AVQ client
Owner : RBS Coutts SDA
-------------------------------------------------------------------------------------------------------------
ID Date Name, Company Issue Change Log or Description
-------------------------------------------------------------------------------------------------------------
001
*/
task definition rbsc$task_load_cut_off (15254)
program (online)
----------------------------------------------------------------------------
-- NAMING
----------------------------------------------------------------------------
naming
dfltlang "Load Cut Off Time"
----------------------------------------------------------------------------
-- TASK ATTRIBUTES
----------------------------------------------------------------------------
hira "110"
procedure rbsc$task_load_cut_off
----------------------------------------------------------------------------
-- PARAMETERS
----------------------------------------------------------------------------
--------------------------------------------------------------------------
i_file_upl_id file
mandatory
label "LABEL.FILE"
i_provider_id code code_obj_class
where "(obj_classif_id = 5540 and id in (11126,11127,11128)
or obj_classif_id = 5426 and id = 509397)"
mandatory
label "LABEL.PROVID"
separator
style "sub_sep"
label "CONST.597"
i_add_id code code_obj_add
where "(obj_type_id = 5 and activ = '+')"
label "LABEL.ADD.P"
i_time_offset number
label "LABEL.T_OFFSET"
i_add_postit boolean
label "LABEL.ADD_POSTIT"
i_postit_text text
label "LABEL.POSTIT_TEXT"
end task definition
