[Home] [Help]
PACKAGE: APPS.OKE_CONTRACT_PVT
Source
1 PACKAGE OKE_CONTRACT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVCCCS.pls 120.1 2005/10/03 12:46:29 ausmani noship $ */
3
4 subtype chr_rec_type is oke_chr_pvt.chr_rec_type;
5 subtype chr_tbl_type is oke_chr_pvt.chr_tbl_type;
6 subtype cle_rec_type is oke_cle_pvt.cle_rec_type;
7 subtype cle_tbl_type is oke_cle_pvt.cle_tbl_type;
8
9
10
11 -- GLOBAL VARIABLES
12
13 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CONTRACT_PVT';
14
15 PROCEDURE create_contract_header(
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_chr_rec IN OKE_CHR_PVT.chr_rec_type,
22 x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type);
23
24 PROCEDURE create_contract_header(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type,
31 x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type);
32
33 PROCEDURE update_contract_header(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_chr_rec IN OKE_CHR_PVT.chr_rec_type,
40 x_chr_rec OUT NOCOPY OKE_CHR_PVT.chr_rec_type);
41
42 PROCEDURE update_contract_header(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type,
49 x_chr_tbl OUT NOCOPY OKE_CHR_PVT.chr_tbl_type);
50
51
52 PROCEDURE delete_contract_header(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_chr_rec IN OKE_CHR_PVT.chr_rec_type);
59
60 PROCEDURE delete_contract_header(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type);
67
68
69 PROCEDURE validate_contract_header(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_chr_rec IN OKE_CHR_PVT.chr_rec_type);
76
77 PROCEDURE validate_contract_header(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type);
84
85
86
87 PROCEDURE create_contract_line(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_cle_rec IN OKE_CLE_PVT.cle_rec_type,
94 x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type);
95
96
97 PROCEDURE create_contract_line(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
104 x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type);
105
106 PROCEDURE update_contract_line(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_cle_rec IN OKE_CLE_PVT.cle_rec_type,
113 x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type);
114
115 PROCEDURE update_contract_line(
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_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
122 x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type);
123
124 PROCEDURE delete_contract_line(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type);
131
132 PROCEDURE delete_contract_line(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_cle_rec IN OKE_CLE_PVT.cle_rec_type);
139
140
141 PROCEDURE delete_contract_line(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_line_id IN NUMBER);
148
149
150 PROCEDURE validate_contract_line(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_cle_rec IN OKE_CLE_PVT.cle_rec_type);
157
158 PROCEDURE validate_contract_line(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type);
165
166 PROCEDURE create_deliverable(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
173 x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type);
174
175
176 PROCEDURE create_deliverable(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
183 x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type);
184
185 PROCEDURE update_deliverable(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
192 x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type);
193
194 PROCEDURE update_deliverable(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
201 x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type);
202
203 PROCEDURE delete_deliverable(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
210
211 PROCEDURE delete_deliverable(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
218
219 PROCEDURE delete_deliverable(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_deliverable_id IN NUMBER);
226
227 PROCEDURE validate_deliverable(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
234
235 PROCEDURE validate_deliverable(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
242
243 PROCEDURE lock_deliverable(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
250
251 PROCEDURE lock_deliverable(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
258
259 FUNCTION Increment_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2;
260
261
262 PROCEDURE delete_minor_entities (
263 p_header_id IN NUMBER,
264 x_return_status OUT NOCOPY VARCHAR2);
265
266 PROCEDURE delete_version_records (
267 p_api_version IN VARCHAR2,
268 p_header_id IN NUMBER,
269 x_return_status OUT NOCOPY varchar2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2);
272
273
274 END OKE_CONTRACT_PVT;
275