APPS.GMDRPGAP_WF_PKG dependencies on GMD_STATUS_NEXT

Line 190: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

186: P_where_clause VARCHAR2(100):= ' GMD_RECIPES_B.RECIPE_ID='||l_RECIPE_ID; -- Where clause to be appended
187: p_role GMA_ACTDATA_WF.ROLE%TYPE;
188: l_data_string VARCHAR2(2000);
189: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
190: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
191:
192: BEGIN
193: IF (p_funcmode = 'RUN') THEN
194: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,

Line 278: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 342: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

338: p_itemkey IN VARCHAR2,
339: p_actid IN NUMBER,
340: p_funcmode IN VARCHAR2,
341: p_resultout OUT NOCOPY VARCHAR2) IS
342: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
343: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
344: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
345: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));
346: BEGIN

Line 343: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 344: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 351: FROM GMD_STATUS_NEXT

347: IF (p_funcmode = 'RUN') THEN
348: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_START_STATUS');
349: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_TARGET_STATUS');
350: SELECT rework_status into l_rework_status
351: FROM GMD_STATUS_NEXT
352: WHERE current_status = l_start_status
353: AND target_status = l_target_status
354: AND pending_status IS NOT NULL;
355: UPDATE GMD_RECIPES_B

Line 369: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

365: p_actid IN NUMBER,
366: p_funcmode IN VARCHAR2,
367: p_resultout OUT NOCOPY VARCHAR2) IS
368: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_RECIPE_ID'));
369: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
370: BEGIN
371: IF (p_funcmode = 'RUN') THEN
372: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDRPGAP_START_STATUS');
373: UPDATE GMD_RECIPES_B