DBA Data[Home] [Help]

APPS.CN_COMP_GRP_HIER_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

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

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out cn_comp_grp_hier_pub.comp_group_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out cn_comp_grp_hier_pub.comp_group_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p1(t out cn_comp_grp_hier_pub.comp_group_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE

Line 33: , a11 JTF_VARCHAR2_TABLE_100

29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin

Line 34: , a12 JTF_VARCHAR2_TABLE_100

30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
38: if a0 is not null and a0.count > 0 then

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

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t cn_comp_grp_hier_pub.comp_group_tbl, a0 out JTF_VARCHAR2_TABLE_100
66: , a1 out JTF_VARCHAR2_TABLE_100
67: , a2 out JTF_NUMBER_TABLE
68: , a3 out JTF_NUMBER_TABLE
69: , a4 out JTF_VARCHAR2_TABLE_100

Line 66: , a1 out JTF_VARCHAR2_TABLE_100

62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t cn_comp_grp_hier_pub.comp_group_tbl, a0 out JTF_VARCHAR2_TABLE_100
66: , a1 out JTF_VARCHAR2_TABLE_100
67: , a2 out JTF_NUMBER_TABLE
68: , a3 out JTF_NUMBER_TABLE
69: , a4 out JTF_VARCHAR2_TABLE_100
70: , a5 out JTF_VARCHAR2_TABLE_100

Line 69: , a4 out JTF_VARCHAR2_TABLE_100

65: procedure rosetta_table_copy_out_p1(t cn_comp_grp_hier_pub.comp_group_tbl, a0 out JTF_VARCHAR2_TABLE_100
66: , a1 out JTF_VARCHAR2_TABLE_100
67: , a2 out JTF_NUMBER_TABLE
68: , a3 out JTF_NUMBER_TABLE
69: , a4 out JTF_VARCHAR2_TABLE_100
70: , a5 out JTF_VARCHAR2_TABLE_100
71: , a6 out JTF_NUMBER_TABLE
72: , a7 out JTF_DATE_TABLE
73: , a8 out JTF_DATE_TABLE

Line 70: , a5 out JTF_VARCHAR2_TABLE_100

66: , a1 out JTF_VARCHAR2_TABLE_100
67: , a2 out JTF_NUMBER_TABLE
68: , a3 out JTF_NUMBER_TABLE
69: , a4 out JTF_VARCHAR2_TABLE_100
70: , a5 out JTF_VARCHAR2_TABLE_100
71: , a6 out JTF_NUMBER_TABLE
72: , a7 out JTF_DATE_TABLE
73: , a8 out JTF_DATE_TABLE
74: , a9 out JTF_NUMBER_TABLE

Line 76: , a11 out JTF_VARCHAR2_TABLE_100

72: , a7 out JTF_DATE_TABLE
73: , a8 out JTF_DATE_TABLE
74: , a9 out JTF_NUMBER_TABLE
75: , a10 out JTF_NUMBER_TABLE
76: , a11 out JTF_VARCHAR2_TABLE_100
77: , a12 out JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin

Line 77: , a12 out JTF_VARCHAR2_TABLE_100

73: , a8 out JTF_DATE_TABLE
74: , a9 out JTF_NUMBER_TABLE
75: , a10 out JTF_NUMBER_TABLE
76: , a11 out JTF_VARCHAR2_TABLE_100
77: , a12 out JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then

Line 82: a0 := JTF_VARCHAR2_TABLE_100();

78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();

Line 83: a1 := JTF_VARCHAR2_TABLE_100();

79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_VARCHAR2_TABLE_100();

Line 86: a4 := JTF_VARCHAR2_TABLE_100();

82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_DATE_TABLE();

Line 87: a5 := JTF_VARCHAR2_TABLE_100();

83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_DATE_TABLE();
91: a9 := JTF_NUMBER_TABLE();

Line 93: a11 := JTF_VARCHAR2_TABLE_100();

89: a7 := JTF_DATE_TABLE();
90: a8 := JTF_DATE_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_VARCHAR2_TABLE_100();

Line 94: a12 := JTF_VARCHAR2_TABLE_100();

90: a8 := JTF_DATE_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_NUMBER_TABLE();

Line 96: a0 := JTF_VARCHAR2_TABLE_100();

92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();

Line 97: a1 := JTF_VARCHAR2_TABLE_100();

93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_VARCHAR2_TABLE_100();

Line 100: a4 := JTF_VARCHAR2_TABLE_100();

96: a0 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_VARCHAR2_TABLE_100();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_DATE_TABLE();

Line 101: a5 := JTF_VARCHAR2_TABLE_100();

97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_VARCHAR2_TABLE_100();
101: a5 := JTF_VARCHAR2_TABLE_100();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_NUMBER_TABLE();

Line 107: a11 := JTF_VARCHAR2_TABLE_100();

103: a7 := JTF_DATE_TABLE();
104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_100();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);

Line 108: a12 := JTF_VARCHAR2_TABLE_100();

104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_NUMBER_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_VARCHAR2_TABLE_100();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);
112: a2.extend(t.count);

