DBA Data[Home] [Help]

PACKAGE: APPS.GMD_QUALITY_PARAMETERS_GRP

Source


1 PACKAGE GMD_QUALITY_PARAMETERS_GRP AS
2 /* $Header: GMDGQLPS.pls 120.1.12000000.2 2007/02/07 08:47:14 srakrish ship $ */
3 -- Start of comments
4 --+==========================================================================+
5 --|                   Copyright (c) 2005 Oracle Corporation             					     |
6 --|                          Redwood Shores, CA, USA                    						     |
7 --|                            All rights reserved.                  							     |
8 --+==========================================================================+
9 --| File Name          : GMDGQPMS.pls                                       					     |
10 --| Package Name       : GMD_QUALITY_PARAMETERS_GRP                        				     |
11 --| Type               : Group                                               						     |
12 --|                                                                          							     |
13 --| Notes                                                                    						 	     |
14 --|  This package contains group layer APIs for retrieving quality parameters				     |
15 --|                                                                          							     |
16 --| HISTORY
17 --|    Saikiran Vankadari  14-Feb-2005	Created as part of Convergence.      	   		     |
18 --|                                                                          							     |
19 --|    Srakrish bug 5570258 20-Nov-2006  Created Procedure sort_by_orgn_code  |
20 --+==========================================================================+
21 -- End of comments
22 
23 PROCEDURE get_quality_parameters
24 (p_organization_id IN NUMBER,
25   x_quality_parameters OUT NOCOPY GMD_QUALITY_CONFIG%ROWTYPE,
26   x_return_status  OUT NOCOPY VARCHAR2,
27   x_orgn_found OUT NOCOPY BOOLEAN
28 ) ;
29 
30 FUNCTION get_next_sample_no
31 (p_organization_id IN NUMBER
32 ) return varchar2	 ;
33 
34 FUNCTION get_next_ss_no
35 (p_organization_id IN NUMBER
36 ) return varchar2	 ;
37 
38 FUNCTION sort_by_orgn_code
39 (p_organization_id IN Number
40 ) return varchar2 ;
41 
42 END GMD_QUALITY_PARAMETERS_GRP;