eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WIP_OSP_SHP_I_WF dependencies on WF_ENGINE

Line 67: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

63: into l_primary_uom
64: from mtl_units_of_measure
65: where uom_code = p_primary_uom;
66: */
67: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
68: , itemkey => p_itemkey
69: , aname => 'WIP_ENTITY_ID'
70: , avalue => p_wip_entity_id);
71:

Line 72: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

68: , itemkey => p_itemkey
69: , aname => 'WIP_ENTITY_ID'
70: , avalue => p_wip_entity_id);
71:
72: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
73: , itemkey => p_itemkey
74: , aname => 'REP_SCHEDULE_ID'
75: , avalue => p_rep_sched_id);
76:

Line 77: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

73: , itemkey => p_itemkey
74: , aname => 'REP_SCHEDULE_ID'
75: , avalue => p_rep_sched_id);
76:
77: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
78: , itemkey => p_itemkey
79: , aname => 'ORGANIZATION_ID'
80: , avalue => p_organization_id);
81:

Line 85: wf_engine.SetItemAttrText( itemtype => p_itemtype

81:
82: IF l_wip_entity_type = WIP_CONSTANTS.DISCRETE or
83: l_wip_entity_type = WIP_CONSTANTS.CLOSED_DISC THEN
84:
85: wf_engine.SetItemAttrText( itemtype => p_itemtype
86: , itemkey => p_itemkey
87: , aname => 'JOB_NAME'
88: , avalue => l_wip_entity_name);
89: elsif l_wip_entity_type = WIP_CONSTANTS.REPETITIVE THEN

Line 99: wf_engine.SetItemAttrText( itemtype => p_itemtype

95: and wrs.organization_id = p_organization_id
96: and wl.line_id = wrs.line_id
97: and wl.organization_id = wrs.organization_id;
98:
99: wf_engine.SetItemAttrText( itemtype => p_itemtype
100: , itemkey => p_itemkey
101: , aname => 'LINE_NAME'
102: , avalue => l_line_name);
103: END IF;

Line 105: wf_engine.SetItemAttrText( itemtype => p_itemtype

101: , aname => 'LINE_NAME'
102: , avalue => l_line_name);
103: END IF;
104:
105: wf_engine.SetItemAttrText( itemtype => p_itemtype
106: , itemkey => p_itemkey
107: , aname => 'ASSY'
108: , avalue => l_primary_item_name);
109:

Line 110: wf_engine.SetItemAttrText( itemtype => p_itemtype

106: , itemkey => p_itemkey
107: , aname => 'ASSY'
108: , avalue => l_primary_item_name);
109:
110: wf_engine.SetItemAttrText( itemtype => p_itemtype
111: , itemkey => p_itemkey
112: , aname => 'ASSY_DESC'
113: , avalue => l_primary_item_desc);
114:

Line 115: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

111: , itemkey => p_itemkey
112: , aname => 'ASSY_DESC'
113: , avalue => l_primary_item_desc);
114:
115: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
116: , itemkey => p_itemkey
117: , aname => 'PRIMARY_QTY'
118: , avalue => p_primary_qty);
119:

Line 120: wf_engine.SetItemAttrText( itemtype => p_itemtype

116: , itemkey => p_itemkey
117: , aname => 'PRIMARY_QTY'
118: , avalue => p_primary_qty);
119:
120: wf_engine.SetItemAttrText( itemtype => p_itemtype
121: , itemkey => p_itemkey
122: , aname => 'PRIMARY_UOM'
123: , avalue => p_primary_uom);
124:

Line 125: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

121: , itemkey => p_itemkey
122: , aname => 'PRIMARY_UOM'
123: , avalue => p_primary_uom);
124:
125: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
126: , itemkey => p_itemkey
127: , aname => 'WIP_OP_SEQ'
128: , avalue => p_op_seq_num);
129:

Line 130: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

126: , itemkey => p_itemkey
127: , aname => 'WIP_OP_SEQ'
128: , avalue => p_op_seq_num);
129:
130: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
131: , itemkey => p_itemkey
132: , aname => 'OSP_ITEM_ID'
133: , avalue => l_osp_item_id);
134:

Line 135: wf_engine.SetItemAttrText( itemtype => p_itemtype

131: , itemkey => p_itemkey
132: , aname => 'OSP_ITEM_ID'
133: , avalue => l_osp_item_id);
134:
135: wf_engine.SetItemAttrText( itemtype => p_itemtype
136: , itemkey => p_itemkey
137: , aname => 'OSP_ITEM'
138: , avalue => l_osp_item);
139:

Line 140: wf_engine.SetItemAttrText( itemtype => p_itemtype

136: , itemkey => p_itemkey
137: , aname => 'OSP_ITEM'
138: , avalue => l_osp_item);
139:
140: wf_engine.SetItemAttrText( itemtype => p_itemtype
141: , itemkey => p_itemkey
142: , aname => 'OSP_ITEM_DESC'
143: , avalue => l_osp_item_desc);
144:

Line 145: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

141: , itemkey => p_itemkey
142: , aname => 'OSP_ITEM_DESC'
143: , avalue => l_osp_item_desc);
144:
145: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
146: , itemkey => p_itemkey
147: , aname => 'USER_ID'
148: , avalue => p_user_id);
149:

Line 150: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

146: , itemkey => p_itemkey
147: , aname => 'USER_ID'
148: , avalue => p_user_id);
149:
150: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
151: , itemkey => p_itemkey
152: , aname => 'RESP_ID'
153: , avalue => p_resp_id);
154:

Line 155: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

151: , itemkey => p_itemkey
152: , aname => 'RESP_ID'
153: , avalue => p_resp_id);
154:
155: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
156: , itemkey => p_itemkey
157: , aname => 'RESP_APPL_ID'
158: , avalue => p_resp_appl_id);
159:

Line 160: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

156: , itemkey => p_itemkey
157: , aname => 'RESP_APPL_ID'
158: , avalue => p_resp_appl_id);
159:
160: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
161: , itemkey => p_itemkey
162: , aname => 'SECURITY_GROUP_ID'
163: , avalue => p_security_group_id);
164: exception

