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