[Home] [Help]
PACKAGE: APPS.OKL_EXTRN_PVT
Source
1 PACKAGE okl_extrn_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLCXCRS.pls 115.1 2002/03/18 08:28:49 pkm ship $ */
3
4 SUBTYPE xcrv_rec_type IS Okl_Xcr_Pvt.xcrv_rec_type;
5 SUBTYPE xcrv_tbl_type IS Okl_Xcr_Pvt.xcrv_tbl_type;
6
7 SUBTYPE xcav_rec_type IS Okl_Xca_Pvt.xcav_rec_type;
8 SUBTYPE xcav_tbl_type IS Okl_Xca_Pvt.xcav_tbl_type;
9
10 ------------------------------------------------------------------------------
11 -- Global Variables
12 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_Extrn_PVT';
13 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'Okl_CONTRACTS_UNEXPECTED_ERROR';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
16 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17 ------------------------------------------------------------------------------
18 --Global Exception
19 ------------------------------------------------------------------------------
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21 ------------------------------------------------------------------------------
22
23
24 PROCEDURE ADD_LANGUAGE;
25
26 --Object type procedure for insert
27 PROCEDURE create_ext_csh_txns(
28 p_api_version IN NUMBER
29 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2
33 ,p_xcrv_rec IN xcrv_rec_type
34 ,p_xcav_tbl IN xcav_tbl_type
35 ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
36 ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
37 );
38
39 --Object type procedure for update
40 PROCEDURE update_ext_csh_txns(
41 p_api_version IN NUMBER
42 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 ,p_xcrv_rec IN xcrv_rec_type
47 ,p_xcav_tbl IN xcav_tbl_type
48 ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
49 ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
50 );
51
52 --Object type procedure for update
53 PROCEDURE delete_ext_csh_txns(
54 p_api_version IN NUMBER
55 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 ,p_xcrv_rec IN xcrv_rec_type
60 ,p_xcav_tbl IN xcav_tbl_type
61 ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
62 ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
63 );
64
65 --Object type procedure for validate
66 PROCEDURE validate_ext_csh_txns(
67 p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,p_xcrv_rec IN xcrv_rec_type
73 ,p_xcav_tbl IN xcav_tbl_type
74 );
75
76 PROCEDURE create_ext_csh_txns(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_tbl IN xcrv_tbl_type,
83 x_xcrv_tbl OUT NOCOPY xcrv_tbl_type);
84
85 PROCEDURE create_ext_csh_txns(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_rec IN xcrv_rec_type,
92 x_xcrv_rec OUT NOCOPY xcrv_rec_type);
93
94 PROCEDURE lock_ext_csh_txns(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_xcrv_tbl IN xcrv_tbl_type);
101
102 PROCEDURE lock_ext_csh_txns(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_xcrv_rec IN xcrv_rec_type);
109
110 PROCEDURE update_ext_csh_txns(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_xcrv_tbl IN xcrv_tbl_type,
117 x_xcrv_tbl OUT NOCOPY xcrv_tbl_type);
118
119 PROCEDURE update_ext_csh_txns(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_xcrv_rec IN xcrv_rec_type,
126 x_xcrv_rec OUT NOCOPY xcrv_rec_type);
127
128 PROCEDURE delete_ext_csh_txns(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_xcrv_tbl IN xcrv_tbl_type);
135
136 PROCEDURE delete_ext_csh_txns(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_xcrv_rec IN xcrv_rec_type);
143
144 PROCEDURE validate_ext_csh_txns(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_xcrv_tbl IN xcrv_tbl_type);
151
152 PROCEDURE validate_ext_csh_txns(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_rec IN xcrv_rec_type);
159
160
161 PROCEDURE create_ext_csh_txns(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_xcav_tbl IN xcav_tbl_type,
168 x_xcav_tbl OUT NOCOPY xcav_tbl_type);
169
170 PROCEDURE create_ext_csh_txns(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_xcav_rec IN xcav_rec_type,
177 x_xcav_rec OUT NOCOPY xcav_rec_type);
178
179 PROCEDURE lock_ext_csh_txns(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_xcav_tbl IN xcav_tbl_type);
186
187 PROCEDURE lock_ext_csh_txns(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_xcav_rec IN xcav_rec_type);
194
195 PROCEDURE update_ext_csh_txns(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_xcav_tbl IN xcav_tbl_type,
202 x_xcav_tbl OUT NOCOPY xcav_tbl_type);
203
204 PROCEDURE update_ext_csh_txns(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_xcav_rec IN xcav_rec_type,
211 x_xcav_rec OUT NOCOPY xcav_rec_type);
212
213 PROCEDURE delete_ext_csh_txns(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_xcav_tbl IN xcav_tbl_type);
220
221 PROCEDURE delete_ext_csh_txns(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_xcav_rec IN xcav_rec_type);
228
229 PROCEDURE validate_ext_csh_txns(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcav_tbl IN xcav_tbl_type);
236
237 PROCEDURE validate_ext_csh_txns(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_xcav_rec IN xcav_rec_type);
244
245 END Okl_Extrn_Pvt;