PACKAGE: APPS.CN_CALC_SQL_EXPS_PVT_W

Source

1 package cn_calc_sql_exps_pvt_w AUTHID CURRENT_USER 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;