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.

APPS.WIP_OSP_SHP_I_WF dependencies on WF_ENGINE

Line 70: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 75: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 80: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 88: wf_engine.SetItemAttrText( itemtype => p_itemtype

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

Line 102: wf_engine.SetItemAttrText( itemtype => p_itemtype

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

Line 108: wf_engine.SetItemAttrText( itemtype => p_itemtype

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

Line 113: wf_engine.SetItemAttrText( itemtype => p_itemtype

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

Line 118: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 123: wf_engine.SetItemAttrText( itemtype => p_itemtype

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

Line 128: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 133: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 138: wf_engine.SetItemAttrText( itemtype => p_itemtype

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

Line 143: wf_engine.SetItemAttrText( itemtype => p_itemtype

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

Line 148: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 153: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 158: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

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

Line 163: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

159: , itemkey => p_itemkey
160: , aname => 'RESP_APPL_ID'
161: , avalue => p_resp_appl_id);
162:
163: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
164: , itemkey => p_itemkey
165: , aname => 'SECURITY_GROUP_ID'
166: , avalue => p_security_group_id);
167:

Line 189: wf_engine.SetItemAttrText( itemtype => p_itemtype

185: END;
186:
187: /*Set the REQ_GROUP_BY attribute which is the "Group By" parameter
188: of Requisition Import Concurrent Program*/
189: wf_engine.SetItemAttrText( itemtype => p_itemtype
190: , itemkey => p_itemkey
191: , aname => 'REQ_GROUP_BY'
192: , avalue => l_req_import);
193: /* End of Fix for bug 8919025 (FP 8850950)*/

Line 202: wf_engine.SetItemAttrText( itemtype => p_itemtype

198: else
199: l_init_reqappr := 'Y';
200: end if;
201:
202: wf_engine.SetItemAttrText( itemtype => p_itemtype
203: , itemkey => p_itemkey
204: , aname => 'INIT_REQAPPR'
205: , avalue => l_init_reqappr);
206: /*End of ER 4276433*/

Line 257: wf_engine.CreateProcess( itemtype => p_itemtype

253: into p_itemkey
254: from dual;
255: end if;
256:
257: wf_engine.CreateProcess( itemtype => p_itemtype
258: , itemkey => p_itemkey
259: , process => p_workflow_process );
260:
261: SetStartupWFAttributes ( p_itemtype => p_itemtype

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

270: , p_resp_id => l_resp_id
271: , p_resp_appl_id => l_resp_appl_id
272: , p_security_group_id => l_security_group_id);
273:
274: wf_engine.StartProcess( itemtype => p_itemtype,
275: itemkey => p_itemkey );
276:
277: /* May need to add the following line in, to prevent any bottleneck */
278: /* wf_engine.threshold := -1;*/

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

274: wf_engine.StartProcess( itemtype => p_itemtype,
275: itemkey => p_itemkey );
276:
277: /* May need to add the following line in, to prevent any bottleneck */
278: /* wf_engine.threshold := -1;*/
279: exception
280: when others then
281: wf_core.context('WIP_OSP_SHP_I_WF', 'startWFProcess', p_itemtype, p_itemkey);
282: raise;

Line 303: wf_engine.GetItemAttrText( p_itemtype

299: , p_security_group_id out nocopy number) is
300: begin
301:
302: p_wip_entity_id :=
303: wf_engine.GetItemAttrText( p_itemtype
304: , p_itemkey
305: , 'WIP_ENTITY_ID');
306: p_rep_sched_id :=
307: wf_engine.GetItemAttrNumber( p_itemtype

Line 307: wf_engine.GetItemAttrNumber( p_itemtype

303: wf_engine.GetItemAttrText( p_itemtype
304: , p_itemkey
305: , 'WIP_ENTITY_ID');
306: p_rep_sched_id :=
307: wf_engine.GetItemAttrNumber( p_itemtype
308: , p_itemkey
309: , 'REP_SCHEDULE_ID');
310: p_organization_id :=
311: wf_engine.GetItemAttrNumber( p_itemtype

Line 311: wf_engine.GetItemAttrNumber( p_itemtype

307: wf_engine.GetItemAttrNumber( p_itemtype
308: , p_itemkey
309: , 'REP_SCHEDULE_ID');
310: p_organization_id :=
311: wf_engine.GetItemAttrNumber( p_itemtype
312: , p_itemkey
313: , 'ORGANIZATION_ID');
314: p_primary_qty :=
315: wf_engine.GetItemAttrNumber( p_itemtype

Line 315: wf_engine.GetItemAttrNumber( p_itemtype

311: wf_engine.GetItemAttrNumber( p_itemtype
312: , p_itemkey
313: , 'ORGANIZATION_ID');
314: p_primary_qty :=
315: wf_engine.GetItemAttrNumber( p_itemtype
316: , p_itemkey
317: , 'PRIMARY_QTY');
318: p_primary_uom :=
319: wf_engine.GetItemAttrText( p_itemtype

Line 319: wf_engine.GetItemAttrText( p_itemtype

315: wf_engine.GetItemAttrNumber( p_itemtype
316: , p_itemkey
317: , 'PRIMARY_QTY');
318: p_primary_uom :=
319: wf_engine.GetItemAttrText( p_itemtype
320: , p_itemkey
321: , 'PRIMARY_UOM');
322: p_osp_operation :=
323: wf_engine.GetItemAttrText( p_itemtype

Line 323: wf_engine.GetItemAttrText( p_itemtype

319: wf_engine.GetItemAttrText( p_itemtype
320: , p_itemkey
321: , 'PRIMARY_UOM');
322: p_osp_operation :=
323: wf_engine.GetItemAttrText( p_itemtype
324: , p_itemkey
325: , 'WIP_OP_SEQ');
326: p_user_id :=
327: wf_engine.GetItemAttrNumber( p_itemtype

Line 327: wf_engine.GetItemAttrNumber( p_itemtype

323: wf_engine.GetItemAttrText( p_itemtype
324: , p_itemkey
325: , 'WIP_OP_SEQ');
326: p_user_id :=
327: wf_engine.GetItemAttrNumber( p_itemtype
328: , p_itemkey
329: , 'USER_ID');
330: p_resp_id :=
331: wf_engine.GetItemAttrNumber( p_itemtype

Line 331: wf_engine.GetItemAttrNumber( p_itemtype

327: wf_engine.GetItemAttrNumber( p_itemtype
328: , p_itemkey
329: , 'USER_ID');
330: p_resp_id :=
331: wf_engine.GetItemAttrNumber( p_itemtype
332: , p_itemkey
333: , 'RESP_ID');
334: p_resp_appl_id :=
335: wf_engine.GetItemAttrNumber( p_itemtype

Line 335: wf_engine.GetItemAttrNumber( p_itemtype

331: wf_engine.GetItemAttrNumber( p_itemtype
332: , p_itemkey
333: , 'RESP_ID');
334: p_resp_appl_id :=
335: wf_engine.GetItemAttrNumber( p_itemtype
336: , p_itemkey
337: , 'RESP_APPL_ID');
338: p_security_group_id :=
339: wf_engine.GetItemAttrNumber( p_itemtype

Line 339: wf_engine.GetItemAttrNumber( p_itemtype

335: wf_engine.GetItemAttrNumber( p_itemtype
336: , p_itemkey
337: , 'RESP_APPL_ID');
338: p_security_group_id :=
339: wf_engine.GetItemAttrNumber( p_itemtype
340: , p_itemkey
341: , 'SECURITY_GROUP_ID');
342: exception
343: when others then

Line 372: wf_engine.GetItemAttrNumber ( itemtype

368:
369: begin
370:
371: l_wip_entity_id :=
372: wf_engine.GetItemAttrNumber ( itemtype
373: , itemkey
374: , 'WIP_ENTITY_ID');
375:
376: open req_to_import(l_wip_entity_id);

Line 383: wf_engine.GetItemAttrNumber( itemtype

379: IF (req_to_import%NOTFOUND) then
380: resultout := 'COMPLETE:N';
381: ELSE
382: l_user_id :=
383: wf_engine.GetItemAttrNumber( itemtype
384: , itemkey
385: , 'USER_ID');
386: l_resp_id :=
387: wf_engine.GetItemAttrNumber( itemtype

Line 387: wf_engine.GetItemAttrNumber( itemtype

383: wf_engine.GetItemAttrNumber( itemtype
384: , itemkey
385: , 'USER_ID');
386: l_resp_id :=
387: wf_engine.GetItemAttrNumber( itemtype
388: , itemkey
389: , 'RESP_ID');
390: l_resp_appl_id :=
391: wf_engine.GetItemAttrNumber( itemtype

Line 391: wf_engine.GetItemAttrNumber( itemtype

387: wf_engine.GetItemAttrNumber( itemtype
388: , itemkey
389: , 'RESP_ID');
390: l_resp_appl_id :=
391: wf_engine.GetItemAttrNumber( itemtype
392: , itemkey
393: , 'RESP_APPL_ID');
394: l_security_group_id :=
395: wf_engine.GetItemAttrNumber( itemtype

Line 395: wf_engine.GetItemAttrNumber( itemtype

391: wf_engine.GetItemAttrNumber( itemtype
392: , itemkey
393: , 'RESP_APPL_ID');
394: l_security_group_id :=
395: wf_engine.GetItemAttrNumber( itemtype
396: , itemkey
397: , 'SECURITY_GROUP_ID');
398:
399: fnd_global.apps_initialize (

Line 439: wf_engine.GetItemAttrText ( p_itemtype

435: l_record_number := p_rec_num;
436: END IF;
437:
438: p_buyer :=
439: wf_engine.GetItemAttrText ( p_itemtype
440: , p_itemkey
441: , 'BUYER' || l_record_number);
442: p_po_number :=
443: wf_engine.GetItemAttrText ( p_itemtype

Line 443: wf_engine.GetItemAttrText ( p_itemtype

439: wf_engine.GetItemAttrText ( p_itemtype
440: , p_itemkey
441: , 'BUYER' || l_record_number);
442: p_po_number :=
443: wf_engine.GetItemAttrText ( p_itemtype
444: , p_itemkey
445: , 'PO_NUM' || l_record_number);
446: p_po_header_id :=
447: wf_engine.GetItemAttrNumber ( p_itemtype

Line 447: wf_engine.GetItemAttrNumber ( p_itemtype

443: wf_engine.GetItemAttrText ( p_itemtype
444: , p_itemkey
445: , 'PO_NUM' || l_record_number);
446: p_po_header_id :=
447: wf_engine.GetItemAttrNumber ( p_itemtype
448: , p_itemkey
449: , 'PO_HEADER_ID' || l_record_number);
450: p_po_distribution_id :=
451: wf_engine.GetItemAttrNumber ( p_itemtype

Line 451: wf_engine.GetItemAttrNumber ( p_itemtype

447: wf_engine.GetItemAttrNumber ( p_itemtype
448: , p_itemkey
449: , 'PO_HEADER_ID' || l_record_number);
450: p_po_distribution_id :=
451: wf_engine.GetItemAttrNumber ( p_itemtype
452: , p_itemkey
453: , 'PO_DISTRIBUTION_ID' || l_record_number);
454: p_org_id :=
455: wf_engine.GetItemAttrNumber ( p_itemtype

Line 455: wf_engine.GetItemAttrNumber ( p_itemtype

451: wf_engine.GetItemAttrNumber ( p_itemtype
452: , p_itemkey
453: , 'PO_DISTRIBUTION_ID' || l_record_number);
454: p_org_id :=
455: wf_engine.GetItemAttrNumber ( p_itemtype
456: , p_itemkey
457: , 'ORG_ID' || l_record_number);
458: p_po_line_qty :=
459: wf_engine.GetItemAttrNumber ( p_itemtype

Line 459: wf_engine.GetItemAttrNumber ( p_itemtype

455: wf_engine.GetItemAttrNumber ( p_itemtype
456: , p_itemkey
457: , 'ORG_ID' || l_record_number);
458: p_po_line_qty :=
459: wf_engine.GetItemAttrNumber ( p_itemtype
460: , p_itemkey
461: , 'PO_LINE_QTY' || l_record_number);
462: p_po_line_uom :=
463: wf_engine.GetItemAttrText ( p_itemtype

Line 463: wf_engine.GetItemAttrText ( p_itemtype

459: wf_engine.GetItemAttrNumber ( p_itemtype
460: , p_itemkey
461: , 'PO_LINE_QTY' || l_record_number);
462: p_po_line_uom :=
463: wf_engine.GetItemAttrText ( p_itemtype
464: , p_itemkey
465: , 'PO_UOM' || l_record_number);
466: p_subcontractor :=
467: wf_engine.GetItemAttrText ( p_itemtype

Line 467: wf_engine.GetItemAttrText ( p_itemtype

463: wf_engine.GetItemAttrText ( p_itemtype
464: , p_itemkey
465: , 'PO_UOM' || l_record_number);
466: p_subcontractor :=
467: wf_engine.GetItemAttrText ( p_itemtype
468: , p_itemkey
469: , 'SUBCONTRACTOR' || l_record_number);
470: p_subcontractor_site :=
471: wf_engine.GetItemAttrText ( p_itemtype

Line 471: wf_engine.GetItemAttrText ( p_itemtype

467: wf_engine.GetItemAttrText ( p_itemtype
468: , p_itemkey
469: , 'SUBCONTRACTOR' || l_record_number);
470: p_subcontractor_site :=
471: wf_engine.GetItemAttrText ( p_itemtype
472: , p_itemkey
473: , 'SUBCONTRACTOR_SITE' || l_record_number);
474: exception
475: when others then

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

501: IF p_rec_num > 1 THEN
502: l_record_number := p_rec_num;
503: END IF;
504:
505: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
506: itemkey => p_itemkey,
507: aname => 'PO_HEADER_ID' || l_record_number,
508: avalue => p_po_header_id);
509:

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

506: itemkey => p_itemkey,
507: aname => 'PO_HEADER_ID' || l_record_number,
508: avalue => p_po_header_id);
509:
510: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
511: itemkey => p_itemkey,
512: aname => 'PO_DISTRIBUTION_ID'|| l_record_number,
513: avalue => p_po_distribution_id);
514:

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

511: itemkey => p_itemkey,
512: aname => 'PO_DISTRIBUTION_ID'|| l_record_number,
513: avalue => p_po_distribution_id);
514:
515: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
516: itemkey => p_itemkey,
517: aname => 'ORG_ID' || l_record_number,
518: avalue => p_org_id);
519:

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

516: itemkey => p_itemkey,
517: aname => 'ORG_ID' || l_record_number,
518: avalue => p_org_id);
519:
520: wf_engine.SetItemAttrText( itemtype => p_itemtype,
521: itemkey => p_itemkey,
522: aname => 'BUYER' || l_record_number,
523: avalue => p_buyer);
524:

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

521: itemkey => p_itemkey,
522: aname => 'BUYER' || l_record_number,
523: avalue => p_buyer);
524:
525: wf_engine.SetItemAttrText( itemtype => p_itemtype,
526: itemkey => p_itemkey,
527: aname => 'SUBCONTRACTOR_SITE' || l_record_number,
528: avalue => p_subcontractor_site);
529:

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

526: itemkey => p_itemkey,
527: aname => 'SUBCONTRACTOR_SITE' || l_record_number,
528: avalue => p_subcontractor_site);
529:
530: wf_engine.SetItemAttrText( itemtype => p_itemtype,
531: itemkey => p_itemkey,
532: aname => 'PO_NUM' || l_record_number,
533: avalue => p_po_number);
534:

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

531: itemkey => p_itemkey,
532: aname => 'PO_NUM' || l_record_number,
533: avalue => p_po_number);
534:
535: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
536: itemkey => p_itemkey,
537: aname => 'PO_LINE_QTY' || l_record_number,
538: avalue => p_po_line_qty);
539:

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

536: itemkey => p_itemkey,
537: aname => 'PO_LINE_QTY' || l_record_number,
538: avalue => p_po_line_qty);
539:
540: wf_engine.SetItemAttrText( itemtype => p_itemtype,
541: itemkey => p_itemkey,
542: aname => 'PO_UOM' || l_record_number,
543: avalue => p_po_line_uom);
544:

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

541: itemkey => p_itemkey,
542: aname => 'PO_UOM' || l_record_number,
543: avalue => p_po_line_uom);
544:
545: wf_engine.SetItemAttrText( itemtype => p_itemtype,
546: itemkey => p_itemkey,
547: aname => 'SUBCONTRACTOR' || l_record_number,
548: avalue => p_subcontractor);
549: wf_engine.SetItemAttrText( itemtype => p_itemtype,

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

545: wf_engine.SetItemAttrText( itemtype => p_itemtype,
546: itemkey => p_itemkey,
547: aname => 'SUBCONTRACTOR' || l_record_number,
548: avalue => p_subcontractor);
549: wf_engine.SetItemAttrText( itemtype => p_itemtype,
550: itemkey => p_itemkey,
551: aname => 'REQUIRED_ASSY_QTY' ||l_record_number,
552: avalue => p_required_assy_qty);
553:

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

726: l_open_reqs VARCHAR2(2000);
727: l_release_num NUMBER ;
728: l_required_assy_qty NUMBER;
729: begin
730: l_wip_entity_id := wf_engine.GetItemAttrNumber ( itemtype,
731: itemkey,
732: 'WIP_ENTITY_ID');
733: l_rep_sched_id := wf_engine.GetItemAttrNumber ( itemtype,
734: itemkey,

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

729: begin
730: l_wip_entity_id := wf_engine.GetItemAttrNumber ( itemtype,
731: itemkey,
732: 'WIP_ENTITY_ID');
733: l_rep_sched_id := wf_engine.GetItemAttrNumber ( itemtype,
734: itemkey,
735: 'REP_SCHEDULE_ID');
736: l_osp_operation_num := wf_engine.GetItemAttrNumber ( itemtype,
737: itemkey,

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

732: 'WIP_ENTITY_ID');
733: l_rep_sched_id := wf_engine.GetItemAttrNumber ( itemtype,
734: itemkey,
735: 'REP_SCHEDULE_ID');
736: l_osp_operation_num := wf_engine.GetItemAttrNumber ( itemtype,
737: itemkey,
738: 'WIP_OP_SEQ');
739: l_num_of_po := 0;
740:

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

785:
786: l_open_reqs := c_req_rec.req_num || ', ' || l_open_reqs ;
787: END LOOP;
788:
789: wf_engine.SetItemAttrNumber( itemtype => itemtype,
790: itemkey => itemkey,
791: aname => 'NUM_OF_POS',
792: avalue => l_num_of_po);
793:

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

790: itemkey => itemkey,
791: aname => 'NUM_OF_POS',
792: avalue => l_num_of_po);
793:
794: wf_engine.SetItemAttrText ( itemtype => itemtype,
795: itemkey => itemkey,
796: aname => 'NON_APPROVED_POS',
797: avalue => substr(l_non_approved_pos,1,length(l_non_approved_pos)-2));
798:

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

795: itemkey => itemkey,
796: aname => 'NON_APPROVED_POS',
797: avalue => substr(l_non_approved_pos,1,length(l_non_approved_pos)-2));
798:
799: wf_engine.SetItemAttrText ( itemtype => itemtype,
800: itemkey => itemkey,
801: aname => 'OPEN_REQS',
802: avalue => substr(l_open_reqs,1,length(l_open_reqs)-2));
803:

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

803:
804: if l_num_of_po = 0 then
805: resultout:='COMPLETE:NONE';
806: elsif l_num_of_po = 1 then
807: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
808: itemkey,
809: 'PRIMARY_QTY');
810:
811: wf_engine.SetItemAttrNumber( itemtype => itemtype,

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

807: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
808: itemkey,
809: 'PRIMARY_QTY');
810:
811: wf_engine.SetItemAttrNumber( itemtype => itemtype,
812: itemkey => itemkey,
813: aname => 'SHIP_QTY',
814: avalue => l_primary_qty);
815:

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

817: fnd_message.set_name ('WIP', 'WIP_SHP_GTR_THAN_PO_QTY');
818: msg := fnd_message.get;
819: end if;
820:
821: wf_engine.SetItemAttrText( itemtype => itemtype,
822: itemkey => itemkey,
823: aname => 'NOT_VALID_MESG',
824: avalue => msg);
825:

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

853: l_ship_qty NUMBER;
854: msg VARCHAR2(2000);
855:
856: begin
857: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
858: itemkey,
859: 'PRIMARY_QTY');
860:
861: l_primary_uom := wf_engine.GetItemAttrText ( itemtype,

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

857: l_primary_qty := wf_engine.GetItemAttrNumber ( itemtype,
858: itemkey,
859: 'PRIMARY_QTY');
860:
861: l_primary_uom := wf_engine.GetItemAttrText ( itemtype,
862: itemkey,
863: 'PRIMARY_UOM');
864:
865: l_num_of_pos := wf_engine.GetItemAttrText ( itemtype,

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

861: l_primary_uom := wf_engine.GetItemAttrText ( itemtype,
862: itemkey,
863: 'PRIMARY_UOM');
864:
865: l_num_of_pos := wf_engine.GetItemAttrText ( itemtype,
866: itemkey,
867: 'NUM_OF_POS');
868:
869: l_osp_item_id := wf_engine.GetItemAttrNumber ( itemtype,

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

865: l_num_of_pos := wf_engine.GetItemAttrText ( itemtype,
866: itemkey,
867: 'NUM_OF_POS');
868:
869: l_osp_item_id := wf_engine.GetItemAttrNumber ( itemtype,
870: itemkey,
871: 'OSP_ITEM_ID');
872:
873: for i in 1..l_num_of_pos loop

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

872:
873: for i in 1..l_num_of_pos loop
874:
875:
876: l_ship_qty := wf_engine.GetItemAttrNumber ( itemtype,
877: itemkey,
878: 'PO_QTY' || i);
879:
880: /* if the buyer has not entered in a number for PO Quantity or

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

893: -- Get Error message to be displayed in notifications
894: fnd_message.set_name ('WIP', 'WIP_QTY_NOT_VALID');
895: msg := fnd_message.get;
896:
897: wf_engine.SetItemAttrText( itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'NOT_VALID_MESG',
900: avalue => msg);
901:

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

947: l_resp_appl_id NUMBER;
948: l_security_group_id NUMBER;
949: begin
950:
951: num_of_proc := wf_engine.GetItemAttrNumber ( itemtype,
952: itemkey,
953: 'NUM_OF_POS');
954:
955:

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

974: select to_char(wip_workflow_s.nextval)
975: into childkey
976: from dual;
977:
978: l_ship_qty := wf_engine.GetItemAttrNumber ( itemtype,
979: itemkey,
980: 'PO_QTY' || i);
981:
982: /* if ship_qty is null or = 0 then there is no need

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

985:
986: if (l_ship_qty is not null and l_ship_qty <> 0) then
987:
988:
989: wf_engine.CreateProcess( itemtype => itemtype,
990: itemkey => childkey,
991: process => 'SHIP_INTERMEDIATE');
992:
993:

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

990: itemkey => childkey,
991: process => 'SHIP_INTERMEDIATE');
992:
993:
994: wf_engine.SetItemAttrText( itemtype => itemtype,
995: itemkey => childkey,
996: aname => 'PARENT_ITEMKEY',
997: avalue => itemkey);
998:

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

1034: , p_po_line_uom => l_po_line_uom
1035: , p_subcontractor => l_subcontractor
1036: , p_subcontractor_site => l_subcontractor_site);
1037:
1038: wf_engine.SetItemAttrText( itemtype => itemtype,
1039: itemkey => childkey,
1040: aname => 'SHIP_QTY',
1041: avalue => l_ship_qty);
1042:

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

1039: itemkey => childkey,
1040: aname => 'SHIP_QTY',
1041: avalue => l_ship_qty);
1042:
1043: wf_engine.StartProcess( itemtype => itemtype,
1044: itemkey => childkey );
1045: end if; /* ship_qty is not null or ship_qty != 0 */
1046:
1047: end loop;

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

1060: funcmode in varchar2,
1061: resultout out nocopy varchar2) is
1062:
1063: l_organization_id number :=
1064: wf_engine.GetItemAttrNumber( itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'ORGANIZATION_ID');
1067:
1068: l_ship_from_2nd_sub varchar2(1) :=

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

1065: itemkey => itemkey,
1066: aname => 'ORGANIZATION_ID');
1067:
1068: l_ship_from_2nd_sub varchar2(1) :=
1069: wf_engine.GetItemAttrText (itemtype => itemtype,
1070: itemkey => itemkey,
1071: aname => 'SHIPPED_FROM_2ND_SUB');
1072:
1073: l_ship_manager varchar2(80) := NULL;

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

1086: l_ship_manager :=
1087: wip_std_wf.GetShipManagerLogin(l_organization_id);
1088:
1089: if (l_ship_manager is not null) then
1090: wf_engine.SetItemAttrText( itemtype => itemtype,
1091: itemkey => itemkey,
1092: aname => 'SHIPPING_MANAGER',
1093: avalue => l_ship_manager);
1094: resultout := 'COMPLETE:WIP_FOUND';

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

1114: l_po_header_id NUMBER;
1115: l_address VARCHAR2(1000);
1116:
1117: begin
1118: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype,
1119: itemkey,
1120: 'PO_HEADER_ID');
1121:
1122: select ap_vendor_sites_pkg.format_address (pvs.country,

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

1129: where ph.po_header_id = l_po_header_id
1130: and pvs.org_id = ph.org_id
1131: and pvs.vendor_site_id = ph.vendor_site_id;
1132:
1133: wf_engine.SetItemAttrText( itemtype => itemtype,
1134: itemkey => itemkey,
1135: aname => 'ADDRESS',
1136: avalue => l_address);
1137:

Line 1243: wf_engine.CreateProcess( itemtype => l_itemtype

1239: select to_char(wip_workflow_s.nextval)
1240: into l_itemkey
1241: from dual;
1242:
1243: wf_engine.CreateProcess( itemtype => l_itemtype
1244: , itemkey => l_itemkey
1245: , process => 'NOTIFY_2ND_BUYER_SUPPLIER' );
1246:
1247: open GetWIPData (p_po_distribution_id);

Line 1288: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1284: p_po_line_uom => l_po_line_uom,
1285: p_subcontractor => l_subcontractor_name,
1286: p_subcontractor_site => l_subcontractor_site);
1287:
1288: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1289: , itemkey => l_itemkey
1290: , aname => 'PO_DISTRIBUTION_ID'
1291: , avalue => p_po_distribution_id);
1292:

Line 1293: wf_engine.SetItemAttrText( itemtype => l_itemtype

1289: , itemkey => l_itemkey
1290: , aname => 'PO_DISTRIBUTION_ID'
1291: , avalue => p_po_distribution_id);
1292:
1293: wf_engine.SetItemAttrText( itemtype => l_itemtype
1294: , itemkey => l_itemkey
1295: , aname => 'SHIPPED_FROM_2ND_SUB'
1296: , avalue => 'Y');
1297:

Line 1298: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1294: , itemkey => l_itemkey
1295: , aname => 'SHIPPED_FROM_2ND_SUB'
1296: , avalue => 'Y');
1297:
1298: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1299: , itemkey => l_itemkey
1300: , aname => 'SHIP_QTY'
1301: , avalue => p_shipped_qty);
1302: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1302: wf_engine.SetItemAttrText( itemtype => l_itemtype

1298: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1299: , itemkey => l_itemkey
1300: , aname => 'SHIP_QTY'
1301: , avalue => p_shipped_qty);
1302: wf_engine.SetItemAttrText( itemtype => l_itemtype
1303: , itemkey => l_itemkey
1304: , aname => 'PRIMARY_UOM'
1305: , avalue => p_shipped_uom);
1306:

Line 1309: wf_engine.SetItemAttrDate( itemtype => l_itemtype

1305: , avalue => p_shipped_uom);
1306:
1307: /* Set up data for ASN */
1308:
1309: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1310: , itemkey => l_itemkey
1311: , aname => 'SHIPPED_DATE'
1312: , avalue => p_shipped_date);
1313: wf_engine.SetItemAttrDate( itemtype => l_itemtype

Line 1313: wf_engine.SetItemAttrDate( itemtype => l_itemtype

1309: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1310: , itemkey => l_itemkey
1311: , aname => 'SHIPPED_DATE'
1312: , avalue => p_shipped_date);
1313: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1314: , itemkey => l_itemkey
1315: , aname => 'EXPECTED_RECEIPT_DATE'
1316: , avalue => p_expected_receipt_date);
1317: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1317: wf_engine.SetItemAttrText( itemtype => l_itemtype

1313: wf_engine.SetItemAttrDate( itemtype => l_itemtype
1314: , itemkey => l_itemkey
1315: , aname => 'EXPECTED_RECEIPT_DATE'
1316: , avalue => p_expected_receipt_date);
1317: wf_engine.SetItemAttrText( itemtype => l_itemtype
1318: , itemkey => l_itemkey
1319: , aname => 'PACKING_SLIP'
1320: , avalue => p_packing_slip);
1321: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1321: wf_engine.SetItemAttrText( itemtype => l_itemtype

1317: wf_engine.SetItemAttrText( itemtype => l_itemtype
1318: , itemkey => l_itemkey
1319: , aname => 'PACKING_SLIP'
1320: , avalue => p_packing_slip);
1321: wf_engine.SetItemAttrText( itemtype => l_itemtype
1322: , itemkey => l_itemkey
1323: , aname => 'AIRBILL_WAYBILL_NUM'
1324: , avalue => p_airbill_waybill);
1325: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1325: wf_engine.SetItemAttrText( itemtype => l_itemtype

1321: wf_engine.SetItemAttrText( itemtype => l_itemtype
1322: , itemkey => l_itemkey
1323: , aname => 'AIRBILL_WAYBILL_NUM'
1324: , avalue => p_airbill_waybill);
1325: wf_engine.SetItemAttrText( itemtype => l_itemtype
1326: , itemkey => l_itemkey
1327: , aname => 'BILL_OF_LADING'
1328: , avalue => p_bill_of_lading);
1329: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1329: wf_engine.SetItemAttrText( itemtype => l_itemtype

1325: wf_engine.SetItemAttrText( itemtype => l_itemtype
1326: , itemkey => l_itemkey
1327: , aname => 'BILL_OF_LADING'
1328: , avalue => p_bill_of_lading);
1329: wf_engine.SetItemAttrText( itemtype => l_itemtype
1330: , itemkey => l_itemkey
1331: , aname => 'PACKAGING_CODE'
1332: , avalue => p_packaging_code);
1333: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1333: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1329: wf_engine.SetItemAttrText( itemtype => l_itemtype
1330: , itemkey => l_itemkey
1331: , aname => 'PACKAGING_CODE'
1332: , avalue => p_packaging_code);
1333: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1334: , itemkey => l_itemkey
1335: , aname => 'NUM_OF_CONTAINER'
1336: , avalue => p_num_of_container);
1337: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1337: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1333: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1334: , itemkey => l_itemkey
1335: , aname => 'NUM_OF_CONTAINER'
1336: , avalue => p_num_of_container);
1337: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1338: , itemkey => l_itemkey
1339: , aname => 'GROSS_WEIGHT'
1340: , avalue => p_gross_weight);
1341: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1341: wf_engine.SetItemAttrText( itemtype => l_itemtype

1337: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1338: , itemkey => l_itemkey
1339: , aname => 'GROSS_WEIGHT'
1340: , avalue => p_gross_weight);
1341: wf_engine.SetItemAttrText( itemtype => l_itemtype
1342: , itemkey => l_itemkey
1343: , aname => 'GROSS_WEIGHT_UOM'
1344: , avalue => p_gross_weight_uom);
1345: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1345: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1341: wf_engine.SetItemAttrText( itemtype => l_itemtype
1342: , itemkey => l_itemkey
1343: , aname => 'GROSS_WEIGHT_UOM'
1344: , avalue => p_gross_weight_uom);
1345: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1346: , itemkey => l_itemkey
1347: , aname => 'NET_WEIGHT'
1348: , avalue => p_net_weight);
1349: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1349: wf_engine.SetItemAttrText( itemtype => l_itemtype

1345: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1346: , itemkey => l_itemkey
1347: , aname => 'NET_WEIGHT'
1348: , avalue => p_net_weight);
1349: wf_engine.SetItemAttrText( itemtype => l_itemtype
1350: , itemkey => l_itemkey
1351: , aname => 'NET_WEIGHT_UOM'
1352: , avalue => p_net_weight_uom);
1353: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 1353: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1349: wf_engine.SetItemAttrText( itemtype => l_itemtype
1350: , itemkey => l_itemkey
1351: , aname => 'NET_WEIGHT_UOM'
1352: , avalue => p_net_weight_uom);
1353: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1354: , itemkey => l_itemkey
1355: , aname => 'TAR_WEIGHT'
1356: , avalue => p_tar_weight);
1357: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1357: wf_engine.SetItemAttrText( itemtype => l_itemtype

1353: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1354: , itemkey => l_itemkey
1355: , aname => 'TAR_WEIGHT'
1356: , avalue => p_tar_weight);
1357: wf_engine.SetItemAttrText( itemtype => l_itemtype
1358: , itemkey => l_itemkey
1359: , aname => 'TAR_WEIGHT_UOM'
1360: , avalue => p_tar_weight_uom);
1361: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1361: wf_engine.SetItemAttrText( itemtype => l_itemtype

1357: wf_engine.SetItemAttrText( itemtype => l_itemtype
1358: , itemkey => l_itemkey
1359: , aname => 'TAR_WEIGHT_UOM'
1360: , avalue => p_tar_weight_uom);
1361: wf_engine.SetItemAttrText( itemtype => l_itemtype
1362: , itemkey => l_itemkey
1363: , aname => 'HAZARD_CLASS'
1364: , avalue => p_hazard_class);
1365: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1365: wf_engine.SetItemAttrText( itemtype => l_itemtype

1361: wf_engine.SetItemAttrText( itemtype => l_itemtype
1362: , itemkey => l_itemkey
1363: , aname => 'HAZARD_CLASS'
1364: , avalue => p_hazard_class);
1365: wf_engine.SetItemAttrText( itemtype => l_itemtype
1366: , itemkey => l_itemkey
1367: , aname => 'HAZARD_CODE'
1368: , avalue => p_hazard_code);
1369: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1369: wf_engine.SetItemAttrText( itemtype => l_itemtype

1365: wf_engine.SetItemAttrText( itemtype => l_itemtype
1366: , itemkey => l_itemkey
1367: , aname => 'HAZARD_CODE'
1368: , avalue => p_hazard_code);
1369: wf_engine.SetItemAttrText( itemtype => l_itemtype
1370: , itemkey => l_itemkey
1371: , aname => 'HAZARD_DESCRIPTION'
1372: , avalue => p_hazard_desc);
1373: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1373: wf_engine.SetItemAttrText( itemtype => l_itemtype

1369: wf_engine.SetItemAttrText( itemtype => l_itemtype
1370: , itemkey => l_itemkey
1371: , aname => 'HAZARD_DESCRIPTION'
1372: , avalue => p_hazard_desc);
1373: wf_engine.SetItemAttrText( itemtype => l_itemtype
1374: , itemkey => l_itemkey
1375: , aname => 'SPECIAL_HANDLING_CODE'
1376: , avalue => p_special_handling_code);
1377: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1377: wf_engine.SetItemAttrText( itemtype => l_itemtype

1373: wf_engine.SetItemAttrText( itemtype => l_itemtype
1374: , itemkey => l_itemkey
1375: , aname => 'SPECIAL_HANDLING_CODE'
1376: , avalue => p_special_handling_code);
1377: wf_engine.SetItemAttrText( itemtype => l_itemtype
1378: , itemkey => l_itemkey
1379: , aname => 'FREIGHT_CARRIER'
1380: , avalue => p_freight_carrier);
1381: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1381: wf_engine.SetItemAttrText( itemtype => l_itemtype

1377: wf_engine.SetItemAttrText( itemtype => l_itemtype
1378: , itemkey => l_itemkey
1379: , aname => 'FREIGHT_CARRIER'
1380: , avalue => p_freight_carrier);
1381: wf_engine.SetItemAttrText( itemtype => l_itemtype
1382: , itemkey => l_itemkey
1383: , aname => 'FREIGHT_CARRIER_TERMS'
1384: , avalue => p_freight_carrier_terms);
1385: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1385: wf_engine.SetItemAttrText( itemtype => l_itemtype

1381: wf_engine.SetItemAttrText( itemtype => l_itemtype
1382: , itemkey => l_itemkey
1383: , aname => 'FREIGHT_CARRIER_TERMS'
1384: , avalue => p_freight_carrier_terms);
1385: wf_engine.SetItemAttrText( itemtype => l_itemtype
1386: , itemkey => l_itemkey
1387: , aname => 'CARRIER_EQUIPMENT'
1388: , avalue => p_carrier_equip);
1389: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1389: wf_engine.SetItemAttrText( itemtype => l_itemtype

1385: wf_engine.SetItemAttrText( itemtype => l_itemtype
1386: , itemkey => l_itemkey
1387: , aname => 'CARRIER_EQUIPMENT'
1388: , avalue => p_carrier_equip);
1389: wf_engine.SetItemAttrText( itemtype => l_itemtype
1390: , itemkey => l_itemkey
1391: , aname => 'CARRIER_METHOD'
1392: , avalue => p_carrier_method);
1393: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1393: wf_engine.SetItemAttrText( itemtype => l_itemtype

1389: wf_engine.SetItemAttrText( itemtype => l_itemtype
1390: , itemkey => l_itemkey
1391: , aname => 'CARRIER_METHOD'
1392: , avalue => p_carrier_method);
1393: wf_engine.SetItemAttrText( itemtype => l_itemtype
1394: , itemkey => l_itemkey
1395: , aname => 'FREIGHT_BILL_NUMBER'
1396: , avalue => p_freight_bill_num);
1397: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1397: wf_engine.SetItemAttrText( itemtype => l_itemtype

1393: wf_engine.SetItemAttrText( itemtype => l_itemtype
1394: , itemkey => l_itemkey
1395: , aname => 'FREIGHT_BILL_NUMBER'
1396: , avalue => p_freight_bill_num);
1397: wf_engine.SetItemAttrText( itemtype => l_itemtype
1398: , itemkey => l_itemkey
1399: , aname => 'RECEIPT_NUMBER'
1400: , avalue => p_receipt_num);
1401: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1401: wf_engine.SetItemAttrText( itemtype => l_itemtype

1397: wf_engine.SetItemAttrText( itemtype => l_itemtype
1398: , itemkey => l_itemkey
1399: , aname => 'RECEIPT_NUMBER'
1400: , avalue => p_receipt_num);
1401: wf_engine.SetItemAttrText( itemtype => l_itemtype
1402: , itemkey => l_itemkey
1403: , aname => 'USSGL_TRANSACTION_CODE'
1404: , avalue => p_ussgl_txn_code);
1405:

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

1402: , itemkey => l_itemkey
1403: , aname => 'USSGL_TRANSACTION_CODE'
1404: , avalue => p_ussgl_txn_code);
1405:
1406: wf_engine.StartProcess( itemtype => l_itemtype,
1407: itemkey => l_itemkey );
1408:
1409:
1410: exception

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

1509: l_vendor_name VARCHAR2(80);
1510: l_release_num NUMBER ;
1511:
1512: begin
1513: l_po_distribution_id := wf_engine.GetItemAttrNumber ( itemtype,
1514: itemkey,
1515: 'PO_DISTRIBUTION_ID');
1516:
1517: open GetShipToData(l_po_distribution_id);

Line 1549: wf_engine.SetItemAttrNumber( itemtype => itemtype

1545: p_po_line_uom => l_po_line_uom,
1546: p_subcontractor => l_subcontractor_name,
1547: p_subcontractor_site => l_subcontractor_site);
1548:
1549: wf_engine.SetItemAttrNumber( itemtype => itemtype
1550: , itemkey => itemkey
1551: , aname => 'WIP_OP_SEQ'
1552: , avalue => l_next_op_seq);
1553:

Line 1554: wf_engine.SetItemAttrNumber( itemtype => itemtype

1550: , itemkey => itemkey
1551: , aname => 'WIP_OP_SEQ'
1552: , avalue => l_next_op_seq);
1553:
1554: wf_engine.SetItemAttrNumber( itemtype => itemtype
1555: , itemkey => itemkey
1556: , aname => 'OSP_ITEM_ID'
1557: , avalue => l_osp_item_id);
1558:

Line 1559: wf_engine.SetItemAttrText( itemtype => itemtype

1555: , itemkey => itemkey
1556: , aname => 'OSP_ITEM_ID'
1557: , avalue => l_osp_item_id);
1558:
1559: wf_engine.SetItemAttrText( itemtype => itemtype
1560: , itemkey => itemkey
1561: , aname => 'OSP_ITEM'
1562: , avalue => l_osp_item);
1563:

Line 1564: wf_engine.SetItemAttrText( itemtype => itemtype

1560: , itemkey => itemkey
1561: , aname => 'OSP_ITEM'
1562: , avalue => l_osp_item);
1563:
1564: wf_engine.SetItemAttrText( itemtype => itemtype
1565: , itemkey => itemkey
1566: , aname => 'OSP_ITEM_DESC'
1567: , avalue => l_osp_item_desc);
1568:

Line 1661: wf_engine.GetItemAttrNumber( itemtype

1657: /*Need to set user context so that we can get the correct profile value
1658: and submit concurrent program in the correct user context*/
1659:
1660: l_user_id :=
1661: wf_engine.GetItemAttrNumber( itemtype
1662: , itemkey
1663: , 'USER_ID');
1664: l_resp_id :=
1665: wf_engine.GetItemAttrNumber( itemtype

Line 1665: wf_engine.GetItemAttrNumber( itemtype

1661: wf_engine.GetItemAttrNumber( itemtype
1662: , itemkey
1663: , 'USER_ID');
1664: l_resp_id :=
1665: wf_engine.GetItemAttrNumber( itemtype
1666: , itemkey
1667: , 'RESP_ID');
1668: l_resp_appl_id :=
1669: wf_engine.GetItemAttrNumber( itemtype

Line 1669: wf_engine.GetItemAttrNumber( itemtype

1665: wf_engine.GetItemAttrNumber( itemtype
1666: , itemkey
1667: , 'RESP_ID');
1668: l_resp_appl_id :=
1669: wf_engine.GetItemAttrNumber( itemtype
1670: , itemkey
1671: , 'RESP_APPL_ID');
1672: l_security_group_id :=
1673: wf_engine.GetItemAttrNumber( itemtype

Line 1673: wf_engine.GetItemAttrNumber( itemtype

1669: wf_engine.GetItemAttrNumber( itemtype
1670: , itemkey
1671: , 'RESP_APPL_ID');
1672: l_security_group_id :=
1673: wf_engine.GetItemAttrNumber( itemtype
1674: , itemkey
1675: , 'SECURITY_GROUP_ID');
1676:
1677: fnd_global.apps_initialize (

Line 1683: l_req_group_by := wf_engine.GetItemAttrNumber ( itemtype,

1679: resp_id => l_resp_id,
1680: resp_appl_id => l_resp_appl_id ,
1681: security_group_id => l_security_group_id);
1682:
1683: l_req_group_by := wf_engine.GetItemAttrNumber ( itemtype,
1684: itemkey,
1685: 'REQ_GROUP_BY');
1686:
1687: /*ER 4276433*/

Line 1709: wf_engine.AddItemAttr(itemtype => itemtype,

1705: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
1706: ) ;
1707:
1708: --After launch the requistion import, add the request id as item attribute for WaitforReqImport to use
1709: wf_engine.AddItemAttr(itemtype => itemtype,
1710: itemkey => itemkey,
1711: aname => 'REQIMPORT_REQUEST_ID');
1712: wf_engine.SetItemAttrNumber(itemtype => itemtype
1713: , itemkey => itemkey

Line 1712: wf_engine.SetItemAttrNumber(itemtype => itemtype

1708: --After launch the requistion import, add the request id as item attribute for WaitforReqImport to use
1709: wf_engine.AddItemAttr(itemtype => itemtype,
1710: itemkey => itemkey,
1711: aname => 'REQIMPORT_REQUEST_ID');
1712: wf_engine.SetItemAttrNumber(itemtype => itemtype
1713: , itemkey => itemkey
1714: , aname => 'REQIMPORT_REQUEST_ID'
1715: , avalue => l_request_id);
1716:

Line 1745: wf_engine.GetItemAttrNumber( itemtype

1741: message VARCHAR2(2000);
1742: begin
1743: --Need to set user context so that we can get the correct profile value
1744: l_user_id :=
1745: wf_engine.GetItemAttrNumber( itemtype
1746: , itemkey
1747: , 'USER_ID');
1748: l_resp_id :=
1749: wf_engine.GetItemAttrNumber( itemtype

Line 1749: wf_engine.GetItemAttrNumber( itemtype

1745: wf_engine.GetItemAttrNumber( itemtype
1746: , itemkey
1747: , 'USER_ID');
1748: l_resp_id :=
1749: wf_engine.GetItemAttrNumber( itemtype
1750: , itemkey
1751: , 'RESP_ID');
1752: l_resp_appl_id :=
1753: wf_engine.GetItemAttrNumber( itemtype

Line 1753: wf_engine.GetItemAttrNumber( itemtype

1749: wf_engine.GetItemAttrNumber( itemtype
1750: , itemkey
1751: , 'RESP_ID');
1752: l_resp_appl_id :=
1753: wf_engine.GetItemAttrNumber( itemtype
1754: , itemkey
1755: , 'RESP_APPL_ID');
1756: l_security_group_id :=
1757: wf_engine.GetItemAttrNumber( itemtype

Line 1757: wf_engine.GetItemAttrNumber( itemtype

1753: wf_engine.GetItemAttrNumber( itemtype
1754: , itemkey
1755: , 'RESP_APPL_ID');
1756: l_security_group_id :=
1757: wf_engine.GetItemAttrNumber( itemtype
1758: , itemkey
1759: , 'SECURITY_GROUP_ID');
1760:
1761: fnd_global.apps_initialize (

Line 1768: l_parent_id := wf_engine.GetItemAttrNumber( itemtype

1764: resp_appl_id => l_resp_appl_id ,
1765: security_group_id => l_security_group_id);
1766:
1767: --Retrieve the request id of requisition import and wait for it to finish
1768: l_parent_id := wf_engine.GetItemAttrNumber( itemtype
1769: , itemkey
1770: , 'REQIMPORT_REQUEST_ID');
1771:
1772: IF l_parent_id <> 0 THEN