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

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

23: /* make sure that process runs with background engine
24: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
25: the value to use for this is -1 */
26:
27: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
28:
29:
30: l_item_no ic_item_mst.item_no%TYPE ;
31: l_item_desc1 ic_item_mst.item_desc1%TYPE ;

Line 47: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess);

43:
44: IF l_count > 0 THEN
45: /* create the process */
46:
47: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess);
48:
49: /* make sure that process runs with background engine */
50: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
51:

Line 50: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

46:
47: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess);
48:
49: /* make sure that process runs with background engine */
50: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
51:
52: /* set the item attributes */
53: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
54: aname => 'TRANS_ID',

Line 53: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

49: /* make sure that process runs with background engine */
50: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
51:
52: /* set the item attributes */
53: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
54: aname => 'TRANS_ID',
55: avalue => p_trans_id);
56:
57: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 57: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

53: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
54: aname => 'TRANS_ID',
55: avalue => p_trans_id);
56:
57: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
58: aname => 'ORGN_CODE',
59: avalue => p_orgn_code);
60:
61: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

Line 61: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

57: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
58: aname => 'ORGN_CODE',
59: avalue => p_orgn_code);
60:
61: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
62: aname => 'WHSE_CODE',
63: avalue => p_whse_code);
64: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
65: aname => 'ITEM_ID',

Line 64: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

60:
61: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
62: aname => 'WHSE_CODE',
63: avalue => p_whse_code);
64: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
65: aname => 'ITEM_ID',
66: avalue => p_item_id);
67:
68: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,

Line 68: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,

64: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
65: aname => 'ITEM_ID',
66: avalue => p_item_id);
67:
68: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,
69: aname => 'LOT_ID',
70: avalue => p_lot_id);
71:
72: WF_ENGINE.SETITEMATTRTEXT (itemtype => l_itemtype,itemkey => l_itemkey,

Line 72: WF_ENGINE.SETITEMATTRTEXT (itemtype => l_itemtype,itemkey => l_itemkey,

68: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,
69: aname => 'LOT_ID',
70: avalue => p_lot_id);
71:
72: WF_ENGINE.SETITEMATTRTEXT (itemtype => l_itemtype,itemkey => l_itemkey,
73: aname => 'DOC_TYPE',
74: avalue => p_doc_type);
75:
76: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,

Line 76: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,

72: WF_ENGINE.SETITEMATTRTEXT (itemtype => l_itemtype,itemkey => l_itemkey,
73: aname => 'DOC_TYPE',
74: avalue => p_doc_type);
75:
76: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,
77: aname => 'DOC_ID',
78: avalue => p_doc_id);
79:
80: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,

Line 80: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,

76: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,
77: aname => 'DOC_ID',
78: avalue => p_doc_id);
79:
80: WF_ENGINE.SETITEMATTRNUMBER (itemtype => l_itemtype,itemkey => l_itemkey,
81: aname => 'TRANS_QTY',
82: avalue => p_trans_qty);
83:
84: /* start the Workflow process */

Line 86: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);

82: avalue => p_trans_qty);
83:
84: /* start the Workflow process */
85:
86: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
87:
88: END IF;
89: EXCEPTION
90: WHEN OTHERS THEN

Line 107: l_item_id ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'ITEM_ID');

103: p_funcmode IN VARCHAR2,
104: p_resultout OUT VARCHAR2
105: )
106: IS
107: l_item_id ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'ITEM_ID');
108: l_item_no ic_item_mst.item_no%TYPE;
109: l_whse_item_no Varchar2(32);
110: l_whse_item_id ic_item_mst.item_id%TYPE;
111: l_item_desc1 ic_item_mst.item_desc1%TYPE;

Line 114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');

110: l_whse_item_id ic_item_mst.item_id%TYPE;
111: l_item_desc1 ic_item_mst.item_desc1%TYPE;
112: l_item_um ic_item_mst.item_um%TYPE;
113: l_item_um2 ic_item_mst.item_um2%TYPE;
114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');
115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');
116: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;

Line 115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');

111: l_item_desc1 ic_item_mst.item_desc1%TYPE;
112: l_item_um ic_item_mst.item_um%TYPE;
113: l_item_um2 ic_item_mst.item_um2%TYPE;
114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');
115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');
116: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;

Line 117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');

113: l_item_um2 ic_item_mst.item_um2%TYPE;
114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');
115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');
116: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
121: l_doc_type sy_docs_mst.doc_type%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_TYPE');

Line 121: l_doc_type sy_docs_mst.doc_type%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_TYPE');

