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

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

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

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

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

Line 43: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

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

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

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

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

46: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
47: aname => 'GMDFMGAP_FORMULA_ID',
48: avalue => p_formula_id);
49:
50: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
51: aname => 'GMDFMGAP_START_STATUS',
52: avalue => p_start_status);
53:
54: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

50: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
51: aname => 'GMDFMGAP_START_STATUS',
52: avalue => p_start_status);
53:
54: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
55: aname => 'GMDFMGAP_TARGET_STATUS',
56: avalue => p_target_status);
57:
58: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

54: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
55: aname => 'GMDFMGAP_TARGET_STATUS',
56: avalue => p_target_status);
57:
58: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
59: aname => 'GMDFMGAP_FORMULA_NO',
60: avalue => p_formula_no);
61:
62: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

58: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
59: aname => 'GMDFMGAP_FORMULA_NO',
60: avalue => p_formula_no);
61:
62: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
63: aname => 'GMDFMGAP_FORMULA_VERS',
64: avalue => p_formula_vers);
65:
66: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes

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

64: avalue => p_formula_vers);
65:
66: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
67:
68: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
69: aname => 'GMDFMGAP_TIMEOUT',
70: avalue => l_wf_timeout);
71: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
72: aname => 'GMDFMGAP_MESG_CNT',

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

67:
68: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
69: aname => 'GMDFMGAP_TIMEOUT',
70: avalue => l_wf_timeout);
71: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
72: aname => 'GMDFMGAP_MESG_CNT',
73: avalue => 1);
74:
75: l_runform := 'GMDFRMED_F:FORMULA_ID='||to_char(p_formula_id);

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

73: avalue => 1);
74:
75: l_runform := 'GMDFRMED_F:FORMULA_ID='||to_char(p_formula_id);
76:
77: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
78: aname => 'GMDFMGAP_FORM',
79: avalue => l_runform);
80:
81: -- get values to be stored into the workflow item

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

83: INTO l_performer_name ,l_performer_display_name
84: FROM FND_USER
85: WHERE USER_ID = p_Requester;
86:
87: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
88: aname => 'GMDFMGAP_REQUSTER',
89: avalue => l_performer_name );
90:
91: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */

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

98: INTO l_performer_name ,l_performer_display_name
99: FROM FND_USER
100: WHERE USER_ID = l_owner_id;
101:
102: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
103: aname => 'GMDFMGAP_OWNER_ID',
104: avalue => l_performer_name);
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 => 'GMDFMGAP_OWNER_ID',
104: avalue => l_performer_name);
105:
106: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
107: aname => 'GMDFMGAP_FORMULA_DESC',
108: avalue => l_formula_desc);
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 => 'GMDFMGAP_FORMULA_DESC',
108: avalue => l_formula_desc);
109:
110: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
111: aname => 'GMDFMGAP_FORMULA_CLASS',
112: avalue => l_formula_class);
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 => 'GMDFMGAP_FORMULA_CLASS',
112: avalue => l_formula_class);
113:
114: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
115: aname => 'GMDFMGAP_SCALE_TYPE',
116: avalue => l_scale_type);
117:
118:

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 157: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

153: IS
154: /* procedure to Check Approval is required or not if required find the approver and send the notification to
155: approver */
156:
157: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
158: p_data_string VARCHAR2(2000);
159: p_lab_wf_item_type VARCHAR2(8) := 'GMDFMGAP'; -- Recipe Lab use Approval Workflow Inernal Name
160: P_lab_Process_name VARCHAR2(32) := 'GMDFMGAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name
161: P_lab_activity_name VARCHAR2(80) := 'GMDFMGAP_NOTI_REQUEST';

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

190: p_lab_activity_name,
191: p_data_string,
192: P_role);
193: l_data_string := replace(p_wf_data_string,l_delimiter,wf_core.newline);
194: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
195: itemkey => p_itemkey,
196: aname => 'GMDFMGAP_ADDL_TEXT',
197: avalue => l_data_string);
198:

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

195: itemkey => p_itemkey,
196: aname => 'GMDFMGAP_ADDL_TEXT',
197: avalue => l_data_string);
198:
199: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
200: itemkey => p_itemkey,
201: aname => 'GMDFMGAP_APPROVER',
202: avalue => p_role);
203:

Line 206: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');

202: avalue => p_role);
203:
204: p_resultout:='COMPLETE:Y';
205: ELSE
206: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');
207: UPDATE FM_FORM_MST_B
208: SET FORMULA_STATUS = l_target_status
209: WHERE FORMULA_ID = l_formula_id;
210: p_resultout:='COMPLETE:N';

Line 227: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDFMGAP_MESG_CNT');

223: p_itemkey IN VARCHAR2,
224: p_actid IN NUMBER,
225: p_funcmode IN VARCHAR2,
226: p_resultout OUT NOCOPY VARCHAR2) IS
227: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDFMGAP_MESG_CNT');
228: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_APPROVER');
229: BEGIN
230: IF (p_funcmode = 'TIMEOUT') THEN
231: l_mesg_cnt := l_mesg_cnt + 1;

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

224: p_actid IN NUMBER,
225: p_funcmode IN VARCHAR2,
226: p_resultout OUT NOCOPY VARCHAR2) IS
227: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDFMGAP_MESG_CNT');
228: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_APPROVER');
229: BEGIN
230: IF (p_funcmode = 'TIMEOUT') THEN
231: l_mesg_cnt := l_mesg_cnt + 1;
232: IF l_mesg_cnt <= 4 THEN

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

