APPS.GMD_STATUS_CODE dependencies on GMD_STATUS

Line 1: Package Body GMD_STATUS_CODE AS

1: Package Body GMD_STATUS_CODE AS
2: /* $Header: GMDSTATB.pls 120.1 2005/07/20 23:41:23 kkillams noship $ */
3:
4: /* Purpose: The package has code used in status management */
5: /* The package will usually be called from the Change Status form */

Line 66: l_cur_dependent_status GMD_STATUS.STATUS_CODE%TYPE;

62: Formula_Status_cur Status_ref_cur;
63: Routing_Status_cur Status_ref_cur;
64: Recipe_Status_cur Status_ref_cur;
65:
66: l_cur_dependent_status GMD_STATUS.STATUS_CODE%TYPE;
67: l_cur_routing_status GMD_STATUS.STATUS_CODE%TYPE;
68: l_lowest_allowed_status GMD_STATUS.STATUS_CODE%TYPE;
69: l_routing_defined FM_ROUT_HDR.ROUTING_ID%TYPE;
70: Dependent_Status_OK BOOLEAN := TRUE;

Line 67: l_cur_routing_status GMD_STATUS.STATUS_CODE%TYPE;

63: Routing_Status_cur Status_ref_cur;
64: Recipe_Status_cur Status_ref_cur;
65:
66: l_cur_dependent_status GMD_STATUS.STATUS_CODE%TYPE;
67: l_cur_routing_status GMD_STATUS.STATUS_CODE%TYPE;
68: l_lowest_allowed_status GMD_STATUS.STATUS_CODE%TYPE;
69: l_routing_defined FM_ROUT_HDR.ROUTING_ID%TYPE;
70: Dependent_Status_OK BOOLEAN := TRUE;
71:

Line 68: l_lowest_allowed_status GMD_STATUS.STATUS_CODE%TYPE;

64: Recipe_Status_cur Status_ref_cur;
65:
66: l_cur_dependent_status GMD_STATUS.STATUS_CODE%TYPE;
67: l_cur_routing_status GMD_STATUS.STATUS_CODE%TYPE;
68: l_lowest_allowed_status GMD_STATUS.STATUS_CODE%TYPE;
69: l_routing_defined FM_ROUT_HDR.ROUTING_ID%TYPE;
70: Dependent_Status_OK BOOLEAN := TRUE;
71:
72: BEGIN

Line 326: FROM GMD_STATUS_NEXT

322: RETURN VARCHAR2
323: IS
324: CURSOR Cur_get_rework IS
325: SELECT rework_status
326: FROM GMD_STATUS_NEXT
327: WHERE current_status = p_from_status
328: AND target_status = p_to_status
329: AND pending_status IS NOT NULL;
330:

Line 347: FROM GMD_STATUS_NEXT

343: RETURN VARCHAR2
344: IS
345: CURSOR Cur_get_pending IS
346: SELECT pending_status
347: FROM GMD_STATUS_NEXT
348: WHERE current_status = p_from_status
349: AND target_status = p_to_status;
350:
351: l_pending_status VARCHAR2(30);

Line 360: END; -- Package Body GMD_STATUS_CODE

356: RETURN (l_pending_status);
357:
358: END get_pending_status;
359:
360: END; -- Package Body GMD_STATUS_CODE