[Home] [Help]
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