APPS.AHL_MM_MTL_MGT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);

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);

Line 4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);

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:

Line 10: , a1 JTF_VARCHAR2_TABLE_100

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

Line 12: , a3 JTF_VARCHAR2_TABLE_100

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

Line 15: , a6 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

Line 18: , a9 JTF_VARCHAR2_TABLE_100

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: );

Line 19: , a10 JTF_VARCHAR2_TABLE_100

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

Line 20: , a11 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

Line 21: , a12 JTF_VARCHAR2_TABLE_100

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

Line 24: , a1 out nocopy 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

Line 26: , a3 out nocopy 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

Line 29: , a6 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

Line 32: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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: );

Line 33: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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:

Line 34: , a11 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

Line 35: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 55: , a1 JTF_VARCHAR2_TABLE_100

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

Line 57: , a3 JTF_VARCHAR2_TABLE_100

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

Line 60: , a1 out nocopy 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:

Line 62: , a3 out nocopy 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

Line 66: , a1 JTF_VARCHAR2_TABLE_100

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

Line 70: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 137: , p5_a1 JTF_VARCHAR2_TABLE_100

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

Line 139: , p5_a3 JTF_VARCHAR2_TABLE_100

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

Line 165: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 167: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 170: , p9_a6 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

Line 173: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 174: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 175: , p9_a11 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: );

Line 176: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 190: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 192: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 195: , p9_a6 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

Line 198: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

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: );

Line 199: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 200: , p9_a11 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

Line 201: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 212: , p_source_sub_inv_tbl JTF_VARCHAR2_TABLE_100

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

Line 214: , p_serial_num_tbl JTF_VARCHAR2_TABLE_100

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

Line 235: , p4_a1 JTF_VARCHAR2_TABLE_100

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