1 Package pay_element_template_util as
2 /* $Header: pyetmutl.pkh 120.0 2005/05/29 04:43:00 appldev noship $ */
3 -------------------------------------------------------------------
4 -- Placeholder string used within formula text and flex columns. --
5 -------------------------------------------------------------------
6 g_name_placeholder constant varchar2(30) default '<BASE NAME>';
7 -----------------------------------
8 -- PL/SQL table types used here. --
9 -----------------------------------
10 type t_boolean is table of boolean index by binary_integer;
11 type t_exclusion_rules is table of pay_ter_shd.g_rec_type index by
12 binary_integer;
13 type t_formulas is table of pay_sf_shd.g_rec_type index by binary_integer;
14 type t_balance_types is table of pay_sbt_shd.g_rec_type index by
15 binary_integer;
16 type t_defined_balances is table of pay_sdb_shd.g_rec_type index by
17 binary_integer;
18 type t_element_types is table of pay_set_shd.g_rec_type index by
19 binary_integer;
20 type t_sub_classi_rules is table of pay_ssr_shd.g_rec_type index by
21 binary_integer;
22 type t_balance_classis is table of pay_sbc_shd.g_rec_type index by
23 binary_integer;
24 type t_input_values is table of pay_siv_shd.g_rec_type index by
25 binary_integer;
26 type t_balance_feeds is table of pay_sbf_shd.g_rec_type index by
27 binary_integer;
28 type t_formula_rules is table of pay_sfr_shd.g_rec_type index by
29 binary_integer;
30 type t_core_objects is table of pay_tco_shd.g_rec_type index by binary_integer;
31 type t_iterative_rules is table of pay_sir_shd.g_rec_type index by
32 binary_integer;
33 type t_ele_type_usages is table of pay_seu_shd.g_rec_type index by
34 binary_integer;
35 type t_gu_bal_exclusions is table of pay_sgb_shd.g_rec_type index by
36 binary_integer;
37 type t_bal_attributes is table of pay_sba_shd.g_rec_type index by
38 binary_integer;
39 type t_template_ff_usages is table of pay_tfu_shd.g_rec_type index by
40 binary_integer;
41 -- ----------------------------------------------------------------------------
42 -- |---------------------------< get_template_type >--------------------------|
43 -- ----------------------------------------------------------------------------
44 function get_template_type(p_template_id in number) return varchar2;
45 -- ----------------------------------------------------------------------------
46 -- |------------------------< create_plsql_template >-------------------------|
47 -- ----------------------------------------------------------------------------
48 procedure create_plsql_template
49 (p_lock in boolean default false
50 ,p_template_id in number
51 ,p_generate_part1 in boolean default false
52 ,p_generate_part2 in boolean default false
53 ,p_element_template in out nocopy pay_etm_shd.g_rec_type
54 ,p_core_objects in out nocopy t_core_objects
55 ,p_exclusion_rules in out nocopy t_exclusion_rules
56 ,p_formulas in out nocopy t_formulas
57 ,p_balance_types in out nocopy t_balance_types
58 ,p_defined_balances in out nocopy t_defined_balances
59 ,p_element_types in out nocopy t_element_types
60 ,p_sub_classi_rules in out nocopy t_sub_classi_rules
61 ,p_balance_classis in out nocopy t_balance_classis
62 ,p_input_values in out nocopy t_input_values
63 ,p_balance_feeds in out nocopy t_balance_feeds
64 ,p_formula_rules in out nocopy t_formula_rules
65 ,p_iterative_rules in out nocopy t_iterative_rules
66 ,p_ele_type_usages in out nocopy t_ele_type_usages
67 ,p_gu_bal_exclusions in out nocopy t_gu_bal_exclusions
68 ,p_bal_attributes in out nocopy t_bal_attributes
69 ,p_template_ff_usages in out nocopy t_template_ff_usages
70 );
71 -- ----------------------------------------------------------------------------
72 -- |------------------------< flush_plsql_template >--------------------------|
73 -- ----------------------------------------------------------------------------
74 procedure flush_plsql_template
75 (p_element_template in out nocopy pay_etm_shd.g_rec_type
76 ,p_core_objects in out nocopy t_core_objects
77 ,p_exclusion_rules in out nocopy t_exclusion_rules
78 ,p_formulas in out nocopy t_formulas
79 ,p_balance_types in out nocopy t_balance_types
80 ,p_defined_balances in out nocopy t_defined_balances
81 ,p_element_types in out nocopy t_element_types
82 ,p_sub_classi_rules in out nocopy t_sub_classi_rules
83 ,p_balance_classis in out nocopy t_balance_classis
84 ,p_input_values in out nocopy t_input_values
85 ,p_balance_feeds in out nocopy t_balance_feeds
86 ,p_formula_rules in out nocopy t_formula_rules
87 ,p_iterative_rules in out nocopy t_iterative_rules
88 ,p_ele_type_usages in out nocopy t_ele_type_usages
89 ,p_gu_bal_exclusions in out nocopy t_gu_bal_exclusions
90 ,p_bal_attributes in out nocopy t_bal_attributes
91 ,p_template_ff_usages in out nocopy t_template_ff_usages
92 );
93 -- ----------------------------------------------------------------------------
94 -- |-------------------< create_plsql_user_structure >------------------------|
95 -- ----------------------------------------------------------------------------
96 procedure create_plsql_user_structure
97 (p_business_group_id in number
98 ,p_base_name in varchar2
99 ,p_base_processing_priority in number default null
100 ,p_preference_info_category in varchar2 default null
101 ,p_preference_information1 in varchar2 default null
102 ,p_preference_information2 in varchar2 default null
103 ,p_preference_information3 in varchar2 default null
104 ,p_preference_information4 in varchar2 default null
105 ,p_preference_information5 in varchar2 default null
106 ,p_preference_information6 in varchar2 default null
107 ,p_preference_information7 in varchar2 default null
108 ,p_preference_information8 in varchar2 default null
109 ,p_preference_information9 in varchar2 default null
110 ,p_preference_information10 in varchar2 default null
111 ,p_preference_information11 in varchar2 default null
112 ,p_preference_information12 in varchar2 default null
113 ,p_preference_information13 in varchar2 default null
114 ,p_preference_information14 in varchar2 default null
115 ,p_preference_information15 in varchar2 default null
116 ,p_preference_information16 in varchar2 default null
117 ,p_preference_information17 in varchar2 default null
118 ,p_preference_information18 in varchar2 default null
119 ,p_preference_information19 in varchar2 default null
120 ,p_preference_information20 in varchar2 default null
121 ,p_preference_information21 in varchar2 default null
122 ,p_preference_information22 in varchar2 default null
123 ,p_preference_information23 in varchar2 default null
124 ,p_preference_information24 in varchar2 default null
125 ,p_preference_information25 in varchar2 default null
126 ,p_preference_information26 in varchar2 default null
127 ,p_preference_information27 in varchar2 default null
128 ,p_preference_information28 in varchar2 default null
129 ,p_preference_information29 in varchar2 default null
130 ,p_preference_information30 in varchar2 default null
131 ,p_configuration_info_category in varchar2 default null
132 ,p_configuration_information1 in varchar2 default null
133 ,p_configuration_information2 in varchar2 default null
134 ,p_configuration_information3 in varchar2 default null
135 ,p_configuration_information4 in varchar2 default null
136 ,p_configuration_information5 in varchar2 default null
137 ,p_configuration_information6 in varchar2 default null
138 ,p_configuration_information7 in varchar2 default null
139 ,p_configuration_information8 in varchar2 default null
140 ,p_configuration_information9 in varchar2 default null
141 ,p_configuration_information10 in varchar2 default null
142 ,p_configuration_information11 in varchar2 default null
143 ,p_configuration_information12 in varchar2 default null
144 ,p_configuration_information13 in varchar2 default null
145 ,p_configuration_information14 in varchar2 default null
146 ,p_configuration_information15 in varchar2 default null
147 ,p_configuration_information16 in varchar2 default null
148 ,p_configuration_information17 in varchar2 default null
149 ,p_configuration_information18 in varchar2 default null
150 ,p_configuration_information19 in varchar2 default null
151 ,p_configuration_information20 in varchar2 default null
152 ,p_configuration_information21 in varchar2 default null
153 ,p_configuration_information22 in varchar2 default null
154 ,p_configuration_information23 in varchar2 default null
155 ,p_configuration_information24 in varchar2 default null
156 ,p_configuration_information25 in varchar2 default null
157 ,p_configuration_information26 in varchar2 default null
158 ,p_configuration_information27 in varchar2 default null
159 ,p_configuration_information28 in varchar2 default null
160 ,p_configuration_information29 in varchar2 default null
161 ,p_configuration_information30 in varchar2 default null
162 ,p_prefix_reporting_name in varchar2 default 'N'
163 ,p_element_template in out nocopy pay_etm_shd.g_rec_type
164 ,p_exclusion_rules in out nocopy t_exclusion_rules
165 ,p_formulas in out nocopy t_formulas
166 ,p_balance_types in out nocopy t_balance_types
167 ,p_defined_balances in out nocopy t_defined_balances
168 ,p_element_types in out nocopy t_element_types
169 ,p_sub_classi_rules in out nocopy t_sub_classi_rules
170 ,p_balance_classis in out nocopy t_balance_classis
171 ,p_input_values in out nocopy t_input_values
172 ,p_balance_feeds in out nocopy t_balance_feeds
173 ,p_formula_rules in out nocopy t_formula_rules
174 ,p_iterative_rules in out nocopy t_iterative_rules
175 ,p_ele_type_usages in out nocopy t_ele_type_usages
176 ,p_gu_bal_exclusions in out nocopy t_gu_bal_exclusions
177 ,p_bal_attributes in out nocopy t_bal_attributes
178 ,p_template_ff_usages in out nocopy t_template_ff_usages
179 );
180 -- ----------------------------------------------------------------------------
181 -- |------------------------< plsql_to_db_template >--------------------------|
182 -- ----------------------------------------------------------------------------
183 procedure plsql_to_db_template
184 (p_effective_date in date
185 ,p_element_template in out nocopy pay_etm_shd.g_rec_type
186 ,p_exclusion_rules in out nocopy t_exclusion_rules
187 ,p_formulas in out nocopy t_formulas
188 ,p_balance_types in out nocopy t_balance_types
189 ,p_defined_balances in out nocopy t_defined_balances
190 ,p_element_types in out nocopy t_element_types
191 ,p_sub_classi_rules in out nocopy t_sub_classi_rules
192 ,p_balance_classis in out nocopy t_balance_classis
193 ,p_input_values in out nocopy t_input_values
194 ,p_balance_feeds in out nocopy t_balance_feeds
195 ,p_formula_rules in out nocopy t_formula_rules
196 ,p_iterative_rules in out nocopy t_iterative_rules
197 ,p_ele_type_usages in out nocopy t_ele_type_usages
198 ,p_gu_bal_exclusions in out nocopy t_gu_bal_exclusions
199 ,p_bal_attributes in out nocopy t_bal_attributes
200 ,p_template_id out nocopy number
201 ,p_object_version_number out nocopy number
202 );
203 -- ----------------------------------------------------------------------------
204 -- |---------------------------< delete_template >----------------------------|
205 -- ----------------------------------------------------------------------------
206 procedure delete_template
207 (p_template_id in number
208 ,p_formulas in t_formulas
209 ,p_delete_formulas in boolean default true
210 );
211 --
212 -- |---------------------------< get_shadow_formula_name >--------------------------|
213 -- ----------------------------------------------------------------------------
214 function get_shadow_formula_name(p_formula_id in number) return varchar2;
215 -- ---------------------------------------------------------------------------------
216 --
217 end pay_element_template_util;