DBA Data[Home] [Help]

APPS.GMD_SS_LOT_WF_PKG dependencies on WF_ENGINE

Line 16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

12: p_funcmode IN VARCHAR2,
13: p_resultout OUT NOCOPY VARCHAR2)
14:
15: IS
16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
17: itemtype=>p_itemtype,
18: itemkey=>P_itemkey,
19: aname=>'EVENT_NAME');
20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

16: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
17: itemtype=>p_itemtype,
18: itemkey=>P_itemkey,
19: aname=>'EVENT_NAME');
20: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
21: itemtype=>p_itemtype,
22: itemkey=>P_itemkey,
23: aname=>'EVENT_KEY');
24:

Line 205: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

201: IF (l_debug = 'Y') THEN
202: gmd_debug.put_line('Going to set workflow attributes ');
203: END IF;
204:
205: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
206: itemkey => l_itemkey,
207: process => l_workflow_process );
208:
209:

Line 212: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,

208:
209:
210: /* Set the User Attribute */
211:
212: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
213: aname => 'CURRENT_APPROVER',
214: avalue => l_user);
215: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
216: aname => 'APPS_FORM',

Line 215: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

211:
212: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
213: aname => 'CURRENT_APPROVER',
214: avalue => l_user);
215: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
216: aname => 'APPS_FORM',
217: avalue =>l_form );
218: /* Set All other Attributes */
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,

Line 219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,

215: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
216: aname => 'APPS_FORM',
217: avalue =>l_form );
218: /* Set All other Attributes */
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
220: aname => 'EVENT_NAME',
221: avalue =>l_event_name );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'EVENT_KEY',

Line 222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

218: /* Set All other Attributes */
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
220: aname => 'EVENT_NAME',
221: avalue =>l_event_name );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'EVENT_KEY',
224: avalue =>l_event_key );
225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'ORG',

Line 225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

221: avalue =>l_event_name );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'EVENT_KEY',
224: avalue =>l_event_key );
225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'ORG',
227: avalue =>l_orgn_code );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'ITEM_NO',

Line 228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

224: avalue =>l_event_key );
225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'ORG',
227: avalue =>l_orgn_code );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'ITEM_NO',
230: avalue =>l_item_no );
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
232: aname => 'ITEM_REVISION',

Line 231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

227: avalue =>l_orgn_code );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'ITEM_NO',
230: avalue =>l_item_no );
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
232: aname => 'ITEM_REVISION',
233: avalue =>l_item_revision );
234: -- JD 10/20/2005 Changed item_desc to l_item_revision above.
235:

Line 236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

232: aname => 'ITEM_REVISION',
233: avalue =>l_item_revision );
234: -- JD 10/20/2005 Changed item_desc to l_item_revision above.
235:
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
237: aname => 'ITEM_DESC',
238: avalue =>l_item_desc );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'LOT_NO',

Line 239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

235:
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
237: aname => 'ITEM_DESC',
238: avalue =>l_item_desc );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'LOT_NO',
241: avalue =>l_lot_no );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'SAMPLE_QTY',

Line 242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

238: avalue =>l_item_desc );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'LOT_NO',
241: avalue =>l_lot_no );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'SAMPLE_QTY',
244: avalue =>l_sample_qty );
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'SAMPLE_UOM',

Line 245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

241: avalue =>l_lot_no );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'SAMPLE_QTY',
244: avalue =>l_sample_qty );
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'SAMPLE_UOM',
247: avalue =>l_sample_uom );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'STUDY',

Line 248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

244: avalue =>l_sample_qty );
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'SAMPLE_UOM',
247: avalue =>l_sample_uom );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'STUDY',
250: avalue =>l_study );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'STUDY_DESC',

Line 251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

247: avalue =>l_sample_uom );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'STUDY',
250: avalue =>l_study );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'STUDY_DESC',
253: avalue =>l_study_desc );
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STATUS',

Line 254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

250: avalue =>l_study );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'STUDY_DESC',
253: avalue =>l_study_desc );
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STATUS',
256: avalue =>l_status );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
258: aname => '#FROM_ROLE',

Line 257: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

253: avalue =>l_study_desc );
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STATUS',
256: avalue =>l_status );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
258: aname => '#FROM_ROLE',
259: avalue =>l_from_role );
260:
261: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 261: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

257: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
258: aname => '#FROM_ROLE',
259: avalue =>l_from_role );
260:
261: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
262: aname => 'MSG_DOCUMENT',
263: avalue =>
264: 'plsqlclob:GMD_SS_LOT_WF_PKG.Get_WF_Notif/'||l_event_key );
265:

Line 267: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

263: avalue =>
264: 'plsqlclob:GMD_SS_LOT_WF_PKG.Get_WF_Notif/'||l_event_key );
265:
266:
267: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
268: aname => 'AME_TRANS',
269: avalue =>l_transaction_type);
270:
271: wf_log_pkg.string(6, 'Dummy','Setting Parent');

Line 274: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,

270:
271: wf_log_pkg.string(6, 'Dummy','Setting Parent');
272:
273:
274: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
275: parent_itemtype => p_itemtype,
276: parent_itemkey=> p_itemkey,
277: parent_context=> NULL);
278:

Line 300: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);

296: forwardeeIn => ame_util.emptyApproverRecord);
297: end if;
298:
299:
300: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
301:
302: IF (l_debug = 'Y') THEN
303: gmd_debug.put_line('Created workflow process ');
304: END IF;

Line 332: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

328: p_funcmode IN VARCHAR2,
329: p_resultout OUT NOCOPY VARCHAR2)
330:
331: IS
332: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
333: itemtype=>p_itemtype,
334: itemkey=>P_itemkey,
335: aname=>'EVENT_NAME');
336: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

Line 336: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

332: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
333: itemtype=>p_itemtype,
334: itemkey=>P_itemkey,
335: aname=>'EVENT_NAME');
336: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
337: itemtype=>p_itemtype,
338: itemkey=>P_itemkey,
339: aname=>'EVENT_KEY');
340:

Line 344: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(

340:
341: l_current_approver varchar2(240);
342:
343: l_application_id number;
344: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
345: itemtype=>p_itemtype,
346: itemkey=>P_itemkey,
347: aname=>'AME_TRANS');
348: l_user varchar2(32);

Line 378: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,

374: end if;
375:
376: /* Set the User Attribute */
377:
378: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
379: aname => 'CURRENT_APPROVER',
380: avalue => l_user);
381:
382: P_resultout:='COMPLETE:Y';