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_ACTPRODUCT_PVT_W

Source


1 package ams_actproduct_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswprds.pls 115.11 2003/10/22 01:55:21 musman ship $ */
3   procedure create_act_product(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_act_product_id OUT NOCOPY  NUMBER
11     , p7_a0  NUMBER := 0-1962.0724
12     , p7_a1  DATE := fnd_api.g_miss_date
13     , p7_a2  NUMBER := 0-1962.0724
14     , p7_a3  DATE := fnd_api.g_miss_date
15     , p7_a4  NUMBER := 0-1962.0724
16     , p7_a5  NUMBER := 0-1962.0724
17     , p7_a6  NUMBER := 0-1962.0724
18     , p7_a7  NUMBER := 0-1962.0724
19     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
20     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
21     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
22     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
24     , p7_a13  NUMBER := 0-1962.0724
25     , p7_a14  NUMBER := 0-1962.0724
26     , p7_a15  NUMBER := 0-1962.0724
27     , p7_a16  NUMBER := 0-1962.0724
28     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
29     , p7_a18  NUMBER := 0-1962.0724
30     , p7_a19  NUMBER := 0-1962.0724
31     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
32     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
33     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
34     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
35     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
36     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
37     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
38     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
39     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
40     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
41     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
42     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
43     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
44     , p7_a33  VARCHAR2 := fnd_api.g_miss_char
45     , p7_a34  VARCHAR2 := fnd_api.g_miss_char
46     , p7_a35  VARCHAR2 := fnd_api.g_miss_char
47     , p7_a36  NUMBER := 0-1962.0724
48     , p7_a37  VARCHAR2 := fnd_api.g_miss_char
49     , p7_a38  NUMBER := 0-1962.0724
50     , p7_a39  NUMBER := 0-1962.0724
51     , p7_a40  NUMBER := 0-1962.0724
52     , p7_a41  VARCHAR2 := fnd_api.g_miss_char
53   );
54   procedure update_act_product(p_api_version  NUMBER
55     , p_init_msg_list  VARCHAR2
56     , p_commit  VARCHAR2
57     , p_validation_level  NUMBER
58     , x_return_status OUT NOCOPY  VARCHAR2
59     , x_msg_count OUT NOCOPY  NUMBER
60     , x_msg_data OUT NOCOPY  VARCHAR2
61     , p7_a0  NUMBER := 0-1962.0724
62     , p7_a1  DATE := fnd_api.g_miss_date
63     , p7_a2  NUMBER := 0-1962.0724
64     , p7_a3  DATE := fnd_api.g_miss_date
65     , p7_a4  NUMBER := 0-1962.0724
66     , p7_a5  NUMBER := 0-1962.0724
67     , p7_a6  NUMBER := 0-1962.0724
68     , p7_a7  NUMBER := 0-1962.0724
69     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
71     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
72     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
73     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a13  NUMBER := 0-1962.0724
75     , p7_a14  NUMBER := 0-1962.0724
76     , p7_a15  NUMBER := 0-1962.0724
77     , p7_a16  NUMBER := 0-1962.0724
78     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
79     , p7_a18  NUMBER := 0-1962.0724
80     , p7_a19  NUMBER := 0-1962.0724
81     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
82     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
83     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
84     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
86     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
87     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
88     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
89     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
90     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
91     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
92     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a33  VARCHAR2 := fnd_api.g_miss_char
95     , p7_a34  VARCHAR2 := fnd_api.g_miss_char
96     , p7_a35  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a36  NUMBER := 0-1962.0724
98     , p7_a37  VARCHAR2 := fnd_api.g_miss_char
99     , p7_a38  NUMBER := 0-1962.0724
100     , p7_a39  NUMBER := 0-1962.0724
101     , p7_a40  NUMBER := 0-1962.0724
102     , p7_a41  VARCHAR2 := fnd_api.g_miss_char
103   );
104   procedure validate_act_product(p_api_version  NUMBER
105     , p_init_msg_list  VARCHAR2
106     , p_validation_level  NUMBER
107     , x_return_status OUT NOCOPY  VARCHAR2
108     , x_msg_count OUT NOCOPY  NUMBER
109     , x_msg_data OUT NOCOPY  VARCHAR2
110     , p6_a0  NUMBER := 0-1962.0724
111     , p6_a1  DATE := fnd_api.g_miss_date
112     , p6_a2  NUMBER := 0-1962.0724
113     , p6_a3  DATE := fnd_api.g_miss_date
114     , p6_a4  NUMBER := 0-1962.0724
115     , p6_a5  NUMBER := 0-1962.0724
116     , p6_a6  NUMBER := 0-1962.0724
117     , p6_a7  NUMBER := 0-1962.0724
118     , p6_a8  VARCHAR2 := fnd_api.g_miss_char
119     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
120     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
121     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
122     , p6_a12  VARCHAR2 := fnd_api.g_miss_char
123     , p6_a13  NUMBER := 0-1962.0724
124     , p6_a14  NUMBER := 0-1962.0724
125     , p6_a15  NUMBER := 0-1962.0724
126     , p6_a16  NUMBER := 0-1962.0724
127     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
128     , p6_a18  NUMBER := 0-1962.0724
129     , p6_a19  NUMBER := 0-1962.0724
130     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
131     , p6_a21  VARCHAR2 := fnd_api.g_miss_char
132     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
133     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
134     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
135     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
136     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
137     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
138     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
139     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
140     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
141     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
142     , p6_a32  VARCHAR2 := fnd_api.g_miss_char
143     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
144     , p6_a34  VARCHAR2 := fnd_api.g_miss_char
145     , p6_a35  VARCHAR2 := fnd_api.g_miss_char
146     , p6_a36  NUMBER := 0-1962.0724
147     , p6_a37  VARCHAR2 := fnd_api.g_miss_char
148     , p6_a38  NUMBER := 0-1962.0724
149     , p6_a39  NUMBER := 0-1962.0724
150     , p6_a40  NUMBER := 0-1962.0724
151     , p6_a41  VARCHAR2 := fnd_api.g_miss_char
152   );
153   procedure validate_act_product_items(p_validation_mode  VARCHAR2
154     , x_return_status OUT NOCOPY  VARCHAR2
155     , p0_a0  NUMBER := 0-1962.0724
156     , p0_a1  DATE := fnd_api.g_miss_date
157     , p0_a2  NUMBER := 0-1962.0724
158     , p0_a3  DATE := fnd_api.g_miss_date
159     , p0_a4  NUMBER := 0-1962.0724
160     , p0_a5  NUMBER := 0-1962.0724
161     , p0_a6  NUMBER := 0-1962.0724
162     , p0_a7  NUMBER := 0-1962.0724
163     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
164     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
165     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
166     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
167     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
168     , p0_a13  NUMBER := 0-1962.0724
169     , p0_a14  NUMBER := 0-1962.0724
170     , p0_a15  NUMBER := 0-1962.0724
171     , p0_a16  NUMBER := 0-1962.0724
172     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
173     , p0_a18  NUMBER := 0-1962.0724
174     , p0_a19  NUMBER := 0-1962.0724
175     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
176     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
177     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
178     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
179     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
180     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
181     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
182     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
183     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
184     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
185     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
186     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
187     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
188     , p0_a33  VARCHAR2 := fnd_api.g_miss_char
189     , p0_a34  VARCHAR2 := fnd_api.g_miss_char
190     , p0_a35  VARCHAR2 := fnd_api.g_miss_char
191     , p0_a36  NUMBER := 0-1962.0724
192     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
193     , p0_a38  NUMBER := 0-1962.0724
194     , p0_a39  NUMBER := 0-1962.0724
195     , p0_a40  NUMBER := 0-1962.0724
196     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
197   );
198   procedure validate_act_product_record(x_return_status OUT NOCOPY  VARCHAR2
199     , p0_a0  NUMBER := 0-1962.0724
200     , p0_a1  DATE := fnd_api.g_miss_date
201     , p0_a2  NUMBER := 0-1962.0724
202     , p0_a3  DATE := fnd_api.g_miss_date
203     , p0_a4  NUMBER := 0-1962.0724
204     , p0_a5  NUMBER := 0-1962.0724
205     , p0_a6  NUMBER := 0-1962.0724
206     , p0_a7  NUMBER := 0-1962.0724
207     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
208     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
209     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
210     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
211     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
212     , p0_a13  NUMBER := 0-1962.0724
213     , p0_a14  NUMBER := 0-1962.0724
214     , p0_a15  NUMBER := 0-1962.0724
215     , p0_a16  NUMBER := 0-1962.0724
216     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
217     , p0_a18  NUMBER := 0-1962.0724
218     , p0_a19  NUMBER := 0-1962.0724
219     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
220     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
221     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
222     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
223     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
224     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
225     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
226     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
227     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
228     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
229     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
230     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
231     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
232     , p0_a33  VARCHAR2 := fnd_api.g_miss_char
233     , p0_a34  VARCHAR2 := fnd_api.g_miss_char
234     , p0_a35  VARCHAR2 := fnd_api.g_miss_char
235     , p0_a36  NUMBER := 0-1962.0724
236     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
237     , p0_a38  NUMBER := 0-1962.0724
238     , p0_a39  NUMBER := 0-1962.0724
239     , p0_a40  NUMBER := 0-1962.0724
240     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
241   );
242   procedure complete_act_product_rec(p1_a0 OUT NOCOPY  NUMBER
243     , p1_a1 OUT NOCOPY  DATE
244     , p1_a2 OUT NOCOPY  NUMBER
245     , p1_a3 OUT NOCOPY  DATE
246     , p1_a4 OUT NOCOPY  NUMBER
247     , p1_a5 OUT NOCOPY  NUMBER
248     , p1_a6 OUT NOCOPY  NUMBER
249     , p1_a7 OUT NOCOPY  NUMBER
250     , p1_a8 OUT NOCOPY  VARCHAR2
251     , p1_a9 OUT NOCOPY  VARCHAR2
252     , p1_a10 OUT NOCOPY  VARCHAR2
253     , p1_a11 OUT NOCOPY  VARCHAR2
254     , p1_a12 OUT NOCOPY  VARCHAR2
255     , p1_a13 OUT NOCOPY  NUMBER
256     , p1_a14 OUT NOCOPY  NUMBER
257     , p1_a15 OUT NOCOPY  NUMBER
258     , p1_a16 OUT NOCOPY  NUMBER
259     , p1_a17 OUT NOCOPY  VARCHAR2
260     , p1_a18 OUT NOCOPY  NUMBER
261     , p1_a19 OUT NOCOPY  NUMBER
262     , p1_a20 OUT NOCOPY  VARCHAR2
263     , p1_a21 OUT NOCOPY  VARCHAR2
264     , p1_a22 OUT NOCOPY  VARCHAR2
265     , p1_a23 OUT NOCOPY  VARCHAR2
266     , p1_a24 OUT NOCOPY  VARCHAR2
267     , p1_a25 OUT NOCOPY  VARCHAR2
268     , p1_a26 OUT NOCOPY  VARCHAR2
269     , p1_a27 OUT NOCOPY  VARCHAR2
270     , p1_a28 OUT NOCOPY  VARCHAR2
271     , p1_a29 OUT NOCOPY  VARCHAR2
272     , p1_a30 OUT NOCOPY  VARCHAR2
273     , p1_a31 OUT NOCOPY  VARCHAR2
274     , p1_a32 OUT NOCOPY  VARCHAR2
275     , p1_a33 OUT NOCOPY  VARCHAR2
276     , p1_a34 OUT NOCOPY  VARCHAR2
277     , p1_a35 OUT NOCOPY  VARCHAR2
278     , p1_a36 OUT NOCOPY  NUMBER
279     , p1_a37 OUT NOCOPY  VARCHAR2
280     , p1_a38 OUT NOCOPY  NUMBER
281     , p1_a39 OUT NOCOPY  NUMBER
282     , p1_a40 OUT NOCOPY  NUMBER
283     , p1_a41 OUT NOCOPY  VARCHAR2
284     , p0_a0  NUMBER := 0-1962.0724
285     , p0_a1  DATE := fnd_api.g_miss_date
286     , p0_a2  NUMBER := 0-1962.0724
287     , p0_a3  DATE := fnd_api.g_miss_date
288     , p0_a4  NUMBER := 0-1962.0724
289     , p0_a5  NUMBER := 0-1962.0724
290     , p0_a6  NUMBER := 0-1962.0724
291     , p0_a7  NUMBER := 0-1962.0724
292     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
293     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
294     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
295     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
296     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
297     , p0_a13  NUMBER := 0-1962.0724
298     , p0_a14  NUMBER := 0-1962.0724
299     , p0_a15  NUMBER := 0-1962.0724
300     , p0_a16  NUMBER := 0-1962.0724
301     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
302     , p0_a18  NUMBER := 0-1962.0724
303     , p0_a19  NUMBER := 0-1962.0724
304     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
305     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
306     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
307     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
308     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
309     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
310     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
311     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
312     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
313     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
314     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
315     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
316     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
317     , p0_a33  VARCHAR2 := fnd_api.g_miss_char
318     , p0_a34  VARCHAR2 := fnd_api.g_miss_char
319     , p0_a35  VARCHAR2 := fnd_api.g_miss_char
320     , p0_a36  NUMBER := 0-1962.0724
321     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
322     , p0_a38  NUMBER := 0-1962.0724
323     , p0_a39  NUMBER := 0-1962.0724
324     , p0_a40  NUMBER := 0-1962.0724
325     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
326   );
327 end ams_actproduct_pvt_w;