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_CELL_PVT_W

Source


1 package ams_cell_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswcels.pls 115.16 2002/11/22 08:56:54 jieli ship $ */
3   procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_cell_pvt.t_number, a0 JTF_NUMBER_TABLE);
4   procedure rosetta_table_copy_out_p2(t ams_cell_pvt.t_number, a0 OUT NOCOPY JTF_NUMBER_TABLE);
5 
6   procedure create_cell(p_api_version  NUMBER
7     , p_init_msg_list  VARCHAR2
8     , p_commit  VARCHAR2
9     , p_validation_level  NUMBER
10     , x_return_status OUT NOCOPY  VARCHAR2
11     , x_msg_count OUT NOCOPY  NUMBER
12     , x_msg_data OUT NOCOPY  VARCHAR2
13     , x_cell_id OUT NOCOPY  NUMBER
14     , p7_a0  NUMBER := 0-1962.0724
15     , p7_a1  VARCHAR2 := fnd_api.g_miss_char
16     , p7_a2  DATE := fnd_api.g_miss_date
17     , p7_a3  NUMBER := 0-1962.0724
18     , p7_a4  DATE := fnd_api.g_miss_date
19     , p7_a5  NUMBER := 0-1962.0724
20     , p7_a6  NUMBER := 0-1962.0724
21     , p7_a7  NUMBER := 0-1962.0724
22     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
24     , p7_a10  NUMBER := 0-1962.0724
25     , p7_a11  NUMBER := 0-1962.0724
26     , p7_a12  NUMBER := 0-1962.0724
27     , p7_a13  NUMBER := 0-1962.0724
28     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
29     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
30     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
31     , p7_a17  DATE := fnd_api.g_miss_date
32     , p7_a18  NUMBER := 0-1962.0724
33   );
34   procedure update_cell(p_api_version  NUMBER
35     , p_init_msg_list  VARCHAR2
36     , p_commit  VARCHAR2
37     , p_validation_level  NUMBER
38     , x_return_status OUT NOCOPY  VARCHAR2
39     , x_msg_count OUT NOCOPY  NUMBER
40     , x_msg_data OUT NOCOPY  VARCHAR2
41     , p7_a0  NUMBER := 0-1962.0724
42     , p7_a1  VARCHAR2 := fnd_api.g_miss_char
43     , p7_a2  DATE := fnd_api.g_miss_date
44     , p7_a3  NUMBER := 0-1962.0724
45     , p7_a4  DATE := fnd_api.g_miss_date
46     , p7_a5  NUMBER := 0-1962.0724
47     , p7_a6  NUMBER := 0-1962.0724
48     , p7_a7  NUMBER := 0-1962.0724
49     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
50     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
51     , p7_a10  NUMBER := 0-1962.0724
52     , p7_a11  NUMBER := 0-1962.0724
53     , p7_a12  NUMBER := 0-1962.0724
54     , p7_a13  NUMBER := 0-1962.0724
55     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
56     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
57     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
58     , p7_a17  DATE := fnd_api.g_miss_date
59     , p7_a18  NUMBER := 0-1962.0724
60   );
61   procedure validate_cell(p_api_version  NUMBER
62     , p_init_msg_list  VARCHAR2
63     , p_validation_level  NUMBER
64     , x_return_status OUT NOCOPY  VARCHAR2
65     , x_msg_count OUT NOCOPY  NUMBER
66     , x_msg_data OUT NOCOPY  VARCHAR2
67     , p6_a0  NUMBER := 0-1962.0724
68     , p6_a1  VARCHAR2 := fnd_api.g_miss_char
69     , p6_a2  DATE := fnd_api.g_miss_date
70     , p6_a3  NUMBER := 0-1962.0724
71     , p6_a4  DATE := fnd_api.g_miss_date
72     , p6_a5  NUMBER := 0-1962.0724
73     , p6_a6  NUMBER := 0-1962.0724
74     , p6_a7  NUMBER := 0-1962.0724
75     , p6_a8  VARCHAR2 := fnd_api.g_miss_char
76     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
77     , p6_a10  NUMBER := 0-1962.0724
78     , p6_a11  NUMBER := 0-1962.0724
79     , p6_a12  NUMBER := 0-1962.0724
80     , p6_a13  NUMBER := 0-1962.0724
81     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
82     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
83     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
84     , p6_a17  DATE := fnd_api.g_miss_date
85     , p6_a18  NUMBER := 0-1962.0724
86   );
87   procedure check_cell_items(p_validation_mode  VARCHAR2
88     , x_return_status OUT NOCOPY  VARCHAR2
89     , p0_a0  NUMBER := 0-1962.0724
90     , p0_a1  VARCHAR2 := fnd_api.g_miss_char
91     , p0_a2  DATE := fnd_api.g_miss_date
92     , p0_a3  NUMBER := 0-1962.0724
93     , p0_a4  DATE := fnd_api.g_miss_date
94     , p0_a5  NUMBER := 0-1962.0724
95     , p0_a6  NUMBER := 0-1962.0724
96     , p0_a7  NUMBER := 0-1962.0724
97     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
98     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
99     , p0_a10  NUMBER := 0-1962.0724
100     , p0_a11  NUMBER := 0-1962.0724
101     , p0_a12  NUMBER := 0-1962.0724
102     , p0_a13  NUMBER := 0-1962.0724
103     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
104     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
105     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
106     , p0_a17  DATE := fnd_api.g_miss_date
107     , p0_a18  NUMBER := 0-1962.0724
108   );
109   procedure init_cell_rec(p0_a0 OUT NOCOPY  NUMBER
110     , p0_a1 OUT NOCOPY  VARCHAR2
111     , p0_a2 OUT NOCOPY  DATE
112     , p0_a3 OUT NOCOPY  NUMBER
113     , p0_a4 OUT NOCOPY  DATE
114     , p0_a5 OUT NOCOPY  NUMBER
115     , p0_a6 OUT NOCOPY  NUMBER
116     , p0_a7 OUT NOCOPY  NUMBER
117     , p0_a8 OUT NOCOPY  VARCHAR2
118     , p0_a9 OUT NOCOPY  VARCHAR2
119     , p0_a10 OUT NOCOPY  NUMBER
120     , p0_a11 OUT NOCOPY  NUMBER
121     , p0_a12 OUT NOCOPY  NUMBER
122     , p0_a13 OUT NOCOPY  NUMBER
123     , p0_a14 OUT NOCOPY  VARCHAR2
124     , p0_a15 OUT NOCOPY  VARCHAR2
125     , p0_a16 OUT NOCOPY  VARCHAR2
126     , p0_a17 OUT NOCOPY  DATE
127     , p0_a18 OUT NOCOPY  NUMBER
128   );
129   procedure complete_cell_rec(p1_a0 OUT NOCOPY  NUMBER
130     , p1_a1 OUT NOCOPY  VARCHAR2
131     , p1_a2 OUT NOCOPY  DATE
132     , p1_a3 OUT NOCOPY  NUMBER
133     , p1_a4 OUT NOCOPY  DATE
134     , p1_a5 OUT NOCOPY  NUMBER
135     , p1_a6 OUT NOCOPY  NUMBER
136     , p1_a7 OUT NOCOPY  NUMBER
137     , p1_a8 OUT NOCOPY  VARCHAR2
138     , p1_a9 OUT NOCOPY  VARCHAR2
139     , p1_a10 OUT NOCOPY  NUMBER
140     , p1_a11 OUT NOCOPY  NUMBER
141     , p1_a12 OUT NOCOPY  NUMBER
142     , p1_a13 OUT NOCOPY  NUMBER
143     , p1_a14 OUT NOCOPY  VARCHAR2
144     , p1_a15 OUT NOCOPY  VARCHAR2
145     , p1_a16 OUT NOCOPY  VARCHAR2
146     , p1_a17 OUT NOCOPY  DATE
147     , p1_a18 OUT NOCOPY  NUMBER
148     , p0_a0  NUMBER := 0-1962.0724
149     , p0_a1  VARCHAR2 := fnd_api.g_miss_char
150     , p0_a2  DATE := fnd_api.g_miss_date
151     , p0_a3  NUMBER := 0-1962.0724
152     , p0_a4  DATE := fnd_api.g_miss_date
153     , p0_a5  NUMBER := 0-1962.0724
154     , p0_a6  NUMBER := 0-1962.0724
155     , p0_a7  NUMBER := 0-1962.0724
156     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
157     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
158     , p0_a10  NUMBER := 0-1962.0724
159     , p0_a11  NUMBER := 0-1962.0724
160     , p0_a12  NUMBER := 0-1962.0724
161     , p0_a13  NUMBER := 0-1962.0724
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  DATE := fnd_api.g_miss_date
166     , p0_a18  NUMBER := 0-1962.0724
167   );
168   procedure create_sql_cell(p_api_version  NUMBER
169     , p_init_msg_list  VARCHAR2
170     , p_commit  VARCHAR2
171     , p_validation_level  NUMBER
172     , x_return_status OUT NOCOPY  VARCHAR2
173     , x_msg_count OUT NOCOPY  NUMBER
174     , x_msg_data OUT NOCOPY  VARCHAR2
175     , x_cell_id OUT NOCOPY  NUMBER
176     , p7_a0  NUMBER := 0-1962.0724
177     , p7_a1  VARCHAR2 := fnd_api.g_miss_char
178     , p7_a2  DATE := fnd_api.g_miss_date
179     , p7_a3  NUMBER := 0-1962.0724
180     , p7_a4  DATE := fnd_api.g_miss_date
181     , p7_a5  NUMBER := 0-1962.0724
182     , p7_a6  NUMBER := 0-1962.0724
183     , p7_a7  NUMBER := 0-1962.0724
184     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
185     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
186     , p7_a10  NUMBER := 0-1962.0724
187     , p7_a11  NUMBER := 0-1962.0724
188     , p7_a12  NUMBER := 0-1962.0724
189     , p7_a13  NUMBER := 0-1962.0724
190     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
191     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
192     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
193     , p7_a17  DATE := fnd_api.g_miss_date
194     , p7_a18  NUMBER := 0-1962.0724
195     , p7_a19  NUMBER := 0-1962.0724
196     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
197     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
198     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
199     , p7_a23  NUMBER := 0-1962.0724
200     , p7_a24  NUMBER := 0-1962.0724
201     , p7_a25  NUMBER := 0-1962.0724
202     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
203     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
204     , p7_a28  NUMBER := 0-1962.0724
205   );
206   procedure update_sql_cell(p_api_version  NUMBER
207     , p_init_msg_list  VARCHAR2
208     , p_commit  VARCHAR2
209     , p_validation_level  NUMBER
210     , x_return_status OUT NOCOPY  VARCHAR2
211     , x_msg_count OUT NOCOPY  NUMBER
212     , x_msg_data OUT NOCOPY  VARCHAR2
213     , p7_a0  NUMBER := 0-1962.0724
214     , p7_a1  VARCHAR2 := fnd_api.g_miss_char
215     , p7_a2  DATE := fnd_api.g_miss_date
216     , p7_a3  NUMBER := 0-1962.0724
217     , p7_a4  DATE := fnd_api.g_miss_date
218     , p7_a5  NUMBER := 0-1962.0724
219     , p7_a6  NUMBER := 0-1962.0724
220     , p7_a7  NUMBER := 0-1962.0724
221     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
222     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
223     , p7_a10  NUMBER := 0-1962.0724
224     , p7_a11  NUMBER := 0-1962.0724
225     , p7_a12  NUMBER := 0-1962.0724
226     , p7_a13  NUMBER := 0-1962.0724
227     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
228     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
229     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
230     , p7_a17  DATE := fnd_api.g_miss_date
231     , p7_a18  NUMBER := 0-1962.0724
232     , p7_a19  NUMBER := 0-1962.0724
233     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
234     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
235     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
236     , p7_a23  NUMBER := 0-1962.0724
237     , p7_a24  NUMBER := 0-1962.0724
238     , p7_a25  NUMBER := 0-1962.0724
239     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
240     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
241     , p7_a28  NUMBER := 0-1962.0724
242   );
243 end ams_cell_pvt_w;