DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on WF_ENGINE

Line 221: wf_engine.CreateProcess( ItemType => ItemType,

217: l_workflow_started_by_id := FND_GLOBAL.user_id;
218: l_resp_id := FND_GLOBAL.resp_id;
219:
220: -- Create a new Wf process
221: wf_engine.CreateProcess( ItemType => ItemType,
222: ItemKey => ItemKey,
223: process => l_process);
224:
225: log_message('START_AR_NOTIFY_WF: Workflow Process created with ItemKey=' || ItemKey || '*', 3);

Line 288: wf_engine.SetItemAttrNumber (itemtype => itemtype

284: END IF;
285:
286: -- Set the Wf Attributes
287: IF l_proj_info_rec.project_id IS NOT NULL THEN
288: wf_engine.SetItemAttrNumber (itemtype => itemtype
289: ,itemkey => itemKey
290: ,aname => 'PROJECT_ID'
291: ,avalue => l_proj_info_rec.project_id
292: );

Line 296: wf_engine.SetItemAttrText (itemtype => itemtype

292: );
293: END IF;
294:
295: IF l_proj_info_rec.project_number IS NOT NULL THEN
296: wf_engine.SetItemAttrText (itemtype => itemtype
297: ,itemkey => itemkey
298: ,aname => 'PROJECT_NUMBER'
299: ,avalue => l_proj_info_rec.project_number
300: );

Line 304: wf_engine.SetItemAttrText (itemtype => itemtype

300: );
301: END IF;
302:
303: IF l_proj_info_rec.project_name IS NOT NULL THEN
304: wf_engine.SetItemAttrText (itemtype => itemtype
305: ,itemkey => itemkey
306: ,aname => 'PROJECT_NAME'
307: ,avalue => l_proj_info_rec.project_name
308: );

Line 312: wf_engine.SetItemAttrText (itemtype => itemtype

308: );
309: END IF;
310:
311: IF l_inv_info_rec.receipt_number IS NOT NULL THEN
312: wf_engine.SetItemAttrText (itemtype => itemtype
313: ,itemkey => itemkey
314: ,aname => 'RECEIPT_NUMBER'
315: ,avalue => l_inv_info_rec.receipt_number
316: );

Line 320: wf_engine.SetItemAttrText (itemtype => itemtype

316: );
317: END IF;
318:
319: IF l_inv_info_rec.receipt_currency_code IS NOT NULL THEN
320: wf_engine.SetItemAttrText (itemtype => itemtype
321: ,itemkey => itemkey
322: ,aname => 'RECEIPT_CURRENCY_CODE'
323: ,avalue => l_inv_info_rec.receipt_currency_code
324: );

Line 328: wf_engine.SetItemAttrText (itemtype => itemtype

324: );
325: END IF;
326:
327: IF l_inv_info_rec.amount_applied IS NOT NULL THEN
328: wf_engine.SetItemAttrText (itemtype => itemtype
329: ,itemkey => itemkey
330: ,aname => 'APPLIED_AMOUNT'
331: ,avalue => l_inv_info_rec.amount_applied
332: );

Line 336: wf_engine.SetItemAttrText (itemtype => itemtype

332: );
333: END IF;
334:
335: IF l_inv_info_rec.ar_invoice_no IS NOT NULL THEN
336: wf_engine.SetItemAttrText (itemtype => itemtype
337: ,itemkey => itemkey
338: ,aname => 'AR_INVOICE_NUMBER'
339: ,avalue => l_inv_info_rec.ar_invoice_no
340: );

Line 344: wf_engine.SetItemAttrNumber (itemtype => itemtype

340: );
341: END IF;
342:
343: IF l_content_id IS NOT NULL THEN
344: wf_engine.SetItemAttrNumber (itemtype => itemtype
345: ,itemkey => itemkey
346: ,aname => 'CONTENT_ID'
347: ,avalue => l_content_id
348: );

Line 353: wf_engine.SetItemAttrNumber (itemtype => itemtype

349: END IF;
350:
351: --Set the standard WHO Attributes of the workflow
352: IF l_workflow_started_by_id IS NOT NULL THEN
353: wf_engine.SetItemAttrNumber (itemtype => itemtype
354: ,itemkey => itemkey
355: ,aname => 'WORKFLOW_STARTED_BY_ID'
356: ,avalue => l_workflow_started_by_id
357: );

Line 361: wf_engine.SetItemAttrText (itemtype => itemtype

357: );
358: END IF;
359:
360: IF l_user_name IS NOT NULL THEN
361: wf_engine.SetItemAttrText (itemtype => itemtype
362: ,itemkey => itemkey
363: ,aname => 'WORKFLOW_STARTED_BY_NAME'
364: ,avalue => l_user_name
365: );

Line 369: wf_engine.SetItemAttrText (itemtype => itemtype

365: );
366: END IF;
367:
368: IF l_user_full_name IS NOT NULL THEN
369: wf_engine.SetItemAttrText (itemtype => itemtype
370: ,itemkey => itemkey
371: ,aname => 'WORKFLOW_STARTED_BY_FULL_NAME'
372: ,avalue => l_user_full_name
373: );

Line 377: wf_engine.SetItemAttrNumber (itemtype => itemtype

373: );
374: END IF;
375:
376: IF l_resp_id IS NOT NULL THEN
377: wf_engine.SetItemAttrNumber (itemtype => itemtype
378: ,itemkey => itemkey
379: ,aname => 'RESPONSIBILITY_ID'
380: ,avalue => l_resp_id
381: );

Line 385: wf_engine.SetItemAttrText (itemtype => itemtype

381: );
382: END IF;
383:
384: IF l_wf_started_date IS NOT NULL THEN
385: wf_engine.SetItemAttrText (itemtype => itemtype
386: ,itemkey => itemkey
387: ,aname => 'WF_STARTED_DATE'
388: ,avalue => l_wf_started_date
389: );

Line 395: wf_engine.StartProcess (itemtype => itemtype

391: -- Attribute assignment done
392:
393: log_message('START_AR_NOTIFY_WF: Before starting the Wf', 3);
394: -- Start the Wf
395: wf_engine.StartProcess (itemtype => itemtype
396: ,itemkey => itemkey
397: );
398:
399:

Line 1002: IF (funcmode <> wf_engine.eng_run) THEN

998: BEGIN
999: --
1000: -- Return if WF Not Running
1001: --
1002: IF (funcmode <> wf_engine.eng_run) THEN
1003: resultout := wf_engine.eng_null;
1004: RETURN;
1005: END IF;
1006:

Line 1003: resultout := wf_engine.eng_null;

999: --
1000: -- Return if WF Not Running
1001: --
1002: IF (funcmode <> wf_engine.eng_run) THEN
1003: resultout := wf_engine.eng_null;
1004: RETURN;
1005: END IF;
1006:
1007: l_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

Line 1007: l_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1003: resultout := wf_engine.eng_null;
1004: RETURN;
1005: END IF;
1006:
1007: l_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1008: ,Itemkey => itemkey
1009: ,aname => 'RESPONSIBILITY_ID' );
1010:
1011: l_project_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

Line 1011: l_project_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1007: l_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1008: ,Itemkey => itemkey
1009: ,aname => 'RESPONSIBILITY_ID' );
1010:
1011: l_project_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1012: ,itemkey => itemkey
1013: ,aname => 'PROJECT_ID' );
1014:
1015: l_workflow_started_by_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

Line 1015: l_workflow_started_by_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1011: l_project_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1012: ,itemkey => itemkey
1013: ,aname => 'PROJECT_ID' );
1014:
1015: l_workflow_started_by_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1016: ,itemkey => itemkey
1017: ,aname => 'WORKFLOW_STARTED_BY_ID' );
1018:
1019: -- Based on the Responsibility, Intialize the Application

