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.PVX_LEAD_PSS_LINES_PVT_W

Source


1 package pvx_lead_pss_lines_pvt_w AUTHID CURRENT_USER as
2   /* $Header: pvxwpsss.pls 115.7 2002/11/20 02:05:32 pklin ship $ */
3   procedure create_lead_pss_line(p_api_version_number  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_lead_pss_line_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  NUMBER := 0-1962.0724
20     , p7_a9  NUMBER := 0-1962.0724
21     , p7_a10  DATE := fnd_api.g_miss_date
22     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a12  NUMBER := 0-1962.0724
24     , p7_a13  NUMBER := 0-1962.0724
25     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
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  VARCHAR2 := fnd_api.g_miss_char
30     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
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  NUMBER := 0-1962.0724
45     , p7_a34  NUMBER := 0-1962.0724
46   );
47   procedure update_lead_pss_line(p_api_version_number  NUMBER
48     , p_init_msg_list  VARCHAR2
49     , p_commit  VARCHAR2
50     , p_validation_level  NUMBER
51     , x_return_status out nocopy  VARCHAR2
52     , x_msg_count out nocopy  NUMBER
53     , x_msg_data out nocopy  VARCHAR2
54     , p7_a0  NUMBER := 0-1962.0724
55     , p7_a1  DATE := fnd_api.g_miss_date
56     , p7_a2  NUMBER := 0-1962.0724
57     , p7_a3  DATE := fnd_api.g_miss_date
58     , p7_a4  NUMBER := 0-1962.0724
59     , p7_a5  NUMBER := 0-1962.0724
60     , p7_a6  NUMBER := 0-1962.0724
61     , p7_a7  NUMBER := 0-1962.0724
62     , p7_a8  NUMBER := 0-1962.0724
63     , p7_a9  NUMBER := 0-1962.0724
64     , p7_a10  DATE := fnd_api.g_miss_date
65     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
66     , p7_a12  NUMBER := 0-1962.0724
67     , p7_a13  NUMBER := 0-1962.0724
68     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
69     , p7_a15  NUMBER := 0-1962.0724
70     , p7_a16  NUMBER := 0-1962.0724
71     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
72     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
73     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
75     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
76     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
78     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
79     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
82     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
83     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
84     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
86     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
87     , p7_a33  NUMBER := 0-1962.0724
88     , p7_a34  NUMBER := 0-1962.0724
89   );
90   procedure validate_lead_pss_line(p_api_version_number  NUMBER
91     , p_init_msg_list  VARCHAR2
92     , p_validation_level  NUMBER
93     , x_return_status out nocopy  VARCHAR2
94     , x_msg_count out nocopy  NUMBER
95     , x_msg_data out nocopy  VARCHAR2
96     , p6_a0  NUMBER := 0-1962.0724
97     , p6_a1  DATE := fnd_api.g_miss_date
98     , p6_a2  NUMBER := 0-1962.0724
99     , p6_a3  DATE := fnd_api.g_miss_date
100     , p6_a4  NUMBER := 0-1962.0724
101     , p6_a5  NUMBER := 0-1962.0724
102     , p6_a6  NUMBER := 0-1962.0724
103     , p6_a7  NUMBER := 0-1962.0724
104     , p6_a8  NUMBER := 0-1962.0724
105     , p6_a9  NUMBER := 0-1962.0724
106     , p6_a10  DATE := fnd_api.g_miss_date
107     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
108     , p6_a12  NUMBER := 0-1962.0724
109     , p6_a13  NUMBER := 0-1962.0724
110     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
111     , p6_a15  NUMBER := 0-1962.0724
112     , p6_a16  NUMBER := 0-1962.0724
113     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
114     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
115     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
116     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
117     , p6_a21  VARCHAR2 := fnd_api.g_miss_char
118     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
119     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
120     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
121     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
122     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
123     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
124     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
125     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
126     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
127     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
128     , p6_a32  VARCHAR2 := fnd_api.g_miss_char
129     , p6_a33  NUMBER := 0-1962.0724
130     , p6_a34  NUMBER := 0-1962.0724
131   );
132   procedure check_lead_pss_line_items(p_validation_mode  VARCHAR2
133     , x_return_status out nocopy  VARCHAR2
134     , p2_a0  NUMBER := 0-1962.0724
135     , p2_a1  DATE := fnd_api.g_miss_date
136     , p2_a2  NUMBER := 0-1962.0724
137     , p2_a3  DATE := fnd_api.g_miss_date
138     , p2_a4  NUMBER := 0-1962.0724
139     , p2_a5  NUMBER := 0-1962.0724
140     , p2_a6  NUMBER := 0-1962.0724
141     , p2_a7  NUMBER := 0-1962.0724
142     , p2_a8  NUMBER := 0-1962.0724
143     , p2_a9  NUMBER := 0-1962.0724
144     , p2_a10  DATE := fnd_api.g_miss_date
145     , p2_a11  VARCHAR2 := fnd_api.g_miss_char
146     , p2_a12  NUMBER := 0-1962.0724
147     , p2_a13  NUMBER := 0-1962.0724
148     , p2_a14  VARCHAR2 := fnd_api.g_miss_char
149     , p2_a15  NUMBER := 0-1962.0724
150     , p2_a16  NUMBER := 0-1962.0724
151     , p2_a17  VARCHAR2 := fnd_api.g_miss_char
152     , p2_a18  VARCHAR2 := fnd_api.g_miss_char
153     , p2_a19  VARCHAR2 := fnd_api.g_miss_char
154     , p2_a20  VARCHAR2 := fnd_api.g_miss_char
155     , p2_a21  VARCHAR2 := fnd_api.g_miss_char
156     , p2_a22  VARCHAR2 := fnd_api.g_miss_char
157     , p2_a23  VARCHAR2 := fnd_api.g_miss_char
158     , p2_a24  VARCHAR2 := fnd_api.g_miss_char
159     , p2_a25  VARCHAR2 := fnd_api.g_miss_char
160     , p2_a26  VARCHAR2 := fnd_api.g_miss_char
161     , p2_a27  VARCHAR2 := fnd_api.g_miss_char
162     , p2_a28  VARCHAR2 := fnd_api.g_miss_char
163     , p2_a29  VARCHAR2 := fnd_api.g_miss_char
164     , p2_a30  VARCHAR2 := fnd_api.g_miss_char
165     , p2_a31  VARCHAR2 := fnd_api.g_miss_char
166     , p2_a32  VARCHAR2 := fnd_api.g_miss_char
167     , p2_a33  NUMBER := 0-1962.0724
168     , p2_a34  NUMBER := 0-1962.0724
169   );
170   procedure check_lead_pss_line_record(p_mode  VARCHAR2
171     , x_return_status out nocopy  VARCHAR2
172     , p0_a0  NUMBER := 0-1962.0724
173     , p0_a1  DATE := fnd_api.g_miss_date
174     , p0_a2  NUMBER := 0-1962.0724
175     , p0_a3  DATE := fnd_api.g_miss_date
176     , p0_a4  NUMBER := 0-1962.0724
177     , p0_a5  NUMBER := 0-1962.0724
178     , p0_a6  NUMBER := 0-1962.0724
179     , p0_a7  NUMBER := 0-1962.0724
180     , p0_a8  NUMBER := 0-1962.0724
181     , p0_a9  NUMBER := 0-1962.0724
182     , p0_a10  DATE := fnd_api.g_miss_date
183     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
184     , p0_a12  NUMBER := 0-1962.0724
185     , p0_a13  NUMBER := 0-1962.0724
186     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
187     , p0_a15  NUMBER := 0-1962.0724
188     , p0_a16  NUMBER := 0-1962.0724
189     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
190     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
191     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
192     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
193     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
194     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
195     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
196     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
197     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
198     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
199     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
200     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
201     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
202     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
203     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
204     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
205     , p0_a33  NUMBER := 0-1962.0724
206     , p0_a34  NUMBER := 0-1962.0724
207     , p1_a0  NUMBER := 0-1962.0724
208     , p1_a1  DATE := fnd_api.g_miss_date
209     , p1_a2  NUMBER := 0-1962.0724
210     , p1_a3  DATE := fnd_api.g_miss_date
211     , p1_a4  NUMBER := 0-1962.0724
212     , p1_a5  NUMBER := 0-1962.0724
213     , p1_a6  NUMBER := 0-1962.0724
214     , p1_a7  NUMBER := 0-1962.0724
215     , p1_a8  NUMBER := 0-1962.0724
216     , p1_a9  NUMBER := 0-1962.0724
217     , p1_a10  DATE := fnd_api.g_miss_date
218     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
219     , p1_a12  NUMBER := 0-1962.0724
220     , p1_a13  NUMBER := 0-1962.0724
221     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
222     , p1_a15  NUMBER := 0-1962.0724
223     , p1_a16  NUMBER := 0-1962.0724
224     , p1_a17  VARCHAR2 := fnd_api.g_miss_char
225     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
226     , p1_a19  VARCHAR2 := fnd_api.g_miss_char
227     , p1_a20  VARCHAR2 := fnd_api.g_miss_char
228     , p1_a21  VARCHAR2 := fnd_api.g_miss_char
229     , p1_a22  VARCHAR2 := fnd_api.g_miss_char
230     , p1_a23  VARCHAR2 := fnd_api.g_miss_char
231     , p1_a24  VARCHAR2 := fnd_api.g_miss_char
232     , p1_a25  VARCHAR2 := fnd_api.g_miss_char
233     , p1_a26  VARCHAR2 := fnd_api.g_miss_char
234     , p1_a27  VARCHAR2 := fnd_api.g_miss_char
235     , p1_a28  VARCHAR2 := fnd_api.g_miss_char
236     , p1_a29  VARCHAR2 := fnd_api.g_miss_char
237     , p1_a30  VARCHAR2 := fnd_api.g_miss_char
238     , p1_a31  VARCHAR2 := fnd_api.g_miss_char
239     , p1_a32  VARCHAR2 := fnd_api.g_miss_char
240     , p1_a33  NUMBER := 0-1962.0724
241     , p1_a34  NUMBER := 0-1962.0724
242   );
243   procedure init_lead_pss_line_rec(p0_a0 out nocopy  NUMBER
244     , p0_a1 out nocopy  DATE
245     , p0_a2 out nocopy  NUMBER
246     , p0_a3 out nocopy  DATE
247     , p0_a4 out nocopy  NUMBER
248     , p0_a5 out nocopy  NUMBER
249     , p0_a6 out nocopy  NUMBER
250     , p0_a7 out nocopy  NUMBER
251     , p0_a8 out nocopy  NUMBER
252     , p0_a9 out nocopy  NUMBER
253     , p0_a10 out nocopy  DATE
254     , p0_a11 out nocopy  VARCHAR2
255     , p0_a12 out nocopy  NUMBER
256     , p0_a13 out nocopy  NUMBER
257     , p0_a14 out nocopy  VARCHAR2
258     , p0_a15 out nocopy  NUMBER
259     , p0_a16 out nocopy  NUMBER
260     , p0_a17 out nocopy  VARCHAR2
261     , p0_a18 out nocopy  VARCHAR2
262     , p0_a19 out nocopy  VARCHAR2
263     , p0_a20 out nocopy  VARCHAR2
264     , p0_a21 out nocopy  VARCHAR2
265     , p0_a22 out nocopy  VARCHAR2
266     , p0_a23 out nocopy  VARCHAR2
267     , p0_a24 out nocopy  VARCHAR2
268     , p0_a25 out nocopy  VARCHAR2
269     , p0_a26 out nocopy  VARCHAR2
270     , p0_a27 out nocopy  VARCHAR2
271     , p0_a28 out nocopy  VARCHAR2
272     , p0_a29 out nocopy  VARCHAR2
273     , p0_a30 out nocopy  VARCHAR2
274     , p0_a31 out nocopy  VARCHAR2
275     , p0_a32 out nocopy  VARCHAR2
276     , p0_a33 out nocopy  NUMBER
277     , p0_a34 out nocopy  NUMBER
278   );
279   procedure complete_lead_pss_line_rec(p1_a0 out nocopy  NUMBER
280     , p1_a1 out nocopy  DATE
281     , p1_a2 out nocopy  NUMBER
282     , p1_a3 out nocopy  DATE
283     , p1_a4 out nocopy  NUMBER
284     , p1_a5 out nocopy  NUMBER
285     , p1_a6 out nocopy  NUMBER
286     , p1_a7 out nocopy  NUMBER
287     , p1_a8 out nocopy  NUMBER
288     , p1_a9 out nocopy  NUMBER
289     , p1_a10 out nocopy  DATE
290     , p1_a11 out nocopy  VARCHAR2
291     , p1_a12 out nocopy  NUMBER
292     , p1_a13 out nocopy  NUMBER
293     , p1_a14 out nocopy  VARCHAR2
294     , p1_a15 out nocopy  NUMBER
295     , p1_a16 out nocopy  NUMBER
296     , p1_a17 out nocopy  VARCHAR2
297     , p1_a18 out nocopy  VARCHAR2
298     , p1_a19 out nocopy  VARCHAR2
299     , p1_a20 out nocopy  VARCHAR2
300     , p1_a21 out nocopy  VARCHAR2
301     , p1_a22 out nocopy  VARCHAR2
302     , p1_a23 out nocopy  VARCHAR2
303     , p1_a24 out nocopy  VARCHAR2
304     , p1_a25 out nocopy  VARCHAR2
305     , p1_a26 out nocopy  VARCHAR2
306     , p1_a27 out nocopy  VARCHAR2
307     , p1_a28 out nocopy  VARCHAR2
308     , p1_a29 out nocopy  VARCHAR2
309     , p1_a30 out nocopy  VARCHAR2
310     , p1_a31 out nocopy  VARCHAR2
311     , p1_a32 out nocopy  VARCHAR2
312     , p1_a33 out nocopy  NUMBER
313     , p1_a34 out nocopy  NUMBER
314     , p0_a0  NUMBER := 0-1962.0724
315     , p0_a1  DATE := fnd_api.g_miss_date
316     , p0_a2  NUMBER := 0-1962.0724
317     , p0_a3  DATE := fnd_api.g_miss_date
321     , p0_a7  NUMBER := 0-1962.0724
318     , p0_a4  NUMBER := 0-1962.0724
319     , p0_a5  NUMBER := 0-1962.0724
320     , p0_a6  NUMBER := 0-1962.0724
322     , p0_a8  NUMBER := 0-1962.0724
323     , p0_a9  NUMBER := 0-1962.0724
324     , p0_a10  DATE := fnd_api.g_miss_date
325     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
326     , p0_a12  NUMBER := 0-1962.0724
327     , p0_a13  NUMBER := 0-1962.0724
328     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
329     , p0_a15  NUMBER := 0-1962.0724
330     , p0_a16  NUMBER := 0-1962.0724
331     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
332     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
333     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
334     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
335     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
336     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
337     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
338     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
339     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
340     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
341     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
342     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
343     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
344     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
345     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
346     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
347     , p0_a33  NUMBER := 0-1962.0724
348     , p0_a34  NUMBER := 0-1962.0724
349   );
350 end pvx_lead_pss_lines_pvt_w;