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.GMDRVGAP_WF_PKG dependencies on GMD_STATUS_NEXT

Line 200: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

196: P_where_clause VARCHAR2(100) ;
197: p_role GMA_ACTDATA_WF.ROLE%TYPE;
198: l_data_string VARCHAR2(2000);
199: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
200: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
201: BEGIN
202: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVGAP_RECIPE_VALIDITYRULEID');
203: -- Bug# 5030408 Kapil M : Removed the table name
204: P_where_clause := ' RECIPE_VALIDITY_RULE_ID=' ||l_recipe_validity_rule_id; -- Where clause to be appended

Line 281: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

277: p_itemkey IN VARCHAR2,
278: p_actid IN NUMBER,
279: p_funcmode IN VARCHAR2,
280: p_resultout OUT NOCOPY VARCHAR2) IS
281: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
282: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
283: BEGIN
284: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVGAP_RECIPE_VALIDITYRULEID');
285: IF (p_funcmode = 'RUN') THEN

Line 300: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

296: p_itemkey IN VARCHAR2,
297: p_actid IN NUMBER,
298: p_funcmode IN VARCHAR2,
299: p_resultout OUT NOCOPY VARCHAR2) IS
300: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
301: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
302: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
303: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
304: BEGIN

Line 301: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

297: p_actid IN NUMBER,
298: p_funcmode IN VARCHAR2,
299: p_resultout OUT NOCOPY VARCHAR2) IS
300: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
301: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
302: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
303: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
304: BEGIN
305: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVGAP_RECIPE_VALIDITYRULEID');

Line 302: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

298: p_funcmode IN VARCHAR2,
299: p_resultout OUT NOCOPY VARCHAR2) IS
300: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
301: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
302: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
303: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
304: BEGIN
305: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVGAP_RECIPE_VALIDITYRULEID');
306: IF (p_funcmode = 'RUN') THEN

Line 310: FROM GMD_STATUS_NEXT

306: IF (p_funcmode = 'RUN') THEN
307: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVGAP_START_STATUS');
308: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVGAP_TARGET_STATUS');
309: SELECT rework_status into l_rework_status
310: FROM GMD_STATUS_NEXT
311: WHERE current_status = l_start_status
312: AND target_status = l_target_status
313: AND pending_status IS NOT NULL;
314: UPDATE GMD_RECIPE_VALIDITY_RULES

Line 327: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

323: p_actid IN NUMBER,
324: p_funcmode IN VARCHAR2,
325: p_resultout OUT NOCOPY VARCHAR2) IS
326: l_recipe_validity_rule_id GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE;
327: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
328: BEGIN
329: l_recipe_validity_rule_id:=wf_engine.getitemattrnumber(p_itemtype, p_itemkey,'GMDRVGAP_RECIPE_VALIDITYRULEID');
330: IF (p_funcmode = 'RUN') THEN
331: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRVGAP_START_STATUS');