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

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

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

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

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

Line 52: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

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

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

51: /* make sure that process runs with background engine */
52: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
53:
54: /* set the item attributes */
55: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
56: aname => 'GMDRVLAP_RECIPE_ID',
57: avalue => p_recipe_id);
58: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
59: aname => 'GMDRVLAP_RECIPE_VALIDITYRULEID',

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

54: /* set the item attributes */
55: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
56: aname => 'GMDRVLAP_RECIPE_ID',
57: avalue => p_recipe_id);
58: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
59: aname => 'GMDRVLAP_RECIPE_VALIDITYRULEID',
60: avalue => p_recipe_validity_rule_id);
61:
62: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

58: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
59: aname => 'GMDRVLAP_RECIPE_VALIDITYRULEID',
60: avalue => p_recipe_validity_rule_id);
61:
62: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
63: aname => 'GMDRVLAP_START_STATUS',
64: avalue => p_start_status);
65:
66: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,

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

62: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
63: aname => 'GMDRVLAP_START_STATUS',
64: avalue => p_start_status);
65:
66: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
67: aname => 'GMDRVLAP_TARGET_STATUS',
68: avalue => p_target_status);
69:
70: SELECT RECIPE_NO,RECIPE_VERSION INTO l_recipe_no,l_recipe_vers

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

69:
70: SELECT RECIPE_NO,RECIPE_VERSION INTO l_recipe_no,l_recipe_vers
71: FROM GMD_RECIPES_B
72: WHERE RECIPE_ID = P_RECIPE_ID;
73: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDRVLAP_RECIPE_NO',
75: avalue => l_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 => 'GMDRVLAP_RECIPE_NO',
75: avalue => l_recipe_no);
76:
77: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
78: aname => 'GMDRVLAP_RECIPE_VERS',
79: avalue => l_recipe_vers);
80:
81:

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

80:
81:
82: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
83:
84: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
85: aname => 'GMDRVLAP_TIMEOUT',
86: avalue => l_wf_timeout);
87: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
88: aname => 'GMDRVLAP_MESG_CNT',

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

83:
84: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
85: aname => 'GMDRVLAP_TIMEOUT',
86: avalue => l_wf_timeout);
87: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,itemkey => l_itemkey,
88: aname => 'GMDRVLAP_MESG_CNT',
89: avalue => 1);
90:
91: l_runform := 'GMDRVRED_F:RECIPE_VALIDITY_RULE_ID='||to_char(p_recipe_validity_rule_id);

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

89: avalue => 1);
90:
91: l_runform := 'GMDRVRED_F:RECIPE_VALIDITY_RULE_ID='||to_char(p_recipe_validity_rule_id);
92:
93: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
94: aname => 'GMDRVLAP_FORM',
95: avalue => l_runform);
96:
97: -- get values to be stored into the workflow item

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

99: INTO l_performer_name ,l_performer_display_name
100: FROM FND_USER
101: WHERE USER_ID = p_Requester;
102:
103: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
104: aname => 'GMDRVLAP_REQUSTER',
105: avalue => l_performer_name );
106:
107: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */

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

119: IF l_orgn_id is NOT NULL then
120: GMD_ERES_UTILS.GET_ORGANIZATION_CODE(l_orgn_id, l_orgn_code);
121: END IF;
122:
123: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
124: aname => 'GMDRVLAP_ORGN_CODE',
125: avalue => l_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 => 'GMDRVLAP_ORGN_CODE',
125: avalue => l_orgn_code);
126:
127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
128: aname => 'GMDRVLAP_RECIPE_USE',
129: avalue => l_recipe_use);
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 => 'GMDRVLAP_RECIPE_USE',
129: avalue => l_recipe_use);
130:
131: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
132: aname => 'GMDRVLAP_ITEM_NO',
133: avalue => l_item_no);
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 => 'GMDRVLAP_ITEM_NO',
133: avalue => l_item_no);
134:
135: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
136: aname => 'GMDRVLAP_PREFERENCE',
137: avalue => l_preference);
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 => 'GMDRVLAP_PREFERENCE',
137: avalue => l_preference);
138:
139: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
140: aname => 'GMDRVLAP_STD_QTY',
141: avalue => l_std_qty);
142:
143: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

139: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
140: aname => 'GMDRVLAP_STD_QTY',
141: avalue => l_std_qty);
142:
143: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
144: aname => 'GMDRVLAP_MIN_QTY',
145: avalue => l_min_qty);
146:
147: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

