eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FF_DATABASE_ITEMS_PKG dependencies on DBMS_SQL

Line 160: ,x_replaced_names out nocopy dbms_sql.varchar2s

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;

Line 277: ,x_message_rowids in out nocopy dbms_sql.varchar2s

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;

Line 279: l_formula_ids dbms_sql.number_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;

Line 280: l_formula_names dbms_sql.varchar2s;

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;

Line 281: l_eff_start_dates dbms_sql.date_table;

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);

Line 282: l_eff_end_dates dbms_sql.date_table;

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);

Line 283: l_bus_group_ids dbms_sql.number_table;

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;

Line 284: l_leg_codes dbms_sql.varchar2s;

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

Line 488: l_replaced_names dbms_sql.varchar2s;

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;

Line 489: l_message_rowids dbms_sql.varchar2s;

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;

Line 1152: ueids dbms_sql.number_table;

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 := 500;