1 PACKAGE per_ri_config_utilities AS
2 /* $Header: perriutl.pkh 120.2.12010000.2 2008/11/28 17:54:14 psengupt ship $ */
3
4 g_enterprise_short_name per_ri_config_information.config_information1%type;
5
6 FUNCTION create_key_flexfield
7 (p_appl_short_Name in varchar2
8 ,p_flex_code in varchar2
9 ,p_structure_code in varchar2
10 ,p_structure_title in varchar2
11 ,p_description in varchar2
12 ,p_view_name in varchar2 default null
13 ,p_freeze_flag in varchar2 default 'N'
14 ,p_enabled_flag in varchar2 default 'Y'
15 ,p_cross_val_flag in varchar2 default 'N'
16 ,p_freeze_rollup_flag in varchar2 default 'N'
17 ,p_dynamic_insert_flag in varchar2 default 'Y'
18 ,p_shorthand_enabled_flag in varchar2 default 'N'
19 ,p_shorthand_prompt in varchar2 default null
20 ,p_shorthand_length in number default null)
21 RETURN number;
22
23 PROCEDURE create_flex_segments
24 (p_appl_short_Name in varchar2
25 ,p_flex_code in varchar2
26 ,p_structure_code in varchar2
27 ,p_segment_name in varchar2
28 ,p_column_name in varchar2
29 ,p_segment_number in varchar2
30 ,p_enabled_flag in varchar2 default 'Y'
31 ,p_displayed_flag in varchar2 default 'Y'
32 ,p_indexed_flag in varchar2 default 'Y'
33 ,p_value_set in varchar2
34 ,p_display_size in number default 60
35 ,p_description_size in number default 60
36 ,p_concat_size in number default 60
37 ,p_lov_prompt in varchar2
38 ,p_window_prompt in varchar2
39 ,p_segment_type in varchar2 default 'CHAR'
40 ,p_fed_seg_attribute in varchar2 default 'N');
41
42 FUNCTION business_group_decision
43 (p_configuration_code in varchar2 default null
44 ,p_country_code in varchar2
45 ,p_number_of_employees in varchar2 default null
46 ,p_payroll_to_process_employees in varchar2 default null
47 ,p_hr_support_for_this_country in varchar2 default null)
48 RETURN varchar2;
49
50 FUNCTION legislation_support
51 (p_legislation_code in varchar2
52 ,p_application_short_name in varchar2)
53 RETURN boolean;
54
55 PROCEDURE set_profile_option_value
56 (p_level in number
57 ,p_level_value in varchar2
58 ,p_level_value_app in varchar2
59 ,p_profile_name in varchar2
60 ,p_profile_option_value in varchar2
61 ,p_custom_mode in varchar2 DEFAULT 'FORCE'
62 ,p_owner in varchar2 DEFAULT 'CUSTOM');
63
64 PROCEDURE write_log
65 (p_message in varchar2
66 ,p_write_to_log_flag in boolean default TRUE);
67
68 FUNCTION get_enterprise_short_name
69 (p_configuration_code in varchar2)
70 RETURN varchar2;
71
72 FUNCTION get_ent_primary_industry
73 (p_configuration_code in varchar2)
74 RETURN varchar2;
75
76
77 FUNCTION get_enterprise_name (p_configuration_code in varchar2)
78 RETURN varchar2;
79
80
81 FUNCTION regional_variance_defined (p_configuration_code in varchar2
82 ,p_rv_type in varchar2)
83 RETURN boolean;
84
85 FUNCTION jpg_defined (p_configuration_code in varchar2
86 ,p_seg_type in varchar2)
87 RETURN boolean;
88
89 FUNCTION get_bg_job_keyflex_name (p_configuration_code in varchar2
90 ,p_bg_country_code in varchar2)
91 RETURN varchar2;
92
93 FUNCTION get_bg_pos_keyflex_name (p_configuration_code in varchar2
94 ,p_bg_country_code in varchar2)
95 RETURN varchar2;
96
97 FUNCTION get_bg_grd_keyflex_name (p_configuration_code in varchar2
98 ,p_bg_country_code in varchar2)
99 RETURN varchar2;
100
101 FUNCTION get_oc_bg_name(p_configuration_code in varchar2
102 ,p_operating_company_name in varchar2)
103 RETURN varchar2;
104
105
106 FUNCTION get_enterprise_bg_name(p_configuration_code in varchar2
107 ,p_enterprise_name in varchar2)
108 RETURN varchar2;
109
110 FUNCTION get_config_location_code(p_configuration_code in varchar2
111 ,p_location_id in number)
112 RETURN varchar2;
113
114 FUNCTION get_le_bg_name(p_configuration_code in varchar2
115 ,p_legal_entity_name in varchar2)
116 RETURN varchar2;
117
118 FUNCTION mandatory_org_info_types(p_legislation_code in varchar2
119 ,p_org_classification in varchar2)
120 RETURN boolean;
121
122 FUNCTION check_currency_enabled(p_legislation_code in varchar2)
123 RETURN varchar2;
124
125 FUNCTION get_country_currency(p_legislation_code in varchar2)
126 RETURN varchar2;
127
128 PROCEDURE enable_country_currency(p_legislation_code in varchar2);
129
130 FUNCTION check_org_class_lookup_tag(p_legislation_code in varchar2
131 ,p_lookup_code in varchar2)
132 RETURN boolean;
133
134
135 PROCEDURE create_valueset(p_valueset_name in varchar2
136 ,p_valueset_type in varchar2);
137
138 PROCEDURE get_selected_country_list(p_configuration_code varchar2
139 ,p_config_info_category varchar2
140 ,p_reg_var_name varchar2
141 ,p_country_list out nocopy varchar2
142 ,p_selected_list out nocopy varchar2);
143
144 FUNCTION get_display_country_list(p_configuration_code varchar2
145 ,p_reg_var_name varchar2
146 ,p_config_info_category varchar2)
147 RETURN varchar2;
148
149 FUNCTION get_country_list(p_configuration_code varchar2
150 ,p_reg_var_name varchar2
151 ,p_config_info_category varchar2)
152 RETURN varchar2;
153
154 PROCEDURE freeze_and_compile_flexfield
155 (p_appl_short_Name in varchar2
156 ,p_flex_code in varchar2
157 ,p_structure_code in varchar2);
158
159 FUNCTION get_country_display_name(p_territory_code in varchar2)
160 RETURN varchar2;
161
162 PROCEDURE submit_int_payroll_request
163 (errbuf out nocopy varchar2
164 ,retcode out nocopy number
165 ,p_country_tab in per_ri_config_datapump_entity.country_tab
166 ,p_technical_summary_mode in boolean default FALSE
167 ,p_int_hrms_setup_tab in out nocopy
168 per_ri_config_tech_summary.int_hrms_setup_tab);
169
170 PROCEDURE create_security_profile_assign(
171 p_security_profile_tab in per_ri_config_fnd_hr_entity.security_profile_tab);
172
173 FUNCTION check_selected_product(p_configuration_code in varchar2
174 ,p_product_name in varchar2)
175 RETURN boolean;
176
177 PROCEDURE update_configuration_status(p_configuration_code in varchar2);
178
179 FUNCTION determine_country_resp(p_country_code in varchar2
180 ,p_assign_responsibility in varchar2)
181 RETURN varchar2;
182
183 FUNCTION responsibility_exists(p_country_code in varchar2
184 ,p_assign_responsibility in varchar2)
185 RETURN boolean;
186
187 PROCEDURE submit_enable_mult_sg_process
188 (errbuf out nocopy varchar2
189 ,retcode out nocopy number);
190
191 FUNCTION check_fresh_installation RETURN boolean;
192
193 FUNCTION check_data_pump_exception(p_patch_header_id in number)
194 return boolean;
195
196 PROCEDURE write_data_pump_exception_log
197 (p_patch_header_id in number);
198
199 PROCEDURE assign_misc_responsibility
200 (p_configuration_code in varchar2
201 ,p_technical_summary_mode in boolean default FALSE
202 ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_misc_resp_tab);
203
204 FUNCTION return_config_entity_name(entity_name in varchar2)
205 RETURN varchar2;
206
207 FUNCTION return_config_entity_name_pre(entity_name in varchar2)
208 RETURN varchar2;
209
210 FUNCTION get_location_prompt(p_style in varchar2
211 ,p_app_column_name in varchar2)
212 RETURN varchar2;
213
214 PROCEDURE create_valueset_ts_data(p_valueset_name in varchar2
215 ,p_valueset_type in varchar2
216 ,p_structure_code in varchar2
217 ,p_segment_name in varchar2
218 ,p_segment_number in varchar2
219 ,p_fed_seg_attribute in varchar2 default 'N'
220 ,p_valueset_tab in out nocopy
221 per_ri_config_tech_summary.valueset_tab);
222 PROCEDURE create_responsibility
223 (p_app_short_name in fnd_application.application_short_name%type
224 ,p_resp_key in fnd_responsibility_vl.responsibility_name%type
225 ,p_responsibility_id in fnd_responsibility.responsibility_id%type
226 ,p_responsibility_name in fnd_responsibility_tl.responsibility_name%type
227 ,p_owner in varchar2
228 ,p_data_group_app_short_name in fnd_application.application_short_name%type
229 ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
230 ,p_menu_name in fnd_menus.menu_name%type
231 ,p_start_date in varchar2
232 ,p_end_date in varchar2
233 ,p_description in varchar2
234 ,p_group_app_short_name in fnd_application.application_short_name%type
235 ,p_request_group_name in fnd_request_groups.request_group_name%type
236 ,p_version in varchar2
237 ,p_web_host_name in fnd_responsibility.web_host_name%type
238 ,p_web_agent_name in fnd_responsibility.web_agent_name%type);
239
240 PROCEDURE create_more_hrms_resps
241 (p_configuration_code in varchar2
242 ,p_security_profile_tab in per_ri_config_fnd_hr_entity.security_profile_tab
243 ,p_int_bg_resp_tab in per_ri_config_fnd_hr_entity.int_bg_resp_tab
244 ,p_technical_summary_mode in boolean default FALSE
245 ,p_hrms_resp_main_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
246 ,p_more_profile_resp_tab in out nocopy per_ri_config_tech_summary.profile_resp_tab
247 ,p_more_int_profile_resp_tab in out nocopy per_ri_config_tech_summary.profile_resp_tab);
248
249 PROCEDURE create_resp_and_profile
250 (p_configuration_code in varchar2
251 ,p_security_profile_name in varchar2
252 ,p_responsibility_key in varchar2
253 ,p_technical_summary_mode in boolean default FALSE
254 ,p_bg_sg_ut_profile_resp_tab in out nocopy per_ri_config_tech_summary.profile_resp_tab
255 ,p_hrms_resp_one_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab);
256
257 FUNCTION get_responsibility_name (p_responsibility_key in varchar2)
258 RETURN varchar2;
259
260 FUNCTION get_business_group_name
261 RETURN varchar2;
262
263 END per_ri_config_utilities;