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

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

30: /* make sure that process runs with background engine
31: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
32: the value to use for this is -1 */
33:
34: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
35:
36:
37: l_WorkflowProcess VARCHAR2(30) := 'GMDOPLAP_PROCESS';
38: l_count NUMBER;

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

38: l_count NUMBER;
39: BEGIN
40:
41: /* create the process */
42: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess) ;
43:
44: /* make sure that process runs with background engine */
45: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
46:

Line 45: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

41: /* create the process */
42: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess) ;
43:
44: /* make sure that process runs with background engine */
45: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
46:
47: /* set the item attributes */
48: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
49: aname => 'GMDOPLAP_OPERATION_ID',

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

44: /* make sure that process runs with background engine */
45: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
46:
47: /* set the item attributes */
48: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
49: aname => 'GMDOPLAP_OPERATION_ID',
50: avalue => p_operation_id);
51:
52: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

48: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
49: aname => 'GMDOPLAP_OPERATION_ID',
50: avalue => p_operation_id);
51:
52: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
53: aname => 'GMDOPLAP_START_STATUS',
54: avalue => p_start_status);
55:
56: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

52: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
53: aname => 'GMDOPLAP_START_STATUS',
54: avalue => p_start_status);
55:
56: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
57: aname => 'GMDOPLAP_TARGET_STATUS',
58: avalue => p_target_status);
59:
60: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

56: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
57: aname => 'GMDOPLAP_TARGET_STATUS',
58: avalue => p_target_status);
59:
60: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
61: aname => 'GMDOPLAP_OPERATION_NO',
62: avalue => p_operation_no);
63:
64: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

60: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
61: aname => 'GMDOPLAP_OPERATION_NO',
62: avalue => p_operation_no);
63:
64: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
65: aname => 'GMDOPLAP_OPERATION_VERS',
66: avalue => p_operation_vers);
67:
68: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes

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

66: avalue => p_operation_vers);
67:
68: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
69:
70: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
71: aname => 'GMDOPLAP_TIMEOUT',
72: avalue => l_wf_timeout);
73: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDOPLAP_MESG_CNT',

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

69:
70: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
71: aname => 'GMDOPLAP_TIMEOUT',
72: avalue => l_wf_timeout);
73: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDOPLAP_MESG_CNT',
75: avalue => 1);
76:
77: l_runform := 'GMDOPRED_F:OPRN_ID='||to_char(p_operation_id);

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

75: avalue => 1);
76:
77: l_runform := 'GMDOPRED_F:OPRN_ID='||to_char(p_operation_id);
78:
79: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
80: aname => 'GMDOPLAP_FORM',
81: avalue => l_runform);
82:
83: -- get values to be stored into the workflow item

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

85: INTO l_performer_name ,l_performer_display_name
86: FROM FND_USER
87: WHERE USER_ID = p_Requester;
88:
89: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
90: aname => 'GMDOPLAP_REQUSTER',
91: avalue => l_performer_name );
92: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
93: SELECT OPRN_DESC, OPRN_CLASS, PROCESS_QTY_UOM, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

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

94: INTO l_oprn_desc, l_oprn_class, l_item_um, l_effective_start_date, l_effective_end_date
95: FROM GMD_OPERATIONS
96: WHERE OPRN_ID = P_OPERATION_ID;
97:
98: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
99: aname => 'GMDOPLAP_OPRN_DESC',
100: avalue => l_oprn_desc);
101:
102: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

98: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
99: aname => 'GMDOPLAP_OPRN_DESC',
100: avalue => l_oprn_desc);
101:
102: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
103: aname => 'GMDOPLAP_OPRN_CLASS',
104: avalue => l_oprn_class);
105:
106: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

102: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
103: aname => 'GMDOPLAP_OPRN_CLASS',
104: avalue => l_oprn_class);
105:
106: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
107: aname => 'GMDOPLAP_OPRN_UOM',
108: avalue => l_item_um);
109:
110: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

106: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
107: aname => 'GMDOPLAP_OPRN_UOM',
108: avalue => l_item_um);
109:
110: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
111: aname => 'GMDOPLAP_EFF_START_DATE',
112: avalue => l_effective_start_date);
113:
114: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

