DBA Data[Home] [Help]

APPS.POS_WF_PO_COMMON_APIS dependencies on WF_ENGINE

Line 72: l_document_id := wf_engine.GetItemAttrNumber

68: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
69:
70: x_progress := '002';
71:
72: l_document_id := wf_engine.GetItemAttrNumber
73: (itemtype => l_item_type,
74: itemkey => l_item_key,
75: aname => 'DOCUMENT_ID');
76:

Line 77: l_document_num := wf_engine.GetItemAttrText

73: (itemtype => l_item_type,
74: itemkey => l_item_key,
75: aname => 'DOCUMENT_ID');
76:
77: l_document_num := wf_engine.GetItemAttrText
78: (itemtype => l_item_type,
79: itemkey => l_item_key,
80: aname => 'DOCUMENT_NUM');
81:

Line 133: x_supplier_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

129: x_orig_system varchar2(4);
130: begin
131:
132: --dbms_output.put_line (' In Get Supplier Username ');
133: x_supplier_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
134: itemkey => itemkey,
135: aname => 'SUPPLIER_ID');
136:
137: --dbms_output.put_line (' Get Supplier Username ' || x_supplier_id);

Line 152: wf_engine.SetItemAttrText ( itemtype => itemtype,

148: x_supplier_username,
149: x_supplier_display_name);
150: x_progress := '004';
151:
152: wf_engine.SetItemAttrText ( itemtype => itemtype,
153: itemkey => itemkey,
154: aname => 'SUPPLIER_USER_NAME',
155: avalue => x_supplier_username);
156: end if;

Line 181: x_buyer_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

177: x_buyer_display_name varchar2(240);
178: x_orig_system varchar2(4);
179: begin
180:
181: x_buyer_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
182: itemkey => itemkey,
183: aname => 'BUYER_USER_ID');
184:
185: if x_buyer_id is not null then

Line 199: wf_engine.SetItemAttrText ( itemtype => itemtype,

195: x_buyer_username,
196: x_buyer_display_name);
197: x_progress := '004';
198:
199: wf_engine.SetItemAttrText ( itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'BUYER_USER_NAME',
202: avalue => x_buyer_username);
203: end if;

Line 227: wf_engine.SetItemAttrText ( itemtype => itemtype,

223: select inventory_organization_id
224: into x_def_inv_org
225: from financials_system_parameters;
226:
227: wf_engine.SetItemAttrText ( itemtype => itemtype,
228: itemkey => itemkey,
229: aname => 'SHIP_TO_ORGANIZATION_ID',
230: avalue => x_def_inv_org);
231:

Line 252: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

248: x_buyer_id number;
249: x_progress varchar2(3) := '000';
250: begin
251:
252: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
253: itemkey => itemkey,
254: aname => 'ITEM_ID');
255:
256: x_default_inv_org := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 256: x_default_inv_org := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

252: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
253: itemkey => itemkey,
254: aname => 'ITEM_ID');
255:
256: x_default_inv_org := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
257: itemkey => itemkey,
258: aname => 'SHIP_TO_ORGANIZATION_ID');
259:
260: x_progress := '001';

Line 267: wf_engine.SetItemAttrText ( itemtype => itemtype,

263: from mtl_system_items
264: where inventory_item_id = x_item_id
265: and organization_id = x_default_inv_org;
266:
267: wf_engine.SetItemAttrText ( itemtype => itemtype,
268: itemkey => itemkey,
269: aname => 'BUYER_USER_ID',
270: avalue => x_buyer_id);
271:

Line 293: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

289: x_vendor varchar2(80);
290: x_progress varchar2(3) := '000';
291: begin
292: --dbms_output.put_line (' In Get Supplier ');
293: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
294: itemkey => itemkey,
295: aname => 'DOCUMENT_ID');
296:
297: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 297: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

293: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
294: itemkey => itemkey,
295: aname => 'DOCUMENT_ID');
296:
297: x_vendor_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'SUPPLIER_ID');
300:
301: --if x_document_id is not null and x_vendor_id is null then

Line 340: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

336: select vendor_name into x_vendor
337: from po_vendors
338: where vendor_id = x_vendor_id;
339:
340: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'SUPPLIER_ID',
343: avalue => x_vendor_id);
344:

Line 345: wf_engine.SetItemAttrText ( itemtype => itemtype,

341: itemkey => itemkey,
342: aname => 'SUPPLIER_ID',
343: avalue => x_vendor_id);
344:
345: wf_engine.SetItemAttrText ( itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'SUPPLIER',
348: avalue => x_vendor);
349: exception

Line 386: wf_engine.abortprocess (l_item_type, l_item_key);

382: l_item_key := 'POS_ACK_' || to_char (x_document_id) || '_' || to_char(x_doc_revision);
383:
384: begin
385: -- Abort process if it exists
386: wf_engine.abortprocess (l_item_type, l_item_key);
387: exception
388: when others then
389: null;
390: end;