[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;