110: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
111: aname => 'GMDOPLAP_EFF_START_DATE',
112: avalue => l_effective_start_date);
113:
114: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
115: aname => 'GMDOPLAP_EFF_END_DATE',
116: avalue => l_effective_end_date);
117:
118: /* Mercy Thomas Bug 3173515 End of the changes */

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

119:
120:
121: /* start the Workflow process */
122:
123: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
124:
125:
126:
127: EXCEPTION

Line 151: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));

147: IS
148: /* procedure to Check Approval is required or not if required find the approver and send the notification to
149: approver */
150:
151: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
152: p_data_string VARCHAR2(2000);
153: p_wf_data_string VARCHAR2(2000);
154: p_lab_wf_item_type VARCHAR2(8) := 'GMDOPLAP'; -- Recipe Lab use Approval Workflow Inernal Name
155: P_lab_Process_name VARCHAR2(32) := 'GMDOPLAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name

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

180: p_lab_activity_name,
181: p_data_string,
182: P_role);
183: l_data_string := replace(p_wf_data_string,l_delimiter,wf_core.newline);
184: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
185: itemkey => p_itemkey,
186: aname => 'GMDOPLAP_ADDL_TEXT',
187: avalue => l_data_string);
188:

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

185: itemkey => p_itemkey,
186: aname => 'GMDOPLAP_ADDL_TEXT',
187: avalue => l_data_string);
188:
189: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
190: itemkey => p_itemkey,
191: aname => 'GMDOPLAP_APPROVER',
192: avalue => p_role);
193:

Line 196: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');

192: avalue => p_role);
193:
194: p_resultout:='COMPLETE:Y';
195: ELSE
196: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');
197: UPDATE GMD_OPERATIONS_B
198: SET OPERATION_STATUS = l_target_status
199: WHERE OPRN_ID = l_operation_id;
200: p_resultout:='COMPLETE:N';

Line 215: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDOPLAP_MESG_CNT');

211: p_itemkey IN VARCHAR2,
212: p_actid IN NUMBER,
213: p_funcmode IN VARCHAR2,
214: p_resultout OUT NOCOPY VARCHAR2) IS
215: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDOPLAP_MESG_CNT');
216: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_APPROVER');
217: BEGIN
218: IF (p_funcmode = 'TIMEOUT') THEN
219: l_mesg_cnt := l_mesg_cnt + 1;

Line 216: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_APPROVER');

212: p_actid IN NUMBER,
213: p_funcmode IN VARCHAR2,
214: p_resultout OUT NOCOPY VARCHAR2) IS
215: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDOPLAP_MESG_CNT');
216: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_APPROVER');
217: BEGIN
218: IF (p_funcmode = 'TIMEOUT') THEN
219: l_mesg_cnt := l_mesg_cnt + 1;
220: IF l_mesg_cnt <= 4 THEN

Line 221: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,

217: BEGIN
218: IF (p_funcmode = 'TIMEOUT') THEN
219: l_mesg_cnt := l_mesg_cnt + 1;
220: IF l_mesg_cnt <= 4 THEN
221: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
222: aname => 'GMDOPLAP_MESG_CNT',
223: avalue => l_mesg_cnt);
224: ELSE
225: p_resultout := 'COMPLETE:DEFAULT';

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

224: ELSE
225: p_resultout := 'COMPLETE:DEFAULT';
226: END IF;
227: ELSIF (p_funcmode = 'RESPOND') THEN
228: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
229: itemkey => p_itemkey,
230: aname => 'GMDOPLAP_CURR_PERFORMER',
231: avalue => l_approver);
232: END IF;

Line 243: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));

239: p_actid IN NUMBER,
240: p_funcmode IN VARCHAR2,
241: p_resultout OUT NOCOPY VARCHAR2) IS
242: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
243: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
244: BEGIN
245: IF (p_funcmode = 'RUN') THEN
246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');
247: UPDATE GMD_OPERATIONS_B

Line 246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');

242: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
243: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
244: BEGIN
245: IF (p_funcmode = 'RUN') THEN
246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');
247: UPDATE GMD_OPERATIONS_B
248: SET OPERATION_STATUS = l_target_status
249: WHERE OPRN_ID = l_operation_id;
250: END IF;

