[Home] [Help]
Skip to content
PACKAGE: APPS.AHL_MM_MTL_MGT_PVT_W
Source
1 package ahl_mm_mtl_mgt_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWMMGS.pls 120.0.12020000.2 2012/12/13 06:00:02 shnatu noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4 procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5
6 procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7 procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8
9 procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10 , a1 JTF_VARCHAR2_TABLE_100
11 , a2 JTF_NUMBER_TABLE
12 , a3 JTF_VARCHAR2_TABLE_100
13 , a4 JTF_NUMBER_TABLE
14 , a5 JTF_NUMBER_TABLE
15 , a6 JTF_VARCHAR2_TABLE_100
16 , a7 JTF_NUMBER_TABLE
17 , a8 JTF_NUMBER_TABLE
18 , a9 JTF_VARCHAR2_TABLE_100
19 , a10 JTF_VARCHAR2_TABLE_100
20 , a11 JTF_VARCHAR2_TABLE_100
21 , a12 JTF_VARCHAR2_TABLE_100
22 );
23 procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24 , a1 out nocopy JTF_VARCHAR2_TABLE_100
25 , a2 out nocopy JTF_NUMBER_TABLE
26 , a3 out nocopy JTF_VARCHAR2_TABLE_100
27 , a4 out nocopy JTF_NUMBER_TABLE
28 , a5 out nocopy JTF_NUMBER_TABLE
29 , a6 out nocopy JTF_VARCHAR2_TABLE_100
30 , a7 out nocopy JTF_NUMBER_TABLE
31 , a8 out nocopy JTF_NUMBER_TABLE
32 , a9 out nocopy JTF_VARCHAR2_TABLE_100
33 , a10 out nocopy JTF_VARCHAR2_TABLE_100
34 , a11 out nocopy JTF_VARCHAR2_TABLE_100
35 , a12 out nocopy JTF_VARCHAR2_TABLE_100
36 );
37
38 procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
39 , a1 JTF_NUMBER_TABLE
40 , a2 JTF_DATE_TABLE
41 , a3 JTF_NUMBER_TABLE
42 , a4 JTF_VARCHAR2_TABLE_2000
43 );
44 procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
45 , a1 out nocopy JTF_NUMBER_TABLE
46 , a2 out nocopy JTF_DATE_TABLE
47 , a3 out nocopy JTF_NUMBER_TABLE
48 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49 );
50
51 procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
52 procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53
54 procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55 , a1 JTF_VARCHAR2_TABLE_100
56 , a2 JTF_NUMBER_TABLE
57 , a3 JTF_VARCHAR2_TABLE_100
58 );
59 procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60 , a1 out nocopy JTF_VARCHAR2_TABLE_100
61 , a2 out nocopy JTF_NUMBER_TABLE
62 , a3 out nocopy JTF_VARCHAR2_TABLE_100
63 );
64
65 procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
66 , a1 JTF_VARCHAR2_TABLE_100
67 , a2 JTF_NUMBER_TABLE
68 );
69 procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70 , a1 out nocopy JTF_VARCHAR2_TABLE_100
71 , a2 out nocopy JTF_NUMBER_TABLE
72 );
73
74 procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
75 , a1 JTF_NUMBER_TABLE
76 , a2 JTF_VARCHAR2_TABLE_2000
77 );
78 procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
79 , a1 out nocopy JTF_NUMBER_TABLE
80 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81 );
82
83 procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE);
84 procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE);
85
86 procedure check_availability(p_api_version NUMBER
87 , p_init_msg_list VARCHAR2
88 , p_commit VARCHAR2
89 , p_module_type VARCHAR2
90 , p_validation_level NUMBER
91 , p_schedule_material_id_tbl JTF_NUMBER_TABLE
92 , p6_a0 out nocopy JTF_NUMBER_TABLE
93 , p6_a1 out nocopy JTF_NUMBER_TABLE
94 , p6_a2 out nocopy JTF_DATE_TABLE
95 , p6_a3 out nocopy JTF_NUMBER_TABLE
96 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
97 , x_return_status out nocopy VARCHAR2
98 , x_msg_count out nocopy NUMBER
99 , x_msg_data out nocopy VARCHAR2
100 );
101 procedure schedule_materials(p_api_version NUMBER
102 , p_init_msg_list VARCHAR2
103 , p_commit VARCHAR2
104 , p_module_type VARCHAR2
105 , p_validation_level NUMBER
106 , p_schedule_material_id_tbl JTF_NUMBER_TABLE
107 , p6_a0 out nocopy JTF_NUMBER_TABLE
108 , p6_a1 out nocopy JTF_NUMBER_TABLE
109 , p6_a2 out nocopy JTF_DATE_TABLE
110 , p6_a3 out nocopy JTF_NUMBER_TABLE
111 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
112 , x_return_status out nocopy VARCHAR2
113 , x_msg_count out nocopy NUMBER
114 , x_msg_data out nocopy VARCHAR2
115 );
116 procedure schedule_visit_materials(p_api_version NUMBER
117 , p_init_msg_list VARCHAR2
118 , p_commit VARCHAR2
119 , p_module_type VARCHAR2
120 , p_validation_level NUMBER
121 , p_visit_id NUMBER
122 , p6_a0 out nocopy JTF_NUMBER_TABLE
123 , p6_a1 out nocopy JTF_NUMBER_TABLE
124 , p6_a2 out nocopy JTF_DATE_TABLE
125 , p6_a3 out nocopy JTF_NUMBER_TABLE
126 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
127 , x_return_status out nocopy VARCHAR2
128 , x_msg_count out nocopy NUMBER
129 , x_msg_data out nocopy VARCHAR2
130 );
131 procedure create_move_order(p_api_version NUMBER
132 , p_init_msg_list VARCHAR2
133 , p_commit VARCHAR2
134 , p_validation_level NUMBER
135 , p_scheduled_material_id NUMBER
136 , p5_a0 JTF_NUMBER_TABLE
137 , p5_a1 JTF_VARCHAR2_TABLE_100
138 , p5_a2 JTF_NUMBER_TABLE
139 , p5_a3 JTF_VARCHAR2_TABLE_100
140 , x_mo_hdr_id out nocopy NUMBER
141 , x_mo_lines_tbl out nocopy JTF_NUMBER_TABLE
142 , x_return_status out nocopy VARCHAR2
143 , x_msg_count out nocopy NUMBER
144 , x_msg_data out nocopy VARCHAR2
145 );
146 procedure invoke_aog_upd_notification(p_api_version NUMBER
147 , p_init_msg_list VARCHAR2
148 , p_commit VARCHAR2
149 , p_validation_level NUMBER
150 , p_asm_id_tab JTF_NUMBER_TABLE
151 , x_return_status out nocopy VARCHAR2
152 , x_msg_count out nocopy NUMBER
153 , x_msg_data out nocopy VARCHAR2
154 );
155 procedure perform_inter_org_transfer(p_api_version NUMBER
156 , p_init_msg_list VARCHAR2
157 , p_commit VARCHAR2
158 , p_validation_level NUMBER
159 , p_default VARCHAR2
160 , p_module_type VARCHAR2
161 , x_return_status out nocopy VARCHAR2
162 , x_msg_count out nocopy NUMBER
163 , x_msg_data out nocopy VARCHAR2
164 , p9_a0 in out nocopy JTF_NUMBER_TABLE
165 , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
166 , p9_a2 in out nocopy JTF_NUMBER_TABLE
167 , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
168 , p9_a4 in out nocopy JTF_NUMBER_TABLE
169 , p9_a5 in out nocopy JTF_NUMBER_TABLE
170 , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
171 , p9_a7 in out nocopy JTF_NUMBER_TABLE
172 , p9_a8 in out nocopy JTF_NUMBER_TABLE
173 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
174 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
175 , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
176 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
177 , p_sched_material_id NUMBER
178 , x_reservation_id out nocopy NUMBER
179 );
180 procedure perform_inter_org_transfer_inv(p_api_version NUMBER
181 , p_init_msg_list VARCHAR2
182 , p_commit VARCHAR2
183 , p_validation_level NUMBER
184 , p_default VARCHAR2
185 , p_module_type VARCHAR2
186 , x_return_status out nocopy VARCHAR2
187 , x_msg_count out nocopy NUMBER
188 , x_msg_data out nocopy VARCHAR2
189 , p9_a0 in out nocopy JTF_NUMBER_TABLE
190 , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
191 , p9_a2 in out nocopy JTF_NUMBER_TABLE
192 , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
193 , p9_a4 in out nocopy JTF_NUMBER_TABLE
194 , p9_a5 in out nocopy JTF_NUMBER_TABLE
195 , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
196 , p9_a7 in out nocopy JTF_NUMBER_TABLE
197 , p9_a8 in out nocopy JTF_NUMBER_TABLE
198 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
199 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
200 , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
201 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
202 );
203 procedure create_internal_sales_order(p_api_version NUMBER
204 , p_init_msg_list VARCHAR2
205 , p_commit VARCHAR2
206 , p_validation_level NUMBER
207 , x_msg_count out nocopy NUMBER
208 , x_msg_data out nocopy VARCHAR2
209 , x_return_status out nocopy VARCHAR2
210 , p_sch_mtl_id NUMBER
211 , p_source_org_tbl JTF_NUMBER_TABLE
212 , p_source_sub_inv_tbl JTF_VARCHAR2_TABLE_100
213 , p_source_locators_tbl JTF_NUMBER_TABLE
214 , p_serial_num_tbl JTF_VARCHAR2_TABLE_100
215 , x_requisition_num out nocopy VARCHAR2
216 , x_requisition_hdr_id out nocopy NUMBER
217 , x_int_order_num out nocopy NUMBER
218 , x_int_order_hdr_id out nocopy NUMBER
219 , x_reservation_id out nocopy NUMBER
220 );
221 procedure aog_upd_notification(p_api_version NUMBER
222 , p_init_msg_list VARCHAR2
223 , p_commit VARCHAR2
224 , p_validation_level NUMBER
225 , p_schedule_material_id_tbl JTF_NUMBER_TABLE
226 , x_return_status out nocopy VARCHAR2
227 , x_msg_count out nocopy NUMBER
228 , x_msg_data out nocopy VARCHAR2
229 );
230 procedure update_aog(p_api_version NUMBER
231 , p_init_msg_list VARCHAR2
232 , p_commit VARCHAR2
233 , p_validation_level NUMBER
234 , p4_a0 JTF_NUMBER_TABLE
235 , p4_a1 JTF_VARCHAR2_TABLE_100
236 , p4_a2 JTF_NUMBER_TABLE
237 , x_return_status out nocopy VARCHAR2
238 , x_msg_count out nocopy NUMBER
239 , x_msg_data out nocopy VARCHAR2
240 );
241 procedure filter_instances_matching_bg(p_api_version NUMBER
242 , p_init_msg_list VARCHAR2
243 , p_commit VARCHAR2
244 , p_module_type VARCHAR2
245 , p4_a0 NUMBER
246 , p4_a1 VARCHAR2
247 , p4_a2 VARCHAR2
248 , p4_a3 VARCHAR2
249 , p4_a4 VARCHAR2
250 , p4_a5 VARCHAR2
251 , p4_a6 VARCHAR2
252 , p4_a7 VARCHAR2
253 , p4_a8 VARCHAR2
254 , p4_a9 VARCHAR2
255 , p4_a10 VARCHAR2
256 , p4_a11 VARCHAR2
257 , p4_a12 VARCHAR2
258 , p4_a13 DATE
259 , p4_a14 VARCHAR2
260 , x_return_status out nocopy VARCHAR2
261 , x_msg_count out nocopy NUMBER
262 , x_msg_data out nocopy VARCHAR2
263 );
264 procedure get_available_quantity(p_api_version NUMBER
265 , p_init_msg_list VARCHAR2
266 , p_commit VARCHAR2
267 , p_module_type VARCHAR2
268 , p_validation_level NUMBER
269 , p_org_id NUMBER
270 , p_inv_item_id NUMBER
271 , p7_a0 out nocopy JTF_NUMBER_TABLE
272 , p7_a1 out nocopy JTF_NUMBER_TABLE
273 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
274 , x_return_status out nocopy VARCHAR2
275 , x_msg_count out nocopy NUMBER
276 , x_msg_data out nocopy VARCHAR2
277 );
278 procedure sched_all_vst_mtls(p_api_version NUMBER
279 , p_init_msg_list VARCHAR2
280 , p_commit VARCHAR2
281 , p_module_type VARCHAR2
282 , p_validation_level NUMBER
283 , p_visit_ids JTF_NUMBER_TABLE
284 , p6_a0 out nocopy JTF_NUMBER_TABLE
285 , p6_a1 out nocopy JTF_NUMBER_TABLE
286 , p6_a2 out nocopy JTF_DATE_TABLE
287 , p6_a3 out nocopy JTF_NUMBER_TABLE
288 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
289 , x_return_status out nocopy VARCHAR2
290 , x_msg_count out nocopy NUMBER
291 , x_msg_data out nocopy VARCHAR2
292 );
293 end ahl_mm_mtl_mgt_pvt_w;