[Home] [Help]
PACKAGE: APPS.OKL_TRANS_CONTRACTS_PVT
Source
1 PACKAGE OKL_TRANS_CONTRACTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRTCTS.pls 115.3 2002/03/21 17:02:41 pkm ship $ */
3
4
5 SUBTYPE tcnv_rec_type IS okl_trx_contracts_pub.tcnv_rec_type;
6
7 SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pub.tcnv_tbl_type;
8
9
10
11 SUBTYPE tclv_rec_type IS okl_trx_contracts_pub.tclv_rec_type;
12
13 SUBTYPE tclv_tbl_type IS okl_trx_contracts_pub.tclv_tbl_type;
14
15
16 PROCEDURE create_trx_contracts(
17
18 p_api_version IN NUMBER
19
20 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
21
22 ,x_return_status OUT NOCOPY VARCHAR2
23
24 ,x_msg_count OUT NOCOPY NUMBER
25
26 ,x_msg_data OUT NOCOPY VARCHAR2
27
28 ,p_tcnv_rec IN tcnv_rec_type
29
30 ,p_tclv_tbl IN tclv_tbl_type
31
32 ,x_tcnv_rec OUT NOCOPY tcnv_rec_type
33
34 ,x_tclv_tbl OUT NOCOPY tclv_tbl_type
35
36 );
37
38
39 PROCEDURE create_trx_contracts(
40
41 p_api_version IN NUMBER,
42
43 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44
45 x_return_status OUT NOCOPY VARCHAR2,
46
47 x_msg_count OUT NOCOPY NUMBER,
48
49 x_msg_data OUT NOCOPY VARCHAR2,
50
51 p_tcnv_rec IN tcnv_rec_type,
52
53 x_tcnv_rec OUT NOCOPY tcnv_rec_type);
54
55
56
57 PROCEDURE create_trx_contracts(
58
59 p_api_version IN NUMBER,
60
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62
63 x_return_status OUT NOCOPY VARCHAR2,
64
65 x_msg_count OUT NOCOPY NUMBER,
66
67 x_msg_data OUT NOCOPY VARCHAR2,
68
69 p_tcnv_tbl IN tcnv_tbl_type,
70
71 x_tcnv_tbl OUT NOCOPY tcnv_tbl_type);
72
73
74
75 PROCEDURE create_trx_cntrct_lines(
76
77 p_api_version IN NUMBER,
78
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80
81 x_return_status OUT NOCOPY VARCHAR2,
82
83 x_msg_count OUT NOCOPY NUMBER,
84
85 x_msg_data OUT NOCOPY VARCHAR2,
86
87 p_tclv_rec IN tclv_rec_type,
88
89 x_tclv_rec OUT NOCOPY tclv_rec_type);
90
91
92
93 PROCEDURE create_trx_cntrct_lines(
94
95 p_api_version IN NUMBER,
96
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98
99 x_return_status OUT NOCOPY VARCHAR2,
100
101 x_msg_count OUT NOCOPY NUMBER,
102
103 x_msg_data OUT NOCOPY VARCHAR2,
104
105 p_tclv_tbl IN tclv_tbl_type,
106
107 x_tclv_tbl OUT NOCOPY tclv_tbl_type);
108
109
110
111 PROCEDURE update_trx_contracts(
112
113 p_api_version IN NUMBER
114
115 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
116
117 ,x_return_status OUT NOCOPY VARCHAR2
118
119 ,x_msg_count OUT NOCOPY NUMBER
120
121 ,x_msg_data OUT NOCOPY VARCHAR2
122
123 ,p_tcnv_rec IN tcnv_rec_type
124
125 ,p_tclv_tbl IN tclv_tbl_type
126
127 ,x_tcnv_rec OUT NOCOPY tcnv_rec_type
128
129 ,x_tclv_tbl OUT NOCOPY tclv_tbl_type);
130
131
132 PROCEDURE update_trx_contracts(
133
134 p_api_version IN NUMBER,
135
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137
138 x_return_status OUT NOCOPY VARCHAR2,
139
140 x_msg_count OUT NOCOPY NUMBER,
141
142 x_msg_data OUT NOCOPY VARCHAR2,
143
144 p_tcnv_rec IN tcnv_rec_type,
145
146 x_tcnv_rec OUT NOCOPY tcnv_rec_type);
147
148
149
150 PROCEDURE update_trx_contracts(
151
152 p_api_version IN NUMBER,
153
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155
156 x_return_status OUT NOCOPY VARCHAR2,
157
158 x_msg_count OUT NOCOPY NUMBER,
159
160 x_msg_data OUT NOCOPY VARCHAR2,
161
162 p_tcnv_tbl IN tcnv_tbl_type,
163
164 x_tcnv_tbl OUT NOCOPY tcnv_tbl_type);
165
166
167 PROCEDURE update_trx_cntrct_lines(
168
169 p_api_version IN NUMBER,
170
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172
173 x_return_status OUT NOCOPY VARCHAR2,
174
175 x_msg_count OUT NOCOPY NUMBER,
176
177 x_msg_data OUT NOCOPY VARCHAR2,
178
179 p_tclv_rec IN tclv_rec_type,
180
181 x_tclv_rec OUT NOCOPY tclv_rec_type);
182
183
184
185 PROCEDURE update_trx_cntrct_lines(
186
187 p_api_version IN NUMBER,
188
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190
191 x_return_status OUT NOCOPY VARCHAR2,
192
193 x_msg_count OUT NOCOPY NUMBER,
194
195 x_msg_data OUT NOCOPY VARCHAR2,
196
197 p_tclv_tbl IN tclv_tbl_type,
198
199 x_tclv_tbl OUT NOCOPY tclv_tbl_type);
200
201
202 PROCEDURE delete_trx_contracts(
203
204 p_api_version IN NUMBER,
205
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207
208 x_return_status OUT NOCOPY VARCHAR2,
209
210 x_msg_count OUT NOCOPY NUMBER,
211
212 x_msg_data OUT NOCOPY VARCHAR2,
213
214 p_tcnv_rec IN tcnv_rec_type);
215
216
217
218 PROCEDURE delete_trx_contracts(
219
220 p_api_version IN NUMBER,
221
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223
224 x_return_status OUT NOCOPY VARCHAR2,
225
226 x_msg_count OUT NOCOPY NUMBER,
227
228 x_msg_data OUT NOCOPY VARCHAR2,
229
230 p_tcnv_tbl IN tcnv_tbl_type);
231
232
233 PROCEDURE delete_trx_cntrct_lines(
234
235 p_api_version IN NUMBER,
236
237 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
238
239 x_return_status OUT NOCOPY VARCHAR2,
240
241 x_msg_count OUT NOCOPY NUMBER,
242
243 x_msg_data OUT NOCOPY VARCHAR2,
244
245 p_tclv_rec IN tclv_rec_type);
246
247
248 PROCEDURE delete_trx_cntrct_lines(
249
250 p_api_version IN NUMBER,
251
252 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253
254 x_return_status OUT NOCOPY VARCHAR2,
255
256 x_msg_count OUT NOCOPY NUMBER,
257
258 x_msg_data OUT NOCOPY VARCHAR2,
259
260 p_tclv_tbl IN tclv_tbl_type);
261
262
263 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRANS_CONTRACTS_PVT' ;
264 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
265 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
266 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
267
268 END OKL_TRANS_CONTRACTS_PVT;