143: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
144: aname => 'GMDRVLAP_MIN_QTY',
145: avalue => l_min_qty);
146:
147: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
148: aname => 'GMDRVLAP_MAX_QTY',
149: avalue => l_max_qty);
150:
151: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

147: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
148: aname => 'GMDRVLAP_MAX_QTY',
149: avalue => l_max_qty);
150:
151: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
152: aname => 'GMDRVLAP_EFF_START_DATE',
153: avalue => l_effective_start_date);
154:
155: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,

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

151: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
152: aname => 'GMDRVLAP_EFF_START_DATE',
153: avalue => l_effective_start_date);
154:
155: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
156: aname => 'GMDRVLAP_EFF_END_DATE',
157: avalue => l_effective_end_date);
158:
159: /* Mercy Thomas Bug 3173515 End of the changes */

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

159: /* Mercy Thomas Bug 3173515 End of the changes */
160:
161: /* start the Workflow process */
162:
163: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
164:
165:
166:
167: EXCEPTION

Line 204: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');

200: l_data_string VARCHAR2(2000);
201: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
202: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
203: BEGIN
204: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
205: -- Bug# 5030408 Kapil M : Removed the table name
206: P_where_clause := ' RECIPE_VALIDITY_RULE_ID='||l_recipe_validity_rule_id;
207: IF (p_funcmode = 'RUN') THEN
208: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,

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

222: p_lab_activity_name,
223: p_data_string,
224: P_role);
225: l_data_string := replace(p_wf_data_string,l_delimiter,wf_core.newline);
226: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
227: itemkey => p_itemkey,
228: aname => 'GMDRVLAP_ADDL_TEXT',
229: avalue => l_data_string);
230:

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

227: itemkey => p_itemkey,
228: aname => 'GMDRVLAP_ADDL_TEXT',
229: avalue => l_data_string);
230:
231: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
232: itemkey => p_itemkey,
233: aname => 'GMDRVLAP_APPROVER',
234: avalue => p_role);
235:

Line 238: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');

234: avalue => p_role);
235:
236: p_resultout:='COMPLETE:Y';
237: ELSE
238: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
239: UPDATE GMD_RECIPE_VALIDITY_RULES
240: SET VALIDITY_RULE_STATUS = l_target_status
241: WHERE RECIPE_VALIDITY_RULE_ID = l_recipe_validity_rule_id;
242: p_resultout:='COMPLETE:N';

Line 258: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_MESG_CNT');

254: p_itemkey IN VARCHAR2,
255: p_actid IN NUMBER,
256: p_funcmode IN VARCHAR2,
257: p_resultout OUT NOCOPY VARCHAR2) IS
258: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_MESG_CNT');
259: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_APPROVER');
260: BEGIN
261: IF (p_funcmode = 'TIMEOUT') THEN
262: l_mesg_cnt := l_mesg_cnt + 1;

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

255: p_actid IN NUMBER,
256: p_funcmode IN VARCHAR2,
257: p_resultout OUT NOCOPY VARCHAR2) IS
258: l_mesg_cnt number:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_MESG_CNT');
259: l_approver VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_APPROVER');
260: BEGIN
261: IF (p_funcmode = 'TIMEOUT') THEN
262: l_mesg_cnt := l_mesg_cnt + 1;
263: IF l_mesg_cnt <= 4 THEN

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

260: BEGIN
261: IF (p_funcmode = 'TIMEOUT') THEN
262: l_mesg_cnt := l_mesg_cnt + 1;
263: IF l_mesg_cnt <= 4 THEN
264: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,
265: aname => 'GMDRVLAP_MESG_CNT',
266: avalue => l_mesg_cnt);
267: ELSE
268: p_resultout := 'COMPLETE:DEFAULT';

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

267: ELSE
268: p_resultout := 'COMPLETE:DEFAULT';
269: END IF;
270: ELSIF (p_funcmode = 'RESPOND') THEN
271: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
272: itemkey => p_itemkey,
273: aname => 'GMDRVLAP_CURR_PERFORMER',
274: avalue => l_approver);
275: END IF;

Line 288: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');

284: p_resultout OUT NOCOPY VARCHAR2) IS
285: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
286: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
287: BEGIN
288: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
289: IF (p_funcmode = 'RUN') THEN
290: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
291: UPDATE GMD_RECIPE_VALIDITY_RULES
292: SET VALIDITY_RULE_STATUS = l_target_status

Line 290: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');

