1: package ozf_vol_offr_pvt_w as
2: /* $Header: ozfwvos.pls 120.0 2005/06/01 01:50:16 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package ozf_vol_offr_pvt_w as
2: /* $Header: ozfwvos.pls 120.0 2005/06/01 01:50:16 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: ozfwvos.pls 120.0 2005/06/01 01:50:16 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
16: , a1 OUT NOCOPY JTF_NUMBER_TABLE
17: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
16: , a1 OUT NOCOPY JTF_NUMBER_TABLE
17: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
18: , a3 OUT NOCOPY JTF_NUMBER_TABLE
19: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
16: , a1 OUT NOCOPY JTF_NUMBER_TABLE
17: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
18: , a3 OUT NOCOPY JTF_NUMBER_TABLE
19: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
20: , a5 OUT NOCOPY JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
16: , a1 OUT NOCOPY JTF_NUMBER_TABLE
17: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
18: , a3 OUT NOCOPY JTF_NUMBER_TABLE
19: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
20: , a5 OUT NOCOPY JTF_NUMBER_TABLE
21: , a6 OUT NOCOPY JTF_NUMBER_TABLE
22: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
16: , a1 OUT NOCOPY JTF_NUMBER_TABLE
17: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
18: , a3 OUT NOCOPY JTF_NUMBER_TABLE
19: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
20: , a5 OUT NOCOPY JTF_NUMBER_TABLE
21: , a6 OUT NOCOPY JTF_NUMBER_TABLE
22: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
23: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
17: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
18: , a3 OUT NOCOPY JTF_NUMBER_TABLE
19: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
20: , a5 OUT NOCOPY JTF_NUMBER_TABLE
21: , a6 OUT NOCOPY JTF_NUMBER_TABLE
22: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
23: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
25: , a10 OUT NOCOPY JTF_NUMBER_TABLE
21: , a6 OUT NOCOPY JTF_NUMBER_TABLE
22: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
23: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
25: , a10 OUT NOCOPY JTF_NUMBER_TABLE
26: );
27:
28: procedure create_vol_offr(p_api_version_number NUMBER
29: , p_init_msg_list VARCHAR2