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

Line 20: l_save_threshold CONSTANT WF_ENGINE.THRESHOLD%TYPE :=WF_ENGINE.THRESHOLD;

16: l_Notification_preference VARCHAR2(240);
17: l_Language VARCHAR2(240);
18: l_territory VARCHAR2(240);
19: /* Save the Threshold Value*/
20: l_save_threshold CONSTANT WF_ENGINE.THRESHOLD%TYPE :=WF_ENGINE.THRESHOLD;
21: BEGIN
22: /* Get the Item Key from Sequence */
23: SELECT OE_WF_FEEDBACK_S.nextval into l_itemkey from DUAL;
24:

Line 27: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

23: SELECT OE_WF_FEEDBACK_S.nextval into l_itemkey from DUAL;
24:
25: /* create the process */
26:
27: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
28: itemkey => l_itemkey,
29: process => l_WorkflowProcess);
30:
31: /* make sure that process runs in defer mode */

Line 32: WF_ENGINE.THRESHOLD := -1;

28: itemkey => l_itemkey,
29: process => l_WorkflowProcess);
30:
31: /* make sure that process runs in defer mode */
32: WF_ENGINE.THRESHOLD := -1;
33:
34: /*Set All Workflow Attributes with Parameter Values */
35:
36: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

Line 36: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

32: WF_ENGINE.THRESHOLD := -1;
33:
34: /*Set All Workflow Attributes with Parameter Values */
35:
36: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
37: itemkey => l_itemkey,
38: aname => 'CUSTF_RECIPIENT',
39: avalue => p_recipient);
40:

Line 50: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

46: l_Language,
47: L_Territory);
48: /* Set Workflow Attributes */
49:
50: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
51: itemkey => l_itemkey,
52: aname => 'CUSTF_RECIPIENT_NAME',
53: avalue => l_display_name);
54:

Line 55: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

51: itemkey => l_itemkey,
52: aname => 'CUSTF_RECIPIENT_NAME',
53: avalue => l_display_name);
54:
55: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
56: itemkey => l_itemkey,
57: aname => 'CUSTF_NAME',
58: avalue => p_name);
59:

Line 60: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

56: itemkey => l_itemkey,
57: aname => 'CUSTF_NAME',
58: avalue => p_name);
59:
60: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
61: itemkey => l_itemkey,
62: aname => 'CUSTF_EMAIL',
63: avalue => p_email);
64:

Line 65: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

61: itemkey => l_itemkey,
62: aname => 'CUSTF_EMAIL',
63: avalue => p_email);
64:
65: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
66: itemkey => l_itemkey,
67: aname => 'CUSTF_COMMENTS',
68: avalue => p_comments);
69:

Line 71: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

67: aname => 'CUSTF_COMMENTS',
68: avalue => p_comments);
69:
70:
71: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
72: itemkey => l_itemkey,
73: aname => 'CUSTF_FEEDBACK',
74: avalue => p_feedback);
75:

Line 76: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

72: itemkey => l_itemkey,
73: aname => 'CUSTF_FEEDBACK',
74: avalue => p_feedback);
75:
76: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
77: itemkey => l_itemkey,
78: aname => 'CUSTF_PHONE',
79: avalue => p_phone);
80:

Line 83: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,

79: avalue => p_phone);
80:
81: /* start the Workflow process */
82:
83: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
84: itemkey => l_itemkey);
85:
86: /* Reset The Threshold Value */
87: WF_ENGINE.THRESHOLD := l_save_threshold;

Line 87: WF_ENGINE.THRESHOLD := l_save_threshold;

83: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
84: itemkey => l_itemkey);
85:
86: /* Reset The Threshold Value */
87: WF_ENGINE.THRESHOLD := l_save_threshold;
88:
89:
90: EXCEPTION
91: WHEN OTHERS THEN

Line 93: WF_ENGINE.THRESHOLD := l_save_threshold;

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: /* Reset The Threshold Value */
93: WF_ENGINE.THRESHOLD := l_save_threshold;
94: WF_CORE.CONTEXT ('ONT_FEEBBACK_PKG','INIT_WF',l_itemtype,l_itemkey,'Recipient-'||P_RECIPIENT,'Customer-'||P_NAME);
95: raise;
96: END init_wf;
97:

Line 125: l_save_threshold CONSTANT WF_ENGINE.THRESHOLD%TYPE :=WF_ENGINE.THRESHOLD;

