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

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

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

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

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

Line 48: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

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

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

47: /* make sure that process runs with background engine */
48: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
49:
50: /* set the item attributes */
51: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
52: aname => 'GMDRTGAP_ROUTING_ID',
53: avalue => p_Routing_id);
54:
55: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

51: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
52: aname => 'GMDRTGAP_ROUTING_ID',
53: avalue => p_Routing_id);
54:
55: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
56: aname => 'GMDRTGAP_START_STATUS',
57: avalue => p_start_status);
58:
59: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

55: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
56: aname => 'GMDRTGAP_START_STATUS',
57: avalue => p_start_status);
58:
59: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
60: aname => 'GMDRTGAP_TARGET_STATUS',
61: avalue => p_target_status);
62:
63: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

59: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
60: aname => 'GMDRTGAP_TARGET_STATUS',
61: avalue => p_target_status);
62:
63: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
64: aname => 'GMDRTGAP_ROUTING_NO',
65: avalue => p_Routing_no);
66:
67: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

63: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
64: aname => 'GMDRTGAP_ROUTING_NO',
65: avalue => p_Routing_no);
66:
67: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
68: aname => 'GMDRTGAP_ROUTING_VERS',
69: avalue => p_Routing_vers);
70:
71: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes

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

69: avalue => p_Routing_vers);
70:
71: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
72:
73: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDRTGAP_TIMEOUT',
75: avalue => l_wf_timeout);
76: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
77: aname => 'GMDRTGAP_MESG_CNT',

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

72:
73: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDRTGAP_TIMEOUT',
75: avalue => l_wf_timeout);
76: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
77: aname => 'GMDRTGAP_MESG_CNT',
78: avalue => 1);
79:
80: l_runform := 'GMDROTED_F:ROUTING_ID='||to_char(p_Routing_id);

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

78: avalue => 1);
79:
80: l_runform := 'GMDROTED_F:ROUTING_ID='||to_char(p_Routing_id);
81:
82: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
83: aname => 'GMDRTGAP_FORM',
84: avalue => l_runform);
85:
86: -- get values to be stored into the workflow item

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

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

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

103: INTO l_performer_name ,l_performer_display_name
104: FROM FND_USER
105: WHERE USER_ID = l_owner_id;
106:
107: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
108: aname => 'GMDRTGAP_OWNER_ID',
109: avalue => l_performer_name);
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 => 'GMDRTGAP_OWNER_ID',
109: avalue => l_performer_name);
110:
111: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
112: aname => 'GMDRTGAP_ROUTING_DESC',
113: avalue => l_routing_desc);
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 => 'GMDRTGAP_ROUTING_DESC',
113: avalue => l_routing_desc);
114:
115: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
116: aname => 'GMDRTGAP_ROUTING_CLASS',
117: avalue => l_routing_class);
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 => 'GMDRTGAP_ROUTING_CLASS',
117: avalue => l_routing_class);
118:
119: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
120: aname => 'GMDRTGAP_ROUTING_QTY',
121: avalue => l_routing_qty);
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 => 'GMDRTGAP_ROUTING_QTY',
121: avalue => l_routing_qty);
122:
123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
124: aname => 'GMDRTGAP_ROUTING_UOM',
125: avalue => l_item_um);
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 => 'GMDRTGAP_ROUTING_UOM',
125: avalue => l_item_um);
126:
127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
128: aname => 'GMDRTGAP_EFF_START_DATE',
129: avalue => l_effective_start_date);
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 => 'GMDRTGAP_EFF_START_DATE',
129: avalue => l_effective_start_date);
130:
131: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
132: aname => 'GMDRTGAP_EFF_END_DATE',
133: avalue => l_effective_end_date);
134:
135: /* Mercy Thomas Bug 3173515 End of the changes */

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

135: /* Mercy Thomas Bug 3173515 End of the changes */
136:
137: /* start the Workflow process */
138:
139: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
140:
141:
142:
143: EXCEPTION

Line 167: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));

