DBA Data[Home] [Help]

APPS.CN_COMP_GRP_HIER_PUB_W dependencies on JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package cn_comp_grp_hier_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwcghrs.pls 115.4 2002/07/30 02:41:24 achung noship $ */
3: procedure rosetta_table_copy_in_p1(t out cn_comp_grp_hier_pub.comp_group_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: cnwcghrs.pls 115.4 2002/07/30 02:41:24 achung noship $ */
3: procedure rosetta_table_copy_in_p1(t out cn_comp_grp_hier_pub.comp_group_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t cn_comp_grp_hier_pub.comp_group_tbl, a0 out JTF_VARCHAR2_TABLE_100

Line 19: , a2 out JTF_NUMBER_TABLE

15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t cn_comp_grp_hier_pub.comp_group_tbl, a0 out JTF_VARCHAR2_TABLE_100
18: , a1 out JTF_VARCHAR2_TABLE_100
19: , a2 out JTF_NUMBER_TABLE
20: , a3 out JTF_NUMBER_TABLE
21: , a4 out JTF_VARCHAR2_TABLE_100
22: , a5 out JTF_VARCHAR2_TABLE_100
23: , a6 out JTF_NUMBER_TABLE

Line 20: , a3 out JTF_NUMBER_TABLE

16: );
17: procedure rosetta_table_copy_out_p1(t cn_comp_grp_hier_pub.comp_group_tbl, a0 out JTF_VARCHAR2_TABLE_100
18: , a1 out JTF_VARCHAR2_TABLE_100
19: , a2 out JTF_NUMBER_TABLE
20: , a3 out JTF_NUMBER_TABLE
21: , a4 out JTF_VARCHAR2_TABLE_100
22: , a5 out JTF_VARCHAR2_TABLE_100
23: , a6 out JTF_NUMBER_TABLE
24: , a7 out JTF_DATE_TABLE

Line 23: , a6 out JTF_NUMBER_TABLE

19: , a2 out JTF_NUMBER_TABLE
20: , a3 out JTF_NUMBER_TABLE
21: , a4 out JTF_VARCHAR2_TABLE_100
22: , a5 out JTF_VARCHAR2_TABLE_100
23: , a6 out JTF_NUMBER_TABLE
24: , a7 out JTF_DATE_TABLE
25: , a8 out JTF_DATE_TABLE
26: , a9 out JTF_NUMBER_TABLE
27: , a10 out JTF_NUMBER_TABLE

Line 26: , a9 out JTF_NUMBER_TABLE

22: , a5 out JTF_VARCHAR2_TABLE_100
23: , a6 out JTF_NUMBER_TABLE
24: , a7 out JTF_DATE_TABLE
25: , a8 out JTF_DATE_TABLE
26: , a9 out JTF_NUMBER_TABLE
27: , a10 out JTF_NUMBER_TABLE
28: , a11 out JTF_VARCHAR2_TABLE_100
29: , a12 out JTF_VARCHAR2_TABLE_100
30: );

Line 27: , a10 out JTF_NUMBER_TABLE

23: , a6 out JTF_NUMBER_TABLE
24: , a7 out JTF_DATE_TABLE
25: , a8 out JTF_DATE_TABLE
26: , a9 out JTF_NUMBER_TABLE
27: , a10 out JTF_NUMBER_TABLE
28: , a11 out JTF_VARCHAR2_TABLE_100
29: , a12 out JTF_VARCHAR2_TABLE_100
30: );
31:

Line 42: , p8_a2 out JTF_NUMBER_TABLE

38: , p_expand CHAR
39: , p_date date
40: , p8_a0 out JTF_VARCHAR2_TABLE_100
41: , p8_a1 out JTF_VARCHAR2_TABLE_100
42: , p8_a2 out JTF_NUMBER_TABLE
43: , p8_a3 out JTF_NUMBER_TABLE
44: , p8_a4 out JTF_VARCHAR2_TABLE_100
45: , p8_a5 out JTF_VARCHAR2_TABLE_100
46: , p8_a6 out JTF_NUMBER_TABLE

Line 43: , p8_a3 out JTF_NUMBER_TABLE

39: , p_date date
40: , p8_a0 out JTF_VARCHAR2_TABLE_100
41: , p8_a1 out JTF_VARCHAR2_TABLE_100
42: , p8_a2 out JTF_NUMBER_TABLE
43: , p8_a3 out JTF_NUMBER_TABLE
44: , p8_a4 out JTF_VARCHAR2_TABLE_100
45: , p8_a5 out JTF_VARCHAR2_TABLE_100
46: , p8_a6 out JTF_NUMBER_TABLE
47: , p8_a7 out JTF_DATE_TABLE

Line 46: , p8_a6 out JTF_NUMBER_TABLE

42: , p8_a2 out JTF_NUMBER_TABLE
43: , p8_a3 out JTF_NUMBER_TABLE
44: , p8_a4 out JTF_VARCHAR2_TABLE_100
45: , p8_a5 out JTF_VARCHAR2_TABLE_100
46: , p8_a6 out JTF_NUMBER_TABLE
47: , p8_a7 out JTF_DATE_TABLE
48: , p8_a8 out JTF_DATE_TABLE
49: , p8_a9 out JTF_NUMBER_TABLE
50: , p8_a10 out JTF_NUMBER_TABLE

Line 49: , p8_a9 out JTF_NUMBER_TABLE

45: , p8_a5 out JTF_VARCHAR2_TABLE_100
46: , p8_a6 out JTF_NUMBER_TABLE
47: , p8_a7 out JTF_DATE_TABLE
48: , p8_a8 out JTF_DATE_TABLE
49: , p8_a9 out JTF_NUMBER_TABLE
50: , p8_a10 out JTF_NUMBER_TABLE
51: , p8_a11 out JTF_VARCHAR2_TABLE_100
52: , p8_a12 out JTF_VARCHAR2_TABLE_100
53: , l_mgr_count out NUMBER

Line 50: , p8_a10 out JTF_NUMBER_TABLE

46: , p8_a6 out JTF_NUMBER_TABLE
47: , p8_a7 out JTF_DATE_TABLE
48: , p8_a8 out JTF_DATE_TABLE
49: , p8_a9 out JTF_NUMBER_TABLE
50: , p8_a10 out JTF_NUMBER_TABLE
51: , p8_a11 out JTF_VARCHAR2_TABLE_100
52: , p8_a12 out JTF_VARCHAR2_TABLE_100
53: , l_mgr_count out NUMBER
54: , x_period_year out VARCHAR2