APPS.HRDYNDBI dependencies on DBMS_SQL

Line 149: interface. Also, use dbms_sql.varchar_table

145: Only delete PAY_DYNDBI_CHANGES row if
146: no errors occurred.
147: arashid 115.142 10-NOV-2006 Bug5464970 fix for changed
148: pay_dbitl_update_errors_pkg.fetch_all_rows
149: interface. Also, use dbms_sql.varchar_table
150: in process_leg_translations.
151: arashid 115.141 22-SEP-2006 Bug 5556728: in the MLS dbi case,
152: 'Pay Value' was passed into
153: replace_code_name so the replacement was

Line 785: ,p_languages in dbms_sql.varchar2s

781: );
782: --
783: procedure gen_et_dbi_prefixes
784: (p_element_type_id in number
785: ,p_languages in dbms_sql.varchar2s
786: ,p_prefixes in out nocopy t_dbi_prefixes
787: );
788: --
789: procedure gen_eiv_dbi_prefixes

Line 792: ,p_languages in dbms_sql.varchar2s

788: --
789: procedure gen_eiv_dbi_prefixes
790: (p_input_value_id in number
791: ,p_effective_date in date
792: ,p_languages in dbms_sql.varchar2s
793: ,p_prefixes in out nocopy t_dbi_prefixes
794: );
795: --
796: procedure update_tl_dbi_name

Line 845: (p_formula_ids in dbms_sql.number_table

841: p_leg_code in varchar2
842: );
843: --
844: procedure ff_compiled_info_del
845: (p_formula_ids in dbms_sql.number_table
846: ,p_start_dates in dbms_sql.date_table
847: );
848: --
849: procedure create_user_entity

Line 846: ,p_start_dates in dbms_sql.date_table

842: );
843: --
844: procedure ff_compiled_info_del
845: (p_formula_ids in dbms_sql.number_table
846: ,p_start_dates in dbms_sql.date_table
847: );
848: --
849: procedure create_user_entity
850: (p_db_item_name in out nocopy varchar2,

Line 2842: l_formula_ids dbms_sql.number_table;

2838: p_user_entity_name in varchar2,
2839: p_leg_code in varchar2
2840: ) is
2841: --
2842: l_formula_ids dbms_sql.number_table;
2843: l_start_dates dbms_sql.date_table;
2844: begin
2845:
2846: delete ff_fdi_usages_f fdi

Line 2843: l_start_dates dbms_sql.date_table;

2839: p_leg_code in varchar2
2840: ) is
2841: --
2842: l_formula_ids dbms_sql.number_table;
2843: l_start_dates dbms_sql.date_table;
2844: begin
2845:
2846: delete ff_fdi_usages_f fdi
2847: where FDI.usage = 'D'

Line 2895: (p_formula_ids dbms_sql.number_table

2891: Bulk delete FF_COMPILED_INFO_F using FORMULA_ID and
2892: EFFECTIVE_START_DATE from FF_FDI_USAGES_F.
2893: */
2894: procedure ff_compiled_info_del
2895: (p_formula_ids dbms_sql.number_table
2896: ,p_start_dates dbms_sql.date_table
2897: ) is
2898: l_iterations number;
2899: l_chunksize binary_integer := 250;

Line 2896: ,p_start_dates dbms_sql.date_table

2892: EFFECTIVE_START_DATE from FF_FDI_USAGES_F.
2893: */
2894: procedure ff_compiled_info_del
2895: (p_formula_ids dbms_sql.number_table
2896: ,p_start_dates dbms_sql.date_table
2897: ) is
2898: l_iterations number;
2899: l_chunksize binary_integer := 250;
2900: l_upper_limit binary_integer;

Line 3037: l_languages dbms_sql.varchar2s;

3033: l_full_mls boolean;
3034: l_base_dbi_name varchar2(2000);
3035: l_user_entity_id number;
3036: l_dbi_prefixes t_dbi_prefixes;
3037: l_languages dbms_sql.varchar2s;
3038: l_startup_mode varchar2(100);
3039: l_legislation_code1 pay_element_types_f.legislation_code%type;
3040: --
3041: ------------------------- create_element_type -------------------------

Line 3889: l_languages dbms_sql.varchar2s;

3885: l_base_dbi_name varchar2(2000);
3886: l_user_entity_id number;
3887: l_legislation_code1 pay_element_types_f.legislation_code%type;
3888: l_startup_mode varchar2(30);
3889: l_languages dbms_sql.varchar2s;
3890: l_dbi_prefixes t_dbi_prefixes;
3891: --
3892: -- debug info
3893: l_iv_eltypeid number;

Line 5478: l_formula_ids dbms_sql.number_table;

5474: is
5475:
5476: workers_complete number;
5477: worker_err number;
5478: l_formula_ids dbms_sql.number_table;
5479: l_start_dates dbms_sql.date_table;
5480: l_rowids dbms_sql.varchar2s;
5481: form_name varchar2(80);
5482:

Line 5479: l_start_dates dbms_sql.date_table;

5475:
5476: workers_complete number;
5477: worker_err number;
5478: l_formula_ids dbms_sql.number_table;
5479: l_start_dates dbms_sql.date_table;
5480: l_rowids dbms_sql.varchar2s;
5481: form_name varchar2(80);
5482:
5483: --

Line 5480: l_rowids dbms_sql.varchar2s;

5476: workers_complete number;
5477: worker_err number;
5478: l_formula_ids dbms_sql.number_table;
5479: l_start_dates dbms_sql.date_table;
5480: l_rowids dbms_sql.varchar2s;
5481: form_name varchar2(80);
5482:
5483: --
5484: -- Cursor to fetch FDIU row information for rows affected by the EIB

Line 7814: sql_cur := dbms_sql.open_cursor;

7810: l_ret_per := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
7811: l_industry, l_per_owner);
7812:
7813: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7814: sql_cur := dbms_sql.open_cursor;
7815: dbms_sql.parse(sql_cur,
7816: statem,
7817: dbms_sql.v7);
7818: ignore := dbms_sql.execute(sql_cur);

