DBA Data[Home] [Help]

APPS.WIP_COMMON_WF_PKG dependencies on WF_ENGINE

Line 25: wf_engine.GetItemAttrText( itemtype => itemtype,

21: funcmode in varchar2,
22: resultout out NOCOPY varchar2) is
23:
24: l_po_header_id number :=
25: wf_engine.GetItemAttrText( itemtype => itemtype,
26: itemkey => itemkey,
27: aname => 'PO_HEADER_ID');
28:
29: l_buyer varchar2(100) := NULL;

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

34:
35: l_buyer := wip_std_wf.GetBuyerLogin(l_po_header_id);
36:
37: if (l_buyer is not null) then
38: wf_engine.SetItemAttrText( itemtype => itemtype,
39: itemkey => itemkey,
40: aname => 'BUYER',
41: avalue => l_buyer);
42: resultout := 'COMPLETE:WIP_FOUND';

Line 75: wf_engine.GetItemAttrText( itemtype => itemtype,

71: funcmode in varchar2,
72: resultout out NOCOPY varchar2) is
73:
74: l_po_header_id number :=
75: wf_engine.GetItemAttrText( itemtype => itemtype,
76: itemkey => itemkey,
77: aname => 'PO_HEADER_ID');
78:
79: l_supplier_contact varchar2(100) := NULL;

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

85: l_supplier_contact :=
86: wip_std_wf.GetSupplierContactLogin(l_po_header_id);
87:
88: if (l_supplier_contact is not null) then
89: wf_engine.SetItemAttrText( itemtype => itemtype,
90: itemkey => itemkey,
91: aname => 'SUPPLIER_CONTACT',
92: avalue => l_supplier_contact);
93: resultout := 'COMPLETE:WIP_FOUND';

Line 125: wf_engine.GetItemAttrText( itemtype => itemtype,

121: funcmode in varchar2,
122: resultout out NOCOPY varchar2) is
123:
124: l_organization_id number :=
125: wf_engine.GetItemAttrText( itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'ORGANIZATION_ID');
128:
129: l_prod_scheduler varchar2(80) := NULL;

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

135: l_prod_scheduler :=
136: wip_std_wf.GetProductionSchedLogin(l_organization_id);
137:
138: if (l_prod_scheduler is not null) then
139: wf_engine.SetItemAttrText( itemtype => itemtype,
140: itemkey => itemkey,
141: aname => 'PRODUCTION_SCHEDULER',
142: avalue => l_prod_scheduler);
143: resultout := 'COMPLETE:WIP_FOUND';

Line 176: wf_engine.GetItemAttrNumber( itemtype => itemtype,

172: funcmode in varchar2,
173: resultout out NOCOPY varchar2) is
174:
175: l_organization_id number :=
176: wf_engine.GetItemAttrNumber( itemtype => itemtype,
177: itemkey => itemkey,
178: aname => 'ORGANIZATION_ID');
179:
180: l_ship_manager varchar2(80) := NULL;

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

186: l_ship_manager :=
187: wip_std_wf.GetShipManagerLogin(l_organization_id);
188:
189: if (l_ship_manager is not null) then
190: wf_engine.SetItemAttrText( itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'SHIPPING_MANAGER',
193: avalue => l_ship_manager);
194: resultout := 'COMPLETE:WIP_FOUND';

Line 228: wf_engine.GetItemAttrNumber( itemtype => itemtype,

224: funcmode in varchar2,
225: resultout out NOCOPY varchar2) is
226:
227: l_organization_id number :=
228: wf_engine.GetItemAttrNumber( itemtype => itemtype,
229: itemkey => itemkey,
230: aname => 'ORGANIZATION_ID');
231:
232: l_osp_item_id number :=

Line 233: wf_engine.GetItemAttrNumber ( itemtype => itemtype,

229: itemkey => itemkey,
230: aname => 'ORGANIZATION_ID');
231:
232: l_osp_item_id number :=
233: wf_engine.GetItemAttrNumber ( itemtype => itemtype,
234: itemkey => itemkey,
235: aname => 'OSP_ITEM_ID');
236:
237: l_default_buyer varchar2(80) := NULL;

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

243: wip_std_wf.GetDefaultBuyerLogin(p_organization_id => l_organization_id,
244: p_item_id => l_osp_item_id);
245:
246: if (l_default_buyer is not null) then
247: wf_engine.SetItemAttrText( itemtype => itemtype,
248: itemkey => itemkey,
249: aname => 'BUYER',
250: avalue => l_default_buyer);
251: resultout := 'COMPLETE:WIP_FOUND';

Line 310: l_po_distribution_id := wf_engine.GetItemAttrNumber(

306: BEGIN
307:
308: if (funcmode = 'RUN') then
309:
310: l_po_distribution_id := wf_engine.GetItemAttrNumber(
311: itemtype => itemtype,
312: itemkey => itemkey,
313: aname => 'PO_DISTRIBUTION_ID');
314:

Line 315: l_wip_entity_id := wf_engine.GetItemAttrNumber(

311: itemtype => itemtype,
312: itemkey => itemkey,
313: aname => 'PO_DISTRIBUTION_ID');
314:
315: l_wip_entity_id := wf_engine.GetItemAttrNumber(
316: itemtype => itemtype,
317: itemkey => itemkey,
318: aname => 'WIP_ENTITY_ID');
319:

Line 320: l_operation_seq_num := wf_engine.GetItemAttrNumber(

316: itemtype => itemtype,
317: itemkey => itemkey,
318: aname => 'WIP_ENTITY_ID');
319:
320: l_operation_seq_num := wf_engine.GetItemAttrNumber(
321: itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'WIP_OP_SEQ');
324:

Line 325: l_organization_id := wf_engine.GetItemAttrNumber(

321: itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'WIP_OP_SEQ');
324:
325: l_organization_id := wf_engine.GetItemAttrNumber(
326: itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'ORGANIZATION_ID');
329:

Line 330: l_rep_schedule_id := wf_engine.GetItemAttrNumber(

326: itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'ORGANIZATION_ID');
329:
330: l_rep_schedule_id := wf_engine.GetItemAttrNumber(
331: itemtype => itemtype,
332: itemkey => itemkey,
333: aname => 'REP_SCHEDULE_ID');
334:

Line 335: l_org_id := wf_engine.GetItemAttrNumber(

331: itemtype => itemtype,
332: itemkey => itemkey,
333: aname => 'REP_SCHEDULE_ID');
334:
335: l_org_id := wf_engine.GetItemAttrNumber(
336: itemtype => itemtype,
337: itemkey => itemkey,
338: aname => 'ORG_ID');
339:

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

358: p_parameter5 => to_char(l_rep_schedule_id),
359: p_parameter11 => NULL );
360: end if;
361:
362: wf_engine.SetItemAttrText (itemtype => itemtype,
363: itemkey => itemkey,
364: aname => 'PO_NUM_URL',
365: avalue => l_url );
366: