36:
37:
38: BEGIN
39:
40: wf_engine.CreateProcess( itemtype => item_type,
41: itemkey => item_key,
42: process => workflow_process);
43:
44: /* Get OSP Item and description */
115: end;
116:
117:
118: /* Set Attributes */
119: wf_engine.SetItemAttrNumber( itemtype => item_type,
120: itemkey => item_key,
121: aname => 'WIP_ENTITY_ID',
122: avalue => p_wip_entity_id);
123:
120: itemkey => item_key,
121: aname => 'WIP_ENTITY_ID',
122: avalue => p_wip_entity_id);
123:
124: wf_engine.SetItemAttrText( itemtype => item_type,
125: itemkey => item_key,
126: aname => 'WIP_ENTITY_NAME',
127: avalue => p_wip_entity_name);
128:
125: itemkey => item_key,
126: aname => 'WIP_ENTITY_NAME',
127: avalue => p_wip_entity_name);
128:
129: wf_engine.SetItemAttrNumber( itemtype => item_type,
130: itemkey => item_key,
131: aname => 'REP_SCHEDULE_ID',
132: avalue => p_rep_schedule_id);
133:
130: itemkey => item_key,
131: aname => 'REP_SCHEDULE_ID',
132: avalue => p_rep_schedule_id);
133:
134: wf_engine.SetItemAttrNumber( itemtype => item_type,
135: itemkey => item_key,
136: aname => 'ORGANIZATION_ID',
137: avalue => p_organization_id);
138:
135: itemkey => item_key,
136: aname => 'ORGANIZATION_ID',
137: avalue => p_organization_id);
138:
139: wf_engine.SetItemAttrNumber( itemtype => item_type,
140: itemkey => item_key,
141: aname => 'ORG_ID',
142: avalue => x_org_id);
143:
140: itemkey => item_key,
141: aname => 'ORG_ID',
142: avalue => x_org_id);
143:
144: wf_engine.SetItemAttrNumber( itemtype => item_type,
145: itemkey => item_key,
146: aname => 'WIP_LINE_ID',
147: avalue => p_wip_line_id);
148:
145: itemkey => item_key,
146: aname => 'WIP_LINE_ID',
147: avalue => p_wip_line_id);
148:
149: wf_engine.SetItemAttrText( itemtype => item_type,
150: itemkey => item_key,
151: aname => 'WIP_LINE_CODE',
152: avalue => p_wip_line_code);
153:
150: itemkey => item_key,
151: aname => 'WIP_LINE_CODE',
152: avalue => p_wip_line_code);
153:
154: wf_engine.SetItemAttrText( itemtype => item_type,
155: itemkey => item_key,
156: aname => 'ASSEMBLY_NUMBER',
157: avalue => p_end_assembly_num);
158:
155: itemkey => item_key,
156: aname => 'ASSEMBLY_NUMBER',
157: avalue => p_end_assembly_num);
158:
159: wf_engine.SetItemAttrText( itemtype => item_type,
160: itemkey => item_key,
161: aname => 'ASSEMBLY_DESC',
162: avalue => p_end_assembly_desc);
163:
160: itemkey => item_key,
161: aname => 'ASSEMBLY_DESC',
162: avalue => p_end_assembly_desc);
163:
164: wf_engine.SetItemAttrNumber( itemtype => item_type,
165: itemkey => item_key,
166: aname => 'WIP_OP_SEQ',
167: avalue => p_operation_seq_num);
168:
165: itemkey => item_key,
166: aname => 'WIP_OP_SEQ',
167: avalue => p_operation_seq_num);
168:
169: wf_engine.SetItemAttrText( itemtype => item_type,
170: itemkey => item_key,
171: aname => 'PO_NUMBER',
172: avalue => p_po_number);
173:
170: itemkey => item_key,
171: aname => 'PO_NUMBER',
172: avalue => p_po_number);
173:
174: wf_engine.SetItemAttrText( itemtype => item_type,
175: itemkey => item_key,
176: aname => 'ITEM_NUMBER',
177: avalue => x_item_number);
178:
175: itemkey => item_key,
176: aname => 'ITEM_NUMBER',
177: avalue => x_item_number);
178:
179: wf_engine.SetItemAttrText( itemtype => item_type,
180: itemkey => item_key,
181: aname => 'OSP_ITEM_DESC',
182: avalue => x_item_desc);
183:
180: itemkey => item_key,
181: aname => 'OSP_ITEM_DESC',
182: avalue => x_item_desc);
183:
184: wf_engine.SetItemAttrNumber( itemtype => item_type,
185: itemkey => item_key,
186: aname => 'QUANTITY_ORDERED',
187: avalue => x_qty_ordered);
188:
185: itemkey => item_key,
186: aname => 'QUANTITY_ORDERED',
187: avalue => x_qty_ordered);
188:
189: wf_engine.SetItemAttrText( itemtype => item_type,
190: itemkey => item_key,
191: aname => 'UOM',
192: avalue => x_uom);
193:
190: itemkey => item_key,
191: aname => 'UOM',
192: avalue => x_uom);
193:
194: wf_engine.SetItemAttrNumber( itemtype => item_type,
195: itemkey => item_key,
196: aname => 'PO_HEADER_ID',
197: avalue => x_po_header_id);
198:
195: itemkey => item_key,
196: aname => 'PO_HEADER_ID',
197: avalue => x_po_header_id);
198:
199: wf_engine.SetItemAttrNumber( itemtype => item_type,
200: itemkey => item_key,
201: aname => 'LINE_LOCATION_ID',
202: avalue => x_line_location_id);
203:
200: itemkey => item_key,
201: aname => 'LINE_LOCATION_ID',
202: avalue => x_line_location_id);
203:
204: wf_engine.SetItemAttrNumber( itemtype => item_type,
205: itemkey => item_key,
206: aname => 'PO_DISTRIBUTION_ID',
207: avalue => p_po_distribution_id);
208:
205: itemkey => item_key,
206: aname => 'PO_DISTRIBUTION_ID',
207: avalue => p_po_distribution_id);
208:
209: wf_engine.SetItemAttrDate( itemtype => item_type,
210: itemkey => item_key,
211: aname => 'NEW_NEED_BY_DATE',
212: avalue => p_new_need_by_date);
213:
210: itemkey => item_key,
211: aname => 'NEW_NEED_BY_DATE',
212: avalue => p_new_need_by_date);
213:
214: wf_engine.SetItemAttrDate( itemtype => item_type,
215: itemkey => item_key,
216: aname => 'OLD_NEED_BY_DATE',
217: avalue => p_old_need_by_date);
218:
215: itemkey => item_key,
216: aname => 'OLD_NEED_BY_DATE',
217: avalue => p_old_need_by_date);
218:
219: wf_engine.SetItemAttrDate( itemtype => item_type,
220: itemkey => item_key,
221: aname => 'OLD_PROMISE_DATE',
222: avalue => x_curr_promise_date);
223:
220: itemkey => item_key,
221: aname => 'OLD_PROMISE_DATE',
222: avalue => x_curr_promise_date);
223:
224: wf_engine.SetItemAttrText( itemtype => item_type,
225: itemkey => item_key,
226: aname => 'COMMENTS',
227: avalue => p_comments);
228:
225: itemkey => item_key,
226: aname => 'COMMENTS',
227: avalue => p_comments);
228:
229: wf_engine.SetItemAttrText( itemtype => item_type,
230: itemkey => item_key,
231: aname => 'SUPPLIER',
232: avalue => x_subcontractor_name);
233:
230: itemkey => item_key,
231: aname => 'SUPPLIER',
232: avalue => x_subcontractor_name);
233:
234: wf_engine.SetItemAttrText( itemtype => item_type,
235: itemkey => item_key,
236: aname => 'PRODUCTION_SCHEDULER',
237: avalue => p_init_scheduler);
238:
235: itemkey => item_key,
236: aname => 'PRODUCTION_SCHEDULER',
237: avalue => p_init_scheduler);
238:
239: wf_engine.SetItemAttrNumber( itemtype => item_type,
240: itemkey => item_key,
241: aname => 'ITEM_KEY',
242: avalue => item_key);
243:
241: aname => 'ITEM_KEY',
242: avalue => item_key);
243:
244: /* Start Process */
245: wf_engine.StartProcess( itemtype => item_type,
246: itemkey => item_key);
247:
248: /* Set workflow process to background for better performance */
249: /* wf_engine.threshold := -1;*/
245: wf_engine.StartProcess( itemtype => item_type,
246: itemkey => item_key);
247:
248: /* Set workflow process to background for better performance */
249: /* wf_engine.threshold := -1;*/
250:
251: EXCEPTION
252:
253: when others then
263: funcmode in varchar2,
264: resultout out nocopy varchar2) is
265:
266: l_line_location_id number :=
267: wf_engine.GetItemAttrNumber( itemtype => itemtype,
268: itemkey => itemkey,
269: aname => 'LINE_LOCATION_ID');
270:
271: l_new_need_by_date date :=
268: itemkey => itemkey,
269: aname => 'LINE_LOCATION_ID');
270:
271: l_new_need_by_date date :=
272: wf_engine.GetItemAttrDate( itemtype => itemtype,
273: itemkey => itemkey,
274: aname => 'NEW_NEED_BY_DATE');
275:
276:
316: funcmode in varchar2,
317: resultout out nocopy varchar2) is
318:
319: l_line_location_id number :=
320: wf_engine.GetItemAttrNumber( itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'LINE_LOCATION_ID');
323:
324: l_new_promise_date date :=
321: itemkey => itemkey,
322: aname => 'LINE_LOCATION_ID');
323:
324: l_new_promise_date date :=
325: wf_engine.GetItemAttrDate( itemtype => itemtype,
326: itemkey => itemkey,
327: aname => 'NEW_NEED_BY_DATE');
328:
329: BEGIN