[Home] [Help]
PACKAGE: APPS.AMS_LIST_SRC_FIELD_PVT_W
Source
1 package ams_list_src_field_pvt_w AUTHID CURRENT_USER as
2 /* $Header: amswlsfs.pls 115.13 2004/03/18 20:29:52 usingh ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ams_list_src_field_pvt.list_src_field_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_100
14 , a11 JTF_VARCHAR2_TABLE_200
15 , a12 JTF_VARCHAR2_TABLE_200
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_VARCHAR2_TABLE_100
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_100
32 );
33 procedure rosetta_table_copy_out_p3(t ams_list_src_field_pvt.list_src_field_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_DATE_TABLE
35 , a2 out nocopy JTF_NUMBER_TABLE
36 , a3 out nocopy JTF_DATE_TABLE
37 , a4 out nocopy JTF_NUMBER_TABLE
38 , a5 out nocopy JTF_NUMBER_TABLE
39 , a6 out nocopy JTF_NUMBER_TABLE
40 , a7 out nocopy JTF_VARCHAR2_TABLE_100
41 , a8 out nocopy JTF_NUMBER_TABLE
42 , a9 out nocopy JTF_VARCHAR2_TABLE_100
43 , a10 out nocopy JTF_VARCHAR2_TABLE_100
44 , a11 out nocopy JTF_VARCHAR2_TABLE_200
45 , a12 out nocopy JTF_VARCHAR2_TABLE_200
46 , a13 out nocopy JTF_VARCHAR2_TABLE_100
47 , a14 out nocopy JTF_NUMBER_TABLE
48 , a15 out nocopy JTF_NUMBER_TABLE
49 , a16 out nocopy JTF_VARCHAR2_TABLE_100
50 , a17 out nocopy JTF_VARCHAR2_TABLE_100
51 , a18 out nocopy JTF_NUMBER_TABLE
52 , a19 out nocopy JTF_VARCHAR2_TABLE_100
53 , a20 out nocopy JTF_NUMBER_TABLE
54 , a21 out nocopy JTF_VARCHAR2_TABLE_100
55 , a22 out nocopy JTF_VARCHAR2_TABLE_100
56 , a23 out nocopy JTF_VARCHAR2_TABLE_100
57 , a24 out nocopy JTF_VARCHAR2_TABLE_100
58 , a25 out nocopy JTF_VARCHAR2_TABLE_100
59 , a26 out nocopy JTF_VARCHAR2_TABLE_100
60 , a27 out nocopy JTF_NUMBER_TABLE
61 , a28 out nocopy JTF_VARCHAR2_TABLE_100
62 );
63
64 procedure create_list_src_field(p_api_version_number NUMBER
65 , p_init_msg_list VARCHAR2
66 , p_commit VARCHAR2
67 , p_validation_level NUMBER
68 , x_return_status out nocopy VARCHAR2
69 , x_msg_count out nocopy NUMBER
70 , x_msg_data out nocopy VARCHAR2
71 , x_list_source_field_id out nocopy NUMBER
72 , p7_a0 NUMBER := 0-1962.0724
73 , p7_a1 DATE := fnd_api.g_miss_date
74 , p7_a2 NUMBER := 0-1962.0724
75 , p7_a3 DATE := fnd_api.g_miss_date
76 , p7_a4 NUMBER := 0-1962.0724
77 , p7_a5 NUMBER := 0-1962.0724
78 , p7_a6 NUMBER := 0-1962.0724
79 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a8 NUMBER := 0-1962.0724
81 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
82 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
85 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a14 NUMBER := 0-1962.0724
87 , p7_a15 NUMBER := 0-1962.0724
88 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
89 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
90 , p7_a18 NUMBER := 0-1962.0724
91 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
92 , p7_a20 NUMBER := 0-1962.0724
93 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
94 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
95 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
97 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
98 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
99 , p7_a27 NUMBER := 0-1962.0724
100 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
101 );
102 procedure update_list_src_field(p_api_version_number NUMBER
103 , p_init_msg_list VARCHAR2
104 , p_commit VARCHAR2
105 , p_validation_level NUMBER
106 , x_return_status out nocopy VARCHAR2
107 , x_msg_count out nocopy NUMBER
108 , x_msg_data out nocopy VARCHAR2
109 , x_object_version_number out nocopy NUMBER
110 , p7_a0 NUMBER := 0-1962.0724
111 , p7_a1 DATE := fnd_api.g_miss_date
112 , p7_a2 NUMBER := 0-1962.0724
113 , p7_a3 DATE := fnd_api.g_miss_date
114 , p7_a4 NUMBER := 0-1962.0724
115 , p7_a5 NUMBER := 0-1962.0724
116 , p7_a6 NUMBER := 0-1962.0724
117 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
118 , p7_a8 NUMBER := 0-1962.0724
119 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
120 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
122 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124 , p7_a14 NUMBER := 0-1962.0724
125 , p7_a15 NUMBER := 0-1962.0724
126 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
127 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
128 , p7_a18 NUMBER := 0-1962.0724
129 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
130 , p7_a20 NUMBER := 0-1962.0724
131 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
132 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
133 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
134 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
135 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
136 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
137 , p7_a27 NUMBER := 0-1962.0724
138 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
139 );
140 procedure validate_list_src_field(p_api_version_number NUMBER
141 , p_init_msg_list VARCHAR2
142 , p_validation_level NUMBER
143 , x_return_status out nocopy VARCHAR2
144 , x_msg_count out nocopy NUMBER
145 , x_msg_data out nocopy VARCHAR2
146 , p3_a0 NUMBER := 0-1962.0724
147 , p3_a1 DATE := fnd_api.g_miss_date
148 , p3_a2 NUMBER := 0-1962.0724
149 , p3_a3 DATE := fnd_api.g_miss_date
150 , p3_a4 NUMBER := 0-1962.0724
151 , p3_a5 NUMBER := 0-1962.0724
152 , p3_a6 NUMBER := 0-1962.0724
153 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
154 , p3_a8 NUMBER := 0-1962.0724
155 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
156 , p3_a10 VARCHAR2 := fnd_api.g_miss_char
157 , p3_a11 VARCHAR2 := fnd_api.g_miss_char
158 , p3_a12 VARCHAR2 := fnd_api.g_miss_char
159 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
160 , p3_a14 NUMBER := 0-1962.0724
161 , p3_a15 NUMBER := 0-1962.0724
162 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
163 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
164 , p3_a18 NUMBER := 0-1962.0724
165 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
166 , p3_a20 NUMBER := 0-1962.0724
167 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
168 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
169 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
170 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
171 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
172 , p3_a26 VARCHAR2 := fnd_api.g_miss_char
173 , p3_a27 NUMBER := 0-1962.0724
174 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
175 );
176 procedure check_list_src_field_items(p_validation_mode VARCHAR2
177 , x_return_status out nocopy VARCHAR2
178 , p0_a0 NUMBER := 0-1962.0724
179 , p0_a1 DATE := fnd_api.g_miss_date
180 , p0_a2 NUMBER := 0-1962.0724
181 , p0_a3 DATE := fnd_api.g_miss_date
182 , p0_a4 NUMBER := 0-1962.0724
183 , p0_a5 NUMBER := 0-1962.0724
184 , p0_a6 NUMBER := 0-1962.0724
185 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
186 , p0_a8 NUMBER := 0-1962.0724
187 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
188 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
189 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
190 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
191 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
192 , p0_a14 NUMBER := 0-1962.0724
193 , p0_a15 NUMBER := 0-1962.0724
194 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
195 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
196 , p0_a18 NUMBER := 0-1962.0724
197 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
198 , p0_a20 NUMBER := 0-1962.0724
199 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
200 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
201 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
202 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
203 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
204 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
205 , p0_a27 NUMBER := 0-1962.0724
206 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
207 );
208 procedure validate_list_src_field_rec(p_api_version_number NUMBER
209 , p_init_msg_list VARCHAR2
210 , x_return_status out nocopy VARCHAR2
211 , x_msg_count out nocopy NUMBER
212 , x_msg_data out nocopy VARCHAR2
213 , p5_a0 NUMBER := 0-1962.0724
214 , p5_a1 DATE := fnd_api.g_miss_date
215 , p5_a2 NUMBER := 0-1962.0724
216 , p5_a3 DATE := fnd_api.g_miss_date
217 , p5_a4 NUMBER := 0-1962.0724
218 , p5_a5 NUMBER := 0-1962.0724
219 , p5_a6 NUMBER := 0-1962.0724
220 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
221 , p5_a8 NUMBER := 0-1962.0724
222 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
223 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
224 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
225 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
226 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
227 , p5_a14 NUMBER := 0-1962.0724
228 , p5_a15 NUMBER := 0-1962.0724
229 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
230 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a18 NUMBER := 0-1962.0724
232 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
233 , p5_a20 NUMBER := 0-1962.0724
234 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
235 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
236 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
237 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
238 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
239 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
240 , p5_a27 NUMBER := 0-1962.0724
241 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
242 );
243 end ams_list_src_field_pvt_w;