286: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
287: BEGIN
288: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
289: IF (p_funcmode = 'RUN') THEN
290: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
291: UPDATE GMD_RECIPE_VALIDITY_RULES
292: SET VALIDITY_RULE_STATUS = l_target_status
293: WHERE RECIPE_VALIDITY_RULE_ID = l_recipe_validity_rule_id;
294: END IF;

Line 308: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');

304: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
305: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
306: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
307: BEGIN
308: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
309: IF (p_funcmode = 'RUN') THEN
310: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');
311: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
312: SELECT rework_status into l_rework_status

Line 310: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');

306: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
307: BEGIN
308: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
309: IF (p_funcmode = 'RUN') THEN
310: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');
311: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
312: SELECT rework_status into l_rework_status
313: FROM GMD_STATUS_NEXT
314: WHERE current_status = l_start_status

Line 311: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');

307: BEGIN
308: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
309: IF (p_funcmode = 'RUN') THEN
310: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');
311: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_TARGET_STATUS');
312: SELECT rework_status into l_rework_status
313: FROM GMD_STATUS_NEXT
314: WHERE current_status = l_start_status
315: AND target_status = l_target_status

Line 332: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');

328: p_resultout OUT NOCOPY VARCHAR2) IS
329: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
330: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
331: BEGIN
332: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
333: IF (p_funcmode = 'RUN') THEN
334: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');
335: UPDATE GMD_RECIPE_VALIDITY_RULES
336: SET VALIDITY_RULE_STATUS = l_start_status

Line 334: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');

330: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
331: BEGIN
332: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVLAP_RECIPE_VALIDITYRULEID');
333: IF (p_funcmode = 'RUN') THEN
334: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_START_STATUS');
335: UPDATE GMD_RECIPE_VALIDITY_RULES
336: SET VALIDITY_RULE_STATUS = l_start_status
337: WHERE RECIPE_VALIDITY_RULE_ID = l_recipe_validity_rule_id;
338: END IF;

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

343: p_itemkey IN VARCHAR2,
344: p_actid IN NUMBER,
345: p_funcmode IN VARCHAR2,
346: p_resultout OUT NOCOPY VARCHAR2) IS
347: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_REQUSTER');
348: BEGIN
349: IF (p_funcmode = 'RESPOND') THEN
350: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
351: itemkey => p_itemkey,

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

346: p_resultout OUT NOCOPY VARCHAR2) IS
347: l_requester VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_REQUSTER');
348: BEGIN
349: IF (p_funcmode = 'RESPOND') THEN
350: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
351: itemkey => p_itemkey,
352: aname => 'GMDRVLAP_CURR_PERFORMER',
353: avalue => l_requester);
354: END IF;

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

360: p_actid IN NUMBER,
361: p_funcmode IN VARCHAR2,
362: p_resultout OUT NOCOPY VARCHAR2) IS
363: l_html_mesg VARCHAR2(4000);
364: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_COMMENT');
365: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_DISP_COMMENT');
366: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_CURR_PERFORMER');
367: BEGIN
368: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN

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

361: p_funcmode IN VARCHAR2,
362: p_resultout OUT NOCOPY VARCHAR2) IS
363: l_html_mesg VARCHAR2(4000);
364: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_COMMENT');
365: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_DISP_COMMENT');
366: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_CURR_PERFORMER');
367: BEGIN
368: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
369: BEGIN

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

362: p_resultout OUT NOCOPY VARCHAR2) IS
363: l_html_mesg VARCHAR2(4000);
364: l_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_COMMENT');
365: l_mesg_comment VARCHAR2(4000):=wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_DISP_COMMENT');
366: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVLAP_CURR_PERFORMER');
367: BEGIN
368: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
369: BEGIN
370: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)||

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

373: l_comment := null;
374: EXCEPTION WHEN OTHERS THEN
375: NULL;
376: END;
377: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
378: itemkey => p_itemkey,
379: aname => 'GMDRVLAP_DISP_COMMENT',
380: avalue => l_mesg_comment);
381: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

377: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
378: itemkey => p_itemkey,
379: aname => 'GMDRVLAP_DISP_COMMENT',
380: avalue => l_mesg_comment);
381: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
382: -- itemkey => p_itemkey,
383: -- aname => 'GMDRVLAP_HTML_DISP_COMMENT',
384: -- avalue => l_html_mesg);
385: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,

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

381: -- WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
382: -- itemkey => p_itemkey,
383: -- aname => 'GMDRVLAP_HTML_DISP_COMMENT',
384: -- avalue => l_html_mesg);
385: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,
386: itemkey => p_itemkey,
387: aname => 'GMDRVLAP_COMMENT',
388: avalue => l_comment);
389: END IF;