APPS.CN_COMP_GRP_HIER_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out cn_comp_grp_hier_pub.comp_group_tbl, a0 JTF_VARCHAR2_TABLE_100

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

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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

Line 7: , a4 JTF_VARCHAR2_TABLE_100

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

Line 8: , a5 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
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE

Line 14: , a11 JTF_VARCHAR2_TABLE_100

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
18: , a1 out JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_VARCHAR2_TABLE_100

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
18: , a1 out JTF_VARCHAR2_TABLE_100
19: , a2 out JTF_NUMBER_TABLE

Line 17: procedure rosetta_table_copy_out_p1(t cn_comp_grp_hier_pub.comp_group_tbl, a0 out JTF_VARCHAR2_TABLE_100

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
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

Line 18: , a1 out JTF_VARCHAR2_TABLE_100

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
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

Line 21: , a4 out JTF_VARCHAR2_TABLE_100

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
25: , a8 out JTF_DATE_TABLE

Line 22: , a5 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
25: , a8 out JTF_DATE_TABLE
26: , a9 out JTF_NUMBER_TABLE

Line 28: , a11 out JTF_VARCHAR2_TABLE_100

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:
32: procedure get_comp_group_hier(p_api_version NUMBER

Line 29: , a12 out JTF_VARCHAR2_TABLE_100

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:
32: procedure get_comp_group_hier(p_api_version NUMBER
33: , p_init_msg_list VARCHAR2

Line 40: , p8_a0 out JTF_VARCHAR2_TABLE_100

36: , p_comp_group_id NUMBER
37: , p_focus_cg_id NUMBER
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

Line 41: , p8_a1 out JTF_VARCHAR2_TABLE_100

37: , p_focus_cg_id NUMBER
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

Line 44: , p8_a4 out JTF_VARCHAR2_TABLE_100

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
48: , p8_a8 out JTF_DATE_TABLE

Line 45: , p8_a5 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
48: , p8_a8 out JTF_DATE_TABLE
49: , p8_a9 out JTF_NUMBER_TABLE

Line 51: , p8_a11 out JTF_VARCHAR2_TABLE_100

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
55: , x_return_status out VARCHAR2

Line 52: , p8_a12 out JTF_VARCHAR2_TABLE_100

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
55: , x_return_status out VARCHAR2
56: , x_msg_count out NUMBER