44:
45:
46: -- Do nothing in cancel or timeout mode
47: --
48: if (funcmode <> wf_engine.eng_run) then
49:
50: result := wf_engine.eng_null;
51: return;
52:
46: -- Do nothing in cancel or timeout mode
47: --
48: if (funcmode <> wf_engine.eng_run) then
49:
50: result := wf_engine.eng_null;
51: return;
52:
53: end if;
54:
51: return;
52:
53: end if;
54:
55: x_destination_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'DESTINATION_TYPE_CODE');
58:
59: x_dest_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
55: x_destination_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'DESTINATION_TYPE_CODE');
58:
59: x_dest_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
60: itemkey => itemkey,
61: aname => 'DESTINATION_ORGANIZATION_ID');
62:
63: x_dest_sub_inv := wf_engine.GetItemAttrText ( itemtype => itemtype,
59: x_dest_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
60: itemkey => itemkey,
61: aname => 'DESTINATION_ORGANIZATION_ID');
62:
63: x_dest_sub_inv := wf_engine.GetItemAttrText ( itemtype => itemtype,
64: itemkey => itemkey,
65: aname => 'DESTINATION_SUBINVENTORY');
66:
67: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
63: x_dest_sub_inv := wf_engine.GetItemAttrText ( itemtype => itemtype,
64: itemkey => itemkey,
65: aname => 'DESTINATION_SUBINVENTORY');
66:
67: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
68: itemkey => itemkey,
69: aname => 'ITEM_ID');
70: /*
71: If (debug_acc_generator_wf) then
90: End;
91:
92: if (x_account IS NOT NULL) then
93:
94: wf_engine.SetItemAttrNumber ( itemtype=>itemtype,
95: itemkey=>itemkey,
96: aname=>'TEMP_ACCOUNT_ID',
97: avalue=>x_account );
98:
136:
137:
138: -- Do nothing in cancel or timeout mode
139: --
140: if (funcmode <> wf_engine.eng_run) then
141:
142: result := wf_engine.eng_null;
143: return;
144:
138: -- Do nothing in cancel or timeout mode
139: --
140: if (funcmode <> wf_engine.eng_run) then
141:
142: result := wf_engine.eng_null;
143: return;
144:
145: end if;
146:
143: return;
144:
145: end if;
146:
147: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
148: itemkey => itemkey,
149: aname => 'ITEM_ID');
150:
151: if (x_item_id is NULL) then
187:
188:
189: -- Do nothing in cancel or timeout mode
190: --
191: if (funcmode <> wf_engine.eng_run) then
192:
193: result := wf_engine.eng_null;
194: return;
195:
189: -- Do nothing in cancel or timeout mode
190: --
191: if (funcmode <> wf_engine.eng_run) then
192:
193: result := wf_engine.eng_null;
194: return;
195:
196: end if;
197:
194: return;
195:
196: end if;
197:
198: x_dest_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
199: itemkey => itemkey,
200: aname => 'DESTINATION_ORGANIZATION_ID');
201:
202: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
198: x_dest_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
199: itemkey => itemkey,
200: aname => 'DESTINATION_ORGANIZATION_ID');
201:
202: x_item_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
203: itemkey => itemkey,
204: aname => 'ITEM_ID');
205: /*
206: If (debug_acc_generator_wf) then
215: from MTL_SYSTEM_ITEMS
216: where organization_id = x_dest_org_id
217: and inventory_item_id = x_item_id;
218:
219: wf_engine.SetItemAttrNumber ( itemtype=>itemtype,
220: itemkey=>itemkey,
221: aname=>'TEMP_ACCOUNT_ID',
222: avalue=>x_account );
223: exception
263:
264:
265: -- Do nothing in cancel or timeout mode
266: --
267: if (funcmode <> wf_engine.eng_run) then
268:
269: result := wf_engine.eng_null;
270: return;
271:
265: -- Do nothing in cancel or timeout mode
266: --
267: if (funcmode <> wf_engine.eng_run) then
268:
269: result := wf_engine.eng_null;
270: return;
271:
272: end if;
273:
270: return;
271:
272: end if;
273:
274: x_dest_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
275: itemkey => itemkey,
276: aname => 'DESTINATION_ORGANIZATION_ID');
277: /*
278: If (debug_acc_generator_wf) then
291: end;
292:
293: if (x_account IS NOT NULL) then
294:
295: wf_engine.SetItemAttrNumber ( itemtype=>itemtype,
296: itemkey=>itemkey,
297: aname=>'TEMP_ACCOUNT_ID',
298: avalue=>x_account );
299:
333:
334:
335: -- Do nothing in cancel or timeout mode
336: --
337: if (funcmode <> wf_engine.eng_run) then
338:
339: result := wf_engine.eng_null;
340: return;
341:
335: -- Do nothing in cancel or timeout mode
336: --
337: if (funcmode <> wf_engine.eng_run) then
338:
339: result := wf_engine.eng_null;
340: return;
341:
342: end if;
343:
340: return;
341:
342: end if;
343:
344: x_account := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
345: itemkey => itemkey,
346: aname => 'CODE_COMBINATION_ID');
347: /*
348: If (debug_acc_generator_wf) then
351: end if;
352: */
353: if (x_account IS NOT NULL) then
354:
355: wf_engine.SetItemAttrNumber ( itemtype=>itemtype,
356: itemkey=>itemkey,
357: aname=>'TEMP_ACCOUNT_ID',
358: avalue=>x_account );
359: