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