1: package csp_parts_requirement_w as
2: /* $Header: cspwprqs.pls 120.0 2005/05/25 11:33:11 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
1: package csp_parts_requirement_w as
2: /* $Header: cspwprqs.pls 120.0 2005/05/25 11:33:11 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
40: , a37 JTF_VARCHAR2_TABLE_200
41: , a38 JTF_VARCHAR2_TABLE_200
42: , a39 JTF_VARCHAR2_TABLE_200
43: );
44: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_300
82: , a38 out nocopy JTF_VARCHAR2_TABLE_200
83: , a39 out nocopy JTF_VARCHAR2_TABLE_200
84: );
85:
86: procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_NUMBER_TABLE
90: );
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_NUMBER_TABLE
95: );
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_NUMBER_TABLE
95: );
96:
97: procedure rosetta_table_copy_in_p6(t out nocopy csp_parts_requirement.rqmt_line_tbl_type, a0 JTF_NUMBER_TABLE
98: );
99: procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: );
101:
95: );
96:
97: procedure rosetta_table_copy_in_p6(t out nocopy csp_parts_requirement.rqmt_line_tbl_type, a0 JTF_NUMBER_TABLE
98: );
99: procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: );
101:
102: procedure rosetta_table_copy_in_p8(t out nocopy csp_parts_requirement.order_tbl_type, a0 JTF_VARCHAR2_TABLE_100
103: , a1 JTF_NUMBER_TABLE
98: );
99: procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: );
101:
102: procedure rosetta_table_copy_in_p8(t out nocopy csp_parts_requirement.order_tbl_type, a0 JTF_VARCHAR2_TABLE_100
103: , a1 JTF_NUMBER_TABLE
104: );
105: procedure rosetta_table_copy_out_p8(t csp_parts_requirement.order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106: , a1 out nocopy JTF_NUMBER_TABLE
101:
102: procedure rosetta_table_copy_in_p8(t out nocopy csp_parts_requirement.order_tbl_type, a0 JTF_VARCHAR2_TABLE_100
103: , a1 JTF_NUMBER_TABLE
104: );
105: procedure rosetta_table_copy_out_p8(t csp_parts_requirement.order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106: , a1 out nocopy JTF_NUMBER_TABLE
107: );
108:
109: procedure process_requirement(p_api_version NUMBER
505: , x_return_status out nocopy VARCHAR2
506: , x_msg_count out nocopy NUMBER
507: , x_msg_data out nocopy VARCHAR2
508: );
509: end csp_parts_requirement_w;