DBA Data[Home] [Help]

APPS.GMD_SS_TIMEPOINT_WF_PKG dependencies on WF_ENGINE

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

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

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

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

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

219: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
220:
221: l_workflow_process:='GMDQSTST_SUB_PROCESS';
222:
223: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
224: itemkey => l_itemkey,
225: process => l_workflow_process );
226:
227: /* Set the User Attribute */

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

225: process => l_workflow_process );
226:
227: /* Set the User Attribute */
228:
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
230: aname => 'CURRENT_APPROVER',
231: avalue => l_user);
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'APPS_FORM',

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

228:
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
230: aname => 'CURRENT_APPROVER',
231: avalue => l_user);
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'APPS_FORM',
234: avalue =>l_form );
235: /* Set All other Attributes */
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,

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

232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'APPS_FORM',
234: avalue =>l_form );
235: /* Set All other Attributes */
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
237: aname => 'EVENT_NAME',
238: avalue =>l_event_name );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'EVENT_KEY',

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

235: /* Set All other Attributes */
236: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
237: aname => 'EVENT_NAME',
238: avalue =>l_event_name );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'EVENT_KEY',
241: avalue =>l_event_key );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'ORG',

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

238: avalue =>l_event_name );
239: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
240: aname => 'EVENT_KEY',
241: avalue =>l_event_key );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'ORG',
244: avalue =>l_organization ); --INVCONV
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'ITEM_NO',

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

241: avalue =>l_event_key );
242: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
243: aname => 'ORG',
244: avalue =>l_organization ); --INVCONV
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'ITEM_NO',
247: avalue =>l_item_no );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'ITEM_DESC',

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

244: avalue =>l_organization ); --INVCONV
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
246: aname => 'ITEM_NO',
247: avalue =>l_item_no );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'ITEM_DESC',
250: avalue =>l_item_desc );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'ITEM_REVISION',

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

247: avalue =>l_item_no );
248: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
249: aname => 'ITEM_DESC',
250: avalue =>l_item_desc );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'ITEM_REVISION',
253: avalue =>l_item_revision ); --INVCONV
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STUDY',

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

250: avalue =>l_item_desc );
251: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
252: aname => 'ITEM_REVISION',
253: avalue =>l_item_revision ); --INVCONV
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STUDY',
256: avalue =>l_study );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
258: aname => 'STUDY_DESC',

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

253: avalue =>l_item_revision ); --INVCONV
254: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
255: aname => 'STUDY',
256: avalue =>l_study );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
258: aname => 'STUDY_DESC',
259: avalue =>l_study_desc );
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'STATUS',

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

256: avalue =>l_study );
257: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
258: aname => 'STUDY_DESC',
259: avalue =>l_study_desc );
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'STATUS',
262: avalue =>l_status );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'SAMPLE_QTY',

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

259: avalue =>l_study_desc );
260: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
261: aname => 'STATUS',
262: avalue =>l_status );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'SAMPLE_QTY',
265: avalue =>l_sample_qty );
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
267: aname => 'SAMPLE_NO',

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

262: avalue =>l_status );
263: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
264: aname => 'SAMPLE_QTY',
265: avalue =>l_sample_qty );
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
267: aname => 'SAMPLE_NO',
268: avalue =>l_sample_no );
269: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
270: aname => 'STUDY_DATE',

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

265: avalue =>l_sample_qty );
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
267: aname => 'SAMPLE_NO',
268: avalue =>l_sample_no );
269: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
270: aname => 'STUDY_DATE',
271: avalue =>l_study_date);
272: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
273: aname => 'RESOURCE',

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

268: avalue =>l_sample_no );
269: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
270: aname => 'STUDY_DATE',
271: avalue =>l_study_date);
272: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
273: aname => 'RESOURCE',
274: avalue =>l_resource);
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
276: aname => 'SUBINVENTORY',

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

271: avalue =>l_study_date);
272: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
273: aname => 'RESOURCE',
274: avalue =>l_resource);
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
276: aname => 'SUBINVENTORY',
277: avalue =>l_storage_subinventory); --INVCONV
278: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
279: aname => 'LOCATOR',

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

