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

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

40: l_api_name CONSTANT VARCHAR2 (30) := 'init_wf';
41: l_itemtype VARCHAR2(240) := 'GMEBTRES';
42: --l_itemkey VARCHAR2(240) := to_char(p_session_id)||'-'||to_char(sysdate,'dd-MON-yyyy HH24:mi:ss');
43: l_itemkey VARCHAR2(240) ;
44: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
45: l_WorkflowProcess VARCHAR2(30) := 'GMEBTRES_PROCESS';
46: l_count NUMBER;
47:
48: l_order_no NUMBER;

Line 213: WF_ENGINE.CREATEPROCESS(

209: /* create the process*/
210: /*IF g_debug <= gme_debug.g_log_procedure THEN
211: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Init_wf before CreateProcess');
212: END IF;
213: WF_ENGINE.CREATEPROCESS(
214: itemtype => l_itemtype
215: , itemkey => l_itemkey
216: , process => l_WorkflowProcess) ;
217: */

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

219: IF g_debug <= gme_debug.g_log_procedure THEN
220: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after CreateProcess');
221: END IF;
222:
223: -- WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
224: --WF_ENGINE.THRESHOLD := -1 ;
225:
226: l_itemkey := p_itemkey;
227: l_itemtype := p_itemtype;

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

220: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after CreateProcess');
221: END IF;
222:
223: -- WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
224: --WF_ENGINE.THRESHOLD := -1 ;
225:
226: l_itemkey := p_itemkey;
227: l_itemtype := p_itemtype;
228: /* set the item attributes*/

Line 229: WF_ENGINE.SETITEMATTRTEXT(

225:
226: l_itemkey := p_itemkey;
227: l_itemtype := p_itemtype;
228: /* set the item attributes*/
229: WF_ENGINE.SETITEMATTRTEXT(
230: itemtype => l_itemtype
231: , itemkey =>l_itemkey
232: , aname => 'APPROVER'
233: , avalue => l_approver_name);

Line 237: WF_ENGINE.SETITEMATTRTEXT(

233: , avalue => l_approver_name);
234: IF g_debug <= gme_debug.g_log_procedure THEN
235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Approver Name');
236: END IF;
237: WF_ENGINE.SETITEMATTRTEXT(
238: itemtype => l_itemtype
239: , itemkey => l_itemkey
240: , aname => 'ACTION_CODE'
241: , avalue => p_action_code );

Line 246: WF_ENGINE.SETITEMATTRTEXT(

242:
243: IF g_debug <= gme_debug.g_log_procedure THEN
244: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Action Code ');
245: END IF;
246: WF_ENGINE.SETITEMATTRTEXT(
247: itemtype => l_itemtype
248: , itemkey => l_itemkey
249: , aname => 'ORDER_NO'
250: , avalue => to_char(l_order_no) );

Line 255: WF_ENGINE.SETITEMATTRTEXT(

251:
252: IF g_debug <= gme_debug.g_log_procedure THEN
253: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Number ');
254: END IF;
255: WF_ENGINE.SETITEMATTRTEXT(
256: itemtype => l_itemtype
257: , itemkey => l_itemkey
258: , aname => 'ORDER_TYPE'
259: , avalue => l_order_type );

Line 264: WF_ENGINE.SETITEMATTRTEXT(

260:
261: IF g_debug <= gme_debug.g_log_procedure THEN
262: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Type ');
263: END IF;
264: WF_ENGINE.SETITEMATTRTEXT(
265: itemtype => l_itemtype
266: , itemkey => l_itemkey
267: , aname => 'SO_LINE_NO'
268: , avalue => to_char(l_so_line_no) );

Line 273: WF_ENGINE.SETITEMATTRTEXT(

269:
270: IF g_debug <= gme_debug.g_log_procedure THEN
271: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set so_line_no ');
272: END IF;
273: WF_ENGINE.SETITEMATTRTEXT(
274: itemtype => l_itemtype
275: , itemkey => l_itemkey
276: , aname => 'ITEM_NO'
277: , avalue => l_item_no );

Line 279: WF_ENGINE.SETITEMATTRTEXT(

275: , itemkey => l_itemkey
276: , aname => 'ITEM_NO'
277: , avalue => l_item_no );
278:
279: WF_ENGINE.SETITEMATTRTEXT(
280: itemtype => l_itemtype
281: , itemkey => l_itemkey
282: , aname => 'ORG_CODE'
283: , avalue => l_organization_code);

Line 287: WF_ENGINE.SETITEMATTRTEXT(

283: , avalue => l_organization_code);
284: IF g_debug <= gme_debug.g_log_procedure THEN
285: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Number ');
286: END IF;
287: WF_ENGINE.SETITEMATTRTEXT(
288: itemtype => l_itemtype
289: , itemkey => l_itemkey
290: , aname => 'BATCH_NO'
291: , avalue => l_batch_no );

Line 296: WF_ENGINE.SETITEMATTRTEXT(

292:
293: IF g_debug <= gme_debug.g_log_procedure THEN
294: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Line Number ');
295: END IF;
296: WF_ENGINE.SETITEMATTRTEXT(
297: itemtype => l_itemtype
298: , itemkey => l_itemkey
299: , aname => 'BATCH_LINE_NO'
300: , avalue => l_batch_line_no );

Line 306: WF_ENGINE.SETITEMATTRTEXT(

302: IF (p_lot_no is NOT NULL) THEN
303: IF g_debug <= gme_debug.g_log_procedure THEN
304: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set lot_no ');
305: END IF;
306: WF_ENGINE.SETITEMATTRTEXT(
307: itemtype => l_itemtype
308: , itemkey => l_itemkey
309: , aname => 'LOT_NO'
310: , avalue => p_lot_no );

Line 315: WF_ENGINE.SETITEMATTRTEXT(

311: END IF;
312: IF g_debug <= gme_debug.g_log_procedure THEN
313: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set FPO Number ');
314: END IF;
315: WF_ENGINE.SETITEMATTRTEXT(
316: itemtype => l_itemtype
317: , itemkey => l_itemkey
318: , aname => 'FPO_NO'
319: , avalue => l_fpo_no );

Line 324: /*WF_ENGINE.STARTPROCESS (

320: IF g_debug <= gme_debug.g_log_procedure THEN
321: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after Setting the Attributes');
322: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Before Start Process');
323: END IF;
324: /*WF_ENGINE.STARTPROCESS (
325: itemtype => l_itemtype
326: , itemkey => l_itemkey );
327: */
328: IF g_debug <= gme_debug.g_log_procedure THEN

Line 354: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT( itemtype=>p_itemtype, itemkey=>P_itemkey, aname => 'ACTION_CODE');

350: p_actid IN NUMBER,
351: p_funcmode IN VARCHAR2,
352: p_resultout OUT NOCOPY VARCHAR2) IS
353:
354: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT( itemtype=>p_itemtype, itemkey=>P_itemkey, aname => 'ACTION_CODE');
355: --l_session_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SESSION_ID');
356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');

Line 355: --l_session_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SESSION_ID');

351: p_funcmode IN VARCHAR2,
352: p_resultout OUT NOCOPY VARCHAR2) IS
353:
354: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT( itemtype=>p_itemtype, itemkey=>P_itemkey, aname => 'ACTION_CODE');
355: --l_session_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SESSION_ID');
356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');

Line 356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');

352: p_resultout OUT NOCOPY VARCHAR2) IS
353:
354: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT( itemtype=>p_itemtype, itemkey=>P_itemkey, aname => 'ACTION_CODE');
355: --l_session_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SESSION_ID');
356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');

Line 357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');

353:
354: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT( itemtype=>p_itemtype, itemkey=>P_itemkey, aname => 'ACTION_CODE');
355: --l_session_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SESSION_ID');
356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');

Line 358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');

354: l_event_type VARCHAR2(240) := WF_ENGINE.GETITEMATTRTEXT( itemtype=>p_itemtype, itemkey=>P_itemkey, aname => 'ACTION_CODE');
355: --l_session_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SESSION_ID');
356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');
362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');

Line 359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');

355: --l_session_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SESSION_ID');
356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');
362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');
363: l_lot_no varchar2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'LOT_NO');

Line 360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');

356: l_approver number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'APPROVER');
357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');
362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');
363: l_lot_no varchar2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'LOT_NO');
364: l_action_code varchar2(30) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ACTION_CODE');

Line 361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');

357: l_so_header_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_HEADER_ID');
358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');
362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');
363: l_lot_no varchar2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'LOT_NO');
364: l_action_code varchar2(30) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ACTION_CODE');
365: BEGIN

Line 362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');

358: l_so_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SO_LINE_ID');
359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');
362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');
363: l_lot_no varchar2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'LOT_NO');
364: l_action_code varchar2(30) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ACTION_CODE');
365: BEGIN
366:

Line 363: l_lot_no varchar2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'LOT_NO');

359: l_batch_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_ID');
360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');
362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');
363: l_lot_no varchar2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'LOT_NO');
364: l_action_code varchar2(30) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ACTION_CODE');
365: BEGIN
366:
367: wf_log_pkg.wf_debug_flag:=TRUE;

Line 364: l_action_code varchar2(30) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ACTION_CODE');

360: l_batch_line_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'BATCH_LINE_ID');
361: l_fpo_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'FPO_ID');
362: l_organization_id number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ORGANIZATION_ID');
363: l_lot_no varchar2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'LOT_NO');
364: l_action_code varchar2(30) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ACTION_CODE');
365: BEGIN
366:
367: wf_log_pkg.wf_debug_flag:=TRUE;
368: IF g_debug <= gme_debug.g_log_procedure THEN