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

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

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

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 => 'GMDOPGAP_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 => 'GMDOPGAP_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 => 'GMDOPGAP_OPERATION_ID',
50: avalue => p_operation_id);
51:
52: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
53: aname => 'GMDOPGAP_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 => 'GMDOPGAP_START_STATUS',
54: avalue => p_start_status);
55:
56: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
57: aname => 'GMDOPGAP_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 => 'GMDOPGAP_TARGET_STATUS',
58: avalue => p_target_status);
59:
60: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
61: aname => 'GMDOPGAP_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 => 'GMDOPGAP_OPERATION_NO',
62: avalue => p_operation_no);
63:
64: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
65: aname => 'GMDOPGAP_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 => 'GMDOPGAP_TIMEOUT',
72: avalue => l_wf_timeout);
73: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDOPGAP_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 => 'GMDOPGAP_TIMEOUT',
72: avalue => l_wf_timeout);
73: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDOPGAP_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 => 'GMDOPGAP_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 => 'GMDOPGAP_REQUSTER',
91: avalue => l_performer_name );
92:
93: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 197: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_TARGET_STATUS');

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

Line 216: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDOPGAP_MESG_CNT');

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

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

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

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

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

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

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

Line 243: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_OPERATION_ID'));
244: BEGIN
245: IF (p_funcmode = 'RUN') THEN
246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_TARGET_STATUS');
247: UPDATE GMD_OPERATIONS_B

Line 246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_OPERATION_ID'));
244: BEGIN
245: IF (p_funcmode = 'RUN') THEN
246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_TARGET_STATUS');

Line 266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_TARGET_STATUS');

263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_START_STATUS');

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

285: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_REQUSTER');
303: BEGIN
304: IF (p_funcmode = 'RESPOND') THEN
305: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
306: itemkey => p_itemkey,
307: aname => 'GMDOPGAP_CURR_PERFORMER',
308: avalue => l_requester);
309: END IF;

Line 319: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_COMMENT');
320: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_DISP_COMMENT');
321: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_COMMENT');
320: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_DISP_COMMENT');
321: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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,'GMDOPGAP_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,'GMDOPGAP_COMMENT');
320: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_DISP_COMMENT');
321: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_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(SYSDATE)||

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 => 'GMDOPGAP_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 => 'GMDOPGAP_DISP_COMMENT',
335: avalue => l_mesg_comment);
336: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
337: -- itemkey => p_itemkey,
338: -- aname => 'GMDOPGAP_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 => 'GMDOPGAP_HTML_DISP_COMMENT',
339: -- avalue => l_html_mesg);
340: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
341: itemkey => p_itemkey,
342: aname => 'GMDOPGAP_COMMENT',
343: avalue => l_comment);
344: END IF;