DBA Data[Home] [Help]

PACKAGE: APPS.GMD_QC_ERES_CHANGE_STATUS_PVT

Source


1 package GMD_QC_ERES_CHANGE_STATUS_PVT AUTHID CURRENT_USER as
2 /* $Header: GMDVERES.pls 115.0 2002/09/19 22:17:26 txdaniel noship $ */
3 
4   PROCEDURE set_spec_status(p_spec_id IN NUMBER,
5                             p_from_status IN VARCHAR2,
6                             p_to_status IN VARCHAR2,
7                             p_signature_status IN VARCHAR2) ;
8 
9   PROCEDURE set_spec_vr_status(p_spec_vr_id IN NUMBER,
10                                p_entity_type IN VARCHAR2,
11                                p_from_status IN VARCHAR2,
12                                p_to_status IN VARCHAR2,
13                                p_signature_status IN VARCHAR2) ;
14 
15   PROCEDURE update_vr_status(pentity_type IN VARCHAR2,
16 		             pspec_vr_id  IN NUMBER,
17 		             p_to_status IN NUMBER) ;
18   FUNCTION chek_spec_validity_eres (p_spec_id IN NUMBER,
19                                     p_to_status IN VARCHAR2,
20                                     p_event  IN VARCHAR2) RETURN BOOLEAN;
21 
22   FUNCTION esig_required (p_event IN VARCHAR2,
23                           p_event_key IN VARCHAR2,
24                           p_to_status IN VARCHAR2)
25 RETURN BOOLEAN;
26 END GMD_QC_ERES_CHANGE_STATUS_PVT;