117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
121: l_doc_type sy_docs_mst.doc_type%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_TYPE');
122: l_doc_desc sy_docs_mst.doc_desc%TYPE;
123: l_role_name wf_roles.name%TYPE;
124: l_role_display_name wf_roles.display_name%TYPE;
125: l_email_Address varchar2(2000);

Line 139: l_doc_id ic_tran_pnd.doc_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_ID');

135: l_process_name VARCHAR2(80):='GMDQC0_PROCESS';
136: l_activity_name VARCHAR2(100):='SELECT_ROLE';
137: /* Begin Bug#2250274 Praveen Reddy */
138: /* Added variables l_doc_id and l_doc_no*/
139: l_doc_id ic_tran_pnd.doc_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_ID');
140: l_doc_no VARCHAR2(40);
141: /* End Bug#2250274*/
142: BEGIN
143: IF (p_funcmode = 'RUN') THEN

Line 223: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

219: l_lot_no||'" SUBLOT_NO="'||l_sublot_no||'" WF="YES"';
220: END IF;
221:
222: /* Setting all the required attributes */
223: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
224: itemkey => p_itemkey,
225: aname => 'SAMPLE_FORM',
226: avalue => l_sample_form);
227:

Line 228: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

224: itemkey => p_itemkey,
225: aname => 'SAMPLE_FORM',
226: avalue => l_sample_form);
227:
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
229: itemkey => p_itemkey,
230: aname => 'ITEM_NO',
231: avalue => l_item_no);
232:

Line 233: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

229: itemkey => p_itemkey,
230: aname => 'ITEM_NO',
231: avalue => l_item_no);
232:
233: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
234: itemkey => p_itemkey,
235: aname => 'ITEM_DESC1',
236: avalue => l_item_desc1);
237:

Line 238: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

234: itemkey => p_itemkey,
235: aname => 'ITEM_DESC1',
236: avalue => l_item_desc1);
237:
238: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
239: itemkey => p_itemkey,
240: aname => 'ITEM_UM',
241: avalue => l_item_um);
242:

Line 243: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

239: itemkey => p_itemkey,
240: aname => 'ITEM_UM',
241: avalue => l_item_um);
242:
243: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
244: itemkey => p_itemkey,
245: aname => 'ITEM_UM2',
246: avalue => l_item_um2);
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

Line 247: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

243: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
244: itemkey => p_itemkey,
245: aname => 'ITEM_UM2',
246: avalue => l_item_um2);
247: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
248: itemkey => p_itemkey,
249: aname => 'LOT_NO',
250: avalue => l_lot_no);
251:

Line 252: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

248: itemkey => p_itemkey,
249: aname => 'LOT_NO',
250: avalue => l_lot_no);
251:
252: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
253: itemkey => p_itemkey,
254: aname => 'SUBLOT_NO',
255: avalue => l_sublot_no);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

Line 256: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

252: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
253: itemkey => p_itemkey,
254: aname => 'SUBLOT_NO',
255: avalue => l_sublot_no);
256: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
257: itemkey => p_itemkey,
258: aname => 'ORGN_NAME',
259: avalue => l_orgn_name);
260:

Line 261: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

257: itemkey => p_itemkey,
258: aname => 'ORGN_NAME',
259: avalue => l_orgn_name);
260:
261: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
262: itemkey => p_itemkey,
263: aname => 'WHSE_NAME',
264: avalue => l_whse_name);
265:

Line 266: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

262: itemkey => p_itemkey,
263: aname => 'WHSE_NAME',
264: avalue => l_whse_name);
265:
266: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
267: itemkey => p_itemkey,
268: aname => 'DOC_DESC',
269: avalue => l_doc_desc);
270: /* Begin Bug#2250274 Praveen Reddy*/

Line 272: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

268: aname => 'DOC_DESC',
269: avalue => l_doc_desc);
270: /* Begin Bug#2250274 Praveen Reddy*/
271: /* Added call to set the doc_no value into the workflow tables */
272: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
273: itemkey => p_itemkey,
274: aname => 'DOC_NO',
275: avalue => l_doc_no);
276: /* End Bug#2250274 */

Line 308: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

304: END;
305:
306: WF_DIRECTORY.GETROLEINFO(l_role_name,l_role_display_name,l_email_Address,
307: l_notification_Preference,l_language,l_territory);
308: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
309: itemkey => p_itemkey,
310: aname => 'ROLE_NAME',
311: avalue => l_role_name);
312:

Line 313: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

309: itemkey => p_itemkey,
310: aname => 'ROLE_NAME',
311: avalue => l_role_name);
312:
313: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
314: itemkey => p_itemkey,
315: aname => 'ROLE_DISPLAY_NAME',
316: avalue => l_role_display_name);
317: END IF;