DBA Data[Home] [Help]

APPS.CN_CALC_SQL_EXPS_PVT_W dependencies on CN_CALC_SQL_EXPS_PVT

Line 1: package cn_calc_sql_exps_pvt_w AUTHID CURRENT_USER as

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:

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100);

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

Line 4: procedure rosetta_table_copy_out_p0(t cn_calc_sql_exps_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);

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

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 19: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 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: );

Line 24: procedure rosetta_table_copy_out_p4(t cn_calc_sql_exps_pvt.expr_type_tbl_type, a0 out nocopy 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: );

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 59: end cn_calc_sql_exps_pvt_w;

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;