Line 263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));

259: p_resultout OUT NOCOPY VARCHAR2) IS
260: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
261: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
262: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');

Line 266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_START_STATUS');

262: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');
268: SELECT rework_status into l_rework_status
269: FROM GMD_STATUS_NEXT
270: WHERE current_status = l_start_status

Line 267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');

263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_TARGET_STATUS');
268: SELECT rework_status into l_rework_status
269: FROM GMD_STATUS_NEXT
270: WHERE current_status = l_start_status
271: AND target_status = l_target_status

Line 285: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));

281: p_itemkey IN VARCHAR2,
282: p_actid IN NUMBER,
283: p_funcmode IN VARCHAR2,
284: p_resultout OUT NOCOPY VARCHAR2) IS
285: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
286: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
287: BEGIN
288: IF (p_funcmode = 'RUN') THEN
289: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_START_STATUS');

Line 289: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_START_STATUS');

285: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_OPERATION_ID'));
286: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
287: BEGIN
288: IF (p_funcmode = 'RUN') THEN
289: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_START_STATUS');
290: UPDATE GMD_OPERATIONS_B
291: SET OPERATION_STATUS = l_start_status
292: WHERE OPRN_ID = l_operation_id;
293: END IF;

Line 302: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_REQUSTER');

298: p_itemkey IN VARCHAR2,
299: p_actid IN NUMBER,
300: p_funcmode IN VARCHAR2,
301: p_resultout OUT NOCOPY VARCHAR2) IS
302: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_REQUSTER');
303: BEGIN
304: IF (p_funcmode = 'RESPOND') THEN
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
306: itemkey => p_itemkey,

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

301: p_resultout OUT NOCOPY VARCHAR2) IS
302: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_REQUSTER');
303: BEGIN
304: IF (p_funcmode = 'RESPOND') THEN
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
306: itemkey => p_itemkey,
307: aname => 'GMDOPLAP_CURR_PERFORMER',
308: avalue => l_requester);
309: END IF;

Line 319: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_COMMENT');

315: p_actid IN NUMBER,
316: p_funcmode IN VARCHAR2,
317: p_resultout OUT NOCOPY VARCHAR2) IS
318: l_html_mesg VARCHAR2(4000);
319: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_COMMENT');
320: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_DISP_COMMENT');
321: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_CURR_PERFORMER');
322: BEGIN
323: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

Line 320: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_DISP_COMMENT');

316: p_funcmode IN VARCHAR2,
317: p_resultout OUT NOCOPY VARCHAR2) IS
318: l_html_mesg VARCHAR2(4000);
319: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_COMMENT');
320: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_DISP_COMMENT');
321: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_CURR_PERFORMER');
322: BEGIN
323: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
324: BEGIN

Line 321: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_CURR_PERFORMER');

317: p_resultout OUT NOCOPY VARCHAR2) IS
318: l_html_mesg VARCHAR2(4000);
319: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_COMMENT');
320: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_DISP_COMMENT');
321: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_CURR_PERFORMER');
322: BEGIN
323: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
324: BEGIN
325: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||

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

328: l_comment := null;
329: EXCEPTION WHEN OTHERS THEN
330: NULL;
331: END;
332: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
333: itemkey => p_itemkey,
334: aname => 'GMDOPLAP_DISP_COMMENT',
335: avalue => l_mesg_comment);
336: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

Line 336: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

332: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
333: itemkey => p_itemkey,
334: aname => 'GMDOPLAP_DISP_COMMENT',
335: avalue => l_mesg_comment);
336: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
337: -- itemkey => p_itemkey,
338: -- aname => 'GMDOPLAP_HTML_DISP_COMMENT',
339: -- avalue => l_html_mesg);
340: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

336: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
337: -- itemkey => p_itemkey,
338: -- aname => 'GMDOPLAP_HTML_DISP_COMMENT',
339: -- avalue => l_html_mesg);
340: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
341: itemkey => p_itemkey,
342: aname => 'GMDOPLAP_COMMENT',
343: avalue => l_comment);
344: END IF;