APPS.GMDFMGAP_WF_PKG dependencies on GMD_STATUS_NEXT

Line 168: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

164: p_role GMA_ACTDATA_WF.ROLE%TYPE;
165: l_data_string VARCHAR2(2000);
166: p_wf_data_string VARCHAR2(2000);
167: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
168: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
169:
170: BEGIN
171:
172: /* Bug No.8355449 - Added the below line to enable m_fs_context */

Line 263: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

259: p_actid IN NUMBER,
260: p_funcmode IN VARCHAR2,
261: p_resultout OUT NOCOPY VARCHAR2) IS
262:
263: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
264: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
265:
266: /* added variables for recipe generation */
267: l_return_status VARCHAR2(1);

Line 343: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

339: p_itemkey IN VARCHAR2,
340: p_actid IN NUMBER,
341: p_funcmode IN VARCHAR2,
342: p_resultout OUT NOCOPY VARCHAR2) IS
343: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
344: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
345: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
346: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
347: BEGIN

Line 344: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

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

Line 345: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

341: p_funcmode IN VARCHAR2,
342: p_resultout OUT NOCOPY VARCHAR2) IS
343: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
344: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
345: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
346: l_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_ID'));
347: BEGIN
348: IF (p_funcmode = 'RUN') THEN
349: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');

Line 352: FROM GMD_STATUS_NEXT

348: IF (p_funcmode = 'RUN') THEN
349: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_START_STATUS');
350: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_TARGET_STATUS');
351: SELECT rework_status into l_rework_status
352: FROM GMD_STATUS_NEXT
353: WHERE current_status = l_start_status
354: AND target_status = l_target_status
355: AND pending_status IS NOT NULL;
356: UPDATE FM_FORM_MST_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_formula_id FM_FORM_MST_B.formula_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDFMGAP_FORMULA_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,'GMDFMGAP_START_STATUS');
373: UPDATE FM_FORM_MST_B