163: IS
164: /* procedure to Check Approval is required or not if required find the approver and send the notification to
165: approver */
166:
167: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
168: p_data_string VARCHAR2(2000);
169: p_wf_data_string VARCHAR2(2000);
170: p_lab_wf_item_type VARCHAR2(8) := 'GMDRTGAP'; -- Recipe Lab use Approval Workflow Inernal Name
171: P_lab_Process_name VARCHAR2(32) := 'GMDRTGAP_PROCESS'; -- Recipe Lab use Approval Workflow Process Inernal Name

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

196: p_lab_activity_name,
197: p_data_string,
198: P_role);
199: l_data_string := replace(p_wf_data_string,l_delimiter,wf_core.newline);
200: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
201: itemkey => p_itemkey,
202: aname => 'GMDRTGAP_ADDL_TEXT',
203: avalue => l_data_string);
204:

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

201: itemkey => p_itemkey,
202: aname => 'GMDRTGAP_ADDL_TEXT',
203: avalue => l_data_string);
204:
205: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
206: itemkey => p_itemkey,
207: aname => 'GMDRTGAP_APPROVER',
208: avalue => p_role);
209:

Line 212: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');

208: avalue => p_role);
209:
210: p_resultout:='COMPLETE:Y';
211: ELSE
212: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');
213: UPDATE GMD_ROUTINGS_B
214: SET ROUTING_STATUS = l_target_status
215: WHERE ROUTING_ID = l_Routing_id;
216: p_resultout:='COMPLETE:N';

Line 232: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRTGAP_MESG_CNT');

228: p_itemkey IN VARCHAR2,
229: p_actid IN NUMBER,
230: p_funcmode IN VARCHAR2,
231: p_resultout OUT NOCOPY VARCHAR2) IS
232: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRTGAP_MESG_CNT');
233: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_APPROVER');
234: BEGIN
235: IF (p_funcmode = 'TIMEOUT') THEN
236: l_mesg_cnt := l_mesg_cnt + 1;

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

229: p_actid IN NUMBER,
230: p_funcmode IN VARCHAR2,
231: p_resultout OUT NOCOPY VARCHAR2) IS
232: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRTGAP_MESG_CNT');
233: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_APPROVER');
234: BEGIN
235: IF (p_funcmode = 'TIMEOUT') THEN
236: l_mesg_cnt := l_mesg_cnt + 1;
237: IF l_mesg_cnt <= 4 THEN

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

234: BEGIN
235: IF (p_funcmode = 'TIMEOUT') THEN
236: l_mesg_cnt := l_mesg_cnt + 1;
237: IF l_mesg_cnt <= 4 THEN
238: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
239: aname => 'GMDRTGAP_MESG_CNT',
240: avalue => l_mesg_cnt);
241: ELSE
242: p_resultout := 'COMPLETE:DEFAULT';

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

241: ELSE
242: p_resultout := 'COMPLETE:DEFAULT';
243: END IF;
244: ELSIF (p_funcmode = 'RESPOND') THEN
245: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
246: itemkey => p_itemkey,
247: aname => 'GMDRTGAP_CURR_PERFORMER',
248: avalue => l_approver);
249: END IF;

Line 260: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));

256: p_actid IN NUMBER,
257: p_funcmode IN VARCHAR2,
258: p_resultout OUT NOCOPY VARCHAR2) IS
259: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
260: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
261: BEGIN
262: IF (p_funcmode = 'RUN') THEN
263: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');
264: UPDATE GMD_ROUTINGS_B

Line 263: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');

259: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
260: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
261: BEGIN
262: IF (p_funcmode = 'RUN') THEN
263: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');
264: UPDATE GMD_ROUTINGS_B
265: SET ROUTING_STATUS = l_target_status
266: WHERE ROUTING_ID = l_Routing_id;
267: END IF;

Line 280: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));

276: p_resultout OUT NOCOPY VARCHAR2) IS
277: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
278: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
279: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
280: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
281: BEGIN
282: IF (p_funcmode = 'RUN') THEN
283: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_START_STATUS');
284: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');

Line 283: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_START_STATUS');