121: l_Notification_preference VARCHAR2(240);
122: l_Language VARCHAR2(240);
123: l_territory VARCHAR2(240);
124: /* Save the Threshold Value*/
125: l_save_threshold CONSTANT WF_ENGINE.THRESHOLD%TYPE :=WF_ENGINE.THRESHOLD;
126: BEGIN
127: /* Get the Item Key from Sequence */
128: SELECT OE_WF_FEEDBACK_S.nextval into l_itemkey from DUAL;
129:

Line 132: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

128: SELECT OE_WF_FEEDBACK_S.nextval into l_itemkey from DUAL;
129:
130: /* create the process */
131:
132: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
133: itemkey => l_itemkey,
134: process => l_WorkflowProcess);
135:
136: /* make sure that process runs in defer mode */

Line 137: WF_ENGINE.THRESHOLD := -1;

133: itemkey => l_itemkey,
134: process => l_WorkflowProcess);
135:
136: /* make sure that process runs in defer mode */
137: WF_ENGINE.THRESHOLD := -1;
138:
139: /*Set All Workflow Attributes with Parameter Values */
140:
141: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

Line 141: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

137: WF_ENGINE.THRESHOLD := -1;
138:
139: /*Set All Workflow Attributes with Parameter Values */
140:
141: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
142: itemkey => l_itemkey,
143: aname => 'NOTIFIER',
144: avalue => p_recipient);
145:

Line 156: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

152: L_Territory);
153: /* Set Workflow Attributes */
154:
155:
156: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
157: itemkey => l_itemkey,
158: aname => 'NAME',
159: avalue => p_name);
160:

Line 161: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

157: itemkey => l_itemkey,
158: aname => 'NAME',
159: avalue => p_name);
160:
161: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
162: itemkey => l_itemkey,
163: aname => 'EMAIL',
164: avalue => p_email);
165:

Line 166: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

162: itemkey => l_itemkey,
163: aname => 'EMAIL',
164: avalue => p_email);
165:
166: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
167: itemkey => l_itemkey,
168: aname => 'COMMENTS',
169: avalue => p_comments);
170:

Line 172: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

168: aname => 'COMMENTS',
169: avalue => p_comments);
170:
171:
172: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
173: itemkey => l_itemkey,
174: aname => 'PHONE',
175: avalue => p_phone);
176:

Line 177: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

173: itemkey => l_itemkey,
174: aname => 'PHONE',
175: avalue => p_phone);
176:
177: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
178: itemkey => l_itemkey,
179: aname => 'ORDERNUM',
180: avalue => p_ordernum);
181:

Line 182: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

178: itemkey => l_itemkey,
179: aname => 'ORDERNUM',
180: avalue => p_ordernum);
181:
182: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
183: itemkey => l_itemkey,
184: aname => 'SHIPNUM',
185: avalue => p_shipnum);
186:

Line 187: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

183: itemkey => l_itemkey,
184: aname => 'SHIPNUM',
185: avalue => p_shipnum);
186:
187: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
188: itemkey => l_itemkey,
189: aname => 'ITEM',
190: avalue => p_products);
191:

Line 193: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

189: aname => 'ITEM',
190: avalue => p_products);
191:
192:
193: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
194: itemkey => l_itemkey,
195: aname => 'LOTNUM',
196: avalue => p_lot);
197:

Line 198: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

194: itemkey => l_itemkey,
195: aname => 'LOTNUM',
196: avalue => p_lot);
197:
198: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
199: itemkey => l_itemkey,
200: aname => 'SHIPDATE',
201: avalue => p_shipdate);
202:

Line 206: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,

202:
203:
204: /* start the Workflow process */
205:
206: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
207: itemkey => l_itemkey);
208:
209: /* Reset The Threshold Value */
210: WF_ENGINE.THRESHOLD := l_save_threshold;

Line 210: WF_ENGINE.THRESHOLD := l_save_threshold;

206: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
207: itemkey => l_itemkey);
208:
209: /* Reset The Threshold Value */
210: WF_ENGINE.THRESHOLD := l_save_threshold;
211:
212:
213: EXCEPTION
214: WHEN OTHERS THEN

Line 216: WF_ENGINE.THRESHOLD := l_save_threshold;

212:
213: EXCEPTION
214: WHEN OTHERS THEN
215: /* Reset The Threshold Value */
216: WF_ENGINE.THRESHOLD := l_save_threshold;
217: WF_CORE.CONTEXT ('ONT_FEEBBACK_PKG','INIT_WF2',l_itemtype,l_itemkey,'Recipient-'||P_RECIPIENT,'Customer-'||P_NAME);
218: raise;
219: END init_wf2;
220:

Line 247: l_save_threshold CONSTANT WF_ENGINE.THRESHOLD%TYPE :=WF_ENGINE.THRESHOLD;

