[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_BUCKETS_PVT_W
Source
1 package okl_process_buckets_pvt_w as
2 /* $Header: OKLEBUKS.pls 120.1 2005/07/11 12:53:48 dkagrawa noship $ */
3 procedure create_buckets(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 out nocopy NUMBER
9 , p6_a1 out nocopy NUMBER
10 , p6_a2 out nocopy NUMBER
11 , p6_a3 out nocopy VARCHAR2
12 , p6_a4 out nocopy VARCHAR2
13 , p6_a5 out nocopy NUMBER
14 , p6_a6 out nocopy NUMBER
15 , p6_a7 out nocopy NUMBER
16 , p6_a8 out nocopy NUMBER
17 , p6_a9 out nocopy DATE
18 , p6_a10 out nocopy DATE
19 , p6_a11 out nocopy DATE
20 , p6_a12 out nocopy NUMBER
21 , p6_a13 out nocopy DATE
22 , p6_a14 out nocopy NUMBER
23 , p6_a15 out nocopy DATE
24 , p6_a16 out nocopy NUMBER
25 , p5_a0 NUMBER := 0-1962.0724
26 , p5_a1 NUMBER := 0-1962.0724
27 , p5_a2 NUMBER := 0-1962.0724
28 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
29 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
30 , p5_a5 NUMBER := 0-1962.0724
31 , p5_a6 NUMBER := 0-1962.0724
32 , p5_a7 NUMBER := 0-1962.0724
33 , p5_a8 NUMBER := 0-1962.0724
34 , p5_a9 DATE := fnd_api.g_miss_date
35 , p5_a10 DATE := fnd_api.g_miss_date
36 , p5_a11 DATE := fnd_api.g_miss_date
37 , p5_a12 NUMBER := 0-1962.0724
38 , p5_a13 DATE := fnd_api.g_miss_date
39 , p5_a14 NUMBER := 0-1962.0724
40 , p5_a15 DATE := fnd_api.g_miss_date
41 , p5_a16 NUMBER := 0-1962.0724
42 );
43 procedure create_buckets(p_api_version NUMBER
44 , p_init_msg_list VARCHAR2
45 , x_return_status out nocopy VARCHAR2
46 , x_msg_count out nocopy NUMBER
47 , x_msg_data out nocopy VARCHAR2
48 , p5_a0 JTF_NUMBER_TABLE
49 , p5_a1 JTF_NUMBER_TABLE
50 , p5_a2 JTF_NUMBER_TABLE
51 , p5_a3 JTF_VARCHAR2_TABLE_100
52 , p5_a4 JTF_VARCHAR2_TABLE_2000
53 , p5_a5 JTF_NUMBER_TABLE
54 , p5_a6 JTF_NUMBER_TABLE
55 , p5_a7 JTF_NUMBER_TABLE
56 , p5_a8 JTF_NUMBER_TABLE
57 , p5_a9 JTF_DATE_TABLE
58 , p5_a10 JTF_DATE_TABLE
59 , p5_a11 JTF_DATE_TABLE
60 , p5_a12 JTF_NUMBER_TABLE
61 , p5_a13 JTF_DATE_TABLE
62 , p5_a14 JTF_NUMBER_TABLE
63 , p5_a15 JTF_DATE_TABLE
64 , p5_a16 JTF_NUMBER_TABLE
65 , p6_a0 out nocopy JTF_NUMBER_TABLE
66 , p6_a1 out nocopy JTF_NUMBER_TABLE
67 , p6_a2 out nocopy JTF_NUMBER_TABLE
68 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70 , p6_a5 out nocopy JTF_NUMBER_TABLE
71 , p6_a6 out nocopy JTF_NUMBER_TABLE
72 , p6_a7 out nocopy JTF_NUMBER_TABLE
73 , p6_a8 out nocopy JTF_NUMBER_TABLE
74 , p6_a9 out nocopy JTF_DATE_TABLE
75 , p6_a10 out nocopy JTF_DATE_TABLE
76 , p6_a11 out nocopy JTF_DATE_TABLE
77 , p6_a12 out nocopy JTF_NUMBER_TABLE
78 , p6_a13 out nocopy JTF_DATE_TABLE
79 , p6_a14 out nocopy JTF_NUMBER_TABLE
80 , p6_a15 out nocopy JTF_DATE_TABLE
81 , p6_a16 out nocopy JTF_NUMBER_TABLE
82 );
83 procedure update_buckets(p_api_version NUMBER
84 , p_init_msg_list VARCHAR2
85 , x_return_status out nocopy VARCHAR2
86 , x_msg_count out nocopy NUMBER
87 , x_msg_data out nocopy VARCHAR2
88 , p6_a0 out nocopy NUMBER
89 , p6_a1 out nocopy NUMBER
90 , p6_a2 out nocopy NUMBER
91 , p6_a3 out nocopy VARCHAR2
92 , p6_a4 out nocopy VARCHAR2
93 , p6_a5 out nocopy NUMBER
94 , p6_a6 out nocopy NUMBER
95 , p6_a7 out nocopy NUMBER
96 , p6_a8 out nocopy NUMBER
97 , p6_a9 out nocopy DATE
98 , p6_a10 out nocopy DATE
99 , p6_a11 out nocopy DATE
100 , p6_a12 out nocopy NUMBER
101 , p6_a13 out nocopy DATE
102 , p6_a14 out nocopy NUMBER
103 , p6_a15 out nocopy DATE
104 , p6_a16 out nocopy NUMBER
105 , p5_a0 NUMBER := 0-1962.0724
106 , p5_a1 NUMBER := 0-1962.0724
107 , p5_a2 NUMBER := 0-1962.0724
108 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
110 , p5_a5 NUMBER := 0-1962.0724
111 , p5_a6 NUMBER := 0-1962.0724
112 , p5_a7 NUMBER := 0-1962.0724
113 , p5_a8 NUMBER := 0-1962.0724
114 , p5_a9 DATE := fnd_api.g_miss_date
115 , p5_a10 DATE := fnd_api.g_miss_date
116 , p5_a11 DATE := fnd_api.g_miss_date
117 , p5_a12 NUMBER := 0-1962.0724
118 , p5_a13 DATE := fnd_api.g_miss_date
119 , p5_a14 NUMBER := 0-1962.0724
120 , p5_a15 DATE := fnd_api.g_miss_date
121 , p5_a16 NUMBER := 0-1962.0724
122 );
123 procedure update_buckets(p_api_version NUMBER
124 , p_init_msg_list VARCHAR2
125 , x_return_status out nocopy VARCHAR2
126 , x_msg_count out nocopy NUMBER
127 , x_msg_data out nocopy VARCHAR2
128 , p5_a0 JTF_NUMBER_TABLE
129 , p5_a1 JTF_NUMBER_TABLE
130 , p5_a2 JTF_NUMBER_TABLE
131 , p5_a3 JTF_VARCHAR2_TABLE_100
132 , p5_a4 JTF_VARCHAR2_TABLE_2000
133 , p5_a5 JTF_NUMBER_TABLE
134 , p5_a6 JTF_NUMBER_TABLE
135 , p5_a7 JTF_NUMBER_TABLE
136 , p5_a8 JTF_NUMBER_TABLE
137 , p5_a9 JTF_DATE_TABLE
138 , p5_a10 JTF_DATE_TABLE
139 , p5_a11 JTF_DATE_TABLE
140 , p5_a12 JTF_NUMBER_TABLE
141 , p5_a13 JTF_DATE_TABLE
142 , p5_a14 JTF_NUMBER_TABLE
143 , p5_a15 JTF_DATE_TABLE
144 , p5_a16 JTF_NUMBER_TABLE
145 , p6_a0 out nocopy JTF_NUMBER_TABLE
146 , p6_a1 out nocopy JTF_NUMBER_TABLE
147 , p6_a2 out nocopy JTF_NUMBER_TABLE
148 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
149 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
150 , p6_a5 out nocopy JTF_NUMBER_TABLE
151 , p6_a6 out nocopy JTF_NUMBER_TABLE
152 , p6_a7 out nocopy JTF_NUMBER_TABLE
153 , p6_a8 out nocopy JTF_NUMBER_TABLE
154 , p6_a9 out nocopy JTF_DATE_TABLE
155 , p6_a10 out nocopy JTF_DATE_TABLE
156 , p6_a11 out nocopy JTF_DATE_TABLE
157 , p6_a12 out nocopy JTF_NUMBER_TABLE
158 , p6_a13 out nocopy JTF_DATE_TABLE
159 , p6_a14 out nocopy JTF_NUMBER_TABLE
160 , p6_a15 out nocopy JTF_DATE_TABLE
161 , p6_a16 out nocopy JTF_NUMBER_TABLE
162 );
163 procedure delete_buckets(p_api_version NUMBER
164 , p_init_msg_list VARCHAR2
165 , x_return_status out nocopy VARCHAR2
166 , x_msg_count out nocopy NUMBER
167 , x_msg_data out nocopy VARCHAR2
168 , p5_a0 NUMBER := 0-1962.0724
169 , p5_a1 NUMBER := 0-1962.0724
170 , p5_a2 NUMBER := 0-1962.0724
171 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
172 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
173 , p5_a5 NUMBER := 0-1962.0724
174 , p5_a6 NUMBER := 0-1962.0724
175 , p5_a7 NUMBER := 0-1962.0724
176 , p5_a8 NUMBER := 0-1962.0724
177 , p5_a9 DATE := fnd_api.g_miss_date
178 , p5_a10 DATE := fnd_api.g_miss_date
179 , p5_a11 DATE := fnd_api.g_miss_date
180 , p5_a12 NUMBER := 0-1962.0724
181 , p5_a13 DATE := fnd_api.g_miss_date
182 , p5_a14 NUMBER := 0-1962.0724
183 , p5_a15 DATE := fnd_api.g_miss_date
184 , p5_a16 NUMBER := 0-1962.0724
185 );
186 procedure delete_buckets(p_api_version NUMBER
187 , p_init_msg_list VARCHAR2
188 , x_return_status out nocopy VARCHAR2
189 , x_msg_count out nocopy NUMBER
190 , x_msg_data out nocopy VARCHAR2
191 , p5_a0 JTF_NUMBER_TABLE
192 , p5_a1 JTF_NUMBER_TABLE
193 , p5_a2 JTF_NUMBER_TABLE
194 , p5_a3 JTF_VARCHAR2_TABLE_100
195 , p5_a4 JTF_VARCHAR2_TABLE_2000
196 , p5_a5 JTF_NUMBER_TABLE
197 , p5_a6 JTF_NUMBER_TABLE
198 , p5_a7 JTF_NUMBER_TABLE
199 , p5_a8 JTF_NUMBER_TABLE
200 , p5_a9 JTF_DATE_TABLE
201 , p5_a10 JTF_DATE_TABLE
202 , p5_a11 JTF_DATE_TABLE
203 , p5_a12 JTF_NUMBER_TABLE
204 , p5_a13 JTF_DATE_TABLE
205 , p5_a14 JTF_NUMBER_TABLE
206 , p5_a15 JTF_DATE_TABLE
207 , p5_a16 JTF_NUMBER_TABLE
208 );
209 end okl_process_buckets_pvt_w;