1: package okl_vp_sts_pub_w as
2: /* $Header: OKLUSSCS.pls 120.2 2005/08/04 03:07:50 manumanu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_vp_sts_pub.vp_sts_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t okl_vp_sts_pub.vp_sts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1: package okl_vp_sts_pub_w as
2: /* $Header: OKLUSSCS.pls 120.2 2005/08/04 03:07:50 manumanu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_vp_sts_pub.vp_sts_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t okl_vp_sts_pub.vp_sts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
2: /* $Header: OKLUSSCS.pls 120.2 2005/08/04 03:07:50 manumanu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_vp_sts_pub.vp_sts_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t okl_vp_sts_pub.vp_sts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure get_listof_new_statuses(p_api_version NUMBER
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_vp_sts_pub.vp_sts_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t okl_vp_sts_pub.vp_sts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure get_listof_new_statuses(p_api_version NUMBER
11: , p_init_msg_list VARCHAR2
15: , p_ste_code VARCHAR2
16: , p_sts_code VARCHAR2
17: , p_start_date DATE
18: , p_end_date DATE
19: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
20: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
21: );
22: end okl_vp_sts_pub_w;
16: , p_sts_code VARCHAR2
17: , p_start_date DATE
18: , p_end_date DATE
19: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
20: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
21: );
22: end okl_vp_sts_pub_w;