243: l_Notification_preference VARCHAR2(240);
244: l_Language VARCHAR2(240);
245: l_territory VARCHAR2(240);
246: /* Save the Threshold Value*/
247: l_save_threshold CONSTANT WF_ENGINE.THRESHOLD%TYPE :=WF_ENGINE.THRESHOLD;
248:
249: BEGIN
250: /* Get the Item Key from Sequence */
251: SELECT OE_WF_FEEDBACK_S.nextval into l_itemkey from DUAL;

Line 255: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,

251: SELECT OE_WF_FEEDBACK_S.nextval into l_itemkey from DUAL;
252:
253: /* create the process */
254:
255: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
256: itemkey => l_itemkey,
257: process => l_WorkflowProcess);
258:
259: /* make sure that process runs in defer mode */

Line 260: WF_ENGINE.THRESHOLD := -1;

256: itemkey => l_itemkey,
257: process => l_WorkflowProcess);
258:
259: /* make sure that process runs in defer mode */
260: WF_ENGINE.THRESHOLD := -1;
261:
262: /*Set All Workflow Attributes with Parameter Values */
263:
264: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

Line 264: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

260: WF_ENGINE.THRESHOLD := -1;
261:
262: /*Set All Workflow Attributes with Parameter Values */
263:
264: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
265: itemkey => l_itemkey,
266: aname => 'CUSTF_RECIPIENT',
267: avalue => p_notifier);
268:

Line 279: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

275: L_Territory);
276: /* Set Workflow Attributes */
277:
278:
279: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
280: itemkey => l_itemkey,
281: aname => 'CUSTF_NAME',
282: avalue => p_name);
283:

Line 284: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

280: itemkey => l_itemkey,
281: aname => 'CUSTF_NAME',
282: avalue => p_name);
283:
284: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
285: itemkey => l_itemkey,
286: aname => 'CUSTF_EMAIL',
287: avalue => p_email);
288:

Line 289: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,

285: itemkey => l_itemkey,
286: aname => 'CUSTF_EMAIL',
287: avalue => p_email);
288:
289: WF_ENGINE.SETITEMATTRTEXT( itemtype => l_itemtype,
290: itemkey => l_itemkey,
291: aname => 'CUSTF_COMMENTS',
292: avalue => p_comments);
293:

Line 295: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

291: aname => 'CUSTF_COMMENTS',
292: avalue => p_comments);
293:
294:
295: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
296: itemkey => l_itemkey,
297: aname => 'CUSTF_PHONE',
298: avalue => p_phone);
299:

Line 300: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

296: itemkey => l_itemkey,
297: aname => 'CUSTF_PHONE',
298: avalue => p_phone);
299:
300: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
301: itemkey => l_itemkey,
302: aname => 'CUSTF_ORDERNUM',
303: avalue => p_ordernum);
304:

Line 305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

301: itemkey => l_itemkey,
302: aname => 'CUSTF_ORDERNUM',
303: avalue => p_ordernum);
304:
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
306: itemkey => l_itemkey,
307: aname => 'CUSTF_LINENUM',
308: avalue => p_linenum);
309:

Line 310: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

306: itemkey => l_itemkey,
307: aname => 'CUSTF_LINENUM',
308: avalue => p_linenum);
309:
310: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
311: itemkey => l_itemkey,
312: aname => 'CUSTF_PRODUCT',
313: avalue => p_products);
314:

Line 316: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

312: aname => 'CUSTF_PRODUCT',
313: avalue => p_products);
314:
315:
316: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
317: itemkey => l_itemkey,
318: aname => 'CUSTF_QUANTITY',
319: avalue => p_quantity);
320:

Line 325: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,

321:
322:
323: /* start the Workflow process */
324:
325: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
326: itemkey => l_itemkey);
327:
328: /* Reset The Threshold Value */
329: WF_ENGINE.THRESHOLD := l_save_threshold;

Line 329: WF_ENGINE.THRESHOLD := l_save_threshold;

325: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
326: itemkey => l_itemkey);
327:
328: /* Reset The Threshold Value */
329: WF_ENGINE.THRESHOLD := l_save_threshold;
330:
331:
332: EXCEPTION
333: WHEN OTHERS THEN

Line 335: WF_ENGINE.THRESHOLD := l_save_threshold;

331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: /* Reset The Threshold Value */
335: WF_ENGINE.THRESHOLD := l_save_threshold;
336: WF_CORE.CONTEXT ('ONT_FEEBBACK_PKG','INIT_WF3',l_itemtype,l_itemkey,'Recipient-'||P_NOTIFIER,'Customer-'||P_NAME);
337: raise;
338: END init_wf3;
339: