[Home] [Help]
PACKAGE: APPS.GMD_DISP_PUB
Source
1 PACKAGE GMD_DISP_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPDISS.pls 120.1.12010000.2 2009/06/08 17:18:49 plowe 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 : GMDPDISB.pls |
11 --| Package Name : GMD_DISP_PUB |
12 --| Type : Public |
13 --| |
14 --| Notes |
15 --| This package contains public layer APIs for Changing the disposition |
16 --| of a Sample/Group |
17 --| |
18 --| HISTORY |
19 --| Ravi Lingappa Nagaraja 16-Jun-2008 Created |
20 --| P Lowe 19-May-2009 bug 8528505 |
21 --| Changed TYPE change_disp_rec IS RECORD is spec to correct size |
22 --| The correct size of fields in tables are:
23 --| to_lot_status VARCHAR2(10) -- VARCHAR2(80)
24 --| to_grade_code VARCHAR2(10) -- VARCHAR2(150)
25 --| reason_code VARCHAR2(10) -- REASON_NAME VARCHAR2(30)
26 --| parent_lot_number VARCHAR2(32) -- VARCHAR2(80)
27 --| lot_number VARCHAR2(32) -- VARCHAR2(80)
28 --+==========================================================================+
29 -- End of comments
30
31
32 TYPE change_disp_rec IS RECORD
33 (
34 sample_id NUMBER
35 ,sampling_event_id NUMBER
36 ,to_lot_status VARCHAR2(80)
37 ,to_grade_code VARCHAR2(150)
38 ,to_disposition VARCHAR2(10)
39 ,reason_code VARCHAR2(30)
40 ,parent_lot_number VARCHAR2(80)
41 ,lot_number VARCHAR2(80)
42 ,lpn VARCHAR2(32)
43 ,lpn_id NUMBER
44 );
45
46
47 PROCEDURE change_disposition (
48 p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
50 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
51 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
52 ,p_change_disp_rec IN CHANGE_DISP_REC
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_count OUT NOCOPY NUMBER
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58
59 END gmd_disp_pub;
60