DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on WF_ENGINE

Line 461: l_document_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,

457: --
458: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
459: l_item_key := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
460:
461: l_document_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
462: itemkey => l_item_key,
463: aname => 'DOCUMENT_ID');
464:
465: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,

Line 465: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,

461: l_document_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
462: itemkey => l_item_key,
463: aname => 'DOCUMENT_ID');
464:
465: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,
466: itemkey => l_item_key,
467: aname => 'DOCUMENT_TYPE');
468:
469: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 469: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

465: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,
466: itemkey => l_item_key,
467: aname => 'DOCUMENT_TYPE');
468:
469: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
470: itemkey => l_item_key,
471: aname => 'ORG_ID');
472:
473: l_progress := 'PO_EMAIL_GENERATE.GENERATE_HTML';

Line 2790: l_document_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,

2786: --
2787: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
2788: l_item_key := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
2789:
2790: l_document_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
2791: itemkey => l_item_key,
2792: aname => 'DOCUMENT_ID');
2793:
2794: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,

Line 2794: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,

2790: l_document_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
2791: itemkey => l_item_key,
2792: aname => 'DOCUMENT_ID');
2793:
2794: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,
2795: itemkey => l_item_key,
2796: aname => 'DOCUMENT_TYPE');
2797:
2798: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 2798: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

2794: l_document_type:=wf_engine.GetItemAttrText (itemtype => l_item_type,
2795: itemkey => l_item_key,
2796: aname => 'DOCUMENT_TYPE');
2797:
2798: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
2799: itemkey => l_item_key,
2800: aname => 'ORG_ID');
2801:
2802: l_progress := 'PO_EMAIL_GENERATE.GENERATE_HEADER';

Line 4624: l_document_id:=wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

4620: l_item_key := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
4621:
4622: --2332866, check if the document is in processing, and
4623: -- show warning message to the supplier
4624: l_document_id:=wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4625: itemkey => l_item_key,
4626: aname => 'DOCUMENT_ID');
4627: --
4628: l_document_type:=wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 4628: l_document_type:=wf_engine.GetItemAttrText ( itemtype => l_item_type,

4624: l_document_id:=wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4625: itemkey => l_item_key,
4626: aname => 'DOCUMENT_ID');
4627: --
4628: l_document_type:=wf_engine.GetItemAttrText ( itemtype => l_item_type,
4629: itemkey => l_item_key,
4630: aname => 'DOCUMENT_TYPE');
4631: --
4632: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 4632: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

4628: l_document_type:=wf_engine.GetItemAttrText ( itemtype => l_item_type,
4629: itemkey => l_item_key,
4630: aname => 'DOCUMENT_TYPE');
4631: --
4632: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4633: itemkey => l_item_key,
4634: aname => 'ORG_ID');
4635:
4636: l_progress := 'PO_EMAIL_GENERATE.GENERATE_TERMS';

Line 4682: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

4678: return;
4679: end if;
4680:
4681:
4682: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4683: itemkey => l_item_key,
4684: aname => l_userid_name);
4685:
4686: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 4686: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

4682: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4683: itemkey => l_item_key,
4684: aname => l_userid_name);
4685:
4686: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4687: itemkey => l_item_key,
4688: aname => l_appid_name);
4689:
4690: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

Line 4690: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,

4686: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4687: itemkey => l_item_key,
4688: aname => l_appid_name);
4689:
4690: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4691: itemkey => l_item_key,
4692: aname => l_respid_name);
4693: --
4694: IF (g_po_wf_debug = 'Y') THEN