APPS.GMDRPLAP_WF_PKG dependencies on GMD_STATUS_NEXT

Line 187: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 275: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 340: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 341: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 342: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 349: FROM GMD_STATUS_NEXT

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

Line 366: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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