Line 214: wf_engine.CreateProcess( itemtype => p_itemtype

210: into p_itemkey
211: from dual;
212: end if;
213:
214: wf_engine.CreateProcess( itemtype => p_itemtype
215: , itemkey => p_itemkey
216: , process => p_workflow_process );
217:
218: SetStartupWFAttributes ( p_itemtype => p_itemtype

Line 231: wf_engine.StartProcess( itemtype => p_itemtype,

227: , p_resp_id => l_resp_id
228: , p_resp_appl_id => l_resp_appl_id
229: , p_security_group_id => l_security_group_id);
230:
231: wf_engine.StartProcess( itemtype => p_itemtype,
232: itemkey => p_itemkey );
233:
234: /* May need to add the following line in, to prevent any bottleneck */
235: /* wf_engine.threshold := -1;*/

Line 235: /* wf_engine.threshold := -1;*/

231: wf_engine.StartProcess( itemtype => p_itemtype,
232: itemkey => p_itemkey );
233:
234: /* May need to add the following line in, to prevent any bottleneck */
235: /* wf_engine.threshold := -1;*/
236: exception
237: when others then
238: wf_core.context('WIP_OSP_SHP_I_WF', 'startWFProcess', p_itemtype, p_itemkey);
239: raise;

Line 260: wf_engine.GetItemAttrText( p_itemtype

256: , p_security_group_id out nocopy number) is
257: begin
258:
259: p_wip_entity_id :=
260: wf_engine.GetItemAttrText( p_itemtype
261: , p_itemkey
262: , 'WIP_ENTITY_ID');
263: p_rep_sched_id :=
264: wf_engine.GetItemAttrNumber( p_itemtype

Line 264: wf_engine.GetItemAttrNumber( p_itemtype

260: wf_engine.GetItemAttrText( p_itemtype
261: , p_itemkey
262: , 'WIP_ENTITY_ID');
263: p_rep_sched_id :=
264: wf_engine.GetItemAttrNumber( p_itemtype
265: , p_itemkey
266: , 'REP_SCHEDULE_ID');
267: p_organization_id :=
268: wf_engine.GetItemAttrNumber( p_itemtype

Line 268: wf_engine.GetItemAttrNumber( p_itemtype

264: wf_engine.GetItemAttrNumber( p_itemtype
265: , p_itemkey
266: , 'REP_SCHEDULE_ID');
267: p_organization_id :=
268: wf_engine.GetItemAttrNumber( p_itemtype
269: , p_itemkey
270: , 'ORGANIZATION_ID');
271: p_primary_qty :=
272: wf_engine.GetItemAttrNumber( p_itemtype

Line 272: wf_engine.GetItemAttrNumber( p_itemtype

268: wf_engine.GetItemAttrNumber( p_itemtype
269: , p_itemkey
270: , 'ORGANIZATION_ID');
271: p_primary_qty :=
272: wf_engine.GetItemAttrNumber( p_itemtype
273: , p_itemkey
274: , 'PRIMARY_QTY');
275: p_primary_uom :=
276: wf_engine.GetItemAttrText( p_itemtype

Line 276: wf_engine.GetItemAttrText( p_itemtype

272: wf_engine.GetItemAttrNumber( p_itemtype
273: , p_itemkey
274: , 'PRIMARY_QTY');
275: p_primary_uom :=
276: wf_engine.GetItemAttrText( p_itemtype
277: , p_itemkey
278: , 'PRIMARY_UOM');
279: p_osp_operation :=
280: wf_engine.GetItemAttrText( p_itemtype

Line 280: wf_engine.GetItemAttrText( p_itemtype

276: wf_engine.GetItemAttrText( p_itemtype
277: , p_itemkey
278: , 'PRIMARY_UOM');
279: p_osp_operation :=
280: wf_engine.GetItemAttrText( p_itemtype
281: , p_itemkey
282: , 'WIP_OP_SEQ');
283: p_user_id :=
284: wf_engine.GetItemAttrNumber( p_itemtype

Line 284: wf_engine.GetItemAttrNumber( p_itemtype

280: wf_engine.GetItemAttrText( p_itemtype
281: , p_itemkey
282: , 'WIP_OP_SEQ');
283: p_user_id :=
284: wf_engine.GetItemAttrNumber( p_itemtype
285: , p_itemkey
286: , 'USER_ID');
287: p_resp_id :=
288: wf_engine.GetItemAttrNumber( p_itemtype

Line 288: wf_engine.GetItemAttrNumber( p_itemtype

284: wf_engine.GetItemAttrNumber( p_itemtype
285: , p_itemkey
286: , 'USER_ID');
287: p_resp_id :=
288: wf_engine.GetItemAttrNumber( p_itemtype
289: , p_itemkey
290: , 'RESP_ID');
291: p_resp_appl_id :=
292: wf_engine.GetItemAttrNumber( p_itemtype

Line 292: wf_engine.GetItemAttrNumber( p_itemtype

288: wf_engine.GetItemAttrNumber( p_itemtype
289: , p_itemkey
290: , 'RESP_ID');
291: p_resp_appl_id :=
292: wf_engine.GetItemAttrNumber( p_itemtype
293: , p_itemkey
294: , 'RESP_APPL_ID');
295: p_security_group_id :=
296: wf_engine.GetItemAttrNumber( p_itemtype

Line 296: wf_engine.GetItemAttrNumber( p_itemtype

292: wf_engine.GetItemAttrNumber( p_itemtype
293: , p_itemkey
294: , 'RESP_APPL_ID');
295: p_security_group_id :=
296: wf_engine.GetItemAttrNumber( p_itemtype
297: , p_itemkey
298: , 'SECURITY_GROUP_ID');
299: exception
300: when others then

Line 329: wf_engine.GetItemAttrNumber ( itemtype

325:
326: begin
327:
328: l_wip_entity_id :=
329: wf_engine.GetItemAttrNumber ( itemtype
330: , itemkey
331: , 'WIP_ENTITY_ID');
332:
333: open req_to_import(l_wip_entity_id);

Line 340: wf_engine.GetItemAttrNumber( itemtype

336: IF (req_to_import%NOTFOUND) then
337: resultout := 'COMPLETE:N';
338: ELSE
339: l_user_id :=
340: wf_engine.GetItemAttrNumber( itemtype
341: , itemkey
342: , 'USER_ID');
343: l_resp_id :=
344: wf_engine.GetItemAttrNumber( itemtype

Line 344: wf_engine.GetItemAttrNumber( itemtype

340: wf_engine.GetItemAttrNumber( itemtype
341: , itemkey
342: , 'USER_ID');
343: l_resp_id :=
344: wf_engine.GetItemAttrNumber( itemtype
345: , itemkey
346: , 'RESP_ID');
347: l_resp_appl_id :=
348: wf_engine.GetItemAttrNumber( itemtype

Line 348: wf_engine.GetItemAttrNumber( itemtype

344: wf_engine.GetItemAttrNumber( itemtype
345: , itemkey
346: , 'RESP_ID');
347: l_resp_appl_id :=
348: wf_engine.GetItemAttrNumber( itemtype
349: , itemkey
350: , 'RESP_APPL_ID');
351: l_security_group_id :=
352: wf_engine.GetItemAttrNumber( itemtype

Line 352: wf_engine.GetItemAttrNumber( itemtype

348: wf_engine.GetItemAttrNumber( itemtype
349: , itemkey
350: , 'RESP_APPL_ID');
351: l_security_group_id :=
352: wf_engine.GetItemAttrNumber( itemtype
353: , itemkey
354: , 'SECURITY_GROUP_ID');
355:
356: fnd_global.apps_initialize (

Line 396: wf_engine.GetItemAttrText ( p_itemtype

392: l_record_number := p_rec_num;
393: END IF;
394:
395: p_buyer :=
396: wf_engine.GetItemAttrText ( p_itemtype
397: , p_itemkey
398: , 'BUYER' || l_record_number);
399: p_po_number :=
400: wf_engine.GetItemAttrText ( p_itemtype

Line 400: wf_engine.GetItemAttrText ( p_itemtype

396: wf_engine.GetItemAttrText ( p_itemtype
397: , p_itemkey
398: , 'BUYER' || l_record_number);
399: p_po_number :=
400: wf_engine.GetItemAttrText ( p_itemtype
401: , p_itemkey
402: , 'PO_NUM' || l_record_number);
403: p_po_header_id :=
404: wf_engine.GetItemAttrNumber ( p_itemtype

Line 404: wf_engine.GetItemAttrNumber ( p_itemtype

400: wf_engine.GetItemAttrText ( p_itemtype
401: , p_itemkey
402: , 'PO_NUM' || l_record_number);
403: p_po_header_id :=
404: wf_engine.GetItemAttrNumber ( p_itemtype
405: , p_itemkey
406: , 'PO_HEADER_ID' || l_record_number);
407: p_po_distribution_id :=
408: wf_engine.GetItemAttrNumber ( p_itemtype

Line 408: wf_engine.GetItemAttrNumber ( p_itemtype

404: wf_engine.GetItemAttrNumber ( p_itemtype
405: , p_itemkey
406: , 'PO_HEADER_ID' || l_record_number);
407: p_po_distribution_id :=
408: wf_engine.GetItemAttrNumber ( p_itemtype
409: , p_itemkey
410: , 'PO_DISTRIBUTION_ID' || l_record_number);
411: p_org_id :=
412: wf_engine.GetItemAttrNumber ( p_itemtype

Line 412: wf_engine.GetItemAttrNumber ( p_itemtype

408: wf_engine.GetItemAttrNumber ( p_itemtype
409: , p_itemkey
410: , 'PO_DISTRIBUTION_ID' || l_record_number);
411: p_org_id :=
412: wf_engine.GetItemAttrNumber ( p_itemtype
413: , p_itemkey
414: , 'ORG_ID' || l_record_number);
415: p_po_line_qty :=
416: wf_engine.GetItemAttrNumber ( p_itemtype

Line 416: wf_engine.GetItemAttrNumber ( p_itemtype

412: wf_engine.GetItemAttrNumber ( p_itemtype
413: , p_itemkey
414: , 'ORG_ID' || l_record_number);
415: p_po_line_qty :=
416: wf_engine.GetItemAttrNumber ( p_itemtype
417: , p_itemkey
418: , 'PO_LINE_QTY' || l_record_number);
419: p_po_line_uom :=
420: wf_engine.GetItemAttrText ( p_itemtype

Line 420: wf_engine.GetItemAttrText ( p_itemtype

416: wf_engine.GetItemAttrNumber ( p_itemtype
417: , p_itemkey
418: , 'PO_LINE_QTY' || l_record_number);
419: p_po_line_uom :=
420: wf_engine.GetItemAttrText ( p_itemtype
421: , p_itemkey
422: , 'PO_UOM' || l_record_number);
423: p_subcontractor :=
424: wf_engine.GetItemAttrText ( p_itemtype

Line 424: wf_engine.GetItemAttrText ( p_itemtype

420: wf_engine.GetItemAttrText ( p_itemtype
421: , p_itemkey
422: , 'PO_UOM' || l_record_number);
423: p_subcontractor :=
424: wf_engine.GetItemAttrText ( p_itemtype
425: , p_itemkey
426: , 'SUBCONTRACTOR' || l_record_number);
427: p_subcontractor_site :=
428: wf_engine.GetItemAttrText ( p_itemtype

Line 428: wf_engine.GetItemAttrText ( p_itemtype

424: wf_engine.GetItemAttrText ( p_itemtype
425: , p_itemkey
426: , 'SUBCONTRACTOR' || l_record_number);
427: p_subcontractor_site :=
428: wf_engine.GetItemAttrText ( p_itemtype
429: , p_itemkey
430: , 'SUBCONTRACTOR_SITE' || l_record_number);
431: exception
432: when others then

Line 462: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,

458: IF p_rec_num > 1 THEN
459: l_record_number := p_rec_num;
460: END IF;
461:
462: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
463: itemkey => p_itemkey,
464: aname => 'PO_HEADER_ID' || l_record_number,
465: avalue => p_po_header_id);
466:

Line 467: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,

463: itemkey => p_itemkey,
464: aname => 'PO_HEADER_ID' || l_record_number,
465: avalue => p_po_header_id);
466:
467: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
468: itemkey => p_itemkey,
469: aname => 'PO_DISTRIBUTION_ID'|| l_record_number,
470: avalue => p_po_distribution_id);
471:

Line 472: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,

468: itemkey => p_itemkey,
469: aname => 'PO_DISTRIBUTION_ID'|| l_record_number,
470: avalue => p_po_distribution_id);
471:
472: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
473: itemkey => p_itemkey,
474: aname => 'ORG_ID' || l_record_number,
475: avalue => p_org_id);
476:

Line 477: wf_engine.SetItemAttrText( itemtype => p_itemtype,

473: itemkey => p_itemkey,
474: aname => 'ORG_ID' || l_record_number,
475: avalue => p_org_id);
476:
477: wf_engine.SetItemAttrText( itemtype => p_itemtype,
478: itemkey => p_itemkey,
479: aname => 'BUYER' || l_record_number,
480: avalue => p_buyer);
481:

Line 482: wf_engine.SetItemAttrText( itemtype => p_itemtype,

478: itemkey => p_itemkey,
479: aname => 'BUYER' || l_record_number,
480: avalue => p_buyer);
481:
482: wf_engine.SetItemAttrText( itemtype => p_itemtype,
483: itemkey => p_itemkey,
484: aname => 'SUBCONTRACTOR_SITE' || l_record_number,
485: avalue => p_subcontractor_site);
486:

Line 487: wf_engine.SetItemAttrText( itemtype => p_itemtype,

483: itemkey => p_itemkey,
484: aname => 'SUBCONTRACTOR_SITE' || l_record_number,
485: avalue => p_subcontractor_site);
486:
487: wf_engine.SetItemAttrText( itemtype => p_itemtype,
488: itemkey => p_itemkey,
489: aname => 'PO_NUM' || l_record_number,
490: avalue => p_po_number);
491:

Line 492: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,

488: itemkey => p_itemkey,
489: aname => 'PO_NUM' || l_record_number,
490: avalue => p_po_number);
491:
492: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
493: itemkey => p_itemkey,
494: aname => 'PO_LINE_QTY' || l_record_number,
495: avalue => p_po_line_qty);
496:

Line 497: wf_engine.SetItemAttrText( itemtype => p_itemtype,

493: itemkey => p_itemkey,
494: aname => 'PO_LINE_QTY' || l_record_number,
495: avalue => p_po_line_qty);
496:
497: wf_engine.SetItemAttrText( itemtype => p_itemtype,
498: itemkey => p_itemkey,
499: aname => 'PO_UOM' || l_record_number,
500: avalue => p_po_line_uom);
501:

Line 502: wf_engine.SetItemAttrText( itemtype => p_itemtype,

498: itemkey => p_itemkey,
499: aname => 'PO_UOM' || l_record_number,
500: avalue => p_po_line_uom);
501:
502: wf_engine.SetItemAttrText( itemtype => p_itemtype,
503: itemkey => p_itemkey,
504: aname => 'SUBCONTRACTOR' || l_record_number,
505: avalue => p_subcontractor);
506: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 506: wf_engine.SetItemAttrText( itemtype => p_itemtype,

502: wf_engine.SetItemAttrText( itemtype => p_itemtype,
503: itemkey => p_itemkey,
504: aname => 'SUBCONTRACTOR' || l_record_number,
505: avalue => p_subcontractor);
506: wf_engine.SetItemAttrText( itemtype => p_itemtype,
507: itemkey => p_itemkey,
508: aname => 'REQUIRED_ASSY_QTY' ||l_record_number,
509: avalue => p_required_assy_qty);
510:

Line 687: l_wip_entity_id := wf_engine.GetItemAttrNumber ( itemtype,

683: l_open_reqs VARCHAR2(2000);
684: l_release_num NUMBER ;
685: l_required_assy_qty NUMBER;
686: begin
687: l_wip_entity_id := wf_engine.GetItemAttrNumber ( itemtype,
688: itemkey,
689: 'WIP_ENTITY_ID');
690: l_rep_sched_id := wf_engine.GetItemAttrNumber ( itemtype,
691: itemkey,

Line 690: l_rep_sched_id := wf_engine.GetItemAttrNumber ( itemtype,

686: begin
687: l_wip_entity_id := wf_engine.GetItemAttrNumber ( itemtype,
688: itemkey,
689: 'WIP_ENTITY_ID');
690: l_rep_sched_id := wf_engine.GetItemAttrNumber ( itemtype,
691: itemkey,
692: 'REP_SCHEDULE_ID');
693: l_osp_operation_num := wf_engine.GetItemAttrNumber ( itemtype,
694: itemkey,

Line 693: l_osp_operation_num := wf_engine.GetItemAttrNumber ( itemtype,

689: 'WIP_ENTITY_ID');
690: l_rep_sched_id := wf_engine.GetItemAttrNumber ( itemtype,
691: itemkey,
692: 'REP_SCHEDULE_ID');
693: l_osp_operation_num := wf_engine.GetItemAttrNumber ( itemtype,
694: itemkey,
695: 'WIP_OP_SEQ');
696: l_num_of_po := 0;
697:

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

742:
743: l_open_reqs := c_req_rec.req_num || ', ' || l_open_reqs ;
744: END LOOP;
745:
746: wf_engine.SetItemAttrNumber( itemtype => itemtype,
747: itemkey => itemkey,
748: aname => 'NUM_OF_POS',
749: avalue => l_num_of_po);
750:

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

747: itemkey => itemkey,
748: aname => 'NUM_OF_POS',
749: avalue => l_num_of_po);
750:
751: wf_engine.SetItemAttrText ( itemtype => itemtype,
752: itemkey => itemkey,
753: aname => 'NON_APPROVED_POS',
754: avalue => substr(l_non_approved_pos,1,length(l_non_approved_pos)-2));
755:

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

752: itemkey => itemkey,
753: aname => 'NON_APPROVED_POS',
754: avalue => substr(l_non_approved_pos,1,length(l_non_approved_pos)-2));
755:
756: wf_engine.SetItemAttrText ( itemtype => itemtype,
757: itemkey => itemkey,
758: aname => 'OPEN_REQS',
759: avalue => substr(l_open_reqs,1,length(l_open_reqs)-2));
760:

Line 764: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,

760:
761: if l_num_of_po = 0 then
762: resultout:='COMPLETE:NONE';
763: elsif l_num_of_po = 1 then
764: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
765: itemkey,
766: 'PRIMARY_QTY');
767:
768: wf_engine.SetItemAttrNumber( itemtype => itemtype,

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

764: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
765: itemkey,
766: 'PRIMARY_QTY');
767:
768: wf_engine.SetItemAttrNumber( itemtype => itemtype,
769: itemkey => itemkey,
770: aname => 'SHIP_QTY',
771: avalue => l_primary_qty);
772:

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

774: fnd_message.set_name ('WIP', 'WIP_SHP_GTR_THAN_PO_QTY');
775: msg := fnd_message.get;
776: end if;
777:
778: wf_engine.SetItemAttrText( itemtype => itemtype,
779: itemkey => itemkey,
780: aname => 'NOT_VALID_MESG',
781: avalue => msg);
782:

Line 814: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,

810: l_ship_qty NUMBER;
811: msg VARCHAR2(2000);
812:
813: begin
814: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
815: itemkey,
816: 'PRIMARY_QTY');
817:
818: l_primary_uom := wf_engine.GetItemAttrText ( itemtype,

Line 818: l_primary_uom := wf_engine.GetItemAttrText ( itemtype,

814: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
815: itemkey,
816: 'PRIMARY_QTY');
817:
818: l_primary_uom := wf_engine.GetItemAttrText ( itemtype,
819: itemkey,
820: 'PRIMARY_UOM');
821:
822: l_num_of_pos := wf_engine.GetItemAttrText ( itemtype,

Line 822: l_num_of_pos := wf_engine.GetItemAttrText ( itemtype,

818: l_primary_uom := wf_engine.GetItemAttrText ( itemtype,
819: itemkey,
820: 'PRIMARY_UOM');
821:
822: l_num_of_pos := wf_engine.GetItemAttrText ( itemtype,
823: itemkey,
824: 'NUM_OF_POS');
825:
826: l_osp_item_id := wf_engine.GetItemAttrNumber ( itemtype,

Line 826: l_osp_item_id := wf_engine.GetItemAttrNumber ( itemtype,

822: l_num_of_pos := wf_engine.GetItemAttrText ( itemtype,
823: itemkey,
824: 'NUM_OF_POS');
825:
826: l_osp_item_id := wf_engine.GetItemAttrNumber ( itemtype,
827: itemkey,
828: 'OSP_ITEM_ID');
829:
830: for i in 1..l_num_of_pos loop

Line 833: l_ship_qty := wf_engine.GetItemAttrNumber ( itemtype,

829:
830: for i in 1..l_num_of_pos loop
831:
832:
833: l_ship_qty := wf_engine.GetItemAttrNumber ( itemtype,
834: itemkey,
835: 'PO_QTY' || i);
836:
837: /* if the buyer has not entered in a number for PO Quantity or

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

850: -- Get Error message to be displayed in notifications
851: fnd_message.set_name ('WIP', 'WIP_QTY_NOT_VALID');
852: msg := fnd_message.get;
853:
854: wf_engine.SetItemAttrText( itemtype => itemtype,
855: itemkey => itemkey,
856: aname => 'NOT_VALID_MESG',
857: avalue => msg);
858:

Line 908: num_of_proc := wf_engine.GetItemAttrNumber ( itemtype,

904: l_resp_appl_id NUMBER;
905: l_security_group_id NUMBER;
906: begin
907:
908: num_of_proc := wf_engine.GetItemAttrNumber ( itemtype,
909: itemkey,
910: 'NUM_OF_POS');
911:
912:

Line 935: l_ship_qty := wf_engine.GetItemAttrNumber ( itemtype,

931: select to_char(wip_workflow_s.nextval)
932: into childkey
933: from dual;
934:
935: l_ship_qty := wf_engine.GetItemAttrNumber ( itemtype,
936: itemkey,
937: 'PO_QTY' || i);
938:
939: /* if ship_qty is null or = 0 then there is no need

Line 946: wf_engine.CreateProcess( itemtype => itemtype,

942:
943: if (l_ship_qty is not null and l_ship_qty <> 0) then
944:
945:
946: wf_engine.CreateProcess( itemtype => itemtype,
947: itemkey => childkey,
948: process => 'SHIP_INTERMEDIATE');
949:
950:

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

947: itemkey => childkey,
948: process => 'SHIP_INTERMEDIATE');
949:
950:
951: wf_engine.SetItemAttrText( itemtype => itemtype,
952: itemkey => childkey,
953: aname => 'PARENT_ITEMKEY',
954: avalue => itemkey);
955:

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

991: , p_po_line_uom => l_po_line_uom
992: , p_subcontractor => l_subcontractor
993: , p_subcontractor_site => l_subcontractor_site);
994:
995: wf_engine.SetItemAttrText( itemtype => itemtype,
996: itemkey => childkey,
997: aname => 'SHIP_QTY',
998: avalue => l_ship_qty);
999:

Line 1000: wf_engine.StartProcess( itemtype => itemtype,

996: itemkey => childkey,
997: aname => 'SHIP_QTY',
998: avalue => l_ship_qty);
999:
1000: wf_engine.StartProcess( itemtype => itemtype,
1001: itemkey => childkey );
1002: end if; /* ship_qty is not null or ship_qty != 0 */
1003:
1004: end loop;

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

1017: funcmode in varchar2,
1018: resultout out nocopy varchar2) is
1019:
1020: l_organization_id number :=
1021: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1022: itemkey => itemkey,
1023: aname => 'ORGANIZATION_ID');
1024:
1025: l_ship_from_2nd_sub varchar2(1) :=

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

1022: itemkey => itemkey,
1023: aname => 'ORGANIZATION_ID');
1024:
1025: l_ship_from_2nd_sub varchar2(1) :=
1026: wf_engine.GetItemAttrText (itemtype => itemtype,
1027: itemkey => itemkey,
1028: aname => 'SHIPPED_FROM_2ND_SUB');
1029:
1030: l_ship_manager varchar2(80) := NULL;

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

1043: l_ship_manager :=
1044: wip_std_wf.GetShipManagerLogin(l_organization_id);
1045:
1046: if (l_ship_manager is not null) then
1047: wf_engine.SetItemAttrText( itemtype => itemtype,
1048: itemkey => itemkey,
1049: aname => 'SHIPPING_MANAGER',
1050: avalue => l_ship_manager);
1051: resultout := 'COMPLETE:WIP_FOUND';

Line 1075: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype,

1071: l_po_header_id NUMBER;
1072: l_address VARCHAR2(1000);
1073:
1074: begin
1075: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype,
1076: itemkey,
1077: 'PO_HEADER_ID');
1078:
1079: select ap_vendor_sites_pkg.format_address (pvs.country,

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

1086: where ph.po_header_id = l_po_header_id
1087: and pvs.org_id = ph.org_id
1088: and pvs.vendor_site_id = ph.vendor_site_id;
1089:
1090: wf_engine.SetItemAttrText( itemtype => itemtype,
1091: itemkey => itemkey,
1092: aname => 'ADDRESS',
1093: avalue => l_address);
1094:

Line 1200: wf_engine.CreateProcess( itemtype => l_itemtype

1196: select to_char(wip_workflow_s.nextval)
1197: into l_itemkey
1198: from dual;
1199:
1200: wf_engine.CreateProcess( itemtype => l_itemtype
1201: , itemkey => l_itemkey
1202: , process => 'NOTIFY_2ND_BUYER_SUPPLIER' );
1203:
1204: open GetWIPData (p_po_distribution_id);

Line 1245: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1241: p_po_line_uom => l_po_line_uom,
1242: p_subcontractor => l_subcontractor_name,
1243: p_subcontractor_site => l_subcontractor_site);
1244:
1245: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1246: , itemkey => l_itemkey
1247: , aname => 'PO_DISTRIBUTION_ID'
1248: , avalue => p_po_distribution_id);
1249:

Line 1250: wf_engine.SetItemAttrText( itemtype => l_itemtype

1246: , itemkey => l_itemkey
1247: , aname => 'PO_DISTRIBUTION_ID'
1248: , avalue => p_po_distribution_id);
1249:
1250: wf_engine.SetItemAttrText( itemtype => l_itemtype
1251: , itemkey => l_itemkey
1252: , aname => 'SHIPPED_FROM_2ND_SUB'
1253: , avalue => 'Y');
1254:

Line 1255: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1251: , itemkey => l_itemkey
1252: , aname => 'SHIPPED_FROM_2ND_SUB'
1253: , avalue => 'Y');
1254:
1255: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1256: , itemkey => l_itemkey
1257: , aname => 'SHIP_QTY'
1258: , avalue => p_shipped_qty);
1259: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1259: wf_engine.SetItemAttrText( itemtype => l_itemtype

1255: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1256: , itemkey => l_itemkey
1257: , aname => 'SHIP_QTY'
1258: , avalue => p_shipped_qty);
1259: wf_engine.SetItemAttrText( itemtype => l_itemtype
1260: , itemkey => l_itemkey
1261: , aname => 'PRIMARY_UOM'
1262: , avalue => p_shipped_uom);
1263:

Line 1266: wf_engine.SetItemAttrDate( itemtype => l_itemtype

1262: , avalue => p_shipped_uom);
1263:
1264: /* Set up data for ASN */
1265:
1266: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1267: , itemkey => l_itemkey
1268: , aname => 'SHIPPED_DATE'
1269: , avalue => p_shipped_date);
1270: wf_engine.SetItemAttrDate( itemtype => l_itemtype

Line 1270: wf_engine.SetItemAttrDate( itemtype => l_itemtype

1266: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1267: , itemkey => l_itemkey
1268: , aname => 'SHIPPED_DATE'
1269: , avalue => p_shipped_date);
1270: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1271: , itemkey => l_itemkey
1272: , aname => 'EXPECTED_RECEIPT_DATE'
1273: , avalue => p_expected_receipt_date);
1274: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1274: wf_engine.SetItemAttrText( itemtype => l_itemtype

1270: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1271: , itemkey => l_itemkey
1272: , aname => 'EXPECTED_RECEIPT_DATE'
1273: , avalue => p_expected_receipt_date);
1274: wf_engine.SetItemAttrText( itemtype => l_itemtype
1275: , itemkey => l_itemkey
1276: , aname => 'PACKING_SLIP'
1277: , avalue => p_packing_slip);
1278: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1278: wf_engine.SetItemAttrText( itemtype => l_itemtype

1274: wf_engine.SetItemAttrText( itemtype => l_itemtype
1275: , itemkey => l_itemkey
1276: , aname => 'PACKING_SLIP'
1277: , avalue => p_packing_slip);
1278: wf_engine.SetItemAttrText( itemtype => l_itemtype
1279: , itemkey => l_itemkey
1280: , aname => 'AIRBILL_WAYBILL_NUM'
1281: , avalue => p_airbill_waybill);
1282: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1282: wf_engine.SetItemAttrText( itemtype => l_itemtype

1278: wf_engine.SetItemAttrText( itemtype => l_itemtype
1279: , itemkey => l_itemkey
1280: , aname => 'AIRBILL_WAYBILL_NUM'
1281: , avalue => p_airbill_waybill);
1282: wf_engine.SetItemAttrText( itemtype => l_itemtype
1283: , itemkey => l_itemkey
1284: , aname => 'BILL_OF_LADING'
1285: , avalue => p_bill_of_lading);
1286: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1286: wf_engine.SetItemAttrText( itemtype => l_itemtype

1282: wf_engine.SetItemAttrText( itemtype => l_itemtype
1283: , itemkey => l_itemkey
1284: , aname => 'BILL_OF_LADING'
1285: , avalue => p_bill_of_lading);
1286: wf_engine.SetItemAttrText( itemtype => l_itemtype
1287: , itemkey => l_itemkey
1288: , aname => 'PACKAGING_CODE'
1289: , avalue => p_packaging_code);
1290: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1290: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1286: wf_engine.SetItemAttrText( itemtype => l_itemtype
1287: , itemkey => l_itemkey
1288: , aname => 'PACKAGING_CODE'
1289: , avalue => p_packaging_code);
1290: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1291: , itemkey => l_itemkey
1292: , aname => 'NUM_OF_CONTAINER'
1293: , avalue => p_num_of_container);
1294: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1294: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1290: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1291: , itemkey => l_itemkey
1292: , aname => 'NUM_OF_CONTAINER'
1293: , avalue => p_num_of_container);
1294: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1295: , itemkey => l_itemkey
1296: , aname => 'GROSS_WEIGHT'
1297: , avalue => p_gross_weight);
1298: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1298: wf_engine.SetItemAttrText( itemtype => l_itemtype

1294: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1295: , itemkey => l_itemkey
1296: , aname => 'GROSS_WEIGHT'
1297: , avalue => p_gross_weight);
1298: wf_engine.SetItemAttrText( itemtype => l_itemtype
1299: , itemkey => l_itemkey
1300: , aname => 'GROSS_WEIGHT_UOM'
1301: , avalue => p_gross_weight_uom);
1302: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1302: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1298: wf_engine.SetItemAttrText( itemtype => l_itemtype
1299: , itemkey => l_itemkey
1300: , aname => 'GROSS_WEIGHT_UOM'
1301: , avalue => p_gross_weight_uom);
1302: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1303: , itemkey => l_itemkey
1304: , aname => 'NET_WEIGHT'
1305: , avalue => p_net_weight);
1306: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1306: wf_engine.SetItemAttrText( itemtype => l_itemtype

1302: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1303: , itemkey => l_itemkey
1304: , aname => 'NET_WEIGHT'
1305: , avalue => p_net_weight);
1306: wf_engine.SetItemAttrText( itemtype => l_itemtype
1307: , itemkey => l_itemkey
1308: , aname => 'NET_WEIGHT_UOM'
1309: , avalue => p_net_weight_uom);
1310: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1310: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1306: wf_engine.SetItemAttrText( itemtype => l_itemtype
1307: , itemkey => l_itemkey
1308: , aname => 'NET_WEIGHT_UOM'
1309: , avalue => p_net_weight_uom);
1310: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1311: , itemkey => l_itemkey
1312: , aname => 'TAR_WEIGHT'
1313: , avalue => p_tar_weight);
1314: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1314: wf_engine.SetItemAttrText( itemtype => l_itemtype

1310: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1311: , itemkey => l_itemkey
1312: , aname => 'TAR_WEIGHT'
1313: , avalue => p_tar_weight);
1314: wf_engine.SetItemAttrText( itemtype => l_itemtype
1315: , itemkey => l_itemkey
1316: , aname => 'TAR_WEIGHT_UOM'
1317: , avalue => p_tar_weight_uom);
1318: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1318: wf_engine.SetItemAttrText( itemtype => l_itemtype

1314: wf_engine.SetItemAttrText( itemtype => l_itemtype
1315: , itemkey => l_itemkey
1316: , aname => 'TAR_WEIGHT_UOM'
1317: , avalue => p_tar_weight_uom);
1318: wf_engine.SetItemAttrText( itemtype => l_itemtype
1319: , itemkey => l_itemkey
1320: , aname => 'HAZARD_CLASS'
1321: , avalue => p_hazard_class);
1322: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1322: wf_engine.SetItemAttrText( itemtype => l_itemtype

1318: wf_engine.SetItemAttrText( itemtype => l_itemtype
1319: , itemkey => l_itemkey
1320: , aname => 'HAZARD_CLASS'
1321: , avalue => p_hazard_class);
1322: wf_engine.SetItemAttrText( itemtype => l_itemtype
1323: , itemkey => l_itemkey
1324: , aname => 'HAZARD_CODE'
1325: , avalue => p_hazard_code);
1326: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1326: wf_engine.SetItemAttrText( itemtype => l_itemtype

1322: wf_engine.SetItemAttrText( itemtype => l_itemtype
1323: , itemkey => l_itemkey
1324: , aname => 'HAZARD_CODE'
1325: , avalue => p_hazard_code);
1326: wf_engine.SetItemAttrText( itemtype => l_itemtype
1327: , itemkey => l_itemkey
1328: , aname => 'HAZARD_DESCRIPTION'
1329: , avalue => p_hazard_desc);
1330: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1330: wf_engine.SetItemAttrText( itemtype => l_itemtype

1326: wf_engine.SetItemAttrText( itemtype => l_itemtype
1327: , itemkey => l_itemkey
1328: , aname => 'HAZARD_DESCRIPTION'
1329: , avalue => p_hazard_desc);
1330: wf_engine.SetItemAttrText( itemtype => l_itemtype
1331: , itemkey => l_itemkey
1332: , aname => 'SPECIAL_HANDLING_CODE'
1333: , avalue => p_special_handling_code);
1334: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1334: wf_engine.SetItemAttrText( itemtype => l_itemtype

1330: wf_engine.SetItemAttrText( itemtype => l_itemtype
1331: , itemkey => l_itemkey
1332: , aname => 'SPECIAL_HANDLING_CODE'
1333: , avalue => p_special_handling_code);
1334: wf_engine.SetItemAttrText( itemtype => l_itemtype
1335: , itemkey => l_itemkey
1336: , aname => 'FREIGHT_CARRIER'
1337: , avalue => p_freight_carrier);
1338: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1338: wf_engine.SetItemAttrText( itemtype => l_itemtype

1334: wf_engine.SetItemAttrText( itemtype => l_itemtype
1335: , itemkey => l_itemkey
1336: , aname => 'FREIGHT_CARRIER'
1337: , avalue => p_freight_carrier);
1338: wf_engine.SetItemAttrText( itemtype => l_itemtype
1339: , itemkey => l_itemkey
1340: , aname => 'FREIGHT_CARRIER_TERMS'
1341: , avalue => p_freight_carrier_terms);
1342: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1342: wf_engine.SetItemAttrText( itemtype => l_itemtype

1338: wf_engine.SetItemAttrText( itemtype => l_itemtype
1339: , itemkey => l_itemkey
1340: , aname => 'FREIGHT_CARRIER_TERMS'
1341: , avalue => p_freight_carrier_terms);
1342: wf_engine.SetItemAttrText( itemtype => l_itemtype
1343: , itemkey => l_itemkey
1344: , aname => 'CARRIER_EQUIPMENT'
1345: , avalue => p_carrier_equip);
1346: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1346: wf_engine.SetItemAttrText( itemtype => l_itemtype

1342: wf_engine.SetItemAttrText( itemtype => l_itemtype
1343: , itemkey => l_itemkey
1344: , aname => 'CARRIER_EQUIPMENT'
1345: , avalue => p_carrier_equip);
1346: wf_engine.SetItemAttrText( itemtype => l_itemtype
1347: , itemkey => l_itemkey
1348: , aname => 'CARRIER_METHOD'
1349: , avalue => p_carrier_method);
1350: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1350: wf_engine.SetItemAttrText( itemtype => l_itemtype

1346: wf_engine.SetItemAttrText( itemtype => l_itemtype
1347: , itemkey => l_itemkey
1348: , aname => 'CARRIER_METHOD'
1349: , avalue => p_carrier_method);
1350: wf_engine.SetItemAttrText( itemtype => l_itemtype
1351: , itemkey => l_itemkey
1352: , aname => 'FREIGHT_BILL_NUMBER'
1353: , avalue => p_freight_bill_num);
1354: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1354: wf_engine.SetItemAttrText( itemtype => l_itemtype

1350: wf_engine.SetItemAttrText( itemtype => l_itemtype
1351: , itemkey => l_itemkey
1352: , aname => 'FREIGHT_BILL_NUMBER'
1353: , avalue => p_freight_bill_num);
1354: wf_engine.SetItemAttrText( itemtype => l_itemtype
1355: , itemkey => l_itemkey
1356: , aname => 'RECEIPT_NUMBER'
1357: , avalue => p_receipt_num);
1358: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1358: wf_engine.SetItemAttrText( itemtype => l_itemtype

1354: wf_engine.SetItemAttrText( itemtype => l_itemtype
1355: , itemkey => l_itemkey
1356: , aname => 'RECEIPT_NUMBER'
1357: , avalue => p_receipt_num);
1358: wf_engine.SetItemAttrText( itemtype => l_itemtype
1359: , itemkey => l_itemkey
1360: , aname => 'USSGL_TRANSACTION_CODE'
1361: , avalue => p_ussgl_txn_code);
1362:

Line 1363: wf_engine.StartProcess( itemtype => l_itemtype,

1359: , itemkey => l_itemkey
1360: , aname => 'USSGL_TRANSACTION_CODE'
1361: , avalue => p_ussgl_txn_code);
1362:
1363: wf_engine.StartProcess( itemtype => l_itemtype,
1364: itemkey => l_itemkey );
1365:
1366:
1367: exception

Line 1470: l_po_distribution_id := wf_engine.GetItemAttrNumber ( itemtype,

1466: l_vendor_name VARCHAR2(80);
1467: l_release_num NUMBER ;
1468:
1469: begin
1470: l_po_distribution_id := wf_engine.GetItemAttrNumber ( itemtype,
1471: itemkey,
1472: 'PO_DISTRIBUTION_ID');
1473:
1474: open GetShipToData(l_po_distribution_id);

Line 1506: wf_engine.SetItemAttrNumber( itemtype => itemtype

1502: p_po_line_uom => l_po_line_uom,
1503: p_subcontractor => l_subcontractor_name,
1504: p_subcontractor_site => l_subcontractor_site);
1505:
1506: wf_engine.SetItemAttrNumber( itemtype => itemtype
1507: , itemkey => itemkey
1508: , aname => 'WIP_OP_SEQ'
1509: , avalue => l_next_op_seq);
1510:

Line 1511: wf_engine.SetItemAttrNumber( itemtype => itemtype

1507: , itemkey => itemkey
1508: , aname => 'WIP_OP_SEQ'
1509: , avalue => l_next_op_seq);
1510:
1511: wf_engine.SetItemAttrNumber( itemtype => itemtype
1512: , itemkey => itemkey
1513: , aname => 'OSP_ITEM_ID'
1514: , avalue => l_osp_item_id);
1515:

Line 1516: wf_engine.SetItemAttrText( itemtype => itemtype

1512: , itemkey => itemkey
1513: , aname => 'OSP_ITEM_ID'
1514: , avalue => l_osp_item_id);
1515:
1516: wf_engine.SetItemAttrText( itemtype => itemtype
1517: , itemkey => itemkey
1518: , aname => 'OSP_ITEM'
1519: , avalue => l_osp_item);
1520:

Line 1521: wf_engine.SetItemAttrText( itemtype => itemtype

1517: , itemkey => itemkey
1518: , aname => 'OSP_ITEM'
1519: , avalue => l_osp_item);
1520:
1521: wf_engine.SetItemAttrText( itemtype => itemtype
1522: , itemkey => itemkey
1523: , aname => 'OSP_ITEM_DESC'
1524: , avalue => l_osp_item_desc);
1525: