DBA Data[Home] [Help]

APPS.POS_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 135: x_supplier_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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