[Home] [Help]
PACKAGE: APPS.CN_CALC_FORMULAS_PVT_W
Source
1 package cn_calc_formulas_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwforms.pls 120.3 2006/01/05 18:08 jxsingh ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy cn_calc_formulas_pvt.input_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 );
15 procedure rosetta_table_copy_out_p3(t cn_calc_formulas_pvt.input_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_NUMBER_TABLE
17 , a2 out nocopy JTF_NUMBER_TABLE
18 , a3 out nocopy JTF_NUMBER_TABLE
19 , a4 out nocopy JTF_VARCHAR2_TABLE_100
20 , a5 out nocopy JTF_VARCHAR2_TABLE_100
21 , a6 out nocopy JTF_VARCHAR2_TABLE_100
22 , a7 out nocopy JTF_VARCHAR2_TABLE_100
23 , a8 out nocopy JTF_NUMBER_TABLE
24 , a9 out nocopy JTF_VARCHAR2_TABLE_100
25 , a10 out nocopy JTF_VARCHAR2_TABLE_100
26 );
27
28 procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_formulas_pvt.rt_assign_tbl_type, a0 JTF_NUMBER_TABLE
29 , a1 JTF_NUMBER_TABLE
30 , a2 JTF_DATE_TABLE
31 , a3 JTF_DATE_TABLE
32 , a4 JTF_VARCHAR2_TABLE_100
33 , a5 JTF_VARCHAR2_TABLE_100
34 , a6 JTF_NUMBER_TABLE
35 );
36 procedure rosetta_table_copy_out_p4(t cn_calc_formulas_pvt.rt_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37 , a1 out nocopy JTF_NUMBER_TABLE
38 , a2 out nocopy JTF_DATE_TABLE
39 , a3 out nocopy JTF_DATE_TABLE
40 , a4 out nocopy JTF_VARCHAR2_TABLE_100
41 , a5 out nocopy JTF_VARCHAR2_TABLE_100
42 , a6 out nocopy JTF_NUMBER_TABLE
43 );
44
45 procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_formulas_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
46 procedure rosetta_table_copy_out_p5(t cn_calc_formulas_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
47
48 procedure rosetta_table_copy_in_p6(t out nocopy cn_calc_formulas_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
49 , a1 JTF_VARCHAR2_TABLE_100
50 , a2 JTF_VARCHAR2_TABLE_100
51 , a3 JTF_VARCHAR2_TABLE_100
52 , a4 JTF_VARCHAR2_TABLE_100
53 , a5 JTF_VARCHAR2_TABLE_100
54 , a6 JTF_NUMBER_TABLE
55 , a7 JTF_VARCHAR2_TABLE_100
56 , a8 JTF_VARCHAR2_TABLE_100
57 , a9 JTF_VARCHAR2_TABLE_100
58 , a10 JTF_VARCHAR2_TABLE_100
59 , a11 JTF_VARCHAR2_TABLE_100
60 , a12 JTF_NUMBER_TABLE
61 , a13 JTF_NUMBER_TABLE
62 , a14 JTF_NUMBER_TABLE
63 , a15 JTF_NUMBER_TABLE
64 );
65 procedure rosetta_table_copy_out_p6(t cn_calc_formulas_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66 , a1 out nocopy JTF_VARCHAR2_TABLE_100
67 , a2 out nocopy JTF_VARCHAR2_TABLE_100
68 , a3 out nocopy JTF_VARCHAR2_TABLE_100
69 , a4 out nocopy JTF_VARCHAR2_TABLE_100
70 , a5 out nocopy JTF_VARCHAR2_TABLE_100
71 , a6 out nocopy JTF_NUMBER_TABLE
72 , a7 out nocopy JTF_VARCHAR2_TABLE_100
73 , a8 out nocopy JTF_VARCHAR2_TABLE_100
74 , a9 out nocopy JTF_VARCHAR2_TABLE_100
75 , a10 out nocopy JTF_VARCHAR2_TABLE_100
76 , a11 out nocopy JTF_VARCHAR2_TABLE_100
77 , a12 out nocopy JTF_NUMBER_TABLE
78 , a13 out nocopy JTF_NUMBER_TABLE
79 , a14 out nocopy JTF_NUMBER_TABLE
80 , a15 out nocopy JTF_NUMBER_TABLE
81 );
82
83 procedure create_formula(p_api_version NUMBER
84 , p_init_msg_list VARCHAR2
85 , p_commit VARCHAR2
86 , p_validation_level NUMBER
87 , p_generate_packages VARCHAR2
88 , p_name VARCHAR2
89 , p_description VARCHAR2
90 , p_formula_type VARCHAR2
91 , p_trx_group_code VARCHAR2
92 , p_number_dim NUMBER
93 , p_cumulative_flag VARCHAR2
94 , p_itd_flag VARCHAR2
95 , p_split_flag VARCHAR2
96 , p_threshold_all_tier_flag VARCHAR2
97 , p_modeling_flag VARCHAR2
98 , p_perf_measure_id NUMBER
99 , p_output_exp_id NUMBER
100 , p_f_output_exp_id NUMBER
101 , p18_a0 JTF_NUMBER_TABLE
102 , p18_a1 JTF_NUMBER_TABLE
103 , p18_a2 JTF_NUMBER_TABLE
104 , p18_a3 JTF_NUMBER_TABLE
105 , p18_a4 JTF_VARCHAR2_TABLE_100
106 , p18_a5 JTF_VARCHAR2_TABLE_100
107 , p18_a6 JTF_VARCHAR2_TABLE_100
108 , p18_a7 JTF_VARCHAR2_TABLE_100
109 , p18_a8 JTF_NUMBER_TABLE
110 , p18_a9 JTF_VARCHAR2_TABLE_100
111 , p18_a10 JTF_VARCHAR2_TABLE_100
112 , p19_a0 JTF_NUMBER_TABLE
113 , p19_a1 JTF_NUMBER_TABLE
114 , p19_a2 JTF_DATE_TABLE
115 , p19_a3 JTF_DATE_TABLE
116 , p19_a4 JTF_VARCHAR2_TABLE_100
117 , p19_a5 JTF_VARCHAR2_TABLE_100
118 , p19_a6 JTF_NUMBER_TABLE
119 , p_org_id NUMBER
120 , x_calc_formula_id in out nocopy NUMBER
121 , x_formula_status out nocopy VARCHAR2
122 , x_return_status out nocopy VARCHAR2
123 , x_msg_count out nocopy NUMBER
124 , x_msg_data out nocopy VARCHAR2
125 );
126 procedure update_formula(p_api_version NUMBER
127 , p_init_msg_list VARCHAR2
128 , p_commit VARCHAR2
129 , p_validation_level NUMBER
130 , p_generate_packages VARCHAR2
131 , p_calc_formula_id NUMBER
132 , p_name VARCHAR2
133 , p_description VARCHAR2
134 , p_formula_type VARCHAR2
135 , p_formula_status VARCHAR2
136 , p_trx_group_code VARCHAR2
137 , p_number_dim NUMBER
138 , p_cumulative_flag VARCHAR2
139 , p_itd_flag VARCHAR2
140 , p_split_flag VARCHAR2
141 , p_threshold_all_tier_flag VARCHAR2
142 , p_modeling_flag VARCHAR2
143 , p_perf_measure_id NUMBER
144 , p_output_exp_id NUMBER
145 , p_f_output_exp_id NUMBER
146 , p20_a0 JTF_NUMBER_TABLE
147 , p20_a1 JTF_NUMBER_TABLE
148 , p20_a2 JTF_NUMBER_TABLE
149 , p20_a3 JTF_NUMBER_TABLE
150 , p20_a4 JTF_VARCHAR2_TABLE_100
151 , p20_a5 JTF_VARCHAR2_TABLE_100
152 , p20_a6 JTF_VARCHAR2_TABLE_100
153 , p20_a7 JTF_VARCHAR2_TABLE_100
154 , p20_a8 JTF_NUMBER_TABLE
155 , p20_a9 JTF_VARCHAR2_TABLE_100
156 , p20_a10 JTF_VARCHAR2_TABLE_100
157 , p21_a0 JTF_NUMBER_TABLE
158 , p21_a1 JTF_NUMBER_TABLE
159 , p21_a2 JTF_DATE_TABLE
160 , p21_a3 JTF_DATE_TABLE
161 , p21_a4 JTF_VARCHAR2_TABLE_100
162 , p21_a5 JTF_VARCHAR2_TABLE_100
163 , p21_a6 JTF_NUMBER_TABLE
164 , p_org_id NUMBER
165 , p_object_version_number in out nocopy NUMBER
166 , x_formula_status out nocopy VARCHAR2
167 , x_return_status out nocopy VARCHAR2
168 , x_msg_count out nocopy NUMBER
169 , x_msg_data out nocopy VARCHAR2
170 );
171 end cn_calc_formulas_pvt_w;