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_CNT_POINT_PVT_W

Source


1 package ams_cnt_point_pvt_w as
2   /* $Header: amswcons.pls 120.0 2005/05/31 21:22:58 appldev noship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ams_cnt_point_pvt.cnt_point_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_DATE_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_300
14     , a11 JTF_VARCHAR2_TABLE_200
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_VARCHAR2_TABLE_200
17     , a14 JTF_VARCHAR2_TABLE_300
18     , a15 JTF_VARCHAR2_TABLE_200
19     , a16 JTF_VARCHAR2_TABLE_200
20     , a17 JTF_VARCHAR2_TABLE_200
21     , a18 JTF_VARCHAR2_TABLE_200
22     , a19 JTF_VARCHAR2_TABLE_200
23     , a20 JTF_VARCHAR2_TABLE_200
24     , a21 JTF_VARCHAR2_TABLE_200
25     , a22 JTF_VARCHAR2_TABLE_200
26     , a23 JTF_VARCHAR2_TABLE_200
27     , a24 JTF_VARCHAR2_TABLE_200
28     , a25 JTF_VARCHAR2_TABLE_200
29     , a26 JTF_VARCHAR2_TABLE_200
30     , a27 JTF_VARCHAR2_TABLE_200
31     , a28 JTF_VARCHAR2_TABLE_200
32     , a29 JTF_VARCHAR2_TABLE_200
33     , a30 JTF_NUMBER_TABLE
34     );
35   procedure rosetta_table_copy_out_p3(t ams_cnt_point_pvt.cnt_point_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36     , a1 out nocopy JTF_DATE_TABLE
37     , a2 out nocopy JTF_NUMBER_TABLE
38     , a3 out nocopy JTF_DATE_TABLE
39     , a4 out nocopy JTF_NUMBER_TABLE
40     , a5 out nocopy JTF_NUMBER_TABLE
41     , a6 out nocopy JTF_NUMBER_TABLE
42     , a7 out nocopy JTF_VARCHAR2_TABLE_100
43     , a8 out nocopy JTF_NUMBER_TABLE
44     , a9 out nocopy JTF_VARCHAR2_TABLE_100
45     , a10 out nocopy JTF_VARCHAR2_TABLE_300
46     , a11 out nocopy JTF_VARCHAR2_TABLE_200
47     , a12 out nocopy JTF_NUMBER_TABLE
48     , a13 out nocopy JTF_VARCHAR2_TABLE_200
49     , a14 out nocopy JTF_VARCHAR2_TABLE_300
50     , a15 out nocopy JTF_VARCHAR2_TABLE_200
51     , a16 out nocopy JTF_VARCHAR2_TABLE_200
52     , a17 out nocopy JTF_VARCHAR2_TABLE_200
53     , a18 out nocopy JTF_VARCHAR2_TABLE_200
54     , a19 out nocopy JTF_VARCHAR2_TABLE_200
55     , a20 out nocopy JTF_VARCHAR2_TABLE_200
56     , a21 out nocopy JTF_VARCHAR2_TABLE_200
57     , a22 out nocopy JTF_VARCHAR2_TABLE_200
58     , a23 out nocopy JTF_VARCHAR2_TABLE_200
59     , a24 out nocopy JTF_VARCHAR2_TABLE_200
60     , a25 out nocopy JTF_VARCHAR2_TABLE_200
61     , a26 out nocopy JTF_VARCHAR2_TABLE_200
62     , a27 out nocopy JTF_VARCHAR2_TABLE_200
63     , a28 out nocopy JTF_VARCHAR2_TABLE_200
64     , a29 out nocopy JTF_VARCHAR2_TABLE_200
65     , a30 out nocopy JTF_NUMBER_TABLE
66     );
67 
68   procedure create_cnt_point(p_api_version_number  NUMBER
69     , p_init_msg_list  VARCHAR2
70     , p_commit  VARCHAR2
71     , p_validation_level  NUMBER
72     , x_return_status out nocopy  VARCHAR2
73     , x_msg_count out nocopy  NUMBER
74     , x_msg_data out nocopy  VARCHAR2
75     , x_contact_point_id out nocopy  NUMBER
76     , p7_a0  NUMBER := 0-1962.0724
77     , p7_a1  DATE := fnd_api.g_miss_date
78     , p7_a2  NUMBER := 0-1962.0724
79     , p7_a3  DATE := fnd_api.g_miss_date
80     , p7_a4  NUMBER := 0-1962.0724
81     , p7_a5  NUMBER := 0-1962.0724
82     , p7_a6  NUMBER := 0-1962.0724
83     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
84     , p7_a8  NUMBER := 0-1962.0724
85     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
86     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
87     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
88     , p7_a12  NUMBER := 0-1962.0724
89     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
90     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
91     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
92     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
95     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
96     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
98     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
99     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
100     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
101     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
102     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
103     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
104     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
105     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
106     , p7_a30  NUMBER := 0-1962.0724
107   );
108   procedure update_cnt_point(p_api_version_number  NUMBER
109     , p_init_msg_list  VARCHAR2
110     , p_commit  VARCHAR2
111     , p_validation_level  NUMBER
112     , x_return_status out nocopy  VARCHAR2
113     , x_msg_count out nocopy  NUMBER
114     , x_msg_data out nocopy  VARCHAR2
115     , x_object_version_number out nocopy  NUMBER
116     , p7_a0  NUMBER := 0-1962.0724
117     , p7_a1  DATE := fnd_api.g_miss_date
118     , p7_a2  NUMBER := 0-1962.0724
119     , p7_a3  DATE := fnd_api.g_miss_date
120     , p7_a4  NUMBER := 0-1962.0724
121     , p7_a5  NUMBER := 0-1962.0724
122     , p7_a6  NUMBER := 0-1962.0724
123     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
124     , p7_a8  NUMBER := 0-1962.0724
125     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
126     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
127     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
128     , p7_a12  NUMBER := 0-1962.0724
129     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
130     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
131     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
132     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
133     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
134     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
135     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
136     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
137     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
138     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
139     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
140     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
141     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
142     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
143     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
144     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
145     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
146     , p7_a30  NUMBER := 0-1962.0724
147   );
148   procedure validate_cnt_point(p_api_version_number  NUMBER
149     , p_init_msg_list  VARCHAR2
150     , p_validation_level  NUMBER
151     , p_validation_mode  VARCHAR2
152     , x_return_status out nocopy  VARCHAR2
153     , x_msg_count out nocopy  NUMBER
154     , x_msg_data out nocopy  VARCHAR2
155     , p4_a0  NUMBER := 0-1962.0724
156     , p4_a1  DATE := fnd_api.g_miss_date
157     , p4_a2  NUMBER := 0-1962.0724
158     , p4_a3  DATE := fnd_api.g_miss_date
159     , p4_a4  NUMBER := 0-1962.0724
160     , p4_a5  NUMBER := 0-1962.0724
161     , p4_a6  NUMBER := 0-1962.0724
162     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
163     , p4_a8  NUMBER := 0-1962.0724
164     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
165     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
166     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
167     , p4_a12  NUMBER := 0-1962.0724
168     , p4_a13  VARCHAR2 := fnd_api.g_miss_char
169     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
170     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
171     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
172     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
173     , p4_a18  VARCHAR2 := fnd_api.g_miss_char
174     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
175     , p4_a20  VARCHAR2 := fnd_api.g_miss_char
176     , p4_a21  VARCHAR2 := fnd_api.g_miss_char
177     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
178     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
179     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
180     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
181     , p4_a26  VARCHAR2 := fnd_api.g_miss_char
182     , p4_a27  VARCHAR2 := fnd_api.g_miss_char
183     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
184     , p4_a29  VARCHAR2 := fnd_api.g_miss_char
185     , p4_a30  NUMBER := 0-1962.0724
186   );
187   procedure check_cnt_point_items(p_validation_mode  VARCHAR2
188     , x_return_status out nocopy  VARCHAR2
189     , p0_a0  NUMBER := 0-1962.0724
190     , p0_a1  DATE := fnd_api.g_miss_date
191     , p0_a2  NUMBER := 0-1962.0724
192     , p0_a3  DATE := fnd_api.g_miss_date
193     , p0_a4  NUMBER := 0-1962.0724
194     , p0_a5  NUMBER := 0-1962.0724
195     , p0_a6  NUMBER := 0-1962.0724
196     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
197     , p0_a8  NUMBER := 0-1962.0724
198     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
199     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
200     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
201     , p0_a12  NUMBER := 0-1962.0724
202     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
203     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
204     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
205     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
206     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
207     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
208     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
209     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
210     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
211     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
212     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
213     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
214     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
215     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
216     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
217     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
218     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
219     , p0_a30  NUMBER := 0-1962.0724
220   );
221   procedure validate_cnt_point_rec(p_api_version_number  NUMBER
222     , p_validation_mode  VARCHAR2
223     , p_init_msg_list  VARCHAR2
224     , x_return_status out nocopy  VARCHAR2
225     , x_msg_count out nocopy  NUMBER
226     , x_msg_data out nocopy  VARCHAR2
227     , p6_a0  NUMBER := 0-1962.0724
228     , p6_a1  DATE := fnd_api.g_miss_date
229     , p6_a2  NUMBER := 0-1962.0724
230     , p6_a3  DATE := fnd_api.g_miss_date
231     , p6_a4  NUMBER := 0-1962.0724
232     , p6_a5  NUMBER := 0-1962.0724
233     , p6_a6  NUMBER := 0-1962.0724
234     , p6_a7  VARCHAR2 := fnd_api.g_miss_char
235     , p6_a8  NUMBER := 0-1962.0724
236     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
237     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
238     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
239     , p6_a12  NUMBER := 0-1962.0724
240     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
241     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
242     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
243     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
244     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
245     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
246     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
247     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
248     , p6_a21  VARCHAR2 := fnd_api.g_miss_char
249     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
250     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
251     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
252     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
253     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
254     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
255     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
256     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
257     , p6_a30  NUMBER := 0-1962.0724
258   );
259 end ams_cnt_point_pvt_w;