1: package ahl_pp_materials_pvt_w as
2: /* $Header: AHLWPPMS.pls 120.2 2008/01/31 09:07:56 bachandr ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
1: package ahl_pp_materials_pvt_w as
2: /* $Header: AHLWPPMS.pls 120.2 2008/01/31 09:07:56 bachandr ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
63: , a60 JTF_VARCHAR2_TABLE_3000
64: , a61 JTF_VARCHAR2_TABLE_100
65: , a62 JTF_VARCHAR2_TABLE_100
66: );
67: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_100
71: , a4 out nocopy JTF_NUMBER_TABLE
128: , a61 out nocopy JTF_VARCHAR2_TABLE_100
129: , a62 out nocopy JTF_VARCHAR2_TABLE_100
130: );
131:
132: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
133: , a1 JTF_NUMBER_TABLE
134: , a2 JTF_NUMBER_TABLE
135: , a3 JTF_VARCHAR2_TABLE_100
136: , a4 JTF_VARCHAR2_TABLE_300
153: , a21 JTF_VARCHAR2_TABLE_100
154: , a22 JTF_NUMBER_TABLE
155: , a23 JTF_VARCHAR2_TABLE_100
156: );
157: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_300
448: , x_return_status out nocopy VARCHAR2
449: , x_msg_count out nocopy NUMBER
450: , x_msg_data out nocopy VARCHAR2
451: );
452: end ahl_pp_materials_pvt_w;