Thursday, January 30, 2014

How to set Item Attribute value from Pl/SQL Code


In PL/SQL code use that API

1-Text--The attribute value is a string of text.

wf_engine.SetItemAttrText(itemtype in varchar2,
                          itemkey  in varchar2,
                          aname    in varchar2,
                          avalue   in varchar2);


 2:- Number--The attribute value is a number with the optional format mask you specify.
                         
wf_engine.SetItemAttrNumber(itemtype in varchar2,
                            itemkey  in varchar2,
                            aname    in varchar2,
                            avalue   in number);



3:- Date--The attribute value is a date with the optional format mask you specify.
                         
wf_engine.SetItemAttrDate(itemtype in varchar2,
                          itemkey  in varchar2,
                          aname    in varchar2,
                          avalue   in date);

                         
4:-Document--The attribute value is an attached document. You can specify the following types of  documents in the default value field:
  • PL/SQL document--a document representing data from the database as a character string, generated from a PL/SQL procedure. 
  • PL/SQL CLOB document--a document representing data from the database as a character large object (CLOB), generated from a PL/SQL procedure.

wf_engine.SetItemAttrDocument(itemtype   in varchar2,
                              itemkey    in varchar2,
                              aname      in varchar2,
                              documentid in varchar2);

                        


5:- Event--The attribute value is a Business Event System event message in the standard WF_EVENT_T structure.

wf_engine.SetItemAttrEvent( itemtype in varchar2,
                            itemkey  in varchar2,
                            name     in varchar2,
                            event    in wf_event_t);
             

6:- TextArray          
wf_engine.SetItemAttrTextArray(itemtype in varchar2,
                               itemkey  in varchar2,
                               aname    in Wf_Engine.NameTabTyp,
                               avalue   in Wf_Engine.TextTabTyp);
   

7:- Owner                         
wf_engine.SetItemOwner(itemtype in varchar2,
                       itemkey in varchar2,
                       owner in varchar2);






Thanks
Sajal


No comments:

Post a Comment