[Home] [Help]
PACKAGE: APPS.OKL_PDT_QUALITYS_PVT
Source
1 PACKAGE OKL_PDT_QUALITYS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLCPQYS.pls 115.3 2002/02/05 11:49:56 pkm ship $ */
3
4 SUBTYPE pqyv_rec_type IS okl_pqy_pvt.pqyv_rec_type;
5 SUBTYPE pqyv_tbl_type IS okl_pqy_pvt.pqyv_tbl_type;
6
7 SUBTYPE qvev_rec_type IS okl_qve_pvt.qvev_rec_type;
8 SUBTYPE qvev_tbl_type IS okl_qve_pvt.qvev_tbl_type;
9 ------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PDT_QUALITYS_PVT';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16 ------------------------------------------------------------------------------
17 --Global Exception
18 ------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ------------------------------------------------------------------------------
21
22 --Object type procedure for insert
23 PROCEDURE create_pdt_qualitys(
24 p_api_version IN NUMBER
25 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 ,p_pqyv_rec IN pqyv_rec_type
30 ,p_qvev_tbl IN qvev_tbl_type
31 ,x_pqyv_rec OUT NOCOPY pqyv_rec_type
32 ,x_qvev_tbl OUT NOCOPY qvev_tbl_type
33 );
34
35 --Object type procedure for update
36 PROCEDURE update_pdt_qualitys(
37 p_api_version IN NUMBER
38 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 ,p_pqyv_rec IN pqyv_rec_type
43 ,p_qvev_tbl IN qvev_tbl_type
44 ,x_pqyv_rec OUT NOCOPY pqyv_rec_type
45 ,x_qvev_tbl OUT NOCOPY qvev_tbl_type
46 );
47
48 --Object type procedure for validate
49 PROCEDURE validate_pdt_qualitys(
50 p_api_version IN NUMBER
51 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
52 ,x_return_status OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,p_pqyv_rec IN pqyv_rec_type
56 ,p_qvev_tbl IN qvev_tbl_type
57 );
58
59
60
61 PROCEDURE create_pdt_qualitys(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_pqyv_tbl IN pqyv_tbl_type,
68 x_pqyv_tbl OUT NOCOPY pqyv_tbl_type);
69
70 PROCEDURE create_pdt_qualitys(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_pqyv_rec IN pqyv_rec_type,
77 x_pqyv_rec OUT NOCOPY pqyv_rec_type);
78
79 PROCEDURE lock_pdt_qualitys(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_pqyv_tbl IN pqyv_tbl_type);
86
87 PROCEDURE lock_pdt_qualitys(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_pqyv_rec IN pqyv_rec_type);
94
95 PROCEDURE update_pdt_qualitys(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_pqyv_tbl IN pqyv_tbl_type,
102 x_pqyv_tbl OUT NOCOPY pqyv_tbl_type);
103
104 PROCEDURE update_pdt_qualitys(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_pqyv_rec IN pqyv_rec_type,
111 x_pqyv_rec OUT NOCOPY pqyv_rec_type);
112
113 PROCEDURE delete_pdt_qualitys(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_pqyv_tbl IN pqyv_tbl_type);
120
121 PROCEDURE delete_pdt_qualitys(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_pqyv_rec IN pqyv_rec_type);
128
129 PROCEDURE validate_pdt_qualitys(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_pqyv_tbl IN pqyv_tbl_type);
136
137 PROCEDURE validate_pdt_qualitys(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_pqyv_rec IN pqyv_rec_type);
144
145
146 PROCEDURE create_pdt_quality_vals(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_qvev_tbl IN qvev_tbl_type,
153 x_qvev_tbl OUT NOCOPY qvev_tbl_type);
154
155 PROCEDURE create_pdt_quality_vals(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_qvev_rec IN qvev_rec_type,
162 x_qvev_rec OUT NOCOPY qvev_rec_type);
163
164 PROCEDURE lock_pdt_quality_vals(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_qvev_tbl IN qvev_tbl_type);
171
172 PROCEDURE lock_pdt_quality_vals(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_qvev_rec IN qvev_rec_type);
179
180 PROCEDURE update_pdt_quality_vals(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_qvev_tbl IN qvev_tbl_type,
187 x_qvev_tbl OUT NOCOPY qvev_tbl_type);
188
189 PROCEDURE update_pdt_quality_vals(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_qvev_rec IN qvev_rec_type,
196 x_qvev_rec OUT NOCOPY qvev_rec_type);
197
198 PROCEDURE delete_pdt_quality_vals(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_qvev_tbl IN qvev_tbl_type);
205
206 PROCEDURE delete_pdt_quality_vals(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_qvev_rec IN qvev_rec_type);
213
214 PROCEDURE validate_pdt_quality_vals(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_qvev_tbl IN qvev_tbl_type);
221
222 PROCEDURE validate_pdt_quality_vals(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_qvev_rec IN qvev_rec_type);
229
230 END OKL_PDT_QUALITYS_PVT;