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

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

35: /* make sure that process runs with background engine
36: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
37: the value to use for this is -1 */
38:
39: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
40: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
41:
42: l_WorkflowProcess VARCHAR2(30) := 'GMDRPGAP_PROCESS';
43: l_count NUMBER;

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

43: l_count NUMBER;
44: BEGIN
45:
46: /* create the process */
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: /* create the process */
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.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
54: aname => 'GMDRPGAP_RECIPE_ID',

Line 53: WF_ENGINE.SETITEMATTRNUMBER(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.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
54: aname => 'GMDRPGAP_RECIPE_ID',
55: avalue => p_recipe_id);
56:
57: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

53: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
54: aname => 'GMDRPGAP_RECIPE_ID',
55: avalue => p_recipe_id);
56:
57: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
58: aname => 'GMDRPGAP_START_STATUS',
59: avalue => p_start_status);
60:
61: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

57: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
58: aname => 'GMDRPGAP_START_STATUS',
59: avalue => p_start_status);
60:
61: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
62: aname => 'GMDRPGAP_TARGET_STATUS',
63: avalue => p_target_status);
64:
65: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

61: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
62: aname => 'GMDRPGAP_TARGET_STATUS',
63: avalue => p_target_status);
64:
65: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
66: aname => 'GMDRPGAP_RECIPE_NO',
67: avalue => p_recipe_no);
68:
69: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

65: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
66: aname => 'GMDRPGAP_RECIPE_NO',
67: avalue => p_recipe_no);
68:
69: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
70: aname => 'GMDRPGAP_RECIPE_VERS',
71: avalue => p_recipe_vers);
72:
73: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes

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

71: avalue => p_recipe_vers);
72:
73: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
74:
75: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
76: aname => 'GMDRPGAP_TIMEOUT',
77: avalue => l_wf_timeout);
78: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
79: aname => 'GMDRPGAP_MESG_CNT',

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

74:
75: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
76: aname => 'GMDRPGAP_TIMEOUT',
77: avalue => l_wf_timeout);
78: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
79: aname => 'GMDRPGAP_MESG_CNT',
80: avalue => 1);
81:
82:

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

81:
82:
83: l_runform := 'GMDRCPED_F:RECIPE_ID='||to_char(p_recipe_id);
84:
85: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
86: aname => 'GMDRPGAP_FORM',
87: avalue => l_runform);
88:
89: -- get values to be stored into the workflow item

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

91: INTO l_performer_name ,l_performer_display_name
92: FROM FND_USER
93: WHERE USER_ID = p_Requester;
94:
95: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
96: aname => 'GMDRPGAP_REQUSTER',
97: avalue => l_performer_name );
98:
99: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */

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

113: INTO l_performer_name ,l_performer_display_name
114: FROM FND_USER
115: WHERE USER_ID = l_owner_id;
116:
117: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
118: aname => 'GMDRPGAP_OWNER_ID',
119: avalue => l_performer_name);
120:
121: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

117: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
118: aname => 'GMDRPGAP_OWNER_ID',
119: avalue => l_performer_name);
120:
121: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
122: aname => 'GMDRPGAP_RECIPE_DESC',
123: avalue => l_recipe_description);
124:
125: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

121: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
122: aname => 'GMDRPGAP_RECIPE_DESC',
123: avalue => l_recipe_description);
124:
125: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
126: aname => 'GMDRPGAP_CREATION_ORG_CODE',
127: avalue => l_creation_orgn_code);
128:
129: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

125: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
126: aname => 'GMDRPGAP_CREATION_ORG_CODE',
127: avalue => l_creation_orgn_code);
128:
129: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
130: aname => 'GMDRPGAP_ROUTING_NO',
131: avalue => l_routing_no);
132:
133: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

129: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
130: aname => 'GMDRPGAP_ROUTING_NO',
131: avalue => l_routing_no);
132:
133: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
134: aname => 'GMDRPGAP_ROUTING_VERS',
135: avalue => l_routing_vers);
136:
137: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

133: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
134: aname => 'GMDRPGAP_ROUTING_VERS',
135: avalue => l_routing_vers);
136:
137: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
138: aname => 'GMDRPGAP_FORMULA_NO',
139: avalue => l_formula_no);
140:
141: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

137: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
138: aname => 'GMDRPGAP_FORMULA_NO',
139: avalue => l_formula_no);
140:
141: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
142: aname => 'GMDRPGAP_FORMULA_VERS',
143: avalue => l_formula_vers);
144:
145: /* Mercy Thomas Bug 3173515 End of the changes */

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

147:
148:
149: /* start the Workflow process */
150:
151: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
152:
153:
154:
155: EXCEPTION

Line 179: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));

175: IS
176: /* procedure to Check Approval is required or not if required find the approver and send the notification to
177: approver */
178:
179: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));
180: p_data_string VARCHAR2(2000);
181: p_wf_data_string VARCHAR2(2000);
182: p_lab_wf_item_type VARCHAR2(8) := 'GMDRPGAP'; -- Recipe Lab use Approval Workflow Inernal Name
183: P_lab_Process_name VARCHAR2(32) := 'GMDRPGAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name

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

208: p_lab_activity_name,
209: p_data_string,
210: P_role);
211: l_data_string := replace(p_wf_data_string,l_delimiter,wf_core.newline);
212: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
213: itemkey => p_itemkey,
214: aname => 'GMDRPGAP_ADDL_TEXT',
215: avalue => l_data_string);
216:

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

