[Home] [Help]
PACKAGE: APPS.CN_CALC_SQL_EXPS_PVT_W
Source
1 package cn_calc_sql_exps_pvt_w as
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
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
17 );
18
19 procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100
20 , a1 JTF_VARCHAR2_TABLE_100
21 , a2 JTF_VARCHAR2_TABLE_100
22 , a3 JTF_VARCHAR2_TABLE_4000
23 );
24 procedure rosetta_table_copy_out_p4(t cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25 , a1 out nocopy JTF_VARCHAR2_TABLE_100
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
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
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 );
48 procedure get_parent_plan_elts(p_api_version NUMBER
49 , p_init_msg_list VARCHAR2
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 );
59 end cn_calc_sql_exps_pvt_w;