DBA Data[Home] [Help]

APPS.CN_CALC_SQL_EXPS_PVT_W dependencies on JTF_NUMBER_TABLE

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

2: /* $Header: cnwcexps.pls 120.6 2007/03/14 12:57:03 kjayapau ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p0(t cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p2(t out nocopy cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_100
8: , a2 JTF_VARCHAR2_TABLE_100
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100

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

8: , a2 JTF_VARCHAR2_TABLE_100
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p2(t cn_calc_sql_exps_pvt.calc_expression_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 30: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_sql_exps_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);

26: , a2 out nocopy JTF_VARCHAR2_TABLE_100
27: , a3 out nocopy JTF_VARCHAR2_TABLE_4000
28: );
29:
30: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_sql_exps_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);
31: procedure rosetta_table_copy_out_p5(t cn_calc_sql_exps_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
32:
33: procedure parse_plan_elements(p_sql_select VARCHAR2
34: , x_plan_elt_tbl out nocopy JTF_NUMBER_TABLE

Line 31: procedure rosetta_table_copy_out_p5(t cn_calc_sql_exps_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

27: , a3 out nocopy JTF_VARCHAR2_TABLE_4000
28: );
29:
30: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_sql_exps_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);
31: procedure rosetta_table_copy_out_p5(t cn_calc_sql_exps_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
32:
33: procedure parse_plan_elements(p_sql_select VARCHAR2
34: , x_plan_elt_tbl out nocopy JTF_NUMBER_TABLE
35: , x_parsed_sql_select out nocopy VARCHAR2

Line 34: , x_plan_elt_tbl out nocopy JTF_NUMBER_TABLE

30: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_sql_exps_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);
31: procedure rosetta_table_copy_out_p5(t cn_calc_sql_exps_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
32:
33: procedure parse_plan_elements(p_sql_select VARCHAR2
34: , x_plan_elt_tbl out nocopy JTF_NUMBER_TABLE
35: , x_parsed_sql_select out nocopy VARCHAR2
36: );
37: procedure get_dependent_plan_elts(p_api_version NUMBER
38: , p_init_msg_list VARCHAR2

Line 43: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE

39: , p_commit VARCHAR2
40: , p_validation_level NUMBER
41: , p_node_type VARCHAR2
42: , p_node_id NUMBER
43: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE
44: , x_return_status out nocopy VARCHAR2
45: , x_msg_count out nocopy NUMBER
46: , x_msg_data out nocopy VARCHAR2
47: );

Line 54: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE

50: , p_commit VARCHAR2
51: , p_validation_level NUMBER
52: , p_node_type VARCHAR2
53: , p_node_id NUMBER
54: , x_plan_elt_id_tbl out nocopy JTF_NUMBER_TABLE
55: , x_return_status out nocopy VARCHAR2
56: , x_msg_count out nocopy NUMBER
57: , x_msg_data out nocopy VARCHAR2
58: );