[Home] [Help]
PACKAGE: APPS.OKE_CONTRACT_PUB
Source
1 PACKAGE OKE_CONTRACT_PUB AUTHID CURRENT_USER AS
2 /*$Header: OKEPCCCS.pls 120.1 2005/06/02 11:59:44 appldev $ */
3
4 subtype chr_rec_type is oke_contract_pvt.chr_rec_type;
5 subtype chr_tbl_type is oke_contract_pvt.chr_tbl_type;
6 subtype cle_rec_type is oke_contract_pvt.cle_rec_type;
7 subtype cle_tbl_type is oke_contract_pvt.cle_tbl_type;
8 subtype del_rec_type is oke_deliverable_pvt.del_rec_type;
9 subtype del_tbl_type is oke_deliverable_pvt.del_tbl_type;
10 subtype chrv_rec_type is okc_contract_pub.chrv_rec_type;
11 subtype chrv_tbl_type is okc_contract_pub.chrv_tbl_type;
12 subtype clev_rec_type is okc_contract_pub.clev_rec_type;
13 subtype clev_tbl_type is okc_contract_pub.clev_tbl_type;
14
15 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CONTRACT_PUB';
16 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
17
18 PROCEDURE Assign_Doc_Number
19 ( X_K_Type_Code IN VARCHAR2
20 , X_Buy_Or_Sell IN VARCHAR2
21 , X_Template_Flag IN VARCHAR2
22 , X_K_Number IN OUT NOCOPY VARCHAR2
23 , X_Return_Status IN OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE create_contract_header(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_chr_rec IN oke_chr_pvt.chr_rec_type,
33 p_chrv_rec IN okc_contract_pub.chrv_rec_type,
34 x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
35 x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);
36
37 PROCEDURE create_contract_header(
38
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44
45 p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
46 p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
47 x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
48 x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
49
50 PROCEDURE update_contract_header(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
57 p_chr_rec IN oke_chr_pvt.chr_rec_type,
58 p_chrv_rec IN okc_contract_pub.chrv_rec_type,
59
60 x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
61 x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);
62
63 PROCEDURE update_contract_header(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
70 p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
71 p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
72
73 x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
74 x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
75
76 PROCEDURE delete_contract_header(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_chr_rec IN oke_chr_pvt.chr_rec_type,
83 p_chrv_rec IN okc_contract_pub.chrv_rec_type);
84
85 PROCEDURE delete_contract_header(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
92 p_chrv_tbl IN okc_contract_pub.chrv_tbl_type);
93
94
95
96 PROCEDURE validate_contract_header(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_chr_rec IN oke_chr_pvt.chr_rec_type,
103 p_chrv_rec IN okc_contract_pub.chrv_rec_type);
104
105 PROCEDURE validate_contract_header(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
112 p_chrv_tbl IN okc_contract_pub.chrv_tbl_type);
113
114 PROCEDURE create_contract_line(
115
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
122 p_cle_rec IN oke_cle_pvt.cle_rec_type,
123 p_clev_rec IN okc_contract_pub.clev_rec_type,
124 x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
125 x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
126
127 PROCEDURE create_contract_line(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
134 p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
135 p_clev_tbl IN okc_contract_pub.clev_tbl_type,
136 x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
137 x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
138
139 PROCEDURE update_contract_line(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
146 p_cle_rec IN oke_cle_pvt.cle_rec_type,
147 p_clev_rec IN okc_contract_pub.clev_rec_type,
148
149 x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
150 x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
151
152 PROCEDURE update_contract_line(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
159 p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
160 p_clev_tbl IN okc_contract_pub.clev_tbl_type,
161
162 x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
163 x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
164
165 PROCEDURE delete_contract_line(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_cle_rec IN oke_cle_pvt.cle_rec_type,
172 p_clev_rec IN okc_contract_pub.clev_rec_type);
173
174 PROCEDURE delete_contract_line(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
181 p_clev_tbl IN okc_contract_pub.clev_tbl_type);
182
183 PROCEDURE delete_contract_line(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_line_id IN NUMBER);
190
191
192 PROCEDURE validate_contract_line(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_cle_rec IN oke_cle_pvt.cle_rec_type,
199 p_clev_rec IN okc_contract_pub.clev_rec_type);
200
201 PROCEDURE validate_contract_line(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
208 p_clev_tbl IN okc_contract_pub.clev_tbl_type);
209
210 PROCEDURE create_deliverable(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
217 x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type);
218
219
220 PROCEDURE create_deliverable(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
227 x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type);
228
229 PROCEDURE update_deliverable(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
236 x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type);
237
238 PROCEDURE update_deliverable(
239 p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
245 x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type);
246
247 PROCEDURE delete_deliverable(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
254
255 PROCEDURE delete_deliverable(
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
262
263
264 PROCEDURE delete_deliverable(
265 p_api_version IN NUMBER,
266 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 p_deliverable_id IN NUMBER);
271
272
273 PROCEDURE validate_deliverable(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
280
281 PROCEDURE validate_deliverable(
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
284 x_return_status OUT NOCOPY VARCHAR2,
285 x_msg_count OUT NOCOPY NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
288
289 PROCEDURE lock_deliverable(
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
296
297 PROCEDURE lock_deliverable(
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
304
305 PROCEDURE default_deliverable (
306 p_api_version IN NUMBER,
307 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2,
311 p_header_id IN NUMBER,
312 p_first_default_flag IN VARCHAR2,
313 x_del_tbl OUT NOCOPY /* file.sql.39 change */ oke_deliverable_pvt.del_tbl_type);
314
315
316
317
318 PROCEDURE Check_Delete_Contract(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2,
324 p_chr_id IN NUMBER,
325 x_return_code OUT NOCOPY VARCHAR2);
326
327
328 PROCEDURE delete_contract (
329 p_api_version IN NUMBER,
330 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
331 x_return_status OUT NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333 x_msg_data OUT NOCOPY VARCHAR2,
334 p_chr_id IN NUMBER,
335 p_pre_deletion_check_yn IN VARCHAR2 DEFAULT 'Y');
336
337
338
339 END OKE_CONTRACT_PUB;
340