1: package okl_populate_prceng_rst_pub_w as
2: /* $Header: OKLUPRSS.pls 120.1 2005/05/30 12:32:18 kthiruva noship $ */
3: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_populate_prceng_rst_pub_w as
2: /* $Header: OKLUPRSS.pls 120.1 2005/05/30 12:32:18 kthiruva noship $ */
3: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: );
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: );
9: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
10: , a1 out nocopy JTF_VARCHAR2_TABLE_200
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: );
9: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
10: , a1 out nocopy JTF_VARCHAR2_TABLE_200
11: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a3 out nocopy JTF_NUMBER_TABLE
13: , a4 out nocopy JTF_NUMBER_TABLE
14: );
23: );
24:
25: procedure populate_sif_ret_strms(x_return_status out nocopy VARCHAR2
26: , p_index_number NUMBER
27: , p2_a0 JTF_VARCHAR2_TABLE_200
28: , p2_a1 JTF_VARCHAR2_TABLE_200
29: , p2_a2 JTF_VARCHAR2_TABLE_100
30: , p2_a3 JTF_NUMBER_TABLE
31: , p2_a4 JTF_NUMBER_TABLE
24:
25: procedure populate_sif_ret_strms(x_return_status out nocopy VARCHAR2
26: , p_index_number NUMBER
27: , p2_a0 JTF_VARCHAR2_TABLE_200
28: , p2_a1 JTF_VARCHAR2_TABLE_200
29: , p2_a2 JTF_VARCHAR2_TABLE_100
30: , p2_a3 JTF_NUMBER_TABLE
31: , p2_a4 JTF_NUMBER_TABLE
32: , p_sir_id NUMBER