279: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
280: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
281: BEGIN
282: IF (p_funcmode = 'RUN') THEN
283: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_START_STATUS');
284: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');
285: SELECT rework_status into l_rework_status
286: FROM GMD_STATUS_NEXT
287: WHERE current_status = l_start_status

Line 284: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');

280: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
281: BEGIN
282: IF (p_funcmode = 'RUN') THEN
283: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_START_STATUS');
284: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_TARGET_STATUS');
285: SELECT rework_status into l_rework_status
286: FROM GMD_STATUS_NEXT
287: WHERE current_status = l_start_status
288: AND target_status = l_target_status

Line 302: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));

298: p_itemkey IN VARCHAR2,
299: p_actid IN NUMBER,
300: p_funcmode IN VARCHAR2,
301: p_resultout OUT NOCOPY VARCHAR2) IS
302: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
303: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
304: BEGIN
305: IF (p_funcmode = 'RUN') THEN
306: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_START_STATUS');

Line 306: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_START_STATUS');

302: l_Routing_id gmd_routings_b.Routing_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_ROUTING_ID'));
303: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
304: BEGIN
305: IF (p_funcmode = 'RUN') THEN
306: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_START_STATUS');
307: UPDATE GMD_ROUTINGS_B
308: SET ROUTING_STATUS = l_start_status
309: WHERE ROUTING_ID = l_Routing_id;
310: END IF;

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

315: p_itemkey IN VARCHAR2,
316: p_actid IN NUMBER,
317: p_funcmode IN VARCHAR2,
318: p_resultout OUT NOCOPY VARCHAR2) IS
319: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_REQUSTER');
320: BEGIN
321: IF (p_funcmode = 'RESPOND') THEN
322: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
323: itemkey => p_itemkey,

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

318: p_resultout OUT NOCOPY VARCHAR2) IS
319: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_REQUSTER');
320: BEGIN
321: IF (p_funcmode = 'RESPOND') THEN
322: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
323: itemkey => p_itemkey,
324: aname => 'GMDRTGAP_CURR_PERFORMER',
325: avalue => l_requester);
326: END IF;

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

332: p_actid IN NUMBER,
333: p_funcmode IN VARCHAR2,
334: p_resultout OUT NOCOPY VARCHAR2) IS
335: l_html_mesg VARCHAR2(4000);
336: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_COMMENT');
337: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_DISP_COMMENT');
338: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_CURR_PERFORMER');
339: BEGIN
340: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

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

333: p_funcmode IN VARCHAR2,
334: p_resultout OUT NOCOPY VARCHAR2) IS
335: l_html_mesg VARCHAR2(4000);
336: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_COMMENT');
337: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_DISP_COMMENT');
338: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_CURR_PERFORMER');
339: BEGIN
340: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
341: BEGIN

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

334: p_resultout OUT NOCOPY VARCHAR2) IS
335: l_html_mesg VARCHAR2(4000);
336: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_COMMENT');
337: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_DISP_COMMENT');
338: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRTGAP_CURR_PERFORMER');
339: BEGIN
340: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
341: BEGIN
342: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||

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

345: l_comment := null;
346: EXCEPTION WHEN OTHERS THEN
347: NULL;
348: END;
349: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
350: itemkey => p_itemkey,
351: aname => 'GMDRTGAP_DISP_COMMENT',
352: avalue => l_mesg_comment);
353: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

349: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
350: itemkey => p_itemkey,
351: aname => 'GMDRTGAP_DISP_COMMENT',
352: avalue => l_mesg_comment);
353: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
354: -- itemkey => p_itemkey,
355: -- aname => 'GMDRTGAP_HTML_DISP_COMMENT',
356: -- avalue => l_html_mesg);
357: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

353: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
354: -- itemkey => p_itemkey,
355: -- aname => 'GMDRTGAP_HTML_DISP_COMMENT',
356: -- avalue => l_html_mesg);
357: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
358: itemkey => p_itemkey,
359: aname => 'GMDRTGAP_COMMENT',
360: avalue => l_comment);
361: END IF;