198: P_where_clause VARCHAR2(100); -- Where clause to be appended
199: p_role GMA_ACTDATA_WF.ROLE%TYPE;
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;
281: p_itemkey IN VARCHAR2,
282: p_actid IN NUMBER,
283: p_funcmode IN VARCHAR2,
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
299: p_itemkey IN VARCHAR2,
300: p_actid IN NUMBER,
301: p_funcmode IN VARCHAR2,
302: p_resultout OUT NOCOPY VARCHAR2) IS
303: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
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
300: p_actid IN NUMBER,
301: p_funcmode IN VARCHAR2,
302: p_resultout OUT NOCOPY VARCHAR2) IS
303: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
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');
301: p_funcmode IN VARCHAR2,
302: p_resultout OUT NOCOPY VARCHAR2) IS
303: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
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
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
316: AND pending_status IS NOT NULL;
317: UPDATE GMD_RECIPE_VALIDITY_RULES
326: p_actid IN NUMBER,
327: p_funcmode IN VARCHAR2,
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');