APPS.CN_CALC_SQL_EXPS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 44: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE

40: end if;
41: end if;
42: end rosetta_table_copy_out_p0;
43:
44: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_VARCHAR2_TABLE_100
46: , a2 JTF_VARCHAR2_TABLE_100
47: , a3 JTF_VARCHAR2_TABLE_100
48: , a4 JTF_VARCHAR2_TABLE_100

Line 71: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

67: end loop;
68: end if;
69: end if;
70: end rosetta_table_copy_in_p2;
71: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_VARCHAR2_TABLE_100
73: , a2 out nocopy JTF_VARCHAR2_TABLE_100
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: a0 := JTF_NUMBER_TABLE();

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

Line 86: a0 := JTF_NUMBER_TABLE();

82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: else
86: a0 := JTF_NUMBER_TABLE();
87: a1 := JTF_VARCHAR2_TABLE_100();
88: a2 := JTF_VARCHAR2_TABLE_100();
89: a3 := JTF_VARCHAR2_TABLE_100();
90: a4 := JTF_VARCHAR2_TABLE_100();

Line 179: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_sql_exps_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as

175: end if;
176: end if;
177: end rosetta_table_copy_out_p4;
178:
179: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_sql_exps_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as
180: ddindx binary_integer; indx binary_integer;
181: begin
182: if a0 is not null and a0.count > 0 then
183: if a0.count > 0 then

Line 197: procedure rosetta_table_copy_out_p5(t cn_calc_sql_exps_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

193: end loop;
194: end if;
195: end if;
196: end rosetta_table_copy_in_p5;
197: procedure rosetta_table_copy_out_p5(t cn_calc_sql_exps_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
198: ddindx binary_integer; indx binary_integer;
199: begin
200: if t is null or t.count = 0 then
201: a0 := JTF_NUMBER_TABLE();

Line 201: a0 := JTF_NUMBER_TABLE();

197: procedure rosetta_table_copy_out_p5(t cn_calc_sql_exps_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
198: ddindx binary_integer; indx binary_integer;
199: begin
200: if t is null or t.count = 0 then
201: a0 := JTF_NUMBER_TABLE();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);

Line 203: a0 := JTF_NUMBER_TABLE();

199: begin
200: if t is null or t.count = 0 then
201: a0 := JTF_NUMBER_TABLE();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
206: ddindx := t.first;
207: indx := 1;

Line 221: , x_plan_elt_tbl out nocopy JTF_NUMBER_TABLE

217: end if;
218: end rosetta_table_copy_out_p5;
219:
220: procedure parse_plan_elements(p_sql_select VARCHAR2
221: , x_plan_elt_tbl out nocopy JTF_NUMBER_TABLE
222: , x_parsed_sql_select out nocopy VARCHAR2
223: )
224:
225: as

Line 251: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE

247: , p_commit VARCHAR2
248: , p_validation_level NUMBER
249: , p_node_type VARCHAR2
250: , p_node_id NUMBER
251: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE
252: , x_return_status out nocopy VARCHAR2
253: , x_msg_count out nocopy NUMBER
254: , x_msg_data out nocopy VARCHAR2
255: )

Line 304: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE

300: , p_commit VARCHAR2
301: , p_validation_level NUMBER
302: , p_node_type VARCHAR2
303: , p_node_id NUMBER
304: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE
305: , x_return_status out nocopy VARCHAR2
306: , x_msg_count out nocopy NUMBER
307: , x_msg_data out nocopy VARCHAR2
308: )