1: package wsmplbmi_w as
2: /* $Header: WSMLBMWS.pls 120.0 2005/07/06 11:09 skaradib noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t wsmplbmi.t_sec_uom_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
1: package wsmplbmi_w as
2: /* $Header: WSMLBMWS.pls 120.0 2005/07/06 11:09 skaradib noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t wsmplbmi.t_sec_uom_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
1: package wsmplbmi_w as
2: /* $Header: WSMLBMWS.pls 120.0 2005/07/06 11:09 skaradib noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t wsmplbmi.t_sec_uom_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
2: /* $Header: WSMLBMWS.pls 120.0 2005/07/06 11:09 skaradib noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t wsmplbmi.t_sec_uom_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
10: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t wsmplbmi.t_sec_uom_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
10: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11:
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
10: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
13: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
6: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
10: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
13: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
14:
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
10: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
13: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
16: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
9: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
10: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
13: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
16: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
17:
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
13: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
16: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy wsmplbmi.t_bonus_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t wsmplbmi.t_bonus_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
12: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
13: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
16: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy wsmplbmi.t_bonus_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t wsmplbmi.t_bonus_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
20:
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
16: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy wsmplbmi.t_bonus_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t wsmplbmi.t_bonus_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
20:
21: procedure rosetta_table_copy_in_p7(t out nocopy wsmplbmi.t_jobop_res_usages_tbl_type, a0 JTF_NUMBER_TABLE
22: , a1 JTF_NUMBER_TABLE
15: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
16: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy wsmplbmi.t_bonus_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t wsmplbmi.t_bonus_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
20:
21: procedure rosetta_table_copy_in_p7(t out nocopy wsmplbmi.t_jobop_res_usages_tbl_type, a0 JTF_NUMBER_TABLE
22: , a1 JTF_NUMBER_TABLE
23: , a2 JTF_NUMBER_TABLE
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy wsmplbmi.t_bonus_code_qty_tbl_type, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t wsmplbmi.t_bonus_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
20:
21: procedure rosetta_table_copy_in_p7(t out nocopy wsmplbmi.t_jobop_res_usages_tbl_type, a0 JTF_NUMBER_TABLE
22: , a1 JTF_NUMBER_TABLE
23: , a2 JTF_NUMBER_TABLE
24: , a3 JTF_NUMBER_TABLE
25: , a4 JTF_NUMBER_TABLE
43: , a22 JTF_VARCHAR2_TABLE_100
44: , a23 JTF_VARCHAR2_TABLE_100
45: , a24 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p7(t wsmplbmi.t_jobop_res_usages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
471: , x_return_status out nocopy VARCHAR2
472: , x_msg_count out nocopy NUMBER
473: , x_msg_data out nocopy VARCHAR2
474: );
475: end wsmplbmi_w;