Line 157: , p8_a0 out JTF_VARCHAR2_TABLE_100

153: , p_comp_group_id NUMBER
154: , p_focus_cg_id NUMBER
155: , p_expand CHAR
156: , p_date date
157: , p8_a0 out JTF_VARCHAR2_TABLE_100
158: , p8_a1 out JTF_VARCHAR2_TABLE_100
159: , p8_a2 out JTF_NUMBER_TABLE
160: , p8_a3 out JTF_NUMBER_TABLE
161: , p8_a4 out JTF_VARCHAR2_TABLE_100

Line 158: , p8_a1 out JTF_VARCHAR2_TABLE_100

154: , p_focus_cg_id NUMBER
155: , p_expand CHAR
156: , p_date date
157: , p8_a0 out JTF_VARCHAR2_TABLE_100
158: , p8_a1 out JTF_VARCHAR2_TABLE_100
159: , p8_a2 out JTF_NUMBER_TABLE
160: , p8_a3 out JTF_NUMBER_TABLE
161: , p8_a4 out JTF_VARCHAR2_TABLE_100
162: , p8_a5 out JTF_VARCHAR2_TABLE_100

Line 161: , p8_a4 out JTF_VARCHAR2_TABLE_100

157: , p8_a0 out JTF_VARCHAR2_TABLE_100
158: , p8_a1 out JTF_VARCHAR2_TABLE_100
159: , p8_a2 out JTF_NUMBER_TABLE
160: , p8_a3 out JTF_NUMBER_TABLE
161: , p8_a4 out JTF_VARCHAR2_TABLE_100
162: , p8_a5 out JTF_VARCHAR2_TABLE_100
163: , p8_a6 out JTF_NUMBER_TABLE
164: , p8_a7 out JTF_DATE_TABLE
165: , p8_a8 out JTF_DATE_TABLE

Line 162: , p8_a5 out JTF_VARCHAR2_TABLE_100

158: , p8_a1 out JTF_VARCHAR2_TABLE_100
159: , p8_a2 out JTF_NUMBER_TABLE
160: , p8_a3 out JTF_NUMBER_TABLE
161: , p8_a4 out JTF_VARCHAR2_TABLE_100
162: , p8_a5 out JTF_VARCHAR2_TABLE_100
163: , p8_a6 out JTF_NUMBER_TABLE
164: , p8_a7 out JTF_DATE_TABLE
165: , p8_a8 out JTF_DATE_TABLE
166: , p8_a9 out JTF_NUMBER_TABLE

Line 168: , p8_a11 out JTF_VARCHAR2_TABLE_100

164: , p8_a7 out JTF_DATE_TABLE
165: , p8_a8 out JTF_DATE_TABLE
166: , p8_a9 out JTF_NUMBER_TABLE
167: , p8_a10 out JTF_NUMBER_TABLE
168: , p8_a11 out JTF_VARCHAR2_TABLE_100
169: , p8_a12 out JTF_VARCHAR2_TABLE_100
170: , l_mgr_count out NUMBER
171: , x_period_year out VARCHAR2
172: , x_return_status out VARCHAR2

Line 169: , p8_a12 out JTF_VARCHAR2_TABLE_100

165: , p8_a8 out JTF_DATE_TABLE
166: , p8_a9 out JTF_NUMBER_TABLE
167: , p8_a10 out JTF_NUMBER_TABLE
168: , p8_a11 out JTF_VARCHAR2_TABLE_100
169: , p8_a12 out JTF_VARCHAR2_TABLE_100
170: , l_mgr_count out NUMBER
171: , x_period_year out VARCHAR2
172: , x_return_status out VARCHAR2
173: , x_msg_count out NUMBER