1 package FF_FORMULA_WEBUI_PKG AUTHID CURRENT_USER as
2 /* $Header: fffwebpk.pkh 120.4 2012/02/08 15:03:15 asnell ship $ */
3 --
4 procedure generate_unique_formula_name(
5 p_formula_type_id in varchar2,
6 p_business_group_id in number,
7 p_legislation_code in varchar2,
8 p_formula_name out nocopy varchar2
9 );
10 --
11 procedure validate_formula_name(
12 p_formula_name in out nocopy varchar2,
13 p_formula_type_id in number,
14 p_business_group_id in number,
15 p_legislation_code in varchar2,
16 p_effective_start_date in date,
17 p_effective_end_date in out nocopy date,
18 p_return_status out nocopy varchar2
19 );
20 --
21 procedure insert_formula(
22 p_rowid in out nocopy varchar2,
23 p_formula_id in out nocopy varchar2,
24 p_effective_start_date in date,
25 p_effective_end_date in date,
26 p_business_group_id in number,
27 p_legislation_code in varchar2,
28 p_formula_type_id in varchar2,
29 p_formula_name in out nocopy varchar2,
30 p_description in varchar2,
31 p_formula_text in clob,
32 p_sticky_flag in varchar2,
33 p_last_update_date in out nocopy date,
34 p_return_status out nocopy varchar2
35 );
36 --
37 procedure update_formula(
38 p_rowid in varchar2,
39 p_formula_id in number,
40 p_effective_start_date in date,
41 p_effective_end_date in date,
42 p_business_group_id in number,
43 p_legislation_code in varchar2,
44 p_formula_type_id in varchar2,
45 p_formula_name in varchar2,
46 p_description in varchar2,
47 p_formula_text in clob,
48 p_sticky_flag in varchar2,
49 p_last_update_date in out nocopy date,
50 p_return_status out nocopy varchar2
51 );
52 --
53 procedure delete_formula(
54 p_rowid in varchar2,
55 p_formula_id in number,
56 p_dt_delete_mode in varchar2,
57 p_validation_start_date in date,
58 p_validation_end_date in date,
59 p_effective_date in date,
60 p_return_status out nocopy varchar2
61 );
62 --
63 procedure lock_formula(
64 p_rowid in varchar2,
65 p_last_update_date in date,
66 p_return_status out nocopy varchar2
67 );
68 --
69 procedure compile_formula(
70 p_formula_id in number,
71 p_effective_date in date,
72 p_outcome out nocopy varchar2,
73 p_message out nocopy varchar2
74 );
75 --
76 procedure compile_formula_autonomously(
77 p_formula_type_id in number,
78 p_effective_start_date in date,
79 p_effective_end_date in date,
80 p_business_group_id in number,
81 p_legislation_code in varchar2,
82 p_formula_text in clob,
83 p_outcome out nocopy varchar2,
84 p_message out nocopy varchar2,
85 p_return_status out nocopy varchar2
86 );
87 --
88 procedure run_formula(
89 p_formula_id in number,
90 p_session_date in date,
91 p_input_name1 in varchar2,
92 p_input_name2 in varchar2,
93 p_input_name3 in varchar2,
94 p_input_name4 in varchar2,
95 p_input_name5 in varchar2,
96 p_input_name6 in varchar2,
97 p_input_name7 in varchar2,
98 p_input_name8 in varchar2,
99 p_input_name9 in varchar2,
100 p_input_name10 in varchar2,
101 p_input_name11 in varchar2,
102 p_input_name12 in varchar2,
103 p_input_name13 in varchar2,
104 p_input_name14 in varchar2,
105 p_input_name15 in varchar2,
106 p_input_name16 in varchar2,
107 p_input_name17 in varchar2,
108 p_input_name18 in varchar2,
109 p_input_name19 in varchar2,
110 p_input_name20 in varchar2,
111 p_input_name21 in varchar2,
112 p_input_name22 in varchar2,
113 p_input_name23 in varchar2,
114 p_input_name24 in varchar2,
115 p_input_name25 in varchar2,
116 p_input_name26 in varchar2,
117 p_input_name27 in varchar2,
118 p_input_name28 in varchar2,
119 p_input_name29 in varchar2,
120 p_input_name30 in varchar2,
121 p_input_value1 in varchar2,
122 p_input_value2 in varchar2,
123 p_input_value3 in varchar2,
124 p_input_value4 in varchar2,
125 p_input_value5 in varchar2,
126 p_input_value6 in varchar2,
127 p_input_value7 in varchar2,
128 p_input_value8 in varchar2,
129 p_input_value9 in varchar2,
130 p_input_value10 in varchar2,
131 p_input_value11 in varchar2,
132 p_input_value12 in varchar2,
133 p_input_value13 in varchar2,
134 p_input_value14 in varchar2,
135 p_input_value15 in varchar2,
136 p_input_value16 in varchar2,
137 p_input_value17 in varchar2,
138 p_input_value18 in varchar2,
139 p_input_value19 in varchar2,
140 p_input_value20 in varchar2,
141 p_input_value21 in varchar2,
142 p_input_value22 in varchar2,
143 p_input_value23 in varchar2,
144 p_input_value24 in varchar2,
145 p_input_value25 in varchar2,
146 p_input_value26 in varchar2,
147 p_input_value27 in varchar2,
148 p_input_value28 in varchar2,
149 p_input_value29 in varchar2,
150 p_input_value30 in varchar2,
151 p_output_name1 in out nocopy varchar2,
152 p_output_name2 in out nocopy varchar2,
153 p_output_name3 in out nocopy varchar2,
154 p_output_name4 in out nocopy varchar2,
155 p_output_name5 in out nocopy varchar2,
156 p_output_name6 in out nocopy varchar2,
157 p_output_name7 in out nocopy varchar2,
158 p_output_name8 in out nocopy varchar2,
159 p_output_name9 in out nocopy varchar2,
160 p_output_name10 in out nocopy varchar2,
161 p_output_name11 in out nocopy varchar2,
162 p_output_name12 in out nocopy varchar2,
163 p_output_name13 in out nocopy varchar2,
164 p_output_name14 in out nocopy varchar2,
165 p_output_name15 in out nocopy varchar2,
166 p_output_name16 in out nocopy varchar2,
167 p_output_name17 in out nocopy varchar2,
168 p_output_name18 in out nocopy varchar2,
169 p_output_name19 in out nocopy varchar2,
170 p_output_name20 in out nocopy varchar2,
171 p_output_name21 in out nocopy varchar2,
172 p_output_name22 in out nocopy varchar2,
173 p_output_name23 in out nocopy varchar2,
174 p_output_name24 in out nocopy varchar2,
175 p_output_name25 in out nocopy varchar2,
176 p_output_name26 in out nocopy varchar2,
177 p_output_name27 in out nocopy varchar2,
178 p_output_name28 in out nocopy varchar2,
179 p_output_name29 in out nocopy varchar2,
180 p_output_name30 in out nocopy varchar2,
181 p_output_value1 out nocopy varchar2,
182 p_output_value2 out nocopy varchar2,
183 p_output_value3 out nocopy varchar2,
184 p_output_value4 out nocopy varchar2,
185 p_output_value5 out nocopy varchar2,
186 p_output_value6 out nocopy varchar2,
187 p_output_value7 out nocopy varchar2,
188 p_output_value8 out nocopy varchar2,
189 p_output_value9 out nocopy varchar2,
190 p_output_value10 out nocopy varchar2,
191 p_output_value11 out nocopy varchar2,
192 p_output_value12 out nocopy varchar2,
193 p_output_value13 out nocopy varchar2,
194 p_output_value14 out nocopy varchar2,
195 p_output_value15 out nocopy varchar2,
196 p_output_value16 out nocopy varchar2,
197 p_output_value17 out nocopy varchar2,
198 p_output_value18 out nocopy varchar2,
199 p_output_value19 out nocopy varchar2,
200 p_output_value20 out nocopy varchar2,
201 p_output_value21 out nocopy varchar2,
202 p_output_value22 out nocopy varchar2,
203 p_output_value23 out nocopy varchar2,
204 p_output_value24 out nocopy varchar2,
205 p_output_value25 out nocopy varchar2,
206 p_output_value26 out nocopy varchar2,
207 p_output_value27 out nocopy varchar2,
208 p_output_value28 out nocopy varchar2,
209 p_output_value29 out nocopy varchar2,
210 p_output_value30 out nocopy varchar2,
211 p_return_status out nocopy varchar2
212 );
213 --
214 function isFormulaCompiled(
215 p_formula_id in number,
216 p_effective_date in date) return varchar2;
217 --
218 function list_function_params(
219 p_function_id in number) return varchar2;
220 --
221 function submit_singlecompile(
222 p_formula_type in varchar2,
223 p_formula_name in varchar2
224 ) return number;
225
226 end FF_FORMULA_WEBUI_PKG;
[Home] [Help]