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_ACT_MARKET_SEGMENTS_PVT_W

Source


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