PACKAGE: APPS.JTF_RS_GRP_SUM_PUB_W

Source

1 package jtf_rs_grp_sum_pub_w AUTHID CURRENT_USER as
2   /* $Header: jtfrsrgs.pls 120.0 2005/05/11 08:21:37 appldev ship $ */
3   procedure rosetta_table_copy_in_p1(t out NOCOPY jtf_rs_grp_sum_pub.grp_sum_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_300
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_DATE_TABLE
8     , a5 JTF_DATE_TABLE
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_NUMBER_TABLE
13     );
14   procedure rosetta_table_copy_out_p1(t jtf_rs_grp_sum_pub.grp_sum_tbl_type, a0 out NOCOPY JTF_NUMBER_TABLE
15     , a1 out NOCOPY JTF_VARCHAR2_TABLE_100
16     , a2 out NOCOPY JTF_VARCHAR2_TABLE_300
17     , a3 out NOCOPY JTF_VARCHAR2_TABLE_100
18     , a4 out NOCOPY JTF_DATE_TABLE
19     , a5 out NOCOPY JTF_DATE_TABLE
20     , a6 out NOCOPY JTF_VARCHAR2_TABLE_100
21     , a7 out NOCOPY JTF_NUMBER_TABLE
22     , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
23     , a9 out NOCOPY JTF_NUMBER_TABLE
24     );
25 
26   procedure get_group(p_range_low  NUMBER
27     , p_range_high  NUMBER
28     , p_called_from  VARCHAR2
29     , p_user_id  NUMBER
30     , p_group_name  VARCHAR2
31     , p_group_number  VARCHAR2
32     , p_group_desc  VARCHAR2
33     , p_group_email  VARCHAR2
34     , p_from_date  VARCHAR2
35     , p_to_date  VARCHAR2
36     , p_date_format  VARCHAR2
37     , p_group_id  NUMBER
38     , p_group_usage  VARCHAR2
39     , x_total_rows out NOCOPY  NUMBER
40     , p14_a0 out NOCOPY JTF_NUMBER_TABLE
41     , p14_a1 out NOCOPY JTF_VARCHAR2_TABLE_100
42     , p14_a2 out NOCOPY JTF_VARCHAR2_TABLE_300
43     , p14_a3 out NOCOPY JTF_VARCHAR2_TABLE_100
44     , p14_a4 out NOCOPY JTF_DATE_TABLE
45     , p14_a5 out NOCOPY JTF_DATE_TABLE
46     , p14_a6 out NOCOPY JTF_VARCHAR2_TABLE_100
47     , p14_a7 out NOCOPY JTF_NUMBER_TABLE
48     , p14_a8 out NOCOPY JTF_VARCHAR2_TABLE_100
49     , p14_a9 out NOCOPY JTF_NUMBER_TABLE
50   );
51 end jtf_rs_grp_sum_pub_w;