1: package cs_sr_dup_chk_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csdupws.pls 120.0 2011/12/16 11:45:50 shramana noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
1: package cs_sr_dup_chk_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csdupws.pls 120.0 2011/12/16 11:45:50 shramana noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_2000
14: );
15: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_2000
14: );
15: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
17: );
18:
19: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE
15: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
17: );
18:
19: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_NUMBER_TABLE
22: , a3 JTF_VARCHAR2_TABLE_2000
23: );
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_NUMBER_TABLE
22: , a3 JTF_VARCHAR2_TABLE_2000
23: );
24: procedure rosetta_table_copy_out_p5(t cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
28: );
176: function check_if_already_in_list(p0_a0 JTF_NUMBER_TABLE
177: , p0_a1 JTF_VARCHAR2_TABLE_2000
178: , p_sr_link_id NUMBER
179: ) return varchar2;
180: end cs_sr_dup_chk_pvt_w;