274: avalue =>l_resource);
275: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
276: aname => 'SUBINVENTORY',
277: avalue =>l_storage_subinventory); --INVCONV
278: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
279: aname => 'LOCATOR',
280: avalue =>l_storage_locator); --INVCONV
281: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
282: aname => 'VARIANT_NO',

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

277: avalue =>l_storage_subinventory); --INVCONV
278: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
279: aname => 'LOCATOR',
280: avalue =>l_storage_locator); --INVCONV
281: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
282: aname => 'VARIANT_NO',
283: avalue =>l_variant_no);
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
285: aname => 'STORAGE_SPEC',

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

280: avalue =>l_storage_locator); --INVCONV
281: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
282: aname => 'VARIANT_NO',
283: avalue =>l_variant_no);
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
285: aname => 'STORAGE_SPEC',
286: avalue =>l_storage_spec);
287: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
288: aname => 'STGE_SPEC_VER',

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

283: avalue =>l_variant_no);
284: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
285: aname => 'STORAGE_SPEC',
286: avalue =>l_storage_spec);
287: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
288: aname => 'STGE_SPEC_VER',
289: avalue =>l_storage_spec_vers);
290: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
291: aname => 'TIME_NAME',

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

286: avalue =>l_storage_spec);
287: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
288: aname => 'STGE_SPEC_VER',
289: avalue =>l_storage_spec_vers);
290: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
291: aname => 'TIME_NAME',
292: avalue =>l_time_name);
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
294: aname => '#FROM_ROLE',

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

289: avalue =>l_storage_spec_vers);
290: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
291: aname => 'TIME_NAME',
292: avalue =>l_time_name);
293: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
294: aname => '#FROM_ROLE',
295: avalue =>l_from_role );
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

293: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
294: aname => '#FROM_ROLE',
295: avalue =>l_from_role );
296:
297: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
298: aname => 'AME_TRANS',
299: avalue =>l_transaction_type);
300:
301: wf_log_pkg.string(6, 'Dummy','Setting Parent');

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

300:
301: wf_log_pkg.string(6, 'Dummy','Setting Parent');
302:
303:
304: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
305: parent_itemtype => p_itemtype,
306: parent_itemkey=> p_itemkey,
307: parent_context=> NULL);
308:

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

323: transactionTypeIn => l_transaction_type,
324: forwardeeIn => ame_util.emptyApproverRecord);
325: end if;
326:
327: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
328:
329: close C1;
330:
331: END IF;

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

348: p_funcmode IN VARCHAR2,
349: p_resultout OUT NOCOPY VARCHAR2)
350:
351: IS
352: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
353: itemtype=>p_itemtype,
354: itemkey=>P_itemkey,
355: aname=>'EVENT_NAME');
356: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

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

352: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
353: itemtype=>p_itemtype,
354: itemkey=>P_itemkey,
355: aname=>'EVENT_NAME');
356: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
357: itemtype=>p_itemtype,
358: itemkey=>P_itemkey,
359: aname=>'EVENT_KEY');
360:

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

360:
361: l_current_approver varchar2(240);
362:
363: l_application_id number;
364: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
365: itemtype=>p_itemtype,
366: itemkey=>P_itemkey,
367: aname=>'AME_TRANS');
368: l_user varchar2(32);

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

399: end if;
400:
401: /* Set the User Attribute */
402:
403: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
404: aname => 'CURRENT_APPROVER',
405: avalue => l_user);
406:
407: P_resultout:='COMPLETE:Y';

Line 439: wf_engine.abortprocess (ITEMTYPE => l_itemtype,

435: l_itemtype :='GMDQSTST';
436: l_itemkey := p_timepoint ;
437:
438: /* Cancel workflow process */
439: wf_engine.abortprocess (ITEMTYPE => l_itemtype,
440: ITEMKEY => l_itemkey);
441:
442:
443: /* update the wf_sent back to N */