DBA Data[Home] [Help]

APPS.JTF_RS_GRP_SUM_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package jtf_rs_grp_sum_pub_w 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

Line 6: , a3 JTF_VARCHAR2_TABLE_100

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

Line 9: , a6 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: );

Line 11: , a8 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

Line 15: , a1 out NOCOPY JTF_VARCHAR2_TABLE_100

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

Line 17: , a3 out NOCOPY JTF_VARCHAR2_TABLE_100

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

Line 20: , a6 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: );

Line 22: , a8 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

Line 41: , p14_a1 out NOCOPY JTF_VARCHAR2_TABLE_100

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

Line 43: , p14_a3 out NOCOPY JTF_VARCHAR2_TABLE_100

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

Line 46: , p14_a6 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: );

Line 48: , p14_a8 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;