[Home] [Help]
PACKAGE: APPS.OKL_INCSH_PVT
Source
1 PACKAGE Okl_Incsh_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLCRCTS.pls 115.3 2002/02/05 11:50:02 pkm ship $ */
3
4 SUBTYPE rctv_rec_type IS Okl_Rct_Pvt.rctv_rec_type;
5 SUBTYPE rctv_tbl_type IS Okl_Rct_Pvt.rctv_tbl_type;
6
7 SUBTYPE rcav_rec_type IS Okl_Rca_Pvt.rcav_rec_type;
8 SUBTYPE rcav_tbl_type IS Okl_Rca_Pvt.rcav_tbl_type;
9 ------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INCSH_PVT';
12 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
16 ------------------------------------------------------------------------------
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'Okl_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17 --Global Exception
18 ------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ------------------------------------------------------------------------------
21
22 PROCEDURE ADD_LANGUAGE;
23
24 --Object type procedure for insert
25 PROCEDURE create_internal_trans(
26 p_api_version IN NUMBER
27 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_msg_count OUT NOCOPY NUMBER
30 ,x_msg_data OUT NOCOPY VARCHAR2
31 ,p_rctv_rec IN rctv_rec_type
32 ,p_rcav_tbl IN rcav_tbl_type
33 ,x_rctv_rec OUT NOCOPY rctv_rec_type
34 ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
35 );
36
37 --Object type procedure for update
38 PROCEDURE update_internal_trans(
39 p_api_version IN NUMBER
40 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_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 ,p_rctv_rec IN rctv_rec_type
45 ,p_rcav_tbl IN rcav_tbl_type
46 ,x_rctv_rec OUT NOCOPY rctv_rec_type
47 ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
48 );
49
50 PROCEDURE delete_internal_trans(
51 p_api_version IN NUMBER
52 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rctv_rec IN rctv_rec_type
57 ,p_rcav_tbl IN rcav_tbl_type
58 ,x_rctv_rec OUT NOCOPY rctv_rec_type
59 ,x_rcav_tbl OUT NOCOPY rcav_tbl_type
60 );
61
62 --Object type procedure for validate
63 PROCEDURE validate_internal_trans(
64 p_api_version IN NUMBER
65 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rctv_rec IN rctv_rec_type
70 ,p_rcav_tbl IN rcav_tbl_type
71 );
72
73
74 PROCEDURE create_internal_trans(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_rctv_tbl IN rctv_tbl_type,
81 x_rctv_tbl OUT NOCOPY rctv_tbl_type);
82
83 PROCEDURE create_internal_trans(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_rctv_rec IN rctv_rec_type,
90 x_rctv_rec OUT NOCOPY rctv_rec_type);
91
92 PROCEDURE lock_internal_trans(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_rctv_tbl IN rctv_tbl_type);
99
100 PROCEDURE lock_internal_trans(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_rctv_rec IN rctv_rec_type);
107
108 PROCEDURE update_internal_trans(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_rctv_tbl IN rctv_tbl_type,
115 x_rctv_tbl OUT NOCOPY rctv_tbl_type);
116
117 PROCEDURE update_internal_trans(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_rctv_rec IN rctv_rec_type,
124 x_rctv_rec OUT NOCOPY rctv_rec_type);
125
126 PROCEDURE delete_internal_trans(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_rctv_tbl IN rctv_tbl_type);
133
134 PROCEDURE delete_internal_trans(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_rctv_rec IN rctv_rec_type);
141
142 PROCEDURE validate_internal_trans(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_rctv_tbl IN rctv_tbl_type);
149
150 PROCEDURE validate_internal_trans(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rctv_rec IN rctv_rec_type);
157
158
159 PROCEDURE create_internal_trans(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_rcav_tbl IN rcav_tbl_type,
166 x_rcav_tbl OUT NOCOPY rcav_tbl_type);
167
168 PROCEDURE create_internal_trans(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_rcav_rec IN rcav_rec_type,
175 x_rcav_rec OUT NOCOPY rcav_rec_type);
176
177 PROCEDURE lock_internal_trans(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_rcav_tbl IN rcav_tbl_type);
184
185 PROCEDURE lock_internal_trans(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rcav_rec IN rcav_rec_type);
192
193 PROCEDURE update_internal_trans(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_rcav_tbl IN rcav_tbl_type,
200 x_rcav_tbl OUT NOCOPY rcav_tbl_type);
201
202 PROCEDURE update_internal_trans(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_rcav_rec IN rcav_rec_type,
209 x_rcav_rec OUT NOCOPY rcav_rec_type);
210
211 PROCEDURE delete_internal_trans(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rcav_tbl IN rcav_tbl_type);
218
219 PROCEDURE delete_internal_trans(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rcav_rec IN rcav_rec_type);
226
227 PROCEDURE validate_internal_trans(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rcav_tbl IN rcav_tbl_type);
234
235 PROCEDURE validate_internal_trans(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_rcav_rec IN rcav_rec_type);
242
243 END Okl_Incsh_Pvt;