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_FORMULA_PVT_W

Source


1 package ams_formula_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswfmls.pls 115.4 2002/11/22 00:44:55 yzhao ship $ */
3   procedure create_formula(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , x_return_status out nocopy  VARCHAR2
8     , x_msg_count out nocopy  NUMBER
9     , x_msg_data out nocopy  VARCHAR2
10     , x_formula_id out nocopy  NUMBER
11     , p7_a0  NUMBER := 0-1962.0724
12     , p7_a1  NUMBER := 0-1962.0724
13     , p7_a2  NUMBER := 0-1962.0724
14     , p7_a3  NUMBER := 0-1962.0724
15     , p7_a4  DATE := fnd_api.g_miss_date
16     , p7_a5  NUMBER := 0-1962.0724
17     , p7_a6  DATE := fnd_api.g_miss_date
18     , p7_a7  NUMBER := 0-1962.0724
19     , p7_a8  NUMBER := 0-1962.0724
20     , p7_a9  NUMBER := 0-1962.0724
21     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
22   );
23   procedure update_formula(p_api_version  NUMBER
24     , p_init_msg_list  VARCHAR2
25     , p_commit  VARCHAR2
26     , p_validation_level  NUMBER
27     , x_return_status out nocopy  VARCHAR2
28     , x_msg_count out nocopy  NUMBER
29     , x_msg_data out nocopy  VARCHAR2
30     , p7_a0  NUMBER := 0-1962.0724
31     , p7_a1  NUMBER := 0-1962.0724
32     , p7_a2  NUMBER := 0-1962.0724
33     , p7_a3  NUMBER := 0-1962.0724
34     , p7_a4  DATE := fnd_api.g_miss_date
35     , p7_a5  NUMBER := 0-1962.0724
36     , p7_a6  DATE := fnd_api.g_miss_date
37     , p7_a7  NUMBER := 0-1962.0724
38     , p7_a8  NUMBER := 0-1962.0724
39     , p7_a9  NUMBER := 0-1962.0724
40     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
41   );
42   procedure validate_formula(p_api_version  NUMBER
43     , p_init_msg_list  VARCHAR2
44     , p_validation_level  NUMBER
45     , x_return_status out nocopy  VARCHAR2
46     , x_msg_count out nocopy  NUMBER
47     , x_msg_data out nocopy  VARCHAR2
48     , p6_a0  NUMBER := 0-1962.0724
49     , p6_a1  NUMBER := 0-1962.0724
50     , p6_a2  NUMBER := 0-1962.0724
51     , p6_a3  NUMBER := 0-1962.0724
52     , p6_a4  DATE := fnd_api.g_miss_date
53     , p6_a5  NUMBER := 0-1962.0724
54     , p6_a6  DATE := fnd_api.g_miss_date
55     , p6_a7  NUMBER := 0-1962.0724
56     , p6_a8  NUMBER := 0-1962.0724
57     , p6_a9  NUMBER := 0-1962.0724
58     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
59   );
60   procedure validate_formula_items(p_validation_mode  VARCHAR2
61     , x_return_status out nocopy  VARCHAR2
62     , p0_a0  NUMBER := 0-1962.0724
63     , p0_a1  NUMBER := 0-1962.0724
64     , p0_a2  NUMBER := 0-1962.0724
65     , p0_a3  NUMBER := 0-1962.0724
66     , p0_a4  DATE := fnd_api.g_miss_date
67     , p0_a5  NUMBER := 0-1962.0724
68     , p0_a6  DATE := fnd_api.g_miss_date
69     , p0_a7  NUMBER := 0-1962.0724
70     , p0_a8  NUMBER := 0-1962.0724
71     , p0_a9  NUMBER := 0-1962.0724
72     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
73   );
74   procedure validate_formula_rec(x_return_status out nocopy  VARCHAR2
75     , p0_a0  NUMBER := 0-1962.0724
76     , p0_a1  NUMBER := 0-1962.0724
77     , p0_a2  NUMBER := 0-1962.0724
78     , p0_a3  NUMBER := 0-1962.0724
79     , p0_a4  DATE := fnd_api.g_miss_date
80     , p0_a5  NUMBER := 0-1962.0724
81     , p0_a6  DATE := fnd_api.g_miss_date
82     , p0_a7  NUMBER := 0-1962.0724
83     , p0_a8  NUMBER := 0-1962.0724
84     , p0_a9  NUMBER := 0-1962.0724
85     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
86     , p1_a0  NUMBER := 0-1962.0724
87     , p1_a1  NUMBER := 0-1962.0724
88     , p1_a2  NUMBER := 0-1962.0724
89     , p1_a3  NUMBER := 0-1962.0724
90     , p1_a4  DATE := fnd_api.g_miss_date
91     , p1_a5  NUMBER := 0-1962.0724
92     , p1_a6  DATE := fnd_api.g_miss_date
93     , p1_a7  NUMBER := 0-1962.0724
94     , p1_a8  NUMBER := 0-1962.0724
95     , p1_a9  NUMBER := 0-1962.0724
96     , p1_a10  VARCHAR2 := fnd_api.g_miss_char
97   );
98   procedure complete_formula_rec(p1_a0 out nocopy  NUMBER
99     , p1_a1 out nocopy  NUMBER
100     , p1_a2 out nocopy  NUMBER
101     , p1_a3 out nocopy  NUMBER
102     , p1_a4 out nocopy  DATE
103     , p1_a5 out nocopy  NUMBER
104     , p1_a6 out nocopy  DATE
105     , p1_a7 out nocopy  NUMBER
106     , p1_a8 out nocopy  NUMBER
107     , p1_a9 out nocopy  NUMBER
108     , p1_a10 out nocopy  VARCHAR2
109     , p0_a0  NUMBER := 0-1962.0724
110     , p0_a1  NUMBER := 0-1962.0724
111     , p0_a2  NUMBER := 0-1962.0724
112     , p0_a3  NUMBER := 0-1962.0724
113     , p0_a4  DATE := fnd_api.g_miss_date
114     , p0_a5  NUMBER := 0-1962.0724
115     , p0_a6  DATE := fnd_api.g_miss_date
116     , p0_a7  NUMBER := 0-1962.0724
117     , p0_a8  NUMBER := 0-1962.0724
118     , p0_a9  NUMBER := 0-1962.0724
119     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
120   );
121   procedure create_formula_entry(p_api_version  NUMBER
122     , p_init_msg_list  VARCHAR2
123     , p_commit  VARCHAR2
124     , p_validation_level  NUMBER
125     , x_return_status out nocopy  VARCHAR2
126     , x_msg_count out nocopy  NUMBER
127     , x_msg_data out nocopy  VARCHAR2
128     , x_formula_entry_id out nocopy  NUMBER
129     , p7_a0  NUMBER := 0-1962.0724
130     , p7_a1  NUMBER := 0-1962.0724
131     , p7_a2  NUMBER := 0-1962.0724
132     , p7_a3  VARCHAR2 := fnd_api.g_miss_char
133     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
134     , p7_a5  VARCHAR2 := fnd_api.g_miss_char
135     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
136     , p7_a7  DATE := fnd_api.g_miss_date
137     , p7_a8  NUMBER := 0-1962.0724
138     , p7_a9  DATE := fnd_api.g_miss_date
139     , p7_a10  NUMBER := 0-1962.0724
140     , p7_a11  NUMBER := 0-1962.0724
141     , p7_a12  NUMBER := 0-1962.0724
142   );
143   procedure update_formula_entry(p_api_version  NUMBER
144     , p_init_msg_list  VARCHAR2
145     , p_commit  VARCHAR2
146     , p_validation_level  NUMBER
147     , x_return_status out nocopy  VARCHAR2
148     , x_msg_count out nocopy  NUMBER
149     , x_msg_data out nocopy  VARCHAR2
150     , p7_a0  NUMBER := 0-1962.0724
151     , p7_a1  NUMBER := 0-1962.0724
152     , p7_a2  NUMBER := 0-1962.0724
153     , p7_a3  VARCHAR2 := fnd_api.g_miss_char
154     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
155     , p7_a5  VARCHAR2 := fnd_api.g_miss_char
156     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
157     , p7_a7  DATE := fnd_api.g_miss_date
158     , p7_a8  NUMBER := 0-1962.0724
159     , p7_a9  DATE := fnd_api.g_miss_date
160     , p7_a10  NUMBER := 0-1962.0724
161     , p7_a11  NUMBER := 0-1962.0724
162     , p7_a12  NUMBER := 0-1962.0724
163   );
164   procedure validate_formula_entry(p_api_version  NUMBER
165     , p_init_msg_list  VARCHAR2
166     , p_validation_level  NUMBER
167     , x_return_status out nocopy  VARCHAR2
168     , x_msg_count out nocopy  NUMBER
169     , x_msg_data out nocopy  VARCHAR2
170     , p6_a0  NUMBER := 0-1962.0724
171     , p6_a1  NUMBER := 0-1962.0724
172     , p6_a2  NUMBER := 0-1962.0724
173     , p6_a3  VARCHAR2 := fnd_api.g_miss_char
174     , p6_a4  VARCHAR2 := fnd_api.g_miss_char
175     , p6_a5  VARCHAR2 := fnd_api.g_miss_char
176     , p6_a6  VARCHAR2 := fnd_api.g_miss_char
177     , p6_a7  DATE := fnd_api.g_miss_date
178     , p6_a8  NUMBER := 0-1962.0724
179     , p6_a9  DATE := fnd_api.g_miss_date
180     , p6_a10  NUMBER := 0-1962.0724
181     , p6_a11  NUMBER := 0-1962.0724
182     , p6_a12  NUMBER := 0-1962.0724
183   );
184   procedure validate_form_ent_items(p_validation_mode  VARCHAR2
185     , x_return_status out nocopy  VARCHAR2
186     , p0_a0  NUMBER := 0-1962.0724
187     , p0_a1  NUMBER := 0-1962.0724
188     , p0_a2  NUMBER := 0-1962.0724
189     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
190     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
191     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
192     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
193     , p0_a7  DATE := fnd_api.g_miss_date
194     , p0_a8  NUMBER := 0-1962.0724
195     , p0_a9  DATE := fnd_api.g_miss_date
196     , p0_a10  NUMBER := 0-1962.0724
197     , p0_a11  NUMBER := 0-1962.0724
198     , p0_a12  NUMBER := 0-1962.0724
199   );
200   procedure validate_form_ent_rec(x_return_status out nocopy  VARCHAR2
201     , p0_a0  NUMBER := 0-1962.0724
202     , p0_a1  NUMBER := 0-1962.0724
203     , p0_a2  NUMBER := 0-1962.0724
204     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
205     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
206     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
207     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
208     , p0_a7  DATE := fnd_api.g_miss_date
209     , p0_a8  NUMBER := 0-1962.0724
210     , p0_a9  DATE := fnd_api.g_miss_date
211     , p0_a10  NUMBER := 0-1962.0724
212     , p0_a11  NUMBER := 0-1962.0724
213     , p0_a12  NUMBER := 0-1962.0724
214     , p1_a0  NUMBER := 0-1962.0724
215     , p1_a1  NUMBER := 0-1962.0724
216     , p1_a2  NUMBER := 0-1962.0724
217     , p1_a3  VARCHAR2 := fnd_api.g_miss_char
218     , p1_a4  VARCHAR2 := fnd_api.g_miss_char
219     , p1_a5  VARCHAR2 := fnd_api.g_miss_char
220     , p1_a6  VARCHAR2 := fnd_api.g_miss_char
221     , p1_a7  DATE := fnd_api.g_miss_date
222     , p1_a8  NUMBER := 0-1962.0724
223     , p1_a9  DATE := fnd_api.g_miss_date
224     , p1_a10  NUMBER := 0-1962.0724
225     , p1_a11  NUMBER := 0-1962.0724
226     , p1_a12  NUMBER := 0-1962.0724
227   );
228   procedure complete_form_ent_rec(p1_a0 out nocopy  NUMBER
229     , p1_a1 out nocopy  NUMBER
230     , p1_a2 out nocopy  NUMBER
231     , p1_a3 out nocopy  VARCHAR2
232     , p1_a4 out nocopy  VARCHAR2
233     , p1_a5 out nocopy  VARCHAR2
234     , p1_a6 out nocopy  VARCHAR2
235     , p1_a7 out nocopy  DATE
236     , p1_a8 out nocopy  NUMBER
237     , p1_a9 out nocopy  DATE
238     , p1_a10 out nocopy  NUMBER
239     , p1_a11 out nocopy  NUMBER
240     , p1_a12 out nocopy  NUMBER
241     , p0_a0  NUMBER := 0-1962.0724
242     , p0_a1  NUMBER := 0-1962.0724
243     , p0_a2  NUMBER := 0-1962.0724
244     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
245     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
246     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
247     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
248     , p0_a7  DATE := fnd_api.g_miss_date
249     , p0_a8  NUMBER := 0-1962.0724
250     , p0_a9  DATE := fnd_api.g_miss_date
251     , p0_a10  NUMBER := 0-1962.0724
252     , p0_a11  NUMBER := 0-1962.0724
253     , p0_a12  NUMBER := 0-1962.0724
254   );
255 end ams_formula_pvt_w;