DBA Data[Home] [Help]

APPS.INV_LOT_SERIAL_DATE_PKG dependencies on WF_ENGINE

Line 30: WF_ENGINE.ITEMSTATUS ( itemtype => l_itemtype,

26: BEGIN
27: IF (WF_ITEM.ITEM_EXIST (l_itemtype, l_itemkey)) THEN
28:
29: /* Check item status */
30: WF_ENGINE.ITEMSTATUS ( itemtype => l_itemtype,
31: itemkey => l_itemkey,
32: status => l_status,
33: result => l_result);
34:

Line 39: WF_ENGINE.ABORTPROCESS (itemtype=> l_itemtype,

35: -- wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);
36: /* If it is not completed then abort the process */
37: IF (l_status <> 'COMPLETE')THEN
38:
39: WF_ENGINE.ABORTPROCESS (itemtype=> l_itemtype,
40: itemkey=> l_itemkey,
41: process=> l_workflowprocess);
42:
43: END IF;

Line 152: l_organization_id := WF_ENGINE.GETITEMATTRNUMBER

148:
149:
150: BEGIN
151:
152: l_organization_id := WF_ENGINE.GETITEMATTRNUMBER
153: (itemtype => p_itemtype,
154: itemkey => p_itemkey,
155: aname => 'ORGANIZATION_ID');
156:

Line 157: l_organization_code := WF_ENGINE.GETITEMATTRTEXT

153: (itemtype => p_itemtype,
154: itemkey => p_itemkey,
155: aname => 'ORGANIZATION_ID');
156:
157: l_organization_code := WF_ENGINE.GETITEMATTRTEXT
158: (itemtype => p_itemtype,
159: itemkey => p_itemkey,
160: aname => 'ORGANIZATION_CODE');
161:

Line 162: l_item_id := WF_ENGINE.GETITEMATTRNUMBER

158: (itemtype => p_itemtype,
159: itemkey => p_itemkey,
160: aname => 'ORGANIZATION_CODE');
161:
162: l_item_id := WF_ENGINE.GETITEMATTRNUMBER
163: (itemtype => p_itemtype,
164: itemkey => p_itemkey,
165: aname => 'ITEM_ID');
166:

Line 167: l_item_number := WF_ENGINE.GETITEMATTRTEXT

163: (itemtype => p_itemtype,
164: itemkey => p_itemkey,
165: aname => 'ITEM_ID');
166:
167: l_item_number := WF_ENGINE.GETITEMATTRTEXT
168: (itemtype => p_itemtype,
169: itemkey => p_itemkey,
170: aname => 'ITEM_NUMBER');
171:

Line 172: l_category_id := WF_ENGINE.GETITEMATTRNUMBER

168: (itemtype => p_itemtype,
169: itemkey => p_itemkey,
170: aname => 'ITEM_NUMBER');
171:
172: l_category_id := WF_ENGINE.GETITEMATTRNUMBER
173: (itemtype => p_itemtype,
174: itemkey => p_itemkey,
175: aname => 'CATEGORY_ID');
176:

Line 177: l_item_category := WF_ENGINE.GETITEMATTRTEXT

173: (itemtype => p_itemtype,
174: itemkey => p_itemkey,
175: aname => 'CATEGORY_ID');
176:
177: l_item_category := WF_ENGINE.GETITEMATTRTEXT
178: (itemtype => p_itemtype,
179: itemkey => p_itemkey,
180: aname => 'ITEM_CATEGORY');
181:

Line 182: l_query_for := WF_ENGINE.GETITEMATTRTEXT

178: (itemtype => p_itemtype,
179: itemkey => p_itemkey,
180: aname => 'ITEM_CATEGORY');
181:
182: l_query_for := WF_ENGINE.GETITEMATTRTEXT
183: (itemtype => p_itemtype,
184: itemkey => p_itemkey,
185: aname => 'QUERY_FOR');
186:

Line 187: l_lot_number := WF_ENGINE.GETITEMATTRTEXT

183: (itemtype => p_itemtype,
184: itemkey => p_itemkey,
185: aname => 'QUERY_FOR');
186:
187: l_lot_number := WF_ENGINE.GETITEMATTRTEXT
188: (itemtype => p_itemtype,
189: itemkey => p_itemkey,
190: aname => 'LOT_NUMBER');
191:

Line 192: l_serial_number := WF_ENGINE.GETITEMATTRTEXT

188: (itemtype => p_itemtype,
189: itemkey => p_itemkey,
190: aname => 'LOT_NUMBER');
191:
192: l_serial_number := WF_ENGINE.GETITEMATTRTEXT
193: (itemtype => p_itemtype,
194: itemkey => p_itemkey,
195: aname => 'SERIAL_NUMBER');
196:

Line 197: l_date_context := WF_ENGINE.GETITEMATTRTEXT

193: (itemtype => p_itemtype,
194: itemkey => p_itemkey,
195: aname => 'SERIAL_NUMBER');
196:
197: l_date_context := WF_ENGINE.GETITEMATTRTEXT
198: (itemtype => p_itemtype,
199: itemkey => p_itemkey,
200: aname => 'DATE_CONTEXT');
201:

Line 202: l_date_type := WF_ENGINE.GETITEMATTRTEXT

198: (itemtype => p_itemtype,
199: itemkey => p_itemkey,
200: aname => 'DATE_CONTEXT');
201:
202: l_date_type := WF_ENGINE.GETITEMATTRTEXT
203: (itemtype => p_itemtype,
204: itemkey => p_itemkey,
205: aname => 'DATE_TYPE');
206:

Line 207: l_user_date_type := WF_ENGINE.GETITEMATTRTEXT

203: (itemtype => p_itemtype,
204: itemkey => p_itemkey,
205: aname => 'DATE_TYPE');
206:
207: l_user_date_type := WF_ENGINE.GETITEMATTRTEXT
208: (itemtype => p_itemtype,
209: itemkey => p_itemkey,
210: aname => 'USER_DATE_TYPE');
211:

Line 212: l_date_value := WF_ENGINE.GETITEMATTRTEXT

208: (itemtype => p_itemtype,
209: itemkey => p_itemkey,
210: aname => 'USER_DATE_TYPE');
211:
212: l_date_value := WF_ENGINE.GETITEMATTRTEXT
213: (itemtype => p_itemtype,
214: itemkey => p_itemkey,
215: aname => 'DATE_VALUE');
216:

Line 217: l_action_code := WF_ENGINE.GETITEMATTRTEXT

213: (itemtype => p_itemtype,
214: itemkey => p_itemkey,
215: aname => 'DATE_VALUE');
216:
217: l_action_code := WF_ENGINE.GETITEMATTRTEXT
218: (itemtype => p_itemtype,
219: itemkey => p_itemkey,
220: aname => 'ACTION_CODE');
221:

Line 222: l_serial_status := WF_ENGINE.GETITEMATTRTEXT

218: (itemtype => p_itemtype,
219: itemkey => p_itemkey,
220: aname => 'ACTION_CODE');
221:
222: l_serial_status := WF_ENGINE.GETITEMATTRTEXT
223: (itemtype => p_itemtype,
224: itemkey => p_itemkey,
225: aname => 'SERIAL_STATUS');
226:

Line 227: l_onhand_qty_uom := WF_ENGINE.GETITEMATTRTEXT

223: (itemtype => p_itemtype,
224: itemkey => p_itemkey,
225: aname => 'SERIAL_STATUS');
226:
227: l_onhand_qty_uom := WF_ENGINE.GETITEMATTRTEXT
228: (itemtype => p_itemtype,
229: itemkey => p_itemkey,
230: aname => 'ONHAND_QTY_UOM');
231:

Line 232: l_transaction_id := WF_ENGINE.GETITEMATTRNUMBER

228: (itemtype => p_itemtype,
229: itemkey => p_itemkey,
230: aname => 'ONHAND_QTY_UOM');
231:
232: l_transaction_id := WF_ENGINE.GETITEMATTRNUMBER
233: (itemtype => p_itemtype,
234: itemkey => p_itemkey,
235: aname => 'TRANSACTION_ID');
236: