DBA Data[Home] [Help]

APPS.ZPB_WF_EVENT dependencies on WF_ENGINE

Line 35: ACID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

31:
32:
33: resultout := 'ERROR';
34:
35: ACID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
36: Itemkey => ItemKey,
37: aname => 'ACID');
38:
39: l_result := wf_engine.GetItemAttrText(Itemtype => ItemType,

Line 39: l_result := wf_engine.GetItemAttrText(Itemtype => ItemType,

35: ACID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
36: Itemkey => ItemKey,
37: aname => 'ACID');
38:
39: l_result := wf_engine.GetItemAttrText(Itemtype => ItemType,
40: Itemkey => ItemKey,
41: aname => 'RESULT');
42:
43: ownerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

Line 43: ownerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

39: l_result := wf_engine.GetItemAttrText(Itemtype => ItemType,
40: Itemkey => ItemKey,
41: aname => 'RESULT');
42:
43: ownerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
44: Itemkey => ItemKey,
45: aname => 'OWNERID');
46: respID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
47: Itemkey => ItemKey,

Line 46: respID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

42:
43: ownerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
44: Itemkey => ItemKey,
45: aname => 'OWNERID');
46: respID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
47: Itemkey => ItemKey,
48: aname => 'RESPID');
49: respAPPID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
50: Itemkey => ItemKey,

Line 49: respAPPID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

45: aname => 'OWNERID');
46: respID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
47: Itemkey => ItemKey,
48: aname => 'RESPID');
49: respAPPID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
50: Itemkey => ItemKey,
51: aname => 'RESPAPPID');
52:
53: -- BUSINESS AREA ID.

Line 54: l_business_area_id := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

50: Itemkey => ItemKey,
51: aname => 'RESPAPPID');
52:
53: -- BUSINESS AREA ID.
54: l_business_area_id := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
55: Itemkey => ItemKey,
56: aname => 'BUSINESSAREAID');
57:
58:

Line 78: wf_engine.SetItemAttrText(Itemtype => ItemType,

74:
75: -- set item key for execute concurrent program
76:
77:
78: wf_engine.SetItemAttrText(Itemtype => ItemType,
79: Itemkey => ItemKey,
80: aname => 'ARG1',
81: avalue => ItemKey);
82:

Line 84: wf_engine.SetItemAttrNumber(Itemtype => ItemType,

80: aname => 'ARG1',
81: avalue => ItemKey);
82:
83: -- Set current value of Taskseq [not sure if it is always 1 might be for startup]
84: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
85: Itemkey => ItemKey,
86: aname => 'TASKSEQ',
87: avalue => 0);
88: -- set Cycle ID!

Line 89: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,

85: Itemkey => ItemKey,
86: aname => 'TASKSEQ',
87: avalue => 0);
88: -- set Cycle ID!
89: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,
90: -- Itemkey => ItemKey,
91: -- aname => 'ACID',
92: -- avalue => ACID);
93: -- set cycle Name!

Line 94: wf_engine.SetItemAttrText(Itemtype => ItemType,

90: -- Itemkey => ItemKey,
91: -- aname => 'ACID',
92: -- avalue => ACID);
93: -- set cycle Name!
94: wf_engine.SetItemAttrText(Itemtype => ItemType,
95: Itemkey => ItemKey,
96: aname => 'ACNAME',
97: avalue => ACNAME);
98:

Line 112: wf_engine.SetItemAttrText(Itemtype => ItemType,

108: from zpb_business_areas_vl
109: where BUSINESS_AREA_ID = l_business_area_id;
110:
111: -- SET business area display name to BUSINESSAREA in notification
112: wf_engine.SetItemAttrText(Itemtype => ItemType,
113: Itemkey => ItemKey,
114: aname => 'BUSINESSAREA',
115: avalue => l_business_area);
116: end if;

Line 124: wf_engine.SetItemOwner(ItemType => ItemType,

120:
121: -- globals set to WF attributes
122:
123: -- This should be the EPB controller user.
124: wf_engine.SetItemOwner(ItemType => ItemType,
125: ItemKey => ItemKey,
126: owner => owner);
127:
128: -- set EPBPerformer to owner name for notifications DEFAULT!

Line 129: wf_engine.SetItemAttrText(Itemtype => ItemType,

125: ItemKey => ItemKey,
126: owner => owner);
127:
128: -- set EPBPerformer to owner name for notifications DEFAULT!
129: wf_engine.SetItemAttrText(Itemtype => ItemType,
130: Itemkey => ItemKey,
131: aname => 'EPBPERFORMER',
132: avalue => owner);
133:

Line 135: wf_engine.SetItemAttrText(Itemtype => ItemType,

131: aname => 'EPBPERFORMER',
132: avalue => owner);
133:
134: -- will get error notifications
135: wf_engine.SetItemAttrText(Itemtype => ItemType,
136: Itemkey => ItemKey,
137: aname => 'WF_ADMINISTRATOR',
138: avalue => owner);
139:

Line 146: -- wf_engine.SetItemAttrText(Itemtype => ItemType,

142:
143:
144:
145:
146: -- wf_engine.SetItemAttrText(Itemtype => ItemType,
147: -- Itemkey => ItemKey,
148: -- aname => 'FNDUSERNAM',
149: -- avalue => owner);
150: --

Line 151: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,

147: -- Itemkey => ItemKey,
148: -- aname => 'FNDUSERNAM',
149: -- avalue => owner);
150: --
151: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,
152: -- Itemkey => ItemKey,
153: -- aname => 'OWNERID',
154: -- avalue => ownerID);
155:

Line 156: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,

152: -- Itemkey => ItemKey,
153: -- aname => 'OWNERID',
154: -- avalue => ownerID);
155:
156: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,
157: -- Itemkey => ItemKey,
158: -- aname => 'RESPID',
159: -- avalue => respID);
160:

