DBA Data[Home] [Help]

APPS.GMD_SS_BATCH_WF_PKG dependencies on WF_ENGINE

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

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

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

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

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

165: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
166:
167: l_workflow_process:='GMDQSBAT_SUB_PROCESS';
168:
169: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
170: itemkey => l_itemkey,
171: process => l_workflow_process );
172:
173:

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

175: gmd_debug.put_line('Going to set workflow attributes ');
176: END IF;
177:
178: /* Set the User Attribute */
179: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
180: aname => 'CURRENT_APPROVER',
181: avalue => l_user);
182: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
183: aname => 'APPS_FORM',

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

178: /* Set the User Attribute */
179: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype, itemkey => l_itemkey,
180: aname => 'CURRENT_APPROVER',
181: avalue => l_user);
182: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
183: aname => 'APPS_FORM',
184: avalue =>l_form );
185: /* Set All other Attributes */
186: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,

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

182: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
183: aname => 'APPS_FORM',
184: avalue =>l_form );
185: /* Set All other Attributes */
186: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
187: aname => 'EVENT_NAME',
188: avalue =>l_event_name );
189: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
190: aname => 'EVENT_KEY',

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

185: /* Set All other Attributes */
186: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => p_itemkey,
187: aname => 'EVENT_NAME',
188: avalue =>l_event_name );
189: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
190: aname => 'EVENT_KEY',
191: avalue =>l_event_key );
192: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
193: aname => 'ITEM_NO',

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

188: avalue =>l_event_name );
189: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
190: aname => 'EVENT_KEY',
191: avalue =>l_event_key );
192: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
193: aname => 'ITEM_NO',
194: avalue =>l_item_no );
195: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
196: aname => 'ITEM_DESC',

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

191: avalue =>l_event_key );
192: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
193: aname => 'ITEM_NO',
194: avalue =>l_item_no );
195: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
196: aname => 'ITEM_DESC',
197: avalue =>l_item_desc );
198: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
199: aname => 'ITEM_REVISION',

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

194: avalue =>l_item_no );
195: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
196: aname => 'ITEM_DESC',
197: avalue =>l_item_desc );
198: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
199: aname => 'ITEM_REVISION',
200: avalue =>l_revision );
201: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
202: aname => 'STUDY',

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

197: avalue =>l_item_desc );
198: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
199: aname => 'ITEM_REVISION',
200: avalue =>l_revision );
201: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
202: aname => 'STUDY',
203: avalue =>l_study );
204: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
205: aname => 'STUDY_DESC',

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

200: avalue =>l_revision );
201: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
202: aname => 'STUDY',
203: avalue =>l_study );
204: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
205: aname => 'STUDY_DESC',
206: avalue =>l_study_desc );
207: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
208: aname => 'ORG',

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

203: avalue =>l_study );
204: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
205: aname => 'STUDY_DESC',
206: avalue =>l_study_desc );
207: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
208: aname => 'ORG',
209: avalue =>l_orgn_code );
210: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
211: aname => 'STATUS',

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

206: avalue =>l_study_desc );
207: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
208: aname => 'ORG',
209: avalue =>l_orgn_code );
210: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
211: aname => 'STATUS',
212: avalue =>l_status );
213: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
214: aname => 'PLANT',

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

209: avalue =>l_orgn_code );
210: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
211: aname => 'STATUS',
212: avalue =>l_status );
213: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
214: aname => 'PLANT',
215: avalue =>l_plant );
216: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
217: aname => 'RECIPE',

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

212: avalue =>l_status );
213: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
214: aname => 'PLANT',
215: avalue =>l_plant );
216: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
217: aname => 'RECIPE',
218: avalue =>l_recipe_no);
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
220: aname => 'RECIPE_VERSION',

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

215: avalue =>l_plant );
216: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
217: aname => 'RECIPE',
218: avalue =>l_recipe_no);
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
220: aname => 'RECIPE_VERSION',
221: avalue =>l_recipe_vers );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'SAMPLE_QTY',

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

218: avalue =>l_recipe_no);
219: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
220: aname => 'RECIPE_VERSION',
221: avalue =>l_recipe_vers );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'SAMPLE_QTY',
224: avalue =>l_sample_qty );
225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'SAMPLE_UOM',

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

221: avalue =>l_recipe_vers );
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
223: aname => 'SAMPLE_QTY',
224: avalue =>l_sample_qty );
225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'SAMPLE_UOM',
227: avalue =>l_sample_uom );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'STUDY_DATE',

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

224: avalue =>l_sample_qty );
225: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
226: aname => 'SAMPLE_UOM',
227: avalue =>l_sample_uom );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'STUDY_DATE',
230: avalue =>l_sched_date);
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
232: aname => '#FROM_ROLE',

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

227: avalue =>l_sample_uom );
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
229: aname => 'STUDY_DATE',
230: avalue =>l_sched_date);
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
232: aname => '#FROM_ROLE',
233: avalue =>l_from_role );
234:
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

231: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
232: aname => '#FROM_ROLE',
233: avalue =>l_from_role );
234:
235: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
236: aname => 'AME_TRANS',
237: avalue =>l_transaction_type);
238:
239: wf_log_pkg.string(6, 'Dummy','Setting Parent');

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

238:
239: wf_log_pkg.string(6, 'Dummy','Setting Parent');
240:
241:
242: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
243: parent_itemtype => p_itemtype,
244: parent_itemkey=> p_itemkey,
245: parent_context=> NULL);
246:

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

261: transactionTypeIn => l_transaction_type,
262: forwardeeIn => ame_util.emptyApproverRecord);
263: end if ;
264:
265: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
266:
267: close C1;
268:
269:

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

288: p_funcmode IN VARCHAR2,
289: p_resultout OUT NOCOPY VARCHAR2)
290:
291: IS
292: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
293: itemtype=>p_itemtype,
294: itemkey=>P_itemkey,
295: aname=>'EVENT_NAME');
296: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(

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

292: l_event_name varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
293: itemtype=>p_itemtype,
294: itemkey=>P_itemkey,
295: aname=>'EVENT_NAME');
296: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT(
297: itemtype=>p_itemtype,
298: itemkey=>P_itemkey,
299: aname=>'EVENT_KEY');
300:

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

300:
301: l_current_approver varchar2(240);
302:
303: l_application_id number;
304: l_transaction_type varchar2(100):=WF_ENGINE.GETITEMATTRTEXT(
305: itemtype=>p_itemtype,
306: itemkey=>P_itemkey,
307: aname=>'AME_TRANS');
308: l_user varchar2(32);

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

334: end if;
335:
336: /* Set the User Attribute */
337:
338: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
339: aname => 'CURRENT_APPROVER',
340: avalue => l_user);
341:
342: P_resultout:='COMPLETE:Y';