213: itemkey => p_itemkey,
214: aname => 'GMDRPGAP_ADDL_TEXT',
215: avalue => l_data_string);
216:
217: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
218: itemkey => p_itemkey,
219: aname => 'GMDRPGAP_APPROVER',
220: avalue => p_role);
221:

Line 224: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');

220: avalue => p_role);
221:
222: p_resultout:='COMPLETE:Y';
223: ELSE
224: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');
225: UPDATE GMD_RECIPES_B
226: SET RECIPE_STATUS = l_target_status
227: WHERE RECIPE_ID = l_recipe_id;
228: p_resultout:='COMPLETE:N';

Line 245: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRPGAP_MESG_CNT');

241: p_itemkey IN VARCHAR2,
242: p_actid IN NUMBER,
243: p_funcmode IN VARCHAR2,
244: p_resultout OUT NOCOPY VARCHAR2) IS
245: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRPGAP_MESG_CNT');
246: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_APPROVER');
247: BEGIN
248: IF (p_funcmode = 'TIMEOUT') THEN
249: l_mesg_cnt := l_mesg_cnt + 1;

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

242: p_actid IN NUMBER,
243: p_funcmode IN VARCHAR2,
244: p_resultout OUT NOCOPY VARCHAR2) IS
245: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRPGAP_MESG_CNT');
246: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_APPROVER');
247: BEGIN
248: IF (p_funcmode = 'TIMEOUT') THEN
249: l_mesg_cnt := l_mesg_cnt + 1;
250: IF l_mesg_cnt <= 4 THEN

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

247: BEGIN
248: IF (p_funcmode = 'TIMEOUT') THEN
249: l_mesg_cnt := l_mesg_cnt + 1;
250: IF l_mesg_cnt <= 4 THEN
251: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
252: aname => 'GMDRPGAP_MESG_CNT',
253: avalue => l_mesg_cnt);
254: ELSE
255: p_resultout := 'COMPLETE:DEFAULT';

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

254: ELSE
255: p_resultout := 'COMPLETE:DEFAULT';
256: END IF;
257: ELSIF (p_funcmode = 'RESPOND') THEN
258: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
259: itemkey => p_itemkey,
260: aname => 'GMDRPGAP_CURR_PERFORMER',
261: avalue => l_approver);
262: END IF;

Line 279: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));

275: p_actid IN NUMBER,
276: p_funcmode IN VARCHAR2,
277: p_resultout OUT NOCOPY VARCHAR2) IS
278: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
279: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));
280: /* added variables for recipe generation B3604554*/
281: l_return_status VARCHAR2(1);
282: l_formula_id NUMBER(10);
283: l_orgn_id NUMBER;

Line 302: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');

298: LocalEnableRecord cur_recipe_enable%ROWTYPE;
299: BEGIN
300:
301: IF (p_funcmode = 'RUN') THEN
302: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');
303: UPDATE GMD_RECIPES_B
304: SET RECIPE_STATUS = l_target_status
305: WHERE RECIPE_ID = l_recipe_id;
306:

Line 345: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));

341: p_resultout OUT NOCOPY VARCHAR2) IS
342: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
343: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
344: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
345: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));
346: BEGIN
347: IF (p_funcmode = 'RUN') THEN
348: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_START_STATUS');
349: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');

Line 348: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_START_STATUS');

344: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
345: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));
346: BEGIN
347: IF (p_funcmode = 'RUN') THEN
348: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_START_STATUS');
349: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');
350: SELECT rework_status into l_rework_status
351: FROM GMD_STATUS_NEXT
352: WHERE current_status = l_start_status

Line 349: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');

345: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));
346: BEGIN
347: IF (p_funcmode = 'RUN') THEN
348: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_START_STATUS');
349: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');
350: SELECT rework_status into l_rework_status
351: FROM GMD_STATUS_NEXT
352: WHERE current_status = l_start_status
353: AND target_status = l_target_status

Line 368: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_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_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_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,'GMDRPGAP_START_STATUS');

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

368: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_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,'GMDRPGAP_START_STATUS');
373: UPDATE GMD_RECIPES_B
374: SET RECIPE_STATUS = l_start_status
375: WHERE RECIPE_ID = l_recipe_id;
376: END IF;

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

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

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

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

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

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

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

401: p_funcmode IN VARCHAR2,
402: p_resultout OUT NOCOPY VARCHAR2) IS
403: l_html_mesg VARCHAR2(4000);
404: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_COMMENT');
405: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_DISP_COMMENT');
406: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_CURR_PERFORMER');
407: BEGIN
408: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
409: BEGIN

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

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

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

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

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

417: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
418: itemkey => p_itemkey,
419: aname => 'GMDRPGAP_DISP_COMMENT',
420: avalue => l_mesg_comment);
421: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
422: -- itemkey => p_itemkey,
423: -- aname => 'GMDRPGAP_HTML_DISP_COMMENT',
424: -- avalue => l_html_mesg);
425: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

421: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
422: -- itemkey => p_itemkey,
423: -- aname => 'GMDRPGAP_HTML_DISP_COMMENT',
424: -- avalue => l_html_mesg);
425: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
426: itemkey => p_itemkey,
427: aname => 'GMDRPGAP_COMMENT',
428: avalue => l_comment);
429: END IF;