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

Line 38: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := 1000;

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

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

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

Line 49: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

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

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

48: /* make sure that process runs with background engine */
49: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
50:
51: /* set the item attributes */
52: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
53: aname => 'GMDRPLAP_RECIPE_ID',
54: avalue => p_recipe_id);
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 => 'GMDRPLAP_RECIPE_ID',
54: avalue => p_recipe_id);
55:
56: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
57: aname => 'GMDRPLAP_START_STATUS',
58: avalue => p_start_status);
59: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
60:

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

57: aname => 'GMDRPLAP_START_STATUS',
58: avalue => p_start_status);
59: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
60:
61: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
62: aname => 'GMDRPLAP_TIMEOUT',
63: avalue => l_wf_timeout);
64: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
65: aname => 'GMDRPLAP_MESG_CNT',

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

60:
61: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
62: aname => 'GMDRPLAP_TIMEOUT',
63: avalue => l_wf_timeout);
64: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
65: aname => 'GMDRPLAP_MESG_CNT',
66: avalue => 1);
67:
68:

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

65: aname => 'GMDRPLAP_MESG_CNT',
66: avalue => 1);
67:
68:
69: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
70: aname => 'GMDRPLAP_TARGET_STATUS',
71: avalue => p_target_status);
72:
73: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

69: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
70: aname => 'GMDRPLAP_TARGET_STATUS',
71: avalue => p_target_status);
72:
73: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDRPLAP_RECIPE_NO',
75: avalue => p_recipe_no);
76:
77: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

73: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDRPLAP_RECIPE_NO',
75: avalue => p_recipe_no);
76:
77: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
78: aname => 'GMDRPLAP_RECIPE_VERS',
79: avalue => p_recipe_vers);
80:
81: l_runform := 'GMDRCPED_F:RECIPE_ID='||to_char(p_recipe_id);

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

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

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

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

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

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

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

115: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
116: aname => 'GMDRPLAP_OWNER_ID',
117: avalue => l_performer_name);
118:
119: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
120: aname => 'GMDRPLAP_RECIPE_DESC',
121: avalue => l_recipe_description);
122:
123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

119: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
120: aname => 'GMDRPLAP_RECIPE_DESC',
121: avalue => l_recipe_description);
122:
123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
124: aname => 'GMDRPLAP_CREATION_ORGN_CODE',
125: avalue => l_creation_orgn_code);
126:
127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
124: aname => 'GMDRPLAP_CREATION_ORGN_CODE',
125: avalue => l_creation_orgn_code);
126:
127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
128: aname => 'GMDRPLAP_ROUTING_NO',
129: avalue => l_routing_no);
130:
131: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
128: aname => 'GMDRPLAP_ROUTING_NO',
129: avalue => l_routing_no);
130:
131: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
132: aname => 'GMDRPLAP_ROUTING_VERS',
133: avalue => l_routing_vers);
134:
135: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

131: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
132: aname => 'GMDRPLAP_ROUTING_VERS',
133: avalue => l_routing_vers);
134:
135: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
136: aname => 'GMDRPLAP_FORMULA_NO',
137: avalue => l_formula_no);
138:
139: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

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

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

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

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

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

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

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

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

211: itemkey => p_itemkey,
212: aname => 'GMDRPLAP_ADDL_TEXT',
213: avalue => l_data_string);
214:
215: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
216: itemkey => p_itemkey,
217: aname => 'GMDRPLAP_APPROVER',
218: avalue => p_role);
219:

Line 222: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_TARGET_STATUS');

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

Line 242: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRPLAP_MESG_CNT');

238: p_itemkey IN VARCHAR2,
239: p_actid IN NUMBER,
240: p_funcmode IN VARCHAR2,
241: p_resultout OUT NOCOPY VARCHAR2) IS
242: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRPLAP_MESG_CNT');
243: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_APPROVER');
244: BEGIN
245: IF (p_funcmode = 'TIMEOUT') THEN
246: l_mesg_cnt := l_mesg_cnt + 1;

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

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

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

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

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

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

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

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

Line 301: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_TARGET_STATUS');

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

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

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

Line 346: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_START_STATUS');

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

Line 347: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_TARGET_STATUS');

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

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

361: p_itemkey IN VARCHAR2,
362: p_actid IN NUMBER,
363: p_funcmode IN VARCHAR2,
364: p_resultout OUT NOCOPY VARCHAR2) IS
365: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));
366: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
367: BEGIN
368: IF (p_funcmode = 'RUN') THEN
369: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_START_STATUS');

Line 369: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_START_STATUS');

365: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_RECIPE_ID'));
366: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
367: BEGIN
368: IF (p_funcmode = 'RUN') THEN
369: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_START_STATUS');
370: UPDATE GMD_RECIPES_B
371: SET RECIPE_STATUS = l_start_status
372: WHERE RECIPE_ID = l_recipe_id;
373: END IF;

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

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

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

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

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

395: p_actid IN NUMBER,
396: p_funcmode IN VARCHAR2,
397: p_resultout OUT NOCOPY VARCHAR2) IS
398: l_html_mesg VARCHAR2(4000);
399: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_COMMENT');
400: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_DISP_COMMENT');
401: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_CURR_PERFORMER');
402: BEGIN
403: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

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

396: p_funcmode IN VARCHAR2,
397: p_resultout OUT NOCOPY VARCHAR2) IS
398: l_html_mesg VARCHAR2(4000);
399: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_COMMENT');
400: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_DISP_COMMENT');
401: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_CURR_PERFORMER');
402: BEGIN
403: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
404: BEGIN

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

397: p_resultout OUT NOCOPY VARCHAR2) IS
398: l_html_mesg VARCHAR2(4000);
399: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_COMMENT');
400: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_DISP_COMMENT');
401: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPLAP_CURR_PERFORMER');
402: BEGIN
403: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
404: BEGIN
405: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)||

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

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

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

412: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
413: itemkey => p_itemkey,
414: aname => 'GMDRPLAP_DISP_COMMENT',
415: avalue => l_mesg_comment);
416: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
417: -- itemkey => p_itemkey,
418: -- aname => 'GMDRPLAP_HTML_DISP_COMMENT',
419: -- avalue => l_html_mesg);
420: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

416: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
417: -- itemkey => p_itemkey,
418: -- aname => 'GMDRPLAP_HTML_DISP_COMMENT',
419: -- avalue => l_html_mesg);
420: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
421: itemkey => p_itemkey,
422: aname => 'GMDRPLAP_COMMENT',
423: avalue => l_comment);
424: END IF;