[Home] [Help]
PACKAGE: APPS.AHL_FMP_PVT_W
Source
1 package ahl_fmp_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWFMPS.pls 120.2.12020000.3 2013/04/01 02:06:13 sracha ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_4000
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_400
8 , a5 JTF_VARCHAR2_TABLE_300
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_VARCHAR2_TABLE_100
15 );
16 procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
17 , a1 out nocopy JTF_VARCHAR2_TABLE_100
18 , a2 out nocopy JTF_VARCHAR2_TABLE_4000
19 , a3 out nocopy JTF_VARCHAR2_TABLE_100
20 , a4 out nocopy JTF_VARCHAR2_TABLE_400
21 , a5 out nocopy JTF_VARCHAR2_TABLE_300
22 , a6 out nocopy JTF_VARCHAR2_TABLE_100
23 , a7 out nocopy JTF_NUMBER_TABLE
24 , a8 out nocopy JTF_NUMBER_TABLE
25 , a9 out nocopy JTF_NUMBER_TABLE
26 , a10 out nocopy JTF_NUMBER_TABLE
27 , a11 out nocopy JTF_VARCHAR2_TABLE_100
28 );
29
30 procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
31 , a1 JTF_NUMBER_TABLE
32 , a2 JTF_NUMBER_TABLE
33 , a3 JTF_VARCHAR2_TABLE_100
34 , a4 JTF_VARCHAR2_TABLE_100
35 , a5 JTF_NUMBER_TABLE
36 , a6 JTF_VARCHAR2_TABLE_100
37 , a7 JTF_VARCHAR2_TABLE_100
38 , a8 JTF_NUMBER_TABLE
39 , a9 JTF_VARCHAR2_TABLE_100
40 , a10 JTF_NUMBER_TABLE
41 , a11 JTF_NUMBER_TABLE
42 );
43 procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44 , a1 out nocopy JTF_NUMBER_TABLE
45 , a2 out nocopy JTF_NUMBER_TABLE
46 , a3 out nocopy JTF_VARCHAR2_TABLE_100
47 , a4 out nocopy JTF_VARCHAR2_TABLE_100
48 , a5 out nocopy JTF_NUMBER_TABLE
49 , a6 out nocopy JTF_VARCHAR2_TABLE_100
50 , a7 out nocopy JTF_VARCHAR2_TABLE_100
51 , a8 out nocopy JTF_NUMBER_TABLE
52 , a9 out nocopy JTF_VARCHAR2_TABLE_100
53 , a10 out nocopy JTF_NUMBER_TABLE
54 , a11 out nocopy JTF_NUMBER_TABLE
55 );
56
57 procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
58 , a1 JTF_NUMBER_TABLE
59 , a2 JTF_NUMBER_TABLE
60 , a3 JTF_NUMBER_TABLE
61 , a4 JTF_NUMBER_TABLE
62 , a5 JTF_VARCHAR2_TABLE_100
63 , a6 JTF_VARCHAR2_TABLE_100
64 , a7 JTF_VARCHAR2_TABLE_100
65 , a8 JTF_VARCHAR2_TABLE_100
66 , a9 JTF_VARCHAR2_TABLE_100
67 );
68 procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69 , a1 out nocopy JTF_NUMBER_TABLE
70 , a2 out nocopy JTF_NUMBER_TABLE
71 , a3 out nocopy JTF_NUMBER_TABLE
72 , a4 out nocopy JTF_NUMBER_TABLE
73 , a5 out nocopy JTF_VARCHAR2_TABLE_100
74 , a6 out nocopy JTF_VARCHAR2_TABLE_100
75 , a7 out nocopy JTF_VARCHAR2_TABLE_100
76 , a8 out nocopy JTF_VARCHAR2_TABLE_100
77 , a9 out nocopy JTF_VARCHAR2_TABLE_100
78 );
79
80 procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
81 , a1 JTF_VARCHAR2_TABLE_200
82 , a2 JTF_VARCHAR2_TABLE_200
83 , a3 JTF_VARCHAR2_TABLE_100
84 , a4 JTF_NUMBER_TABLE
85 , a5 JTF_VARCHAR2_TABLE_300
86 , a6 JTF_VARCHAR2_TABLE_300
87 , a7 JTF_NUMBER_TABLE
88 , a8 JTF_VARCHAR2_TABLE_200
89 , a9 JTF_VARCHAR2_TABLE_2000
90 , a10 JTF_VARCHAR2_TABLE_100
91 , a11 JTF_VARCHAR2_TABLE_100
92 , a12 JTF_NUMBER_TABLE
93 , a13 JTF_DATE_TABLE
94 , a14 JTF_DATE_TABLE
95 , a15 JTF_VARCHAR2_TABLE_100
96 , a16 JTF_VARCHAR2_TABLE_100
97 , a17 JTF_DATE_TABLE
98 , a18 JTF_DATE_TABLE
99 , a19 JTF_VARCHAR2_TABLE_100
100 , a20 JTF_VARCHAR2_TABLE_2000
101 , a21 JTF_DATE_TABLE
102 , a22 JTF_VARCHAR2_TABLE_100
103 , a23 JTF_VARCHAR2_TABLE_500
104 , a24 JTF_NUMBER_TABLE
105 );
106 procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107 , a1 out nocopy JTF_VARCHAR2_TABLE_200
108 , a2 out nocopy JTF_VARCHAR2_TABLE_200
109 , a3 out nocopy JTF_VARCHAR2_TABLE_100
110 , a4 out nocopy JTF_NUMBER_TABLE
111 , a5 out nocopy JTF_VARCHAR2_TABLE_300
112 , a6 out nocopy JTF_VARCHAR2_TABLE_300
113 , a7 out nocopy JTF_NUMBER_TABLE
114 , a8 out nocopy JTF_VARCHAR2_TABLE_200
115 , a9 out nocopy JTF_VARCHAR2_TABLE_2000
116 , a10 out nocopy JTF_VARCHAR2_TABLE_100
117 , a11 out nocopy JTF_VARCHAR2_TABLE_100
118 , a12 out nocopy JTF_NUMBER_TABLE
119 , a13 out nocopy JTF_DATE_TABLE
120 , a14 out nocopy JTF_DATE_TABLE
121 , a15 out nocopy JTF_VARCHAR2_TABLE_100
122 , a16 out nocopy JTF_VARCHAR2_TABLE_100
123 , a17 out nocopy JTF_DATE_TABLE
124 , a18 out nocopy JTF_DATE_TABLE
125 , a19 out nocopy JTF_VARCHAR2_TABLE_100
126 , a20 out nocopy JTF_VARCHAR2_TABLE_2000
127 , a21 out nocopy JTF_DATE_TABLE
128 , a22 out nocopy JTF_VARCHAR2_TABLE_100
129 , a23 out nocopy JTF_VARCHAR2_TABLE_500
130 , a24 out nocopy JTF_NUMBER_TABLE
131 );
132
133 procedure get_mr_affected_items(p_api_version NUMBER
134 , p_init_msg_list VARCHAR2
135 , p_commit VARCHAR2
136 , p_validation_level NUMBER
137 , x_return_status out nocopy VARCHAR2
138 , x_msg_count out nocopy NUMBER
139 , x_msg_data out nocopy VARCHAR2
140 , p_mr_header_id NUMBER
141 , p_mr_effectivity_id NUMBER
142 , p_top_node_flag VARCHAR2
143 , p_unique_inst_flag VARCHAR2
144 , p_sort_flag VARCHAR2
145 , p_consider_fleet_flag VARCHAR2
146 , p_flt_range_calc_date date
147 , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
148 , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
149 , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
150 , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
151 , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
152 , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
153 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
154 , p14_a7 out nocopy JTF_NUMBER_TABLE
155 , p14_a8 out nocopy JTF_NUMBER_TABLE
156 , p14_a9 out nocopy JTF_NUMBER_TABLE
157 , p14_a10 out nocopy JTF_NUMBER_TABLE
158 , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
159 );
160 procedure get_applicable_mrs(p_api_version NUMBER
161 , p_init_msg_list VARCHAR2
162 , p_commit VARCHAR2
163 , p_validation_level NUMBER
164 , x_return_status out nocopy VARCHAR2
165 , x_msg_count out nocopy NUMBER
166 , x_msg_data out nocopy VARCHAR2
167 , p_item_instance_id NUMBER
168 , p_mr_header_id NUMBER
169 , p_components_flag VARCHAR2
170 , p_include_donotimplmt VARCHAR2
171 , p_visit_type_code VARCHAR2
172 , p_consider_fleet_flag VARCHAR2
173 , p_flt_range_calc_date date
174 , p_insert_into_tmp_tbl VARCHAR2
175 , p15_a0 out nocopy JTF_NUMBER_TABLE
176 , p15_a1 out nocopy JTF_NUMBER_TABLE
177 , p15_a2 out nocopy JTF_NUMBER_TABLE
178 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
179 , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
180 , p15_a5 out nocopy JTF_NUMBER_TABLE
181 , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
182 , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
183 , p15_a8 out nocopy JTF_NUMBER_TABLE
184 , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
185 , p15_a10 out nocopy JTF_NUMBER_TABLE
186 , p15_a11 out nocopy JTF_NUMBER_TABLE
187 );
188 procedure get_pm_applicable_mrs(p_api_version NUMBER
189 , p_init_msg_list VARCHAR2
190 , p_commit VARCHAR2
191 , p_validation_level NUMBER
192 , x_return_status out nocopy VARCHAR2
193 , x_msg_count out nocopy NUMBER
194 , x_msg_data out nocopy VARCHAR2
195 , p_item_instance_id NUMBER
196 , p8_a0 out nocopy JTF_NUMBER_TABLE
197 , p8_a1 out nocopy JTF_NUMBER_TABLE
198 , p8_a2 out nocopy JTF_NUMBER_TABLE
199 , p8_a3 out nocopy JTF_NUMBER_TABLE
200 , p8_a4 out nocopy JTF_NUMBER_TABLE
201 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
202 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
203 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
204 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
205 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
206 , p9_a0 out nocopy JTF_NUMBER_TABLE
207 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
208 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
209 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
210 , p9_a4 out nocopy JTF_NUMBER_TABLE
211 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
212 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
213 , p9_a7 out nocopy JTF_NUMBER_TABLE
214 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
215 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
216 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
217 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
218 , p9_a12 out nocopy JTF_NUMBER_TABLE
219 , p9_a13 out nocopy JTF_DATE_TABLE
220 , p9_a14 out nocopy JTF_DATE_TABLE
221 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
222 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
223 , p9_a17 out nocopy JTF_DATE_TABLE
224 , p9_a18 out nocopy JTF_DATE_TABLE
225 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
226 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
227 , p9_a21 out nocopy JTF_DATE_TABLE
228 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
229 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
230 , p9_a24 out nocopy JTF_NUMBER_TABLE
231 );
232 procedure get_mr_applicability(p_api_version NUMBER
233 , p_init_msg_list VARCHAR2
234 , p_commit VARCHAR2
235 , p_validation_level NUMBER
236 , x_return_status out nocopy VARCHAR2
237 , x_msg_count out nocopy NUMBER
238 , x_msg_data out nocopy VARCHAR2
239 , p_item_instance_id NUMBER
240 , p_mr_header_id NUMBER
241 , p_components_flag VARCHAR2
242 , p_include_donotimplmt VARCHAR2
243 , p11_a0 out nocopy JTF_NUMBER_TABLE
244 , p11_a1 out nocopy JTF_NUMBER_TABLE
245 , p11_a2 out nocopy JTF_NUMBER_TABLE
246 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
247 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
248 , p11_a5 out nocopy JTF_NUMBER_TABLE
249 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
250 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
251 , p11_a8 out nocopy JTF_NUMBER_TABLE
252 , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
253 , p11_a10 out nocopy JTF_NUMBER_TABLE
254 , p11_a11 out nocopy JTF_NUMBER_TABLE
255 );
256 end ahl_fmp_pvt_w;