DBA Data[Home] [Help]

APPS.WIP_WF_UPDATE_DATE dependencies on WF_ENGINE

Line 40: wf_engine.CreateProcess( itemtype => item_type,

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 */

Line 119: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 124: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 129: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 134: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 139: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 144: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 149: wf_engine.SetItemAttrText( itemtype => item_type,

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:

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

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:

Line 159: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 164: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 169: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 174: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 179: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 184: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 189: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 194: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 199: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 204: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 209: wf_engine.SetItemAttrDate( itemtype => item_type,

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:

Line 214: wf_engine.SetItemAttrDate( itemtype => item_type,

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:

Line 219: wf_engine.SetItemAttrDate( itemtype => item_type,

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:

Line 224: wf_engine.SetItemAttrText( itemtype => item_type,

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:

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

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:

Line 234: wf_engine.SetItemAttrText( itemtype => item_type,

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:

Line 239: wf_engine.SetItemAttrNumber( itemtype => item_type,

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:

Line 245: wf_engine.StartProcess( itemtype => item_type,

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;*/

Line 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

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

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 :=

Line 272: wf_engine.GetItemAttrDate( itemtype => itemtype,

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:

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

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 :=

Line 325: wf_engine.GetItemAttrDate( itemtype => itemtype,

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