Line 7815: dbms_sql.parse(sql_cur,

7811: l_industry, l_per_owner);
7812:
7813: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7814: sql_cur := dbms_sql.open_cursor;
7815: dbms_sql.parse(sql_cur,
7816: statem,
7817: dbms_sql.v7);
7818: ignore := dbms_sql.execute(sql_cur);
7819: dbms_sql.close_cursor(sql_cur);

Line 7817: dbms_sql.v7);

7813: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7814: sql_cur := dbms_sql.open_cursor;
7815: dbms_sql.parse(sql_cur,
7816: statem,
7817: dbms_sql.v7);
7818: ignore := dbms_sql.execute(sql_cur);
7819: dbms_sql.close_cursor(sql_cur);
7820: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7821: sql_cur := dbms_sql.open_cursor;

Line 7818: ignore := dbms_sql.execute(sql_cur);

7814: sql_cur := dbms_sql.open_cursor;
7815: dbms_sql.parse(sql_cur,
7816: statem,
7817: dbms_sql.v7);
7818: ignore := dbms_sql.execute(sql_cur);
7819: dbms_sql.close_cursor(sql_cur);
7820: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7821: sql_cur := dbms_sql.open_cursor;
7822: dbms_sql.parse(sql_cur,

Line 7819: dbms_sql.close_cursor(sql_cur);

7815: dbms_sql.parse(sql_cur,
7816: statem,
7817: dbms_sql.v7);
7818: ignore := dbms_sql.execute(sql_cur);
7819: dbms_sql.close_cursor(sql_cur);
7820: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7821: sql_cur := dbms_sql.open_cursor;
7822: dbms_sql.parse(sql_cur,
7823: statem,

Line 7821: sql_cur := dbms_sql.open_cursor;

7817: dbms_sql.v7);
7818: ignore := dbms_sql.execute(sql_cur);
7819: dbms_sql.close_cursor(sql_cur);
7820: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7821: sql_cur := dbms_sql.open_cursor;
7822: dbms_sql.parse(sql_cur,
7823: statem,
7824: dbms_sql.v7);
7825: ignore := dbms_sql.execute(sql_cur);

Line 7822: dbms_sql.parse(sql_cur,

7818: ignore := dbms_sql.execute(sql_cur);
7819: dbms_sql.close_cursor(sql_cur);
7820: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7821: sql_cur := dbms_sql.open_cursor;
7822: dbms_sql.parse(sql_cur,
7823: statem,
7824: dbms_sql.v7);
7825: ignore := dbms_sql.execute(sql_cur);
7826: dbms_sql.close_cursor(sql_cur);

Line 7824: dbms_sql.v7);

7820: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7821: sql_cur := dbms_sql.open_cursor;
7822: dbms_sql.parse(sql_cur,
7823: statem,
7824: dbms_sql.v7);
7825: ignore := dbms_sql.execute(sql_cur);
7826: dbms_sql.close_cursor(sql_cur);
7827: end truncate_fcomp_info;
7828: --

Line 7825: ignore := dbms_sql.execute(sql_cur);

7821: sql_cur := dbms_sql.open_cursor;
7822: dbms_sql.parse(sql_cur,
7823: statem,
7824: dbms_sql.v7);
7825: ignore := dbms_sql.execute(sql_cur);
7826: dbms_sql.close_cursor(sql_cur);
7827: end truncate_fcomp_info;
7828: --
7829:

Line 7826: dbms_sql.close_cursor(sql_cur);

7822: dbms_sql.parse(sql_cur,
7823: statem,
7824: dbms_sql.v7);
7825: ignore := dbms_sql.execute(sql_cur);
7826: dbms_sql.close_cursor(sql_cur);
7827: end truncate_fcomp_info;
7828: --
7829:
7830: procedure disable_ffue_cascade_trig is

Line 7836: sql_cur := dbms_sql.open_cursor;

7832: sql_cur number;
7833: ignore number;
7834: begin
7835: statem := 'alter trigger ff_database_items_brd disable';
7836: sql_cur := dbms_sql.open_cursor;
7837: dbms_sql.parse(sql_cur,
7838: statem,
7839: dbms_sql.v7);
7840: ignore := dbms_sql.execute(sql_cur);

Line 7837: dbms_sql.parse(sql_cur,

7833: ignore number;
7834: begin
7835: statem := 'alter trigger ff_database_items_brd disable';
7836: sql_cur := dbms_sql.open_cursor;
7837: dbms_sql.parse(sql_cur,
7838: statem,
7839: dbms_sql.v7);
7840: ignore := dbms_sql.execute(sql_cur);
7841: dbms_sql.close_cursor(sql_cur);

Line 7839: dbms_sql.v7);

7835: statem := 'alter trigger ff_database_items_brd disable';
7836: sql_cur := dbms_sql.open_cursor;
7837: dbms_sql.parse(sql_cur,
7838: statem,
7839: dbms_sql.v7);
7840: ignore := dbms_sql.execute(sql_cur);
7841: dbms_sql.close_cursor(sql_cur);
7842: statem := 'alter trigger ff_rpv_brud disable';
7843: sql_cur := dbms_sql.open_cursor;

Line 7840: ignore := dbms_sql.execute(sql_cur);

7836: sql_cur := dbms_sql.open_cursor;
7837: dbms_sql.parse(sql_cur,
7838: statem,
7839: dbms_sql.v7);
7840: ignore := dbms_sql.execute(sql_cur);
7841: dbms_sql.close_cursor(sql_cur);
7842: statem := 'alter trigger ff_rpv_brud disable';
7843: sql_cur := dbms_sql.open_cursor;
7844: dbms_sql.parse(sql_cur,

Line 7841: dbms_sql.close_cursor(sql_cur);

7837: dbms_sql.parse(sql_cur,
7838: statem,
7839: dbms_sql.v7);
7840: ignore := dbms_sql.execute(sql_cur);
7841: dbms_sql.close_cursor(sql_cur);
7842: statem := 'alter trigger ff_rpv_brud disable';
7843: sql_cur := dbms_sql.open_cursor;
7844: dbms_sql.parse(sql_cur,
7845: statem,

Line 7843: sql_cur := dbms_sql.open_cursor;

7839: dbms_sql.v7);
7840: ignore := dbms_sql.execute(sql_cur);
7841: dbms_sql.close_cursor(sql_cur);
7842: statem := 'alter trigger ff_rpv_brud disable';
7843: sql_cur := dbms_sql.open_cursor;
7844: dbms_sql.parse(sql_cur,
7845: statem,
7846: dbms_sql.v7);
7847: ignore := dbms_sql.execute(sql_cur);

Line 7844: dbms_sql.parse(sql_cur,

7840: ignore := dbms_sql.execute(sql_cur);
7841: dbms_sql.close_cursor(sql_cur);
7842: statem := 'alter trigger ff_rpv_brud disable';
7843: sql_cur := dbms_sql.open_cursor;
7844: dbms_sql.parse(sql_cur,
7845: statem,
7846: dbms_sql.v7);
7847: ignore := dbms_sql.execute(sql_cur);
7848: dbms_sql.close_cursor(sql_cur);

Line 7846: dbms_sql.v7);

7842: statem := 'alter trigger ff_rpv_brud disable';
7843: sql_cur := dbms_sql.open_cursor;
7844: dbms_sql.parse(sql_cur,
7845: statem,
7846: dbms_sql.v7);
7847: ignore := dbms_sql.execute(sql_cur);
7848: dbms_sql.close_cursor(sql_cur);
7849: end disable_ffue_cascade_trig;
7850: --

Line 7847: ignore := dbms_sql.execute(sql_cur);

7843: sql_cur := dbms_sql.open_cursor;
7844: dbms_sql.parse(sql_cur,
7845: statem,
7846: dbms_sql.v7);
7847: ignore := dbms_sql.execute(sql_cur);
7848: dbms_sql.close_cursor(sql_cur);
7849: end disable_ffue_cascade_trig;
7850: --
7851: procedure enable_ffue_cascade_trig is

Line 7848: dbms_sql.close_cursor(sql_cur);

7844: dbms_sql.parse(sql_cur,
7845: statem,
7846: dbms_sql.v7);
7847: ignore := dbms_sql.execute(sql_cur);
7848: dbms_sql.close_cursor(sql_cur);
7849: end disable_ffue_cascade_trig;
7850: --
7851: procedure enable_ffue_cascade_trig is
7852: statem varchar2(256);

Line 7857: sql_cur := dbms_sql.open_cursor;

7853: sql_cur number;
7854: ignore number;
7855: begin
7856: statem := 'alter trigger ff_database_items_brd enable';
7857: sql_cur := dbms_sql.open_cursor;
7858: dbms_sql.parse(sql_cur,
7859: statem,
7860: dbms_sql.v7);
7861: ignore := dbms_sql.execute(sql_cur);

Line 7858: dbms_sql.parse(sql_cur,

7854: ignore number;
7855: begin
7856: statem := 'alter trigger ff_database_items_brd enable';
7857: sql_cur := dbms_sql.open_cursor;
7858: dbms_sql.parse(sql_cur,
7859: statem,
7860: dbms_sql.v7);
7861: ignore := dbms_sql.execute(sql_cur);
7862: dbms_sql.close_cursor(sql_cur);

Line 7860: dbms_sql.v7);

7856: statem := 'alter trigger ff_database_items_brd enable';
7857: sql_cur := dbms_sql.open_cursor;
7858: dbms_sql.parse(sql_cur,
7859: statem,
7860: dbms_sql.v7);
7861: ignore := dbms_sql.execute(sql_cur);
7862: dbms_sql.close_cursor(sql_cur);
7863: statem := 'alter trigger ff_rpv_brud enable';
7864: sql_cur := dbms_sql.open_cursor;

Line 7861: ignore := dbms_sql.execute(sql_cur);

7857: sql_cur := dbms_sql.open_cursor;
7858: dbms_sql.parse(sql_cur,
7859: statem,
7860: dbms_sql.v7);
7861: ignore := dbms_sql.execute(sql_cur);
7862: dbms_sql.close_cursor(sql_cur);
7863: statem := 'alter trigger ff_rpv_brud enable';
7864: sql_cur := dbms_sql.open_cursor;
7865: dbms_sql.parse(sql_cur,

Line 7862: dbms_sql.close_cursor(sql_cur);

7858: dbms_sql.parse(sql_cur,
7859: statem,
7860: dbms_sql.v7);
7861: ignore := dbms_sql.execute(sql_cur);
7862: dbms_sql.close_cursor(sql_cur);
7863: statem := 'alter trigger ff_rpv_brud enable';
7864: sql_cur := dbms_sql.open_cursor;
7865: dbms_sql.parse(sql_cur,
7866: statem,

Line 7864: sql_cur := dbms_sql.open_cursor;

7860: dbms_sql.v7);
7861: ignore := dbms_sql.execute(sql_cur);
7862: dbms_sql.close_cursor(sql_cur);
7863: statem := 'alter trigger ff_rpv_brud enable';
7864: sql_cur := dbms_sql.open_cursor;
7865: dbms_sql.parse(sql_cur,
7866: statem,
7867: dbms_sql.v7);
7868: ignore := dbms_sql.execute(sql_cur);

Line 7865: dbms_sql.parse(sql_cur,

7861: ignore := dbms_sql.execute(sql_cur);
7862: dbms_sql.close_cursor(sql_cur);
7863: statem := 'alter trigger ff_rpv_brud enable';
7864: sql_cur := dbms_sql.open_cursor;
7865: dbms_sql.parse(sql_cur,
7866: statem,
7867: dbms_sql.v7);
7868: ignore := dbms_sql.execute(sql_cur);
7869: dbms_sql.close_cursor(sql_cur);

Line 7867: dbms_sql.v7);

7863: statem := 'alter trigger ff_rpv_brud enable';
7864: sql_cur := dbms_sql.open_cursor;
7865: dbms_sql.parse(sql_cur,
7866: statem,
7867: dbms_sql.v7);
7868: ignore := dbms_sql.execute(sql_cur);
7869: dbms_sql.close_cursor(sql_cur);
7870: end enable_ffue_cascade_trig;
7871: --

Line 7868: ignore := dbms_sql.execute(sql_cur);

7864: sql_cur := dbms_sql.open_cursor;
7865: dbms_sql.parse(sql_cur,
7866: statem,
7867: dbms_sql.v7);
7868: ignore := dbms_sql.execute(sql_cur);
7869: dbms_sql.close_cursor(sql_cur);
7870: end enable_ffue_cascade_trig;
7871: --
7872: procedure disable_refbal_trig is

Line 7869: dbms_sql.close_cursor(sql_cur);

7865: dbms_sql.parse(sql_cur,
7866: statem,
7867: dbms_sql.v7);
7868: ignore := dbms_sql.execute(sql_cur);
7869: dbms_sql.close_cursor(sql_cur);
7870: end enable_ffue_cascade_trig;
7871: --
7872: procedure disable_refbal_trig is
7873: statem varchar2(256);

Line 7878: sql_cur := dbms_sql.open_cursor;

7874: sql_cur number;
7875: ignore number;
7876: begin
7877: statem := 'alter trigger ff_user_entities_bri disable';
7878: sql_cur := dbms_sql.open_cursor;
7879: dbms_sql.parse(sql_cur,
7880: statem,
7881: dbms_sql.v7);
7882: ignore := dbms_sql.execute(sql_cur);

Line 7879: dbms_sql.parse(sql_cur,

7875: ignore number;
7876: begin
7877: statem := 'alter trigger ff_user_entities_bri disable';
7878: sql_cur := dbms_sql.open_cursor;
7879: dbms_sql.parse(sql_cur,
7880: statem,
7881: dbms_sql.v7);
7882: ignore := dbms_sql.execute(sql_cur);
7883: dbms_sql.close_cursor(sql_cur);

Line 7881: dbms_sql.v7);

7877: statem := 'alter trigger ff_user_entities_bri disable';
7878: sql_cur := dbms_sql.open_cursor;
7879: dbms_sql.parse(sql_cur,
7880: statem,
7881: dbms_sql.v7);
7882: ignore := dbms_sql.execute(sql_cur);
7883: dbms_sql.close_cursor(sql_cur);
7884: statem := 'alter trigger ff_database_items_bri disable';
7885: sql_cur := dbms_sql.open_cursor;

Line 7882: ignore := dbms_sql.execute(sql_cur);

7878: sql_cur := dbms_sql.open_cursor;
7879: dbms_sql.parse(sql_cur,
7880: statem,
7881: dbms_sql.v7);
7882: ignore := dbms_sql.execute(sql_cur);
7883: dbms_sql.close_cursor(sql_cur);
7884: statem := 'alter trigger ff_database_items_bri disable';
7885: sql_cur := dbms_sql.open_cursor;
7886: dbms_sql.parse(sql_cur,

Line 7883: dbms_sql.close_cursor(sql_cur);

7879: dbms_sql.parse(sql_cur,
7880: statem,
7881: dbms_sql.v7);
7882: ignore := dbms_sql.execute(sql_cur);
7883: dbms_sql.close_cursor(sql_cur);
7884: statem := 'alter trigger ff_database_items_bri disable';
7885: sql_cur := dbms_sql.open_cursor;
7886: dbms_sql.parse(sql_cur,
7887: statem,

Line 7885: sql_cur := dbms_sql.open_cursor;

7881: dbms_sql.v7);
7882: ignore := dbms_sql.execute(sql_cur);
7883: dbms_sql.close_cursor(sql_cur);
7884: statem := 'alter trigger ff_database_items_bri disable';
7885: sql_cur := dbms_sql.open_cursor;
7886: dbms_sql.parse(sql_cur,
7887: statem,
7888: dbms_sql.v7);
7889: ignore := dbms_sql.execute(sql_cur);

Line 7886: dbms_sql.parse(sql_cur,

7882: ignore := dbms_sql.execute(sql_cur);
7883: dbms_sql.close_cursor(sql_cur);
7884: statem := 'alter trigger ff_database_items_bri disable';
7885: sql_cur := dbms_sql.open_cursor;
7886: dbms_sql.parse(sql_cur,
7887: statem,
7888: dbms_sql.v7);
7889: ignore := dbms_sql.execute(sql_cur);
7890: dbms_sql.close_cursor(sql_cur);

Line 7888: dbms_sql.v7);

7884: statem := 'alter trigger ff_database_items_bri disable';
7885: sql_cur := dbms_sql.open_cursor;
7886: dbms_sql.parse(sql_cur,
7887: statem,
7888: dbms_sql.v7);
7889: ignore := dbms_sql.execute(sql_cur);
7890: dbms_sql.close_cursor(sql_cur);
7891: statem := 'alter trigger ff_rpv_bri disable';
7892: sql_cur := dbms_sql.open_cursor;

Line 7889: ignore := dbms_sql.execute(sql_cur);

7885: sql_cur := dbms_sql.open_cursor;
7886: dbms_sql.parse(sql_cur,
7887: statem,
7888: dbms_sql.v7);
7889: ignore := dbms_sql.execute(sql_cur);
7890: dbms_sql.close_cursor(sql_cur);
7891: statem := 'alter trigger ff_rpv_bri disable';
7892: sql_cur := dbms_sql.open_cursor;
7893: dbms_sql.parse(sql_cur,

Line 7890: dbms_sql.close_cursor(sql_cur);

7886: dbms_sql.parse(sql_cur,
7887: statem,
7888: dbms_sql.v7);
7889: ignore := dbms_sql.execute(sql_cur);
7890: dbms_sql.close_cursor(sql_cur);
7891: statem := 'alter trigger ff_rpv_bri disable';
7892: sql_cur := dbms_sql.open_cursor;
7893: dbms_sql.parse(sql_cur,
7894: statem,

Line 7892: sql_cur := dbms_sql.open_cursor;

7888: dbms_sql.v7);
7889: ignore := dbms_sql.execute(sql_cur);
7890: dbms_sql.close_cursor(sql_cur);
7891: statem := 'alter trigger ff_rpv_bri disable';
7892: sql_cur := dbms_sql.open_cursor;
7893: dbms_sql.parse(sql_cur,
7894: statem,
7895: dbms_sql.v7);
7896: ignore := dbms_sql.execute(sql_cur);

Line 7893: dbms_sql.parse(sql_cur,

7889: ignore := dbms_sql.execute(sql_cur);
7890: dbms_sql.close_cursor(sql_cur);
7891: statem := 'alter trigger ff_rpv_bri disable';
7892: sql_cur := dbms_sql.open_cursor;
7893: dbms_sql.parse(sql_cur,
7894: statem,
7895: dbms_sql.v7);
7896: ignore := dbms_sql.execute(sql_cur);
7897: dbms_sql.close_cursor(sql_cur);

Line 7895: dbms_sql.v7);

7891: statem := 'alter trigger ff_rpv_bri disable';
7892: sql_cur := dbms_sql.open_cursor;
7893: dbms_sql.parse(sql_cur,
7894: statem,
7895: dbms_sql.v7);
7896: ignore := dbms_sql.execute(sql_cur);
7897: dbms_sql.close_cursor(sql_cur);
7898: end disable_refbal_trig;
7899: --

Line 7896: ignore := dbms_sql.execute(sql_cur);

7892: sql_cur := dbms_sql.open_cursor;
7893: dbms_sql.parse(sql_cur,
7894: statem,
7895: dbms_sql.v7);
7896: ignore := dbms_sql.execute(sql_cur);
7897: dbms_sql.close_cursor(sql_cur);
7898: end disable_refbal_trig;
7899: --
7900: procedure enable_refbal_trig is

Line 7897: dbms_sql.close_cursor(sql_cur);

7893: dbms_sql.parse(sql_cur,
7894: statem,
7895: dbms_sql.v7);
7896: ignore := dbms_sql.execute(sql_cur);
7897: dbms_sql.close_cursor(sql_cur);
7898: end disable_refbal_trig;
7899: --
7900: procedure enable_refbal_trig is
7901: statem varchar2(256);

Line 7906: sql_cur := dbms_sql.open_cursor;

7902: sql_cur number;
7903: ignore number;
7904: begin
7905: statem := 'alter trigger ff_user_entities_bri enable';
7906: sql_cur := dbms_sql.open_cursor;
7907: dbms_sql.parse(sql_cur,
7908: statem,
7909: dbms_sql.v7);
7910: ignore := dbms_sql.execute(sql_cur);

Line 7907: dbms_sql.parse(sql_cur,

7903: ignore number;
7904: begin
7905: statem := 'alter trigger ff_user_entities_bri enable';
7906: sql_cur := dbms_sql.open_cursor;
7907: dbms_sql.parse(sql_cur,
7908: statem,
7909: dbms_sql.v7);
7910: ignore := dbms_sql.execute(sql_cur);
7911: dbms_sql.close_cursor(sql_cur);

Line 7909: dbms_sql.v7);

7905: statem := 'alter trigger ff_user_entities_bri enable';
7906: sql_cur := dbms_sql.open_cursor;
7907: dbms_sql.parse(sql_cur,
7908: statem,
7909: dbms_sql.v7);
7910: ignore := dbms_sql.execute(sql_cur);
7911: dbms_sql.close_cursor(sql_cur);
7912: statem := 'alter trigger ff_database_items_bri enable';
7913: sql_cur := dbms_sql.open_cursor;

Line 7910: ignore := dbms_sql.execute(sql_cur);

7906: sql_cur := dbms_sql.open_cursor;
7907: dbms_sql.parse(sql_cur,
7908: statem,
7909: dbms_sql.v7);
7910: ignore := dbms_sql.execute(sql_cur);
7911: dbms_sql.close_cursor(sql_cur);
7912: statem := 'alter trigger ff_database_items_bri enable';
7913: sql_cur := dbms_sql.open_cursor;
7914: dbms_sql.parse(sql_cur,

Line 7911: dbms_sql.close_cursor(sql_cur);

7907: dbms_sql.parse(sql_cur,
7908: statem,
7909: dbms_sql.v7);
7910: ignore := dbms_sql.execute(sql_cur);
7911: dbms_sql.close_cursor(sql_cur);
7912: statem := 'alter trigger ff_database_items_bri enable';
7913: sql_cur := dbms_sql.open_cursor;
7914: dbms_sql.parse(sql_cur,
7915: statem,

Line 7913: sql_cur := dbms_sql.open_cursor;

7909: dbms_sql.v7);
7910: ignore := dbms_sql.execute(sql_cur);
7911: dbms_sql.close_cursor(sql_cur);
7912: statem := 'alter trigger ff_database_items_bri enable';
7913: sql_cur := dbms_sql.open_cursor;
7914: dbms_sql.parse(sql_cur,
7915: statem,
7916: dbms_sql.v7);
7917: ignore := dbms_sql.execute(sql_cur);

Line 7914: dbms_sql.parse(sql_cur,

7910: ignore := dbms_sql.execute(sql_cur);
7911: dbms_sql.close_cursor(sql_cur);
7912: statem := 'alter trigger ff_database_items_bri enable';
7913: sql_cur := dbms_sql.open_cursor;
7914: dbms_sql.parse(sql_cur,
7915: statem,
7916: dbms_sql.v7);
7917: ignore := dbms_sql.execute(sql_cur);
7918: dbms_sql.close_cursor(sql_cur);

Line 7916: dbms_sql.v7);

7912: statem := 'alter trigger ff_database_items_bri enable';
7913: sql_cur := dbms_sql.open_cursor;
7914: dbms_sql.parse(sql_cur,
7915: statem,
7916: dbms_sql.v7);
7917: ignore := dbms_sql.execute(sql_cur);
7918: dbms_sql.close_cursor(sql_cur);
7919: statem := 'alter trigger ff_rpv_bri enable';
7920: sql_cur := dbms_sql.open_cursor;

Line 7917: ignore := dbms_sql.execute(sql_cur);

7913: sql_cur := dbms_sql.open_cursor;
7914: dbms_sql.parse(sql_cur,
7915: statem,
7916: dbms_sql.v7);
7917: ignore := dbms_sql.execute(sql_cur);
7918: dbms_sql.close_cursor(sql_cur);
7919: statem := 'alter trigger ff_rpv_bri enable';
7920: sql_cur := dbms_sql.open_cursor;
7921: dbms_sql.parse(sql_cur,

Line 7918: dbms_sql.close_cursor(sql_cur);

7914: dbms_sql.parse(sql_cur,
7915: statem,
7916: dbms_sql.v7);
7917: ignore := dbms_sql.execute(sql_cur);
7918: dbms_sql.close_cursor(sql_cur);
7919: statem := 'alter trigger ff_rpv_bri enable';
7920: sql_cur := dbms_sql.open_cursor;
7921: dbms_sql.parse(sql_cur,
7922: statem,

Line 7920: sql_cur := dbms_sql.open_cursor;

7916: dbms_sql.v7);
7917: ignore := dbms_sql.execute(sql_cur);
7918: dbms_sql.close_cursor(sql_cur);
7919: statem := 'alter trigger ff_rpv_bri enable';
7920: sql_cur := dbms_sql.open_cursor;
7921: dbms_sql.parse(sql_cur,
7922: statem,
7923: dbms_sql.v7);
7924: ignore := dbms_sql.execute(sql_cur);

Line 7921: dbms_sql.parse(sql_cur,

7917: ignore := dbms_sql.execute(sql_cur);
7918: dbms_sql.close_cursor(sql_cur);
7919: statem := 'alter trigger ff_rpv_bri enable';
7920: sql_cur := dbms_sql.open_cursor;
7921: dbms_sql.parse(sql_cur,
7922: statem,
7923: dbms_sql.v7);
7924: ignore := dbms_sql.execute(sql_cur);
7925: dbms_sql.close_cursor(sql_cur);

Line 7923: dbms_sql.v7);

7919: statem := 'alter trigger ff_rpv_bri enable';
7920: sql_cur := dbms_sql.open_cursor;
7921: dbms_sql.parse(sql_cur,
7922: statem,
7923: dbms_sql.v7);
7924: ignore := dbms_sql.execute(sql_cur);
7925: dbms_sql.close_cursor(sql_cur);
7926: end enable_refbal_trig;
7927: --

Line 7924: ignore := dbms_sql.execute(sql_cur);

7920: sql_cur := dbms_sql.open_cursor;
7921: dbms_sql.parse(sql_cur,
7922: statem,
7923: dbms_sql.v7);
7924: ignore := dbms_sql.execute(sql_cur);
7925: dbms_sql.close_cursor(sql_cur);
7926: end enable_refbal_trig;
7927: --
7928: -- The following procedure recreates ALL dbis and UEs for all

Line 7925: dbms_sql.close_cursor(sql_cur);

7921: dbms_sql.parse(sql_cur,
7922: statem,
7923: dbms_sql.v7);
7924: ignore := dbms_sql.execute(sql_cur);
7925: dbms_sql.close_cursor(sql_cur);
7926: end enable_refbal_trig;
7927: --
7928: -- The following procedure recreates ALL dbis and UEs for all
7929: -- existing elements input values and balances. It is not intended to

Line 8565: ,p_languages in dbms_sql.varchar2s

8561: end gen_eiv_tl_dbi_prefix;
8562:
8563: procedure gen_et_dbi_prefixes
8564: (p_element_type_id in number
8565: ,p_languages in dbms_sql.varchar2s
8566: ,p_prefixes in out nocopy t_dbi_prefixes
8567: ) is
8568: l_prefix r_dbi_prefix;
8569: begin

Line 8587: ,p_languages in dbms_sql.varchar2s

8583:
8584: procedure gen_eiv_dbi_prefixes
8585: (p_input_value_id in number
8586: ,p_effective_date in date
8587: ,p_languages in dbms_sql.varchar2s
8588: ,p_prefixes in out nocopy t_dbi_prefixes
8589: ) is
8590: l_prefix r_dbi_prefix;
8591: begin

Line 9035: ,p_languages in dbms_sql.varchar2s

9031: -- Update all the dbis for a defined balance --
9032: -- ========================================= --
9033: procedure update_defined_balance
9034: (p_defined_balance_id in number
9035: ,p_languages in dbms_sql.varchar2s
9036: ) is
9037: l_leg_code varchar2(30);
9038: l_bg_id number;
9039: l_bal_id pay_defined_balances.balance_type_id%type;

Line 9113: ,p_languages in dbms_sql.varchar2s

9109: --
9110: procedure update_element_type
9111: (p_element_type_id in number
9112: ,p_effective_date in date
9113: ,p_languages in dbms_sql.varchar2s
9114: ,p_dbi_prefixes in t_dbi_prefixes
9115: ) is
9116: l_date_p varchar2(16);
9117: l_do_date_p boolean;

Line 9151: ,p_languages in dbms_sql.varchar2s

9147: ,p_prefix in out nocopy varchar2
9148: ,p_dbi_prefixes in t_dbi_prefixes
9149: ,p_date_p in varchar2
9150: ,p_startup_mode in varchar2
9151: ,p_languages in dbms_sql.varchar2s
9152: ,p_user_entity_id in out nocopy number
9153: ,p_suffix in varchar2
9154: ) is
9155: l_base_name ff_database_items.user_name%type;

Line 9546: ,p_languages in dbms_sql.varchar2s

9542: --
9543: procedure update_element_type
9544: (p_element_type_id in number
9545: ,p_effective_date in date
9546: ,p_languages in dbms_sql.varchar2s
9547: ) is
9548: l_prefixes t_dbi_prefixes;
9549: begin
9550: -- ========================== --

Line 9581: ,p_languages in dbms_sql.varchar2s

9577: --
9578: procedure update_input_value
9579: (p_input_value_id in number
9580: ,p_effective_date in date
9581: ,p_languages in dbms_sql.varchar2s
9582: ,p_dbi_prefixes in t_dbi_prefixes
9583: ) is
9584: --
9585: -- Cursor to get input value information.

Line 9627: ,p_languages in dbms_sql.varchar2s

9623: ,p_prefix in out nocopy varchar2
9624: ,p_dbi_prefixes in t_dbi_prefixes
9625: ,p_date_p in varchar2
9626: ,p_startup_mode in varchar2
9627: ,p_languages in dbms_sql.varchar2s
9628: ,p_user_entity_id in out nocopy number
9629: ,p_suffix in varchar2
9630: ) is
9631: l_base_name ff_database_items.user_name%type;

Line 10023: ,p_languages in dbms_sql.varchar2s

10019: --
10020: procedure update_input_value
10021: (p_input_value_id in number
10022: ,p_effective_date in date
10023: ,p_languages in dbms_sql.varchar2s
10024: ) is
10025: l_prefixes t_dbi_prefixes;
10026: begin
10027: -- ========================== --

Line 10071: (p_errors in out nocopy dbms_sql.varchar2_table

10067: --
10068: -- P_ERRORS collects errors in this procedure.
10069: --
10070: procedure process_leg_translations
10071: (p_errors in out nocopy dbms_sql.varchar2_table
10072: ) is
10073: l_dummy varchar2(1);
10074: l_package_name varchar2(1000);
10075: l_debug boolean := hr_utility.debug_enabled;

Line 10166: ,p_ids out nocopy dbms_sql.number_table

10162: -- Procedure to fetch changes for a particular entity type.
10163: --
10164: procedure fetch_dyndbi_changes
10165: (p_type in varchar2
10166: ,p_ids out nocopy dbms_sql.number_table
10167: ,p_languages out nocopy dbms_sql.varchar2s
10168: ) is
10169: cursor csr_dyndbi_changes
10170: (p_type in varchar2

Line 10167: ,p_languages out nocopy dbms_sql.varchar2s

10163: --
10164: procedure fetch_dyndbi_changes
10165: (p_type in varchar2
10166: ,p_ids out nocopy dbms_sql.number_table
10167: ,p_languages out nocopy dbms_sql.varchar2s
10168: ) is
10169: cursor csr_dyndbi_changes
10170: (p_type in varchar2
10171: ) is

Line 10193: (p_ids in dbms_sql.number_table

10189: -- _id to process, the list of languages, and the next index
10190: -- to start from.
10191: --
10192: procedure next_dyndbi_change
10193: (p_ids in dbms_sql.number_table
10194: ,p_languages in dbms_sql.varchar2s
10195: ,p_start in out nocopy binary_integer
10196: ,p_id out nocopy number
10197: ,p_id_langs out nocopy dbms_sql.varchar2s

Line 10194: ,p_languages in dbms_sql.varchar2s

10190: -- to start from.
10191: --
10192: procedure next_dyndbi_change
10193: (p_ids in dbms_sql.number_table
10194: ,p_languages in dbms_sql.varchar2s
10195: ,p_start in out nocopy binary_integer
10196: ,p_id out nocopy number
10197: ,p_id_langs out nocopy dbms_sql.varchar2s
10198: ) is

Line 10197: ,p_id_langs out nocopy dbms_sql.varchar2s

10193: (p_ids in dbms_sql.number_table
10194: ,p_languages in dbms_sql.varchar2s
10195: ,p_start in out nocopy binary_integer
10196: ,p_id out nocopy number
10197: ,p_id_langs out nocopy dbms_sql.varchar2s
10198: ) is
10199: i binary_integer;
10200: j binary_integer;
10201: l_id number;

Line 10233: l_ids dbms_sql.number_table;

10229: ,p_defined_balances in varchar2
10230: ,p_localization in varchar2
10231: ) is
10232: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10233: l_ids dbms_sql.number_table;
10234: l_languages dbms_sql.varchar2s;
10235: l_id number;
10236: l_id_langs dbms_sql.varchar2s;
10237: i binary_integer;

Line 10234: l_languages dbms_sql.varchar2s;

10230: ,p_localization in varchar2
10231: ) is
10232: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10233: l_ids dbms_sql.number_table;
10234: l_languages dbms_sql.varchar2s;
10235: l_id number;
10236: l_id_langs dbms_sql.varchar2s;
10237: i binary_integer;
10238: l_eff_date date;

Line 10236: l_id_langs dbms_sql.varchar2s;

10232: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10233: l_ids dbms_sql.number_table;
10234: l_languages dbms_sql.varchar2s;
10235: l_id number;
10236: l_id_langs dbms_sql.varchar2s;
10237: i binary_integer;
10238: l_eff_date date;
10239: l_found boolean;
10240: l_cnt binary_integer;

Line 10242: l_rowids dbms_sql.varchar2s;

10238: l_eff_date date;
10239: l_found boolean;
10240: l_cnt binary_integer;
10241: l_dummy varchar2(1);
10242: l_rowids dbms_sql.varchar2s;
10243: l_messages dbms_sql.varchar2_table;
10244: l_errors dbms_sql.varchar2_table;
10245: l_debug boolean := hr_utility.debug_enabled;
10246: l_newline varchar2(10) := '

Line 10243: l_messages dbms_sql.varchar2_table;

10239: l_found boolean;
10240: l_cnt binary_integer;
10241: l_dummy varchar2(1);
10242: l_rowids dbms_sql.varchar2s;
10243: l_messages dbms_sql.varchar2_table;
10244: l_errors dbms_sql.varchar2_table;
10245: l_debug boolean := hr_utility.debug_enabled;
10246: l_newline varchar2(10) := '
10247: ';

Line 10244: l_errors dbms_sql.varchar2_table;

10240: l_cnt binary_integer;
10241: l_dummy varchar2(1);
10242: l_rowids dbms_sql.varchar2s;
10243: l_messages dbms_sql.varchar2_table;
10244: l_errors dbms_sql.varchar2_table;
10245: l_debug boolean := hr_utility.debug_enabled;
10246: l_newline varchar2(10) := '
10247: ';
10248: l_separator varchar2(100);