DBA Data[Home] [Help]

APPS.GMD_SS_LATETEST_WF_PKG dependencies on WF_ENGINE

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

12: p_resultout OUT NOCOPY VARCHAR2)
13:
14: IS
15:
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 206: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

202: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
203:
204: l_workflow_process:='GMDQSTSL_SUB_PROCESS';
205:
206: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
207: itemkey => l_itemkey,
208: process => l_workflow_process );
209:
210: /* Set the User Attribute */

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

208: process => l_workflow_process );
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:
226: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

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

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

225:
226: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
227: aname => 'ORG',
228: avalue =>l_organization ); --INVCONV
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
230: aname => 'ITEM_NO',
231: avalue =>l_item_no );
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'ITEM_DESC',

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

228: avalue =>l_organization ); --INVCONV
229: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
230: aname => 'ITEM_NO',
231: avalue =>l_item_no );
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'ITEM_DESC',
234: avalue =>l_item_desc );
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'ITEM_REVISION',

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

231: avalue =>l_item_no );
232: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
233: aname => 'ITEM_DESC',
234: avalue =>l_item_desc );
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'ITEM_REVISION',
237: avalue =>l_item_revision ); --INVCONV
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'STUDY',

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

234: avalue =>l_item_desc );
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'ITEM_REVISION',
237: avalue =>l_item_revision ); --INVCONV
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'STUDY',
240: avalue =>l_study );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
242: aname => 'STUDY_DESC',

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

237: avalue =>l_item_revision ); --INVCONV
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
239: aname => 'STUDY',
240: avalue =>l_study );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
242: aname => 'STUDY_DESC',
243: avalue =>l_study_desc );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'STATUS',

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

240: avalue =>l_study );
241: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
242: aname => 'STUDY_DESC',
243: avalue =>l_study_desc );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'STATUS',
246: avalue =>l_status );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'SAMPLE_QTY',

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

243: avalue =>l_study_desc );
244: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
245: aname => 'STATUS',
246: avalue =>l_status );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'SAMPLE_QTY',
249: avalue =>l_sample_qty );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'SAMPLE_NO',

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

246: avalue =>l_status );
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
248: aname => 'SAMPLE_QTY',
249: avalue =>l_sample_qty );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'SAMPLE_NO',
252: avalue =>l_sample_no );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'STUDY_DATE',

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

249: avalue =>l_sample_qty );
250: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
251: aname => 'SAMPLE_NO',
252: avalue =>l_sample_no );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'STUDY_DATE',
255: avalue =>l_study_date);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'RESOURCE',

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

252: avalue =>l_sample_no );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
254: aname => 'STUDY_DATE',
255: avalue =>l_study_date);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'RESOURCE',
258: avalue =>l_resource);
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'SUBINVENTORY',

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

255: avalue =>l_study_date);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
257: aname => 'RESOURCE',
258: avalue =>l_resource);
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'SUBINVENTORY',
261: avalue =>l_storage_subinventory); --INVCONV
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'LOCATOR',

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

258: avalue =>l_resource);
259: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
260: aname => 'SUBINVENTORY',
261: avalue =>l_storage_subinventory); --INVCONV
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'LOCATOR',
264: avalue =>l_storage_locator); --INVCONV
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'VARIANT_NO',

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

261: avalue =>l_storage_subinventory); --INVCONV
262: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
263: aname => 'LOCATOR',
264: avalue =>l_storage_locator); --INVCONV
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'VARIANT_NO',
267: avalue =>l_variant_no);
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'STORAGE_SPEC',

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

264: avalue =>l_storage_locator); --INVCONV
265: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
266: aname => 'VARIANT_NO',
267: avalue =>l_variant_no);
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'STORAGE_SPEC',
270: avalue =>l_storage_spec);
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'STGE_SPEC_VER',

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

267: avalue =>l_variant_no);
268: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
269: aname => 'STORAGE_SPEC',
270: avalue =>l_storage_spec);
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'STGE_SPEC_VER',
273: avalue =>l_storage_spec_vers);
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TIME_NAME',

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

270: avalue =>l_storage_spec);
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
272: aname => 'STGE_SPEC_VER',
273: avalue =>l_storage_spec_vers);
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TIME_NAME',
276: avalue =>l_time_name);
277: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
278: aname => '#FROM_ROLE',

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

273: avalue =>l_storage_spec_vers);
274: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
275: aname => 'TIME_NAME',
276: avalue =>l_time_name);
277: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
278: aname => '#FROM_ROLE',
279: avalue =>l_from_role );
280:
281:

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

278: aname => '#FROM_ROLE',
279: avalue =>l_from_role );
280:
281:
282: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
283: aname => 'AME_TRANS',
284: avalue =>l_transaction_type);
285:
286: wf_log_pkg.string(6, 'Dummy','Setting Parent');

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

285:
286: wf_log_pkg.string(6, 'Dummy','Setting Parent');
287:
288:
289: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
290: parent_itemtype => p_itemtype,
291: parent_itemkey=> p_itemkey,
292: parent_context=> NULL);
293:

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

308: transactionTypeIn => l_transaction_type,
309: forwardeeIn => ame_util.emptyApproverRecord);
310: end if;
311:
312: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
313:
314: close C1;
315:
316: END IF;

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

333: p_funcmode IN VARCHAR2,
334: p_resultout OUT NOCOPY VARCHAR2)
335:
336: IS
337: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
338: itemtype=>p_itemtype,
339: itemkey=>P_itemkey,
340: aname=>'EVENT_NAME');
341: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

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

337: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
338: itemtype=>p_itemtype,
339: itemkey=>P_itemkey,
340: aname=>'EVENT_NAME');
341: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
342: itemtype=>p_itemtype,
343: itemkey=>P_itemkey,
344: aname=>'EVENT_KEY');
345:

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

345:
346: l_current_approver varchar2(240);
347:
348: l_application_id number;
349: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
350: itemtype=>p_itemtype,
351: itemkey=>P_itemkey,
352: aname=>'AME_TRANS');
353: l_user varchar2(32);

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

379: end if;
380:
381: /* Set the User Attribute */
382:
383: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
384: aname => 'CURRENT_APPROVER',
385: avalue => l_user);
386:
387: P_resultout:='COMPLETE:Y';