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.GML_BATCH_WORKFLOW_PKG dependencies on WF_ENGINE

Line 37: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;

33: , p_action_code IN VARCHAR2 )IS
34:
35: l_itemtype VARCHAR2(240) := 'GMLBTRES';
36: l_itemkey VARCHAR2(240) := to_char(p_session_id)||'-'||to_char(sysdate,'dd-MON-yyyy HH24:mi:ss');
37: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
38: l_WorkflowProcess VARCHAR2(30) := 'GMLBTRES_PROCESS';
39: l_count NUMBER;
40:
41: l_order_no NUMBER;

Line 157: WF_ENGINE.CREATEPROCESS(

153:
154:
155: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf before CreateProcess');
156:
157: WF_ENGINE.CREATEPROCESS(
158: itemtype => l_itemtype
159: , itemkey => l_itemkey
160: , process => l_WorkflowProcess) ;
161:

Line 166: -- WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

162: /* make sure that process runs with background engine */
163:
164: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf after CreateProcess');
165:
166: -- WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
167: --WF_ENGINE.THRESHOLD := -1 ;
168:
169: /* set the item attributes*/
170: /*

Line 167: --WF_ENGINE.THRESHOLD := -1 ;

163:
164: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf after CreateProcess');
165:
166: -- WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
167: --WF_ENGINE.THRESHOLD := -1 ;
168:
169: /* set the item attributes*/
170: /*
171: WF_ENGINE.SETITEMATTRNUMBER(

Line 171: WF_ENGINE.SETITEMATTRNUMBER(

167: --WF_ENGINE.THRESHOLD := -1 ;
168:
169: /* set the item attributes*/
170: /*
171: WF_ENGINE.SETITEMATTRNUMBER(
172: itemtype => l_itemtype
173: , itemkey => l_itemkey
174: , aname => 'SESSION_ID'
175: , avalue => l_session_id );

Line 178: WF_ENGINE.SETITEMATTRTEXT(

174: , aname => 'SESSION_ID'
175: , avalue => l_session_id );
176: */
177:
178: WF_ENGINE.SETITEMATTRTEXT(
179: itemtype => l_itemtype
180: , itemkey =>l_itemkey
181: , aname => 'APPROVER'
182: , avalue => l_approver_name);

Line 186: WF_ENGINE.SETITEMATTRTEXT(

182: , avalue => l_approver_name);
183:
184: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Approver Name');
185:
186: WF_ENGINE.SETITEMATTRTEXT(
187: itemtype => l_itemtype
188: , itemkey => l_itemkey
189: , aname => 'ACTION_CODE'
190: , avalue => p_action_code );

Line 194: WF_ENGINE.SETITEMATTRTEXT(

190: , avalue => p_action_code );
191:
192: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set action Code');
193:
194: WF_ENGINE.SETITEMATTRTEXT(
195: itemtype => l_itemtype
196: , itemkey => l_itemkey
197: , aname => 'ORDER_NO'
198: , avalue => to_char(l_order_no) );

Line 202: WF_ENGINE.SETITEMATTRTEXT(

198: , avalue => to_char(l_order_no) );
199:
200: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Order Number ');
201:
202: WF_ENGINE.SETITEMATTRTEXT(
203: itemtype => l_itemtype
204: , itemkey => l_itemkey
205: , aname => 'ORDER_TYPE'
206: , avalue => l_order_type );

Line 210: WF_ENGINE.SETITEMATTRTEXT(

206: , avalue => l_order_type );
207:
208: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Order Type ');
209:
210: WF_ENGINE.SETITEMATTRTEXT(
211: itemtype => l_itemtype
212: , itemkey => l_itemkey
213: , aname => 'SO_LINE_NO'
214: , avalue => to_char(l_so_line_no) );

Line 218: WF_ENGINE.SETITEMATTRTEXT(

214: , avalue => to_char(l_so_line_no) );
215:
216: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set so_line_no ');
217:
218: WF_ENGINE.SETITEMATTRTEXT(
219: itemtype => l_itemtype
220: , itemkey => l_itemkey
221: , aname => 'ITEM_NO'
222: , avalue => l_item_no );

Line 226: WF_ENGINE.SETITEMATTRTEXT(

222: , avalue => l_item_no );
223:
224: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Item Number ');
225:
226: WF_ENGINE.SETITEMATTRTEXT(
227: itemtype => l_itemtype
228: , itemkey => l_itemkey
229: , aname => 'PLANT_CODE'
230: , avalue => l_plant_code );

Line 234: WF_ENGINE.SETITEMATTRTEXT(

230: , avalue => l_plant_code );
231:
232: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Plant Code ');
233:
234: WF_ENGINE.SETITEMATTRTEXT(
235: itemtype => l_itemtype
236: , itemkey => l_itemkey
237: , aname => 'BATCH_NO'
238: , avalue => l_batch_no );

Line 242: WF_ENGINE.SETITEMATTRTEXT(

238: , avalue => l_batch_no );
239:
240: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Whse Code ');
241:
242: WF_ENGINE.SETITEMATTRTEXT(
243: itemtype => l_itemtype
244: , itemkey => l_itemkey
245: , aname => 'WHSE_CODE'
246: , avalue => p_whse_code );

Line 250: WF_ENGINE.SETITEMATTRTEXT(

246: , avalue => p_whse_code );
247:
248: IF (p_lot_no is NOT NULL) THEN
249: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Whse Code ');
250: WF_ENGINE.SETITEMATTRTEXT(
251: itemtype => l_itemtype
252: , itemkey => l_itemkey
253: , aname => 'LOT_NO'
254: , avalue => p_lot_no );

Line 259: WF_ENGINE.SETITEMATTRTEXT(

255: END IF;
256:
257: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set Batch Number ');
258:
259: WF_ENGINE.SETITEMATTRTEXT(
260: itemtype => l_itemtype
261: , itemkey => l_itemkey
262: , aname => 'FPO_NO'
263: , avalue => l_fpo_no );

Line 268: WF_ENGINE.SETITEMATTRTEXT(

264:
265: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Set FPO Number ');
266:
267: /*
268: WF_ENGINE.SETITEMATTRTEXT(
269: itemtype => l_itemtype
270: , itemkey => l_itemkey
271: , aname => 'PL_COMPL_DATE'
272: , avalue => TO_CHAR(TO_DATE(l_plan_complt_date,'MON-DD-YYYY')) );

Line 280: WF_ENGINE.STARTPROCESS (

276:
277: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf after Setting the Attributes');
278: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Before Start Process');
279:
280: WF_ENGINE.STARTPROCESS (
281: itemtype => l_itemtype
282: , itemkey => l_itemkey );
283:
284: GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf After Start Process');

Line 325: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT(

321: p_actid IN NUMBER,
322: p_funcmode IN VARCHAR2,
323: p_resultout OUT NOCOPY VARCHAR2) IS
324:
325: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT(
326: itemtype=>p_itemtype,
327: itemkey=>P_itemkey,
328: aname => 'ACTION_CODE');
329: BEGIN