APPS.GMDFMLAP_WF_PKG dependencies on GMD_STATUS_NEXT

Line 163: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

159: p_role GMA_ACTDATA_WF.ROLE%TYPE;
160: l_data_string VARCHAR2(2000);
161: p_wf_data_string VARCHAR2(2000);
162: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
163: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
164: BEGIN
165:
166: IF (p_funcmode = 'RUN') THEN
167: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,

Line 253: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

249: p_itemkey IN VARCHAR2,
250: p_actid IN NUMBER,
251: p_funcmode IN VARCHAR2,
252: p_resultout OUT NOCOPY VARCHAR2) IS
253: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
254: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_FORMULA_ID'));
255: /* GK added variables for recipe generation B3604554 */
256: l_return_status VARCHAR2(1);
257: x_recipe_no VARCHAR2(32);

Line 330: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

326: p_itemkey IN VARCHAR2,
327: p_actid IN NUMBER,
328: p_funcmode IN VARCHAR2,
329: p_resultout OUT NOCOPY VARCHAR2) IS
330: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
331: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
332: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
333: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_FORMULA_ID'));
334: BEGIN

Line 331: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

327: p_actid IN NUMBER,
328: p_funcmode IN VARCHAR2,
329: p_resultout OUT NOCOPY VARCHAR2) IS
330: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
331: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
332: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
333: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_FORMULA_ID'));
334: BEGIN
335: IF (p_funcmode = 'RUN') THEN

Line 332: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

328: p_funcmode IN VARCHAR2,
329: p_resultout OUT NOCOPY VARCHAR2) IS
330: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
331: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
332: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
333: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_FORMULA_ID'));
334: BEGIN
335: IF (p_funcmode = 'RUN') THEN
336: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_START_STATUS');

Line 339: FROM GMD_STATUS_NEXT

335: IF (p_funcmode = 'RUN') THEN
336: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_START_STATUS');
337: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_TARGET_STATUS');
338: SELECT rework_status into l_rework_status
339: FROM GMD_STATUS_NEXT
340: WHERE current_status = l_start_status
341: AND target_status = l_target_status
342: AND pending_status IS NOT NULL;
343: UPDATE FM_FORM_MST_B

Line 356: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

352: p_actid IN NUMBER,
353: p_funcmode IN VARCHAR2,
354: p_resultout OUT NOCOPY VARCHAR2) IS
355: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_FORMULA_ID'));
356: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
357: BEGIN
358: IF (p_funcmode = 'RUN') THEN
359: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMLAP_START_STATUS');
360: UPDATE FM_FORM_MST_B