APPS.GMD_QC_STATUS_NEXT_PVT dependencies on GMD_QC_STATUS_NEXT

Line 1: Package Body GMD_QC_STATUS_NEXT_PVT AS

1: Package Body GMD_QC_STATUS_NEXT_PVT AS
2: /* $Header: GMDVSTNB.pls 115.0 2002/09/12 15:31:40 sschinch 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 19: FROM GMD_QC_STATUS_NEXT

15: RETURN VARCHAR2
16: IS
17: CURSOR Cur_get_rework IS
18: SELECT rework_status
19: FROM GMD_QC_STATUS_NEXT
20: WHERE current_status = p_from_status
21: AND target_status = p_to_status
22: AND entity_type = p_entity_type
23: AND pending_status IS NOT NULL;

Line 42: FROM GMD_QC_STATUS_NEXT

38: RETURN VARCHAR2
39: IS
40: CURSOR Cur_get_pending IS
41: SELECT pending_status
42: FROM GMD_QC_STATUS_NEXT
43: WHERE current_status = p_from_status
44: AND target_status = p_to_status
45: AND entity_type = p_entity_type;
46:

Line 56: END GMD_QC_STATUS_NEXT_PVT;

52: RETURN (l_pending_status);
53:
54: END get_pending_status;
55:
56: END GMD_QC_STATUS_NEXT_PVT;