229: BEGIN
230: IF (p_funcmode = 'TIMEOUT') THEN
231: l_mesg_cnt := l_mesg_cnt + 1;
232: IF l_mesg_cnt <= 4 THEN
233: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
234: aname => 'GMDFMGAP_MESG_CNT',
235: avalue => l_mesg_cnt);
236: ELSE
237: p_resultout := 'COMPLETE:DEFAULT';

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

236: ELSE
237: p_resultout := 'COMPLETE:DEFAULT';
238: END IF;
239: ELSIF (p_funcmode = 'RESPOND') THEN
240: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
241: itemkey => p_itemkey,
242: aname => 'GMDFMGAP_CURR_PERFORMER',
243: avalue => l_approver);
244: END IF;

Line 264: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

260: p_funcmode IN VARCHAR2,
261: p_resultout OUT NOCOPY VARCHAR2) IS
262:
263: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
264: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
265:
266: /* added variables for recipe generation */
267: l_return_status VARCHAR2(1);
268: x_recipe_no VARCHAR2(32);

Line 306: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');

302: /* Bug No.8355449 - Added the below line to enable m_fs_context */
303: gmd_p_fs_context.set_additional_attr;
304:
305: IF (p_funcmode = 'RUN') THEN
306: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');
307: UPDATE FM_FORM_MST_B
308: SET FORMULA_STATUS = l_target_status
309: WHERE FORMULA_ID = l_formula_id;
310:

Line 346: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

342: p_resultout OUT NOCOPY VARCHAR2) IS
343: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
344: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
345: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
346: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
347: BEGIN
348: IF (p_funcmode = 'RUN') THEN
349: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');
350: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');

Line 349: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');

345: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
346: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
347: BEGIN
348: IF (p_funcmode = 'RUN') THEN
349: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');
350: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');
351: SELECT rework_status into l_rework_status
352: FROM GMD_STATUS_NEXT
353: WHERE current_status = l_start_status

Line 350: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');

346: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
347: BEGIN
348: IF (p_funcmode = 'RUN') THEN
349: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');
350: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');
351: SELECT rework_status into l_rework_status
352: FROM GMD_STATUS_NEXT
353: WHERE current_status = l_start_status
354: AND target_status = l_target_status

Line 368: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));

364: p_itemkey IN VARCHAR2,
365: p_actid IN NUMBER,
366: p_funcmode IN VARCHAR2,
367: p_resultout OUT NOCOPY VARCHAR2) IS
368: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
369: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
370: BEGIN
371: IF (p_funcmode = 'RUN') THEN
372: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');

Line 372: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');

368: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
369: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
370: BEGIN
371: IF (p_funcmode = 'RUN') THEN
372: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');
373: UPDATE FM_FORM_MST_B
374: SET FORMULA_STATUS = l_start_status
375: WHERE FORMULA_ID = l_formula_id;
376: END IF;

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

381: p_itemkey IN VARCHAR2,
382: p_actid IN NUMBER,
383: p_funcmode IN VARCHAR2,
384: p_resultout OUT NOCOPY VARCHAR2) IS
385: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_REQUSTER');
386: BEGIN
387: IF (p_funcmode = 'RESPOND') THEN
388: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
389: itemkey => p_itemkey,

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

384: p_resultout OUT NOCOPY VARCHAR2) IS
385: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_REQUSTER');
386: BEGIN
387: IF (p_funcmode = 'RESPOND') THEN
388: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
389: itemkey => p_itemkey,
390: aname => 'GMDFMGAP_CURR_PERFORMER',
391: avalue => l_requester);
392: END IF;

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

398: p_actid IN NUMBER,
399: p_funcmode IN VARCHAR2,
400: p_resultout OUT NOCOPY VARCHAR2) IS
401: l_html_mesg VARCHAR2(4000);
402: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_COMMENT');
403: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_DISP_COMMENT');
404: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_CURR_PERFORMER');
405: BEGIN
406: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

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

399: p_funcmode IN VARCHAR2,
400: p_resultout OUT NOCOPY VARCHAR2) IS
401: l_html_mesg VARCHAR2(4000);
402: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_COMMENT');
403: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_DISP_COMMENT');
404: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_CURR_PERFORMER');
405: BEGIN
406: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
407: BEGIN

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

400: p_resultout OUT NOCOPY VARCHAR2) IS
401: l_html_mesg VARCHAR2(4000);
402: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_COMMENT');
403: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_DISP_COMMENT');
404: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_CURR_PERFORMER');
405: BEGIN
406: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
407: BEGIN
408: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||

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

411: l_comment := null;
412: EXCEPTION WHEN OTHERS THEN
413: NULL;
414: END;
415: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
416: itemkey => p_itemkey,
417: aname => 'GMDFMGAP_DISP_COMMENT',
418: avalue => l_mesg_comment);
419: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

415: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
416: itemkey => p_itemkey,
417: aname => 'GMDFMGAP_DISP_COMMENT',
418: avalue => l_mesg_comment);
419: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
420: -- itemkey => p_itemkey,
421: -- aname => 'GMDFMGAP_HTML_DISP_COMMENT',
422: -- avalue => l_html_mesg);
423: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

419: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
420: -- itemkey => p_itemkey,
421: -- aname => 'GMDFMGAP_HTML_DISP_COMMENT',
422: -- avalue => l_html_mesg);
423: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
424: itemkey => p_itemkey,
425: aname => 'GMDFMGAP_COMMENT',
426: avalue => l_comment);
427: END IF;