eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AMS_PS_RULE_PVT_W

Source


1 package ams_ps_rule_pvt_w as
2   /* $Header: amswruls.pls 120.0 2005/05/31 14:00:18 appldev noship $ */
3   procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_VARCHAR2_TABLE_100
5     );
6   procedure rosetta_table_copy_out_p3(t ams_ps_rule_pvt.ps_rules_tuple_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
7     , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
8     );
9 
10   procedure rosetta_table_copy_in_p8(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tbl_type, a0 JTF_NUMBER_TABLE
11     , a1 JTF_DATE_TABLE
12     , a2 JTF_NUMBER_TABLE
13     , a3 JTF_DATE_TABLE
14     , a4 JTF_NUMBER_TABLE
15     , a5 JTF_NUMBER_TABLE
16     , a6 JTF_NUMBER_TABLE
17     , a7 JTF_NUMBER_TABLE
18     , a8 JTF_NUMBER_TABLE
19     , a9 JTF_NUMBER_TABLE
20     , a10 JTF_NUMBER_TABLE
21     , a11 JTF_VARCHAR2_TABLE_100
22     , a12 JTF_VARCHAR2_TABLE_100
23     , a13 JTF_VARCHAR2_TABLE_100
24     , a14 JTF_NUMBER_TABLE
25     , a15 JTF_VARCHAR2_TABLE_100
26     , a16 JTF_VARCHAR2_TABLE_100
27     , a17 JTF_NUMBER_TABLE
28     , a18 JTF_VARCHAR2_TABLE_100
29     , a19 JTF_VARCHAR2_TABLE_100
30     , a20 JTF_VARCHAR2_TABLE_100
31     , a21 JTF_VARCHAR2_TABLE_100
32     , a22 JTF_VARCHAR2_TABLE_100
33     , a23 JTF_VARCHAR2_TABLE_100
34     , a24 JTF_VARCHAR2_TABLE_100
35     , a25 JTF_VARCHAR2_TABLE_100
36     , a26 JTF_VARCHAR2_TABLE_100
37     , a27 JTF_VARCHAR2_TABLE_100
38     );
39   procedure rosetta_table_copy_out_p8(t ams_ps_rule_pvt.ps_rules_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
40     , a1 OUT NOCOPY JTF_DATE_TABLE
41     , a2 OUT NOCOPY JTF_NUMBER_TABLE
42     , a3 OUT NOCOPY JTF_DATE_TABLE
43     , a4 OUT NOCOPY JTF_NUMBER_TABLE
44     , a5 OUT NOCOPY JTF_NUMBER_TABLE
45     , a6 OUT NOCOPY JTF_NUMBER_TABLE
46     , a7 OUT NOCOPY JTF_NUMBER_TABLE
47     , a8 OUT NOCOPY JTF_NUMBER_TABLE
48     , a9 OUT NOCOPY JTF_NUMBER_TABLE
49     , a10 OUT NOCOPY JTF_NUMBER_TABLE
50     , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51     , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52     , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53     , a14 OUT NOCOPY JTF_NUMBER_TABLE
54     , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55     , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
56     , a17 OUT NOCOPY JTF_NUMBER_TABLE
57     , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
58     , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59     , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60     , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
61     , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62     , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
63     , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_100
64     , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65     , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66     , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_100
67     );
68 
69   procedure create_ps_rule(p_api_version_number  NUMBER
70     , p_init_msg_list  VARCHAR2
71     , p_commit  VARCHAR2
72     , p_validation_level  NUMBER
73     , x_return_status OUT NOCOPY  VARCHAR2
74     , x_msg_count OUT NOCOPY  NUMBER
75     , x_msg_data OUT NOCOPY  VARCHAR2
76     , p8_a0  NUMBER
77     , p8_a1  NUMBER
78     , p8_a2  NUMBER
79     , x_rule_id OUT NOCOPY  NUMBER
80     , p7_a0  NUMBER := 0-1962.0724
81     , p7_a1  DATE := fnd_api.g_miss_date
82     , p7_a2  NUMBER := 0-1962.0724
83     , p7_a3  DATE := fnd_api.g_miss_date
84     , p7_a4  NUMBER := 0-1962.0724
85     , p7_a5  NUMBER := 0-1962.0724
86     , p7_a6  NUMBER := 0-1962.0724
87     , p7_a7  NUMBER := 0-1962.0724
88     , p7_a8  NUMBER := 0-1962.0724
89     , p7_a9  NUMBER := 0-1962.0724
90     , p7_a10  NUMBER := 0-1962.0724
91     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
92     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a14  NUMBER := 0-1962.0724
95     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
96     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a17  NUMBER := 0-1962.0724
98     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
99     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
100     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
101     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
102     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
103     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
104     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
105     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
106     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
107     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
108   );
109   procedure update_ps_rule(p_api_version_number  NUMBER
110     , p_init_msg_list  VARCHAR2
111     , p_commit  VARCHAR2
112     , p_validation_level  NUMBER
113     , x_return_status OUT NOCOPY  VARCHAR2
114     , x_msg_count OUT NOCOPY  NUMBER
115     , x_msg_data OUT NOCOPY  VARCHAR2
116     , p8_a0  NUMBER
117     , p8_a1  NUMBER
118     , p8_a2  NUMBER
119     , p9_a0 JTF_VARCHAR2_TABLE_100
120     , p9_a1 JTF_VARCHAR2_TABLE_100
121     , p10_a0 JTF_VARCHAR2_TABLE_100
122     , p10_a1 JTF_VARCHAR2_TABLE_100
123     , x_object_version_number OUT NOCOPY  NUMBER
124     , p7_a0  NUMBER := 0-1962.0724
125     , p7_a1  DATE := fnd_api.g_miss_date
126     , p7_a2  NUMBER := 0-1962.0724
127     , p7_a3  DATE := fnd_api.g_miss_date
128     , p7_a4  NUMBER := 0-1962.0724
129     , p7_a5  NUMBER := 0-1962.0724
130     , p7_a6  NUMBER := 0-1962.0724
131     , p7_a7  NUMBER := 0-1962.0724
132     , p7_a8  NUMBER := 0-1962.0724
133     , p7_a9  NUMBER := 0-1962.0724
134     , p7_a10  NUMBER := 0-1962.0724
135     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
136     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
137     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
138     , p7_a14  NUMBER := 0-1962.0724
139     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
140     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
141     , p7_a17  NUMBER := 0-1962.0724
142     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
143     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
144     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
145     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
146     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
147     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
148     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
149     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
150     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
151     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
152   );
153   procedure update_ps_rule_alt(p_api_version_number  NUMBER
154     , p_init_msg_list  VARCHAR2
155     , p_commit  VARCHAR2
156     , p_validation_level  NUMBER
157     , x_return_status OUT NOCOPY  VARCHAR2
158     , x_msg_count OUT NOCOPY  NUMBER
159     , x_msg_data OUT NOCOPY  VARCHAR2
160     , p8_a0  NUMBER
161     , p8_a1  NUMBER
162     , p8_a2  NUMBER
163     , p9_a0 JTF_VARCHAR2_TABLE_100
164     , p9_a1 JTF_VARCHAR2_TABLE_100
165     , p10_a0 JTF_VARCHAR2_TABLE_100
166     , p10_a1 JTF_VARCHAR2_TABLE_100
167     , p_vistype_change  number
168     , p_rem_change  number
169     , x_object_version_number OUT NOCOPY  NUMBER
170     , p7_a0  NUMBER := 0-1962.0724
171     , p7_a1  DATE := fnd_api.g_miss_date
172     , p7_a2  NUMBER := 0-1962.0724
173     , p7_a3  DATE := fnd_api.g_miss_date
174     , p7_a4  NUMBER := 0-1962.0724
175     , p7_a5  NUMBER := 0-1962.0724
176     , p7_a6  NUMBER := 0-1962.0724
177     , p7_a7  NUMBER := 0-1962.0724
178     , p7_a8  NUMBER := 0-1962.0724
179     , p7_a9  NUMBER := 0-1962.0724
180     , p7_a10  NUMBER := 0-1962.0724
181     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
182     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
183     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
184     , p7_a14  NUMBER := 0-1962.0724
185     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
186     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
187     , p7_a17  NUMBER := 0-1962.0724
188     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
189     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
190     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
191     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
192     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
193     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
194     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
195     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
196     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
197     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
198   );
199   procedure delete_ps_rule_alt(p_api_version_number  NUMBER
200     , p_init_msg_list  VARCHAR2
201     , p_commit  VARCHAR2
202     , p_validation_level  NUMBER
203     , x_return_status OUT NOCOPY  VARCHAR2
204     , x_msg_count OUT NOCOPY  NUMBER
205     , x_msg_data OUT NOCOPY  VARCHAR2
206     , p_object_version_number  NUMBER
207     , p7_a0  NUMBER := 0-1962.0724
208     , p7_a1  DATE := fnd_api.g_miss_date
209     , p7_a2  NUMBER := 0-1962.0724
210     , p7_a3  DATE := fnd_api.g_miss_date
211     , p7_a4  NUMBER := 0-1962.0724
212     , p7_a5  NUMBER := 0-1962.0724
213     , p7_a6  NUMBER := 0-1962.0724
214     , p7_a7  NUMBER := 0-1962.0724
215     , p7_a8  NUMBER := 0-1962.0724
216     , p7_a9  NUMBER := 0-1962.0724
217     , p7_a10  NUMBER := 0-1962.0724
218     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
219     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
220     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
221     , p7_a14  NUMBER := 0-1962.0724
222     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
223     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
224     , p7_a17  NUMBER := 0-1962.0724
225     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
226     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
227     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
228     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
229     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
230     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
231     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
232     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
233     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
234     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
235   );
236   procedure validate_ps_rule(p_api_version_number  NUMBER
237     , p_init_msg_list  VARCHAR2
238     , p_validation_level  NUMBER
239     , x_return_status OUT NOCOPY  VARCHAR2
240     , x_msg_count OUT NOCOPY  NUMBER
241     , x_msg_data OUT NOCOPY  VARCHAR2
242     , p3_a0  NUMBER := 0-1962.0724
243     , p3_a1  DATE := fnd_api.g_miss_date
244     , p3_a2  NUMBER := 0-1962.0724
245     , p3_a3  DATE := fnd_api.g_miss_date
246     , p3_a4  NUMBER := 0-1962.0724
247     , p3_a5  NUMBER := 0-1962.0724
248     , p3_a6  NUMBER := 0-1962.0724
249     , p3_a7  NUMBER := 0-1962.0724
250     , p3_a8  NUMBER := 0-1962.0724
251     , p3_a9  NUMBER := 0-1962.0724
252     , p3_a10  NUMBER := 0-1962.0724
253     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
254     , p3_a12  VARCHAR2 := fnd_api.g_miss_char
255     , p3_a13  VARCHAR2 := fnd_api.g_miss_char
256     , p3_a14  NUMBER := 0-1962.0724
257     , p3_a15  VARCHAR2 := fnd_api.g_miss_char
258     , p3_a16  VARCHAR2 := fnd_api.g_miss_char
259     , p3_a17  NUMBER := 0-1962.0724
260     , p3_a18  VARCHAR2 := fnd_api.g_miss_char
261     , p3_a19  VARCHAR2 := fnd_api.g_miss_char
262     , p3_a20  VARCHAR2 := fnd_api.g_miss_char
263     , p3_a21  VARCHAR2 := fnd_api.g_miss_char
264     , p3_a22  VARCHAR2 := fnd_api.g_miss_char
265     , p3_a23  VARCHAR2 := fnd_api.g_miss_char
266     , p3_a24  VARCHAR2 := fnd_api.g_miss_char
267     , p3_a25  VARCHAR2 := fnd_api.g_miss_char
268     , p3_a26  VARCHAR2 := fnd_api.g_miss_char
269     , p3_a27  VARCHAR2 := fnd_api.g_miss_char
270   );
271   procedure check_ps_rules_items(p_validation_mode  VARCHAR2
272     , x_return_status OUT NOCOPY  VARCHAR2
273     , p0_a0  NUMBER := 0-1962.0724
274     , p0_a1  DATE := fnd_api.g_miss_date
275     , p0_a2  NUMBER := 0-1962.0724
276     , p0_a3  DATE := fnd_api.g_miss_date
277     , p0_a4  NUMBER := 0-1962.0724
278     , p0_a5  NUMBER := 0-1962.0724
279     , p0_a6  NUMBER := 0-1962.0724
280     , p0_a7  NUMBER := 0-1962.0724
281     , p0_a8  NUMBER := 0-1962.0724
282     , p0_a9  NUMBER := 0-1962.0724
283     , p0_a10  NUMBER := 0-1962.0724
284     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
285     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
286     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
287     , p0_a14  NUMBER := 0-1962.0724
288     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
289     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
290     , p0_a17  NUMBER := 0-1962.0724
291     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
292     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
293     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
294     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
295     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
296     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
297     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
298     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
299     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
300     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
301   );
302   procedure update_filters(p_rulegroup_id  NUMBER
303     , p1_a0 JTF_VARCHAR2_TABLE_100
304     , p1_a1 JTF_VARCHAR2_TABLE_100
305     , x_return_status OUT NOCOPY  VARCHAR2
306   );
307   procedure update_strategy_params(p_rulegroup_id  NUMBER
308     , p1_a0 JTF_VARCHAR2_TABLE_100
309     , p1_a1 JTF_VARCHAR2_TABLE_100
310     , x_return_status OUT NOCOPY  VARCHAR2
311   );
312   procedure validate_ps_rules_rec(p_api_version_number  NUMBER
313     , p_init_msg_list  VARCHAR2
314     , x_return_status OUT NOCOPY  VARCHAR2
315     , x_msg_count OUT NOCOPY  NUMBER
316     , x_msg_data OUT NOCOPY  VARCHAR2
317     , p5_a0  NUMBER := 0-1962.0724
318     , p5_a1  DATE := fnd_api.g_miss_date
319     , p5_a2  NUMBER := 0-1962.0724
320     , p5_a3  DATE := fnd_api.g_miss_date
321     , p5_a4  NUMBER := 0-1962.0724
322     , p5_a5  NUMBER := 0-1962.0724
323     , p5_a6  NUMBER := 0-1962.0724
324     , p5_a7  NUMBER := 0-1962.0724
325     , p5_a8  NUMBER := 0-1962.0724
326     , p5_a9  NUMBER := 0-1962.0724
327     , p5_a10  NUMBER := 0-1962.0724
328     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
329     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
330     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
331     , p5_a14  NUMBER := 0-1962.0724
332     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
333     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
334     , p5_a17  NUMBER := 0-1962.0724
335     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
336     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
337     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
338     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
339     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
340     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
341     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
342     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
343     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
344     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
345   );
346 end ams_ps_rule_pvt_w;