Line 161: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,

157: -- Itemkey => ItemKey,
158: -- aname => 'RESPID',
159: -- avalue => respID);
160:
161: -- wf_engine.SetItemAttrNumber(Itemtype => ItemType,
162: -- Itemkey => ItemKey,
163: -- aname => 'RESPAPPID',
164: -- avalue => respAppID);
165:

Line 216: InstanceID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

212:
213: resultout := 'ERROR';
214: relative := 7;
215: -- get and set the BP run desc
216: InstanceID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
217: Itemkey => ItemKey,
218: aname => 'INSTANCEID');
219:
220: if InstanceID is not NULL then

Line 228: wf_engine.SetItemAttrText(Itemtype => ItemType,

224: from ZPB_ANALYSIS_CYCLE_INSTANCES
225: where INSTANCE_AC_ID = InstanceID;
226:
227: -- set descripton
228: wf_engine.SetItemAttrText(Itemtype => ItemType,
229: Itemkey => ItemKey,
230: aname => 'INSTANCEDESC',
231: avalue => InstDesc);
232: end if;

Line 236: ACID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

232: end if;
233:
234:
235:
236: ACID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
237: Itemkey => ItemKey,
238: aname => 'ACID');
239:
240:

Line 241: ownerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,

237: Itemkey => ItemKey,
238: aname => 'ACID');
239:
240:
241: ownerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
242: Itemkey => ItemKey,
243: aname => 'OWNERID');
244:
245:

Line 264: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,

260: rolename := zpb_wf_ntf.MakeRoleName(ACID, instanceID, OwnerID);
261: zpb_wf_ntf.SetRole(rolename, relative);
262:
263: -- BUG 4407850 06/02/2005 NTF NOT SENT TO CALLER changed ATTRNumber to ATTRTEXT
264: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,
265: Itemkey => ItemKey,
266: aname => 'EPBPERFORMER');
267:
268:

Line 274: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,

270: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
271: end if;
272:
273: -- BUG 4407850 06/02/2005 NTF NOT SENT TO CALLER changed ATTRNumber to ATTRTEXT
274: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,
275: Itemkey => ItemKey,
276: aname => 'FNDUSERNAM');
277:
278: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then

Line 283: wf_engine.SetItemAttrText(Itemtype => ItemType,

279: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
280: end if;
281:
282: -- reset EPBPERFORMER to ntf role
283: wf_engine.SetItemAttrText(Itemtype => ItemType,
284: Itemkey => ItemKey,
285: aname => 'EPBPERFORMER',
286: avalue => RoleName);
287:

Line 291: wf_engine.SetItemAttrText(Itemtype => ItemType,

287:
288:
289: -- set error message
290:
291: wf_engine.SetItemAttrText(Itemtype => ItemType,
292: Itemkey => ItemKey,
293: aname => 'ISSUEMSG',
294: avalue => l_result || ': ' || l_errorname || ' ' || l_errormsg);
295:

Line 494: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,

490: end if;
491:
492: -- BUG 4355208 WF_INVALID_ROLE add in caller if not already there.
493: -- BUG 4407850 06/02/2005 NTF NOT SENT TO CALLER changed ATTRNumber to ATTRTEXT
494: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,
495: Itemkey => ItemKey, aname => 'FNDUSERNAM');
496:
497: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
498: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);

Line 503: wf_engine.SetItemAttrText(Itemtype => ItemType,

499: end if;
500:
501: -- end BUG 4355208
502:
503: wf_engine.SetItemAttrText(Itemtype => ItemType,
504: Itemkey => ItemKey,
505: aname => 'EPBPERFORMER',
506:
507: avalue => RoleName);