156: (x_user_name in varchar2
157: ,x_user_entity_id in number
158: ,x_language in varchar2
159: ,x_translated_user_name in varchar2
160: ,x_replaced_names out nocopy dbms_sql.varchar2s
161: ) is
162: l_debug boolean := hr_utility.debug_enabled;
163: l_found varchar2(1);
164: i binary_integer;
273: ,x_tl_user_name in varchar2
274: ,x_old_tl_name in varchar2
275: ,x_language in varchar2
276: ,x_dont_update in out nocopy boolean
277: ,x_message_rowids in out nocopy dbms_sql.varchar2s
278: ) is
279: l_formula_ids dbms_sql.number_table;
280: l_formula_names dbms_sql.varchar2s;
281: l_eff_start_dates dbms_sql.date_table;
275: ,x_language in varchar2
276: ,x_dont_update in out nocopy boolean
277: ,x_message_rowids in out nocopy dbms_sql.varchar2s
278: ) is
279: l_formula_ids dbms_sql.number_table;
280: l_formula_names dbms_sql.varchar2s;
281: l_eff_start_dates dbms_sql.date_table;
282: l_eff_end_dates dbms_sql.date_table;
283: l_bus_group_ids dbms_sql.number_table;
276: ,x_dont_update in out nocopy boolean
277: ,x_message_rowids in out nocopy dbms_sql.varchar2s
278: ) is
279: l_formula_ids dbms_sql.number_table;
280: l_formula_names dbms_sql.varchar2s;
281: l_eff_start_dates dbms_sql.date_table;
282: l_eff_end_dates dbms_sql.date_table;
283: l_bus_group_ids dbms_sql.number_table;
284: l_leg_codes dbms_sql.varchar2s;
277: ,x_message_rowids in out nocopy dbms_sql.varchar2s
278: ) is
279: l_formula_ids dbms_sql.number_table;
280: l_formula_names dbms_sql.varchar2s;
281: l_eff_start_dates dbms_sql.date_table;
282: l_eff_end_dates dbms_sql.date_table;
283: l_bus_group_ids dbms_sql.number_table;
284: l_leg_codes dbms_sql.varchar2s;
285: l_encoded_message varchar2(2000);
278: ) is
279: l_formula_ids dbms_sql.number_table;
280: l_formula_names dbms_sql.varchar2s;
281: l_eff_start_dates dbms_sql.date_table;
282: l_eff_end_dates dbms_sql.date_table;
283: l_bus_group_ids dbms_sql.number_table;
284: l_leg_codes dbms_sql.varchar2s;
285: l_encoded_message varchar2(2000);
286: l_rowid varchar2(2000);
279: l_formula_ids dbms_sql.number_table;
280: l_formula_names dbms_sql.varchar2s;
281: l_eff_start_dates dbms_sql.date_table;
282: l_eff_end_dates dbms_sql.date_table;
283: l_bus_group_ids dbms_sql.number_table;
284: l_leg_codes dbms_sql.varchar2s;
285: l_encoded_message varchar2(2000);
286: l_rowid varchar2(2000);
287: l_debug boolean := hr_utility.debug_enabled;
280: l_formula_names dbms_sql.varchar2s;
281: l_eff_start_dates dbms_sql.date_table;
282: l_eff_end_dates dbms_sql.date_table;
283: l_bus_group_ids dbms_sql.number_table;
284: l_leg_codes dbms_sql.varchar2s;
285: l_encoded_message varchar2(2000);
286: l_rowid varchar2(2000);
287: l_debug boolean := hr_utility.debug_enabled;
288: begin
484: l_disable_triggers varchar2(2000);
485: l_user_name varchar2(2000);
486: l_tl_user_name varchar2(2000);
487: l_outcome varchar2(10);
488: l_replaced_names dbms_sql.varchar2s;
489: l_message_rowids dbms_sql.varchar2s;
490: l_encoded_message varchar2(2000);
491: l_debug boolean;
492: l_raise_errors boolean;
485: l_user_name varchar2(2000);
486: l_tl_user_name varchar2(2000);
487: l_outcome varchar2(10);
488: l_replaced_names dbms_sql.varchar2s;
489: l_message_rowids dbms_sql.varchar2s;
490: l_encoded_message varchar2(2000);
491: l_debug boolean;
492: l_raise_errors boolean;
493: l_dont_update boolean;
1148: l_disable_triggers varchar2(100);
1149: --
1150: l_userenv_lang varchar2(2000);
1151: --
1152: ueids dbms_sql.number_table;
1153: --
1154: l_debug boolean;
1155: --
1156: l_limit number := 2000;