Line 1049: wf_engine.SetItemAttrNumber (itemtype => itemtype

1045: IF (c_manager%FOUND) THEN
1046: IF c_manager%ISOPEN THEN
1047: CLOSE c_manager;
1048: END IF;
1049: wf_engine.SetItemAttrNumber (itemtype => itemtype
1050: ,itemkey => itemkey
1051: ,aname => 'PROJECT_MANAGER_ID'
1052: ,avalue => l_manager_user_id );
1053: wf_engine.SetItemAttrText (itemtype => itemtype

Line 1053: wf_engine.SetItemAttrText (itemtype => itemtype

1049: wf_engine.SetItemAttrNumber (itemtype => itemtype
1050: ,itemkey => itemkey
1051: ,aname => 'PROJECT_MANAGER_ID'
1052: ,avalue => l_manager_user_id );
1053: wf_engine.SetItemAttrText (itemtype => itemtype
1054: ,itemkey => itemkey
1055: ,aname => 'PROJECT_MANAGER_NAME'
1056: ,avalue => l_manager_user_name);
1057: wf_engine.SetItemAttrText (itemtype => itemtype

Line 1057: wf_engine.SetItemAttrText (itemtype => itemtype

1053: wf_engine.SetItemAttrText (itemtype => itemtype
1054: ,itemkey => itemkey
1055: ,aname => 'PROJECT_MANAGER_NAME'
1056: ,avalue => l_manager_user_name);
1057: wf_engine.SetItemAttrText (itemtype => itemtype
1058: ,itemkey => itemkey
1059: ,aname => 'PROJECT_MANAGER_FULL_NAME'
1060: ,avalue => l_manager_full_name);
1061:

Line 1062: resultout := wf_engine.eng_completed||':'||'T';

1058: ,itemkey => itemkey
1059: ,aname => 'PROJECT_MANAGER_FULL_NAME'
1060: ,avalue => l_manager_full_name);
1061:
1062: resultout := wf_engine.eng_completed||':'||'T';
1063: ELSE
1064: IF c_manager%ISOPEN THEN
1065: CLOSE c_manager;
1066: END IF;

Line 1067: resultout := wf_engine.eng_completed||':'||'F';

1063: ELSE
1064: IF c_manager%ISOPEN THEN
1065: CLOSE c_manager;
1066: END IF;
1067: resultout := wf_engine.eng_completed||':'||'F';
1068: END IF;
1069: ELSE
1070: resultout := wf_engine.eng_completed||':'||'F';
1071: END IF;

Line 1070: resultout := wf_engine.eng_completed||':'||'F';

1066: END IF;
1067: resultout := wf_engine.eng_completed||':'||'F';
1068: END IF;
1069: ELSE
1070: resultout := wf_engine.eng_completed||':'||'F';
1071: END IF;
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN