DBA Data[Home] [Help]

APPS.WF_INITIATE dependencies on WF_ENGINE

Line 768: wf_engine.SetItemAttrDate(SetAttribute.itemType,SetAttribute.itemkey,

764: --
765: begin
766: if (attr_type = 'DATE') then
767: if (attr_fmt is not null) then
768: wf_engine.SetItemAttrDate(SetAttribute.itemType,SetAttribute.itemkey,
769: attr_name,to_date(attr_value,attr_fmt));
770: else
771: wf_engine.SetItemAttrDate (SetAttribute.itemType,SetAttribute.itemkey ,
772: attr_name,to_date(attr_value,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')));

Line 771: wf_engine.SetItemAttrDate (SetAttribute.itemType,SetAttribute.itemkey ,

767: if (attr_fmt is not null) then
768: wf_engine.SetItemAttrDate(SetAttribute.itemType,SetAttribute.itemkey,
769: attr_name,to_date(attr_value,attr_fmt));
770: else
771: wf_engine.SetItemAttrDate (SetAttribute.itemType,SetAttribute.itemkey ,
772: attr_name,to_date(attr_value,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')));
773: end if;
774: elsif (attr_type = 'NUMBER') then
775: if (attr_fmt is not null) then

Line 776: wf_engine.SetItemAttrNumber(SetAttribute.itemType,SetAttribute.itemkey, attr_name,

772: attr_name,to_date(attr_value,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')));
773: end if;
774: elsif (attr_type = 'NUMBER') then
775: if (attr_fmt is not null) then
776: wf_engine.SetItemAttrNumber(SetAttribute.itemType,SetAttribute.itemkey, attr_name,
777: to_number(attr_value, attr_fmt));
778: else
779: wf_engine.SetItemAttrNumber (SetAttribute.itemType,SetAttribute.itemkey, attr_name,
780: to_number(attr_value));

Line 779: wf_engine.SetItemAttrNumber (SetAttribute.itemType,SetAttribute.itemkey, attr_name,

775: if (attr_fmt is not null) then
776: wf_engine.SetItemAttrNumber(SetAttribute.itemType,SetAttribute.itemkey, attr_name,
777: to_number(attr_value, attr_fmt));
778: else
779: wf_engine.SetItemAttrNumber (SetAttribute.itemType,SetAttribute.itemkey, attr_name,
780: to_number(attr_value));
781: end if;
782: elsif (attr_type = 'VARCHAR2' )
783: and (length(attr_value) > nvl(to_number(attr_fmt),length(attr_value))) then

Line 796: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,

792: l_attr_value := attr_value;
793:
794: wfa_html.validate_display_name (attr_doc_name, l_attr_value);
795:
796: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,
797: attr_name, l_attr_value);
798: elsif (attr_type = 'DOCUMENT' ) then
799: -- if PLSQL then use the display value into which the user typed
800: if upper(substr(attr_doc_name,1, 5)) = 'PLSQL' then

Line 802: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,

798: elsif (attr_type = 'DOCUMENT' ) then
799: -- if PLSQL then use the display value into which the user typed
800: if upper(substr(attr_doc_name,1, 5)) = 'PLSQL' then
801:
802: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,
803: attr_name, attr_doc_name);
804: -- use the hidden field populated by doc lov
805: else
806:

Line 807: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,

803: attr_name, attr_doc_name);
804: -- use the hidden field populated by doc lov
805: else
806:
807: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,
808: attr_name, attr_value);
809: end if;
810:
811: else

Line 813: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,

809: end if;
810:
811: else
812: -- Lookup, VARCHAR2 or misc value
813: wf_engine.setitemattrtext( SetAttribute.itemType,SetAttribute.itemkey,
814: attr_name, attr_value);
815: end if;
816: exception
817: when others then

Line 891: wf_engine.createprocess(itemtype => SubmitWorkflow.itemtype,

887: htp.center(htf.bold(l_error_msg));
888: return;
889: end if;
890:
891: wf_engine.createprocess(itemtype => SubmitWorkflow.itemtype,
892: itemkey => SubmitWorkflow.itemkey,
893: process => SubmitWorkflow.process );
894:
895: if SubmitWorkflow.UserKey is not null then

Line 896: wf_engine.SetItemUserKey(ItemType=> SubmitWorkflow.ItemType,

892: itemkey => SubmitWorkflow.itemkey,
893: process => SubmitWorkflow.process );
894:
895: if SubmitWorkflow.UserKey is not null then
896: wf_engine.SetItemUserKey(ItemType=> SubmitWorkflow.ItemType,
897: ItemKey => SubmitWorkflow.ItemKey,
898: UserKey => SubmitWorkflow.UserKey);
899: end if;
900:

Line 902: wf_engine.SetItemOwner (itemtype=>SubmitWorkflow.itemtype,

898: UserKey => SubmitWorkflow.UserKey);
899: end if;
900:
901: if SubmitWorkflow.t_Owner is not null then
902: wf_engine.SetItemOwner (itemtype=>SubmitWorkflow.itemtype,
903: itemkey =>SubmitWorkflow.itemkey,
904: owner =>upper(SubmitWorkflow.t_Owner) );
905: end if;
906:

Line 918: wf_engine.startprocess(SubmitWorkflow.itemtype, SubmitWorkflow.itemkey);

914: h_fnames(counter), h_fvalues(counter), h_fdocnames(counter));
915: end loop;
916:
917: -- Submit workflow
918: wf_engine.startprocess(SubmitWorkflow.itemtype, SubmitWorkflow.itemkey);
919:
920:
921: -- go to the advanced envelope to display all the results.
922: -- call it with all options so it displays every activity response.