PACKAGE: APPS.GMD_STATUS_CODE

Source

1 Package GMD_STATUS_CODE AUTHID CURRENT_USER AS
2 /* $Header: GMDSTATS.pls 115.4 2002/08/23 20:27:33 txdaniel noship $ */
3 
4 /* Purpose: The package has code used in status management                 */
5 /*          The package will usually be called from the Change Status form */
6 /*                                                                         */
7 /*                                                                         */
8 /* Check_Dependent_Status                                                  */
9 /*                                                                         */
10 /* MODIFICATION HISTORY                                                    */
11 /* Person      Date      Comments                                          */
12 /* ---------   ------    ------------------------------------------        */
13 /* L.Jackson   15Mar2001  Start
14 /* Sukarna Reddy 05/03/01 Added Check parent Status routine */
15 
16 /* Constants                                                                                        */
17 /* =========                                                                                        */
18 G_PKG_NAME     CONSTANT VARCHAR2(30) := 'GMD_STATUS_CODE';
19 
20   FUNCTION CHECK_DEPENDENT_STATUS
21      ( P_Entity_Type    NUMBER,
22        P_Entity_id      NUMBER,
23        P_Current_Status VARCHAR2,
24        P_To_Status      VARCHAR2)
25    	RETURN BOOLEAN;
26 
27   FUNCTION CHECK_PARENT_STATUS(pentity_name VARCHAR2,
28                                pentity_id   NUMBER)
29                                RETURN BOOLEAN;
30 
31 
32   FUNCTION GET_REWORK_STATUS(p_from_status VARCHAR2,
33                              p_to_status VARCHAR2)
34                                RETURN VARCHAR2;
35 
36   FUNCTION GET_PENDING_STATUS(p_from_status VARCHAR2,
37                               p_to_status VARCHAR2)
38                                RETURN VARCHAR2;
39 
40 END; -- Package Specification GMD_STATUS_CODE