[Home] [Help]
PACKAGE: APPS.OKL_PAY_CURE_REFUNDS_PVT_W
Source
1 package okl_pay_cure_refunds_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLEPCRS.pls 115.5 2003/04/25 03:50:27 nmakhani noship $ */
3 procedure rosetta_table_copy_in_p8(t out nocopy okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_2000
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 );
24 procedure rosetta_table_copy_out_p8(t okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
25 , a1 out nocopy JTF_NUMBER_TABLE
26 , a2 out nocopy JTF_NUMBER_TABLE
27 , a3 out nocopy JTF_DATE_TABLE
28 , a4 out nocopy JTF_NUMBER_TABLE
29 , a5 out nocopy JTF_VARCHAR2_TABLE_100
30 , a6 out nocopy JTF_VARCHAR2_TABLE_100
31 , a7 out nocopy JTF_NUMBER_TABLE
32 , a8 out nocopy JTF_NUMBER_TABLE
33 , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34 , a10 out nocopy JTF_NUMBER_TABLE
35 , a11 out nocopy JTF_NUMBER_TABLE
36 , a12 out nocopy JTF_NUMBER_TABLE
37 , a13 out nocopy JTF_NUMBER_TABLE
38 , a14 out nocopy JTF_NUMBER_TABLE
39 , a15 out nocopy JTF_NUMBER_TABLE
40 , a16 out nocopy JTF_VARCHAR2_TABLE_100
41 , a17 out nocopy JTF_NUMBER_TABLE
42 , a18 out nocopy JTF_NUMBER_TABLE
43 , a19 out nocopy JTF_NUMBER_TABLE
44 );
45
46 procedure create_refund_hdr(p_api_version NUMBER
47 , p_init_msg_list VARCHAR2
48 , p_commit VARCHAR2
49 , x_cure_refund_header_id out nocopy NUMBER
50 , x_return_status out nocopy VARCHAR2
51 , x_msg_count out nocopy NUMBER
52 , x_msg_data out nocopy VARCHAR2
53 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
54 , p3_a1 NUMBER := 0-1962.0724
55 , p3_a2 NUMBER := 0-1962.0724
56 , p3_a3 DATE := fnd_api.g_miss_date
57 , p3_a4 NUMBER := 0-1962.0724
58 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
59 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
60 , p3_a7 NUMBER := 0-1962.0724
61 , p3_a8 NUMBER := 0-1962.0724
62 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
63 , p3_a10 NUMBER := 0-1962.0724
64 , p3_a11 NUMBER := 0-1962.0724
65 , p3_a12 NUMBER := 0-1962.0724
66 , p3_a13 NUMBER := 0-1962.0724
67 , p3_a14 NUMBER := 0-1962.0724
68 , p3_a15 NUMBER := 0-1962.0724
69 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
70 , p3_a17 NUMBER := 0-1962.0724
71 , p3_a18 NUMBER := 0-1962.0724
72 , p3_a19 NUMBER := 0-1962.0724
73 );
74 procedure update_refund_hdr(p_api_version NUMBER
75 , p_init_msg_list VARCHAR2
76 , p_commit VARCHAR2
77 , x_return_status out nocopy VARCHAR2
78 , x_msg_count out nocopy NUMBER
79 , x_msg_data out nocopy VARCHAR2
80 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
81 , p3_a1 NUMBER := 0-1962.0724
82 , p3_a2 NUMBER := 0-1962.0724
83 , p3_a3 DATE := fnd_api.g_miss_date
84 , p3_a4 NUMBER := 0-1962.0724
85 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
86 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
87 , p3_a7 NUMBER := 0-1962.0724
88 , p3_a8 NUMBER := 0-1962.0724
89 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
90 , p3_a10 NUMBER := 0-1962.0724
91 , p3_a11 NUMBER := 0-1962.0724
92 , p3_a12 NUMBER := 0-1962.0724
93 , p3_a13 NUMBER := 0-1962.0724
94 , p3_a14 NUMBER := 0-1962.0724
95 , p3_a15 NUMBER := 0-1962.0724
96 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
97 , p3_a17 NUMBER := 0-1962.0724
98 , p3_a18 NUMBER := 0-1962.0724
99 , p3_a19 NUMBER := 0-1962.0724
100 );
101 procedure create_refund_headers(p_api_version NUMBER
102 , p_init_msg_list VARCHAR2
103 , p_commit VARCHAR2
104 , x_cure_refund_header_id out nocopy NUMBER
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
109 , p3_a1 NUMBER := 0-1962.0724
110 , p3_a2 NUMBER := 0-1962.0724
111 , p3_a3 DATE := fnd_api.g_miss_date
112 , p3_a4 NUMBER := 0-1962.0724
113 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
114 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
115 , p3_a7 NUMBER := 0-1962.0724
116 , p3_a8 NUMBER := 0-1962.0724
117 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
118 , p3_a10 NUMBER := 0-1962.0724
119 , p3_a11 NUMBER := 0-1962.0724
120 , p3_a12 NUMBER := 0-1962.0724
121 , p3_a13 NUMBER := 0-1962.0724
122 , p3_a14 NUMBER := 0-1962.0724
123 , p3_a15 NUMBER := 0-1962.0724
124 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
125 , p3_a17 NUMBER := 0-1962.0724
126 , p3_a18 NUMBER := 0-1962.0724
127 , p3_a19 NUMBER := 0-1962.0724
128 );
129 procedure update_refund_headers(p_api_version NUMBER
130 , p_init_msg_list VARCHAR2
131 , p_commit VARCHAR2
132 , x_return_status out nocopy VARCHAR2
133 , x_msg_count out nocopy NUMBER
134 , x_msg_data out nocopy VARCHAR2
135 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
136 , p3_a1 NUMBER := 0-1962.0724
137 , p3_a2 NUMBER := 0-1962.0724
138 , p3_a3 DATE := fnd_api.g_miss_date
139 , p3_a4 NUMBER := 0-1962.0724
140 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
141 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
142 , p3_a7 NUMBER := 0-1962.0724
143 , p3_a8 NUMBER := 0-1962.0724
144 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
145 , p3_a10 NUMBER := 0-1962.0724
146 , p3_a11 NUMBER := 0-1962.0724
147 , p3_a12 NUMBER := 0-1962.0724
148 , p3_a13 NUMBER := 0-1962.0724
149 , p3_a14 NUMBER := 0-1962.0724
150 , p3_a15 NUMBER := 0-1962.0724
151 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
152 , p3_a17 NUMBER := 0-1962.0724
153 , p3_a18 NUMBER := 0-1962.0724
154 , p3_a19 NUMBER := 0-1962.0724
155 );
156 procedure create_refund_details(p_api_version NUMBER
157 , p_init_msg_list VARCHAR2
158 , p_commit VARCHAR2
159 , p3_a0 JTF_VARCHAR2_TABLE_200
160 , p3_a1 JTF_NUMBER_TABLE
161 , p3_a2 JTF_NUMBER_TABLE
162 , p3_a3 JTF_DATE_TABLE
163 , p3_a4 JTF_NUMBER_TABLE
164 , p3_a5 JTF_VARCHAR2_TABLE_100
165 , p3_a6 JTF_VARCHAR2_TABLE_100
166 , p3_a7 JTF_NUMBER_TABLE
167 , p3_a8 JTF_NUMBER_TABLE
168 , p3_a9 JTF_VARCHAR2_TABLE_2000
169 , p3_a10 JTF_NUMBER_TABLE
170 , p3_a11 JTF_NUMBER_TABLE
171 , p3_a12 JTF_NUMBER_TABLE
172 , p3_a13 JTF_NUMBER_TABLE
173 , p3_a14 JTF_NUMBER_TABLE
174 , p3_a15 JTF_NUMBER_TABLE
175 , p3_a16 JTF_VARCHAR2_TABLE_100
176 , p3_a17 JTF_NUMBER_TABLE
177 , p3_a18 JTF_NUMBER_TABLE
178 , p3_a19 JTF_NUMBER_TABLE
179 , x_return_status out nocopy VARCHAR2
180 , x_msg_count out nocopy NUMBER
181 , x_msg_data out nocopy VARCHAR2
182 );
183 procedure update_refund_details(p_api_version NUMBER
184 , p_init_msg_list VARCHAR2
185 , p_commit VARCHAR2
186 , p3_a0 JTF_VARCHAR2_TABLE_200
187 , p3_a1 JTF_NUMBER_TABLE
188 , p3_a2 JTF_NUMBER_TABLE
189 , p3_a3 JTF_DATE_TABLE
190 , p3_a4 JTF_NUMBER_TABLE
191 , p3_a5 JTF_VARCHAR2_TABLE_100
192 , p3_a6 JTF_VARCHAR2_TABLE_100
193 , p3_a7 JTF_NUMBER_TABLE
194 , p3_a8 JTF_NUMBER_TABLE
195 , p3_a9 JTF_VARCHAR2_TABLE_2000
196 , p3_a10 JTF_NUMBER_TABLE
197 , p3_a11 JTF_NUMBER_TABLE
198 , p3_a12 JTF_NUMBER_TABLE
199 , p3_a13 JTF_NUMBER_TABLE
200 , p3_a14 JTF_NUMBER_TABLE
201 , p3_a15 JTF_NUMBER_TABLE
202 , p3_a16 JTF_VARCHAR2_TABLE_100
203 , p3_a17 JTF_NUMBER_TABLE
204 , p3_a18 JTF_NUMBER_TABLE
205 , p3_a19 JTF_NUMBER_TABLE
206 , x_return_status out nocopy VARCHAR2
207 , x_msg_count out nocopy NUMBER
208 , x_msg_data out nocopy VARCHAR2
209 );
210 procedure delete_refund_details(p_api_version NUMBER
211 , p_init_msg_list VARCHAR2
212 , p_commit VARCHAR2
213 , p3_a0 JTF_VARCHAR2_TABLE_200
214 , p3_a1 JTF_NUMBER_TABLE
215 , p3_a2 JTF_NUMBER_TABLE
216 , p3_a3 JTF_DATE_TABLE
217 , p3_a4 JTF_NUMBER_TABLE
218 , p3_a5 JTF_VARCHAR2_TABLE_100
219 , p3_a6 JTF_VARCHAR2_TABLE_100
220 , p3_a7 JTF_NUMBER_TABLE
221 , p3_a8 JTF_NUMBER_TABLE
222 , p3_a9 JTF_VARCHAR2_TABLE_2000
223 , p3_a10 JTF_NUMBER_TABLE
224 , p3_a11 JTF_NUMBER_TABLE
225 , p3_a12 JTF_NUMBER_TABLE
226 , p3_a13 JTF_NUMBER_TABLE
227 , p3_a14 JTF_NUMBER_TABLE
228 , p3_a15 JTF_NUMBER_TABLE
229 , p3_a16 JTF_VARCHAR2_TABLE_100
230 , p3_a17 JTF_NUMBER_TABLE
231 , p3_a18 JTF_NUMBER_TABLE
232 , p3_a19 JTF_NUMBER_TABLE
233 , x_return_status out nocopy VARCHAR2
234 , x_msg_count out nocopy NUMBER
235 , x_msg_data out nocopy VARCHAR2
236 );
237 end okl_pay_cure_refunds_pvt_w;