[Home] [Help]
PACKAGE: APPS.GMD_QUALITY_GRP
Source
1 PACKAGE GMD_QUALITY_GRP AS
2 /* $Header: GMDGQCMS.pls 120.1 2005/06/21 04:08:38 appldev ship $ */
3
4 -- Input Record Structure
5 TYPE inv_inp_rec_type IS RECORD
6 ( organization_id NUMBER
7 , inventory_item_id NUMBER
8 , grade_code VARCHAR2(150)
9 , parent_lot_number VARCHAR2(80)
10 , lot_number VARCHAR2(80)
11 , subinventory VARCHAR2(10)
12 , locator_id NUMBER
13 , test_id NUMBER
14 , Plant_id NUMBER Default NULL);
15
16 -- Output Record Structure
17 TYPE inv_val_out_rec_type IS RECORD
18 ( Entity_Id NUMBER -- Could be result_id or spec_id
19 , Spec_id NUMBER -- Specification id
20 , Entity_Value VARCHAR2(80) -- format based on report Precision
21 , Entity_min_value VARCHAR2(80)
22 , Entity_max_value VARCHAR2(80)
23 , Level NUMBER
24 , Composite_ind NUMBER);
25
26 -- Output Record Structure for fetch results tests
27 TYPE inv_rslt_out_rec_type IS RECORD
28 ( Result_Id NUMBER
29 , Spec_id NUMBER
30 , result_value VARCHAR2(80)
31 , Min_Value VARCHAR2(80)
32 , Max_Value VARCHAR2(80)
33 , Display_Precision NUMBER
34 , Level NUMBER
35 , Composite_ind NUMBER);
36
37 -- Output Record Structure for fetch spec tests
38 TYPE inv_spec_out_rec_type IS RECORD
39 ( Spec_Id NUMBER
40 , Target_Value VARCHAR2(80)
41 , Min_Value VARCHAR2(80)
42 , Max_Value VARCHAR2(80)
43 , Display_Precision NUMBER
44 , test_id NUMBER
45 , Level NUMBER(5));
46
47 -- Output Record Structure for sampling events
48 TYPE sampling_events_rec_type IS RECORD
49 ( sampling_event_id NUMBER
50 , sample_id NUMBER
51 , event_spec_disp_id NUMBER
52 , sample_active_cnt NUMBER
53 , spec_id NUMBER
54 , organization_id NUMBER
55 , inventory_item_id NUMBER
56 , parent_lot_number VARCHAR2(80)
57 , lot_number VARCHAR2(80)
58 , subinventory VARCHAR2(10)
59 , locator_id NUMBER
60 );
61
62 -- Table Structure for sampling events
63 TYPE sampling_events_tbl_type IS TABLE OF sampling_events_rec_type INDEX BY BINARY_INTEGER;
64
65
66 -- Start of comments
67 -- API name : get_inv_test_value
68 -- Type : Private
69 -- Function :
70 -- Pre-reqs : None.
71 -- Parameters :
72 -- IN : P_inv_test_inp_rec IN inv_inp_rec_type (Required)
73 --
74 -- OUT : x_return_status OUT VARCHAR2(1)
75 -- : x_inv_test_out_rec OUT inv_inp_rec_type
76 -- HISTORY
77 -- 20-Feb-2003 Shyam Sitaraman Initial Implementation
78 --
79 -- End of comments
80 PROCEDURE get_inv_test_value
81 ( P_inv_test_inp_rec IN inv_inp_rec_type
82 , x_inv_test_out_rec OUT NOCOPY inv_val_out_rec_type
83 , x_return_status OUT NOCOPY VARCHAR2
84 );
85
86
87 -- Start of comments
88 -- API name : get_inv_result_test_value
89 -- Type : Private
90 -- Function :
91 -- Pre-reqs : None.
92 -- Parameters :
93 -- IN : P_inv_rslt_inp_rec IN inv_inp_rec_type (Required)
94 --
95 -- OUT : x_return_status OUT VARCHAR2(1)
96 -- : x_inv_rslt_out_rec OUT inv_val_out_rec_type
97 -- HISTORY
98 -- 20-Feb-2003 Shyam Sitaraman Initial Implementation
99 --
100 -- End of comments
101 PROCEDURE get_inv_result_test_value
102 ( P_inv_rslt_inp_rec IN inv_inp_rec_type
103 , x_inv_rslt_out_rec OUT NOCOPY inv_rslt_out_rec_type
104 , x_return_status OUT NOCOPY VARCHAR2
105 );
106
107
108 -- Start of comments
109 -- API name : get_appr_sampling_events
110 -- Type : Private
111 -- Function :
112 -- Pre-reqs : None.
113 -- Parameters :
114 -- IN : P_inv_rslt_inp_rec IN inv_inp_rec_type (Required)
115 --
116 -- OUT : x_return_status OUT VARCHAR2(1)
117 -- : x_sampling_events_tbl OUT sampling_events_tbl_type
118 --
119 -- Version : Initial version 1.0
120 --
121 --
122 -- Notes : Retrieves 1 or more approved sampling events and specication
123 -- for an item, based on the organization, lot, warehouse and
124 -- location information.
125 --
126 -- HISTORY
127 -- 20-Feb-2003 Shyam Sitaraman Initial Implementation
128 --
129 -- End of comments
130 PROCEDURE get_appr_sampling_events
131 ( p_inv_rslt_inp_rec IN inv_inp_rec_type
132 , x_sampling_events_tbl OUT NOCOPY sampling_events_tbl_type
133 , x_return_status OUT NOCOPY VARCHAR2
134 );
135
136
137
138 -- Start of comments
139 -- API name : get_inv_spec_test_value
140 -- Type : Private
141 -- Function :
142 -- Pre-reqs : None.
143 -- Parameters :
144 -- IN : p_inv_spec_inp_rec IN inv_inp_rec_type (Required)
145 --
146 -- OUT : x_return_status OUT VARCHAR2(1)
147 -- : x_inv_spec_out_rec OUT inv_spec_out_rec_type
148 -- HISTORY
149 -- 20-Feb-2003 Shyam Sitaraman Initial Implementation
150 --
151 -- End of comments
152 PROCEDURE get_inv_spec_test_value
153 ( p_inv_spec_inp_rec IN inv_inp_rec_type
154 , x_inv_spec_out_rec OUT NOCOPY inv_spec_out_rec_type
155 , x_return_status OUT NOCOPY VARCHAR2
156 );
157
158
159
160 -- Start of comments
161 -- API name : get_level
162 -- Type : Private
163 -- Function :
164 -- Pre-reqs : None.
165 -- Parameters :
166 -- IN : p_inv_spec_inp_rec IN inv_inp_rec_type (Required)
167 -- : p_called_from IN VARCHAR2 Default 'RESULT'
168 --
169 -- OUT : x_return_status OUT VARCHAR2(1)
170 -- : x_level OUT NUMBER
171 --
172 -- Version : Initial version 1.0
173 --
174 --
175 -- Notes : Retrieves spec tests or result test levels
176 --
177 -- HISTORY
178 -- 20-Feb-2003 Shyam Sitaraman Initial Implementation
179 --
180 -- End of comments
181 PROCEDURE get_level
182 ( p_inv_inp_rec IN inv_inp_rec_type
183 , p_called_from IN VARCHAR2
184 , x_level OUT NOCOPY NUMBER
185 , x_return_status OUT NOCOPY VARCHAR2
186 );
187
188
189 END;