DBA Data[Home] [Help]

PACKAGE: APPS.GMD_DISP_GRP

Source


1 PACKAGE GMD_DISP_GRP AUTHID CURRENT_USER AS
2 /* $Header: GMDGDISS.pls 120.0.12010000.1 2009/03/31 18:23:08 rnalla noship $ */
3 
4 -- Start of comments
5 --+==========================================================================+
6 --|                   Copyright (c) 1998 Oracle Corporation                  |
7 --|                          Redwood Shores, CA, USA                         |
8 --|                            All rights reserved.                          |
9 --+==========================================================================+
10 --| File Name          : GMDGDISS.pls                                        |
11 --| Package Name       : GMD_DISP_GRP                                        |
12 --| Type               : Group                                               |
13 --|                                                                          |
14 --| Notes                                                                    |
15 --|    This package contains Group layer APIs for Changing the disposition   |
16 --|    of a Sample/Group                                                     |
17 --|                                                                          |
18 --| HISTORY                                                                  |
19 --|     Ravi Lingappa Nagaraja    16-Jun-2008     Created.                   |
20 --+==========================================================================+
21 -- End of comments
22 
23 PROCEDURE update_sample_comp_disp
24 (
25   p_update_disp_rec	        IN Gmd_Samples_Grp.update_disp_rec
26 , p_to_disposition		IN         VARCHAR2
27 , x_return_status 		OUT NOCOPY VARCHAR2
28 , x_message_data		OUT NOCOPY VARCHAR2
29 );
30 
31 PROCEDURE update_lot_grade_batch
32 (
33   p_sample_id			IN         NUMBER DEFAULT NULL
34 , p_composite_spec_disp_id  	IN         NUMBER DEFAULT NULL
35 , p_to_lot_status_id	  	IN         NUMBER
36 , p_from_lot_status_id	  	IN         NUMBER
37 , p_to_grade_code		IN         VARCHAR2
38 , p_from_grade_code		IN         VARCHAR2 DEFAULT NULL
39 , p_to_qc_status		IN         NUMBER
40 , p_reason_id			IN         NUMBER
41 , p_hold_date                   IN         DATE DEFAULT SYSDATE
42 , x_return_status 		OUT NOCOPY VARCHAR2
43 , x_message_data		OUT NOCOPY VARCHAR2
44 );
45 
46 END gmd_disp_grp;
47