276: aname => 'VALUE2',
277: avalue => CompDate);
278: end if;
279:
280: -- if fixed date for Distrbution or Standard Collection then set Wait to null.
281: if WorkflowProcess = 'ODPDISTPLANS'
282: then
283: select count(value) into FixedDate from v$parameter
284: where name like '%fixed_date%' AND length(VALUE) > 0;
668: --
669: -- Concurrent program that is used to run WF Background Engine in the looop
670: -- to complete each deferred activity for particular WF Process(ItemType/ItemKey).
671: --
672: -- This program has to be run from Standard Submit Concurrent Program Activity.
673: --
674: -- IN
675: -- itemtype - A valid item type from WF_ITEM_TYPES table.
676: -- cost_itemkey - Item key of the process whose activities were deferred.
712:
713: --========================================================================
714: -- SetColDate
715: --
716: -- WF proc to set the number of days to run the Standard Collection.
717: --
718: -- IN Standard parameters supplied by WF engine:
719: -- itemtype , itemkey, actid, funcmode
720: --
714: -- SetColDate
715: --
716: -- WF proc to set the number of days to run the Standard Collection.
717: --
718: -- IN Standard parameters supplied by WF engine:
719: -- itemtype , itemkey, actid, funcmode
720: --
721: -- OUT
722: -- resultout 'COMPLETE:N' for failure, 'COMPLETE:Y' for success
768: --
769: -- WF proc to set the number of days to run the Upload Process.
770: --
771: -- IN
772: -- Standard parameters supplied by WF engine:
773: -- itemtype , itemkey, actid, funcmode
774: --
775: -- OUT
776: -- resultout 'COMPLETE:N' for failure, 'COMPLETE:Y' for success
1110: --
1111: -- set WF Attributes. Currently just argument1. Will add more as needed.
1112: --
1113: -- IN
1114: -- Standard parameters supplied by WF engine: itemtype , itemkey, actid, funcmode
1115: --
1116: -- OUT
1117: -- resultout 'COMPLETE' for success
1118: --
1153: -- IN one argument:
1154: -- itemkey
1155: --
1156: -- OUT
1157: -- standard for concurrent program: errbuf, retcode: 0,1 ,2.
1158: --
1159:
1160: PROCEDURE DISTRIBUTE (errbuf out NOCOPY varchar2,
1161: retcode out NOCOPY number,