APPS.HRDYNDBI dependencies on DBMS_SQL

Line 152: interface. Also, use dbms_sql.varchar_table

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

Line 788: ,p_languages in dbms_sql.varchar2s

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

Line 795: ,p_languages in dbms_sql.varchar2s

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

Line 848: (p_formula_ids in dbms_sql.number_table

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

Line 849: ,p_start_dates in dbms_sql.date_table

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

Line 2845: l_formula_ids dbms_sql.number_table;

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

Line 2846: l_start_dates dbms_sql.date_table;

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

Line 2898: (p_formula_ids dbms_sql.number_table

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

Line 2899: ,p_start_dates dbms_sql.date_table

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

Line 3040: l_languages dbms_sql.varchar2s;

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

Line 3892: l_languages dbms_sql.varchar2s;

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

Line 5481: l_formula_ids dbms_sql.number_table;

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

Line 5482: l_start_dates dbms_sql.date_table;

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

Line 5483: l_rowids dbms_sql.varchar2s;

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

Line 7891: sql_cur := dbms_sql.open_cursor;

7887: l_ret_per := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
7888: l_industry, l_per_owner);
7889:
7890: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7891: sql_cur := dbms_sql.open_cursor;
7892: dbms_sql.parse(sql_cur,
7893: statem,
7894: dbms_sql.v7);
7895: ignore := dbms_sql.execute(sql_cur);

Line 7892: dbms_sql.parse(sql_cur,

7888: l_industry, l_per_owner);
7889:
7890: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7891: sql_cur := dbms_sql.open_cursor;
7892: dbms_sql.parse(sql_cur,
7893: statem,
7894: dbms_sql.v7);
7895: ignore := dbms_sql.execute(sql_cur);
7896: dbms_sql.close_cursor(sql_cur);

Line 7894: dbms_sql.v7);

7890: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7891: sql_cur := dbms_sql.open_cursor;
7892: dbms_sql.parse(sql_cur,
7893: statem,
7894: dbms_sql.v7);
7895: ignore := dbms_sql.execute(sql_cur);
7896: dbms_sql.close_cursor(sql_cur);
7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7898: sql_cur := dbms_sql.open_cursor;

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

7891: sql_cur := dbms_sql.open_cursor;
7892: dbms_sql.parse(sql_cur,
7893: statem,
7894: dbms_sql.v7);
7895: ignore := dbms_sql.execute(sql_cur);
7896: dbms_sql.close_cursor(sql_cur);
7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7898: sql_cur := dbms_sql.open_cursor;
7899: dbms_sql.parse(sql_cur,

Line 7896: dbms_sql.close_cursor(sql_cur);

7892: dbms_sql.parse(sql_cur,
7893: statem,
7894: dbms_sql.v7);
7895: ignore := dbms_sql.execute(sql_cur);
7896: dbms_sql.close_cursor(sql_cur);
7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7898: sql_cur := dbms_sql.open_cursor;
7899: dbms_sql.parse(sql_cur,
7900: statem,

Line 7898: sql_cur := dbms_sql.open_cursor;

7894: dbms_sql.v7);
7895: ignore := dbms_sql.execute(sql_cur);
7896: dbms_sql.close_cursor(sql_cur);
7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7898: sql_cur := dbms_sql.open_cursor;
7899: dbms_sql.parse(sql_cur,
7900: statem,
7901: dbms_sql.v7);
7902: ignore := dbms_sql.execute(sql_cur);

Line 7899: dbms_sql.parse(sql_cur,

7895: ignore := dbms_sql.execute(sql_cur);
7896: dbms_sql.close_cursor(sql_cur);
7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7898: sql_cur := dbms_sql.open_cursor;
7899: dbms_sql.parse(sql_cur,
7900: statem,
7901: dbms_sql.v7);
7902: ignore := dbms_sql.execute(sql_cur);
7903: dbms_sql.close_cursor(sql_cur);

Line 7901: dbms_sql.v7);

7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7898: sql_cur := dbms_sql.open_cursor;
7899: dbms_sql.parse(sql_cur,
7900: statem,
7901: dbms_sql.v7);
7902: ignore := dbms_sql.execute(sql_cur);
7903: dbms_sql.close_cursor(sql_cur);
7904: end truncate_fcomp_info;
7905: --

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

7898: sql_cur := dbms_sql.open_cursor;
7899: dbms_sql.parse(sql_cur,
7900: statem,
7901: dbms_sql.v7);
7902: ignore := dbms_sql.execute(sql_cur);
7903: dbms_sql.close_cursor(sql_cur);
7904: end truncate_fcomp_info;
7905: --
7906:

Line 7903: dbms_sql.close_cursor(sql_cur);

7899: dbms_sql.parse(sql_cur,
7900: statem,
7901: dbms_sql.v7);
7902: ignore := dbms_sql.execute(sql_cur);
7903: dbms_sql.close_cursor(sql_cur);
7904: end truncate_fcomp_info;
7905: --
7906:
7907: procedure disable_ffue_cascade_trig is

Line 7913: sql_cur := dbms_sql.open_cursor;

7909: sql_cur number;
7910: ignore number;
7911: begin
7912: statem := 'alter trigger ff_database_items_brd disable';
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 number;
7911: begin
7912: statem := 'alter trigger ff_database_items_brd disable';
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_brd disable';
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_brud disable';
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_brud disable';
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_brud disable';
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_brud disable';
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_brud disable';
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_brud disable';
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 disable_ffue_cascade_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 disable_ffue_cascade_trig;
7927: --
7928: procedure enable_ffue_cascade_trig is

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 disable_ffue_cascade_trig;
7927: --
7928: procedure enable_ffue_cascade_trig is
7929: statem varchar2(256);

Line 7934: sql_cur := dbms_sql.open_cursor;

7930: sql_cur number;
7931: ignore number;
7932: begin
7933: statem := 'alter trigger ff_database_items_brd enable';
7934: sql_cur := dbms_sql.open_cursor;
7935: dbms_sql.parse(sql_cur,
7936: statem,
7937: dbms_sql.v7);
7938: ignore := dbms_sql.execute(sql_cur);

Line 7935: dbms_sql.parse(sql_cur,

7931: ignore number;
7932: begin
7933: statem := 'alter trigger ff_database_items_brd enable';
7934: sql_cur := dbms_sql.open_cursor;
7935: dbms_sql.parse(sql_cur,
7936: statem,
7937: dbms_sql.v7);
7938: ignore := dbms_sql.execute(sql_cur);
7939: dbms_sql.close_cursor(sql_cur);

Line 7937: dbms_sql.v7);

7933: statem := 'alter trigger ff_database_items_brd enable';
7934: sql_cur := dbms_sql.open_cursor;
7935: dbms_sql.parse(sql_cur,
7936: statem,
7937: dbms_sql.v7);
7938: ignore := dbms_sql.execute(sql_cur);
7939: dbms_sql.close_cursor(sql_cur);
7940: statem := 'alter trigger ff_rpv_brud enable';
7941: sql_cur := dbms_sql.open_cursor;

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

7934: sql_cur := dbms_sql.open_cursor;
7935: dbms_sql.parse(sql_cur,
7936: statem,
7937: dbms_sql.v7);
7938: ignore := dbms_sql.execute(sql_cur);
7939: dbms_sql.close_cursor(sql_cur);
7940: statem := 'alter trigger ff_rpv_brud enable';
7941: sql_cur := dbms_sql.open_cursor;
7942: dbms_sql.parse(sql_cur,

Line 7939: dbms_sql.close_cursor(sql_cur);

7935: dbms_sql.parse(sql_cur,
7936: statem,
7937: dbms_sql.v7);
7938: ignore := dbms_sql.execute(sql_cur);
7939: dbms_sql.close_cursor(sql_cur);
7940: statem := 'alter trigger ff_rpv_brud enable';
7941: sql_cur := dbms_sql.open_cursor;
7942: dbms_sql.parse(sql_cur,
7943: statem,

Line 7941: sql_cur := dbms_sql.open_cursor;

7937: dbms_sql.v7);
7938: ignore := dbms_sql.execute(sql_cur);
7939: dbms_sql.close_cursor(sql_cur);
7940: statem := 'alter trigger ff_rpv_brud enable';
7941: sql_cur := dbms_sql.open_cursor;
7942: dbms_sql.parse(sql_cur,
7943: statem,
7944: dbms_sql.v7);
7945: ignore := dbms_sql.execute(sql_cur);

Line 7942: dbms_sql.parse(sql_cur,

7938: ignore := dbms_sql.execute(sql_cur);
7939: dbms_sql.close_cursor(sql_cur);
7940: statem := 'alter trigger ff_rpv_brud enable';
7941: sql_cur := dbms_sql.open_cursor;
7942: dbms_sql.parse(sql_cur,
7943: statem,
7944: dbms_sql.v7);
7945: ignore := dbms_sql.execute(sql_cur);
7946: dbms_sql.close_cursor(sql_cur);

Line 7944: dbms_sql.v7);

7940: statem := 'alter trigger ff_rpv_brud enable';
7941: sql_cur := dbms_sql.open_cursor;
7942: dbms_sql.parse(sql_cur,
7943: statem,
7944: dbms_sql.v7);
7945: ignore := dbms_sql.execute(sql_cur);
7946: dbms_sql.close_cursor(sql_cur);
7947: end enable_ffue_cascade_trig;
7948: --

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

7941: sql_cur := dbms_sql.open_cursor;
7942: dbms_sql.parse(sql_cur,
7943: statem,
7944: dbms_sql.v7);
7945: ignore := dbms_sql.execute(sql_cur);
7946: dbms_sql.close_cursor(sql_cur);
7947: end enable_ffue_cascade_trig;
7948: --
7949: procedure disable_refbal_trig is

Line 7946: dbms_sql.close_cursor(sql_cur);

7942: dbms_sql.parse(sql_cur,
7943: statem,
7944: dbms_sql.v7);
7945: ignore := dbms_sql.execute(sql_cur);
7946: dbms_sql.close_cursor(sql_cur);
7947: end enable_ffue_cascade_trig;
7948: --
7949: procedure disable_refbal_trig is
7950: statem varchar2(256);

Line 7955: sql_cur := dbms_sql.open_cursor;

7951: sql_cur number;
7952: ignore number;
7953: begin
7954: statem := 'alter trigger ff_user_entities_bri disable';
7955: sql_cur := dbms_sql.open_cursor;
7956: dbms_sql.parse(sql_cur,
7957: statem,
7958: dbms_sql.v7);
7959: ignore := dbms_sql.execute(sql_cur);

Line 7956: dbms_sql.parse(sql_cur,

7952: ignore number;
7953: begin
7954: statem := 'alter trigger ff_user_entities_bri disable';
7955: sql_cur := dbms_sql.open_cursor;
7956: dbms_sql.parse(sql_cur,
7957: statem,
7958: dbms_sql.v7);
7959: ignore := dbms_sql.execute(sql_cur);
7960: dbms_sql.close_cursor(sql_cur);

Line 7958: dbms_sql.v7);

7954: statem := 'alter trigger ff_user_entities_bri disable';
7955: sql_cur := dbms_sql.open_cursor;
7956: dbms_sql.parse(sql_cur,
7957: statem,
7958: dbms_sql.v7);
7959: ignore := dbms_sql.execute(sql_cur);
7960: dbms_sql.close_cursor(sql_cur);
7961: statem := 'alter trigger ff_database_items_bri disable';
7962: sql_cur := dbms_sql.open_cursor;

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

7955: sql_cur := dbms_sql.open_cursor;
7956: dbms_sql.parse(sql_cur,
7957: statem,
7958: dbms_sql.v7);
7959: ignore := dbms_sql.execute(sql_cur);
7960: dbms_sql.close_cursor(sql_cur);
7961: statem := 'alter trigger ff_database_items_bri disable';
7962: sql_cur := dbms_sql.open_cursor;
7963: dbms_sql.parse(sql_cur,

Line 7960: dbms_sql.close_cursor(sql_cur);

7956: dbms_sql.parse(sql_cur,
7957: statem,
7958: dbms_sql.v7);
7959: ignore := dbms_sql.execute(sql_cur);
7960: dbms_sql.close_cursor(sql_cur);
7961: statem := 'alter trigger ff_database_items_bri disable';
7962: sql_cur := dbms_sql.open_cursor;
7963: dbms_sql.parse(sql_cur,
7964: statem,

Line 7962: sql_cur := dbms_sql.open_cursor;

7958: dbms_sql.v7);
7959: ignore := dbms_sql.execute(sql_cur);
7960: dbms_sql.close_cursor(sql_cur);
7961: statem := 'alter trigger ff_database_items_bri disable';
7962: sql_cur := dbms_sql.open_cursor;
7963: dbms_sql.parse(sql_cur,
7964: statem,
7965: dbms_sql.v7);
7966: ignore := dbms_sql.execute(sql_cur);

Line 7963: dbms_sql.parse(sql_cur,

7959: ignore := dbms_sql.execute(sql_cur);
7960: dbms_sql.close_cursor(sql_cur);
7961: statem := 'alter trigger ff_database_items_bri disable';
7962: sql_cur := dbms_sql.open_cursor;
7963: dbms_sql.parse(sql_cur,
7964: statem,
7965: dbms_sql.v7);
7966: ignore := dbms_sql.execute(sql_cur);
7967: dbms_sql.close_cursor(sql_cur);

Line 7965: dbms_sql.v7);

7961: statem := 'alter trigger ff_database_items_bri disable';
7962: sql_cur := dbms_sql.open_cursor;
7963: dbms_sql.parse(sql_cur,
7964: statem,
7965: dbms_sql.v7);
7966: ignore := dbms_sql.execute(sql_cur);
7967: dbms_sql.close_cursor(sql_cur);
7968: statem := 'alter trigger ff_rpv_bri disable';
7969: sql_cur := dbms_sql.open_cursor;

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

7962: sql_cur := dbms_sql.open_cursor;
7963: dbms_sql.parse(sql_cur,
7964: statem,
7965: dbms_sql.v7);
7966: ignore := dbms_sql.execute(sql_cur);
7967: dbms_sql.close_cursor(sql_cur);
7968: statem := 'alter trigger ff_rpv_bri disable';
7969: sql_cur := dbms_sql.open_cursor;
7970: dbms_sql.parse(sql_cur,

Line 7967: dbms_sql.close_cursor(sql_cur);

7963: dbms_sql.parse(sql_cur,
7964: statem,
7965: dbms_sql.v7);
7966: ignore := dbms_sql.execute(sql_cur);
7967: dbms_sql.close_cursor(sql_cur);
7968: statem := 'alter trigger ff_rpv_bri disable';
7969: sql_cur := dbms_sql.open_cursor;
7970: dbms_sql.parse(sql_cur,
7971: statem,

Line 7969: sql_cur := dbms_sql.open_cursor;

7965: dbms_sql.v7);
7966: ignore := dbms_sql.execute(sql_cur);
7967: dbms_sql.close_cursor(sql_cur);
7968: statem := 'alter trigger ff_rpv_bri disable';
7969: sql_cur := dbms_sql.open_cursor;
7970: dbms_sql.parse(sql_cur,
7971: statem,
7972: dbms_sql.v7);
7973: ignore := dbms_sql.execute(sql_cur);

Line 7970: dbms_sql.parse(sql_cur,

7966: ignore := dbms_sql.execute(sql_cur);
7967: dbms_sql.close_cursor(sql_cur);
7968: statem := 'alter trigger ff_rpv_bri disable';
7969: sql_cur := dbms_sql.open_cursor;
7970: dbms_sql.parse(sql_cur,
7971: statem,
7972: dbms_sql.v7);
7973: ignore := dbms_sql.execute(sql_cur);
7974: dbms_sql.close_cursor(sql_cur);

Line 7972: dbms_sql.v7);

7968: statem := 'alter trigger ff_rpv_bri disable';
7969: sql_cur := dbms_sql.open_cursor;
7970: dbms_sql.parse(sql_cur,
7971: statem,
7972: dbms_sql.v7);
7973: ignore := dbms_sql.execute(sql_cur);
7974: dbms_sql.close_cursor(sql_cur);
7975: end disable_refbal_trig;
7976: --

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

7969: sql_cur := dbms_sql.open_cursor;
7970: dbms_sql.parse(sql_cur,
7971: statem,
7972: dbms_sql.v7);
7973: ignore := dbms_sql.execute(sql_cur);
7974: dbms_sql.close_cursor(sql_cur);
7975: end disable_refbal_trig;
7976: --
7977: procedure enable_refbal_trig is

Line 7974: dbms_sql.close_cursor(sql_cur);

7970: dbms_sql.parse(sql_cur,
7971: statem,
7972: dbms_sql.v7);
7973: ignore := dbms_sql.execute(sql_cur);
7974: dbms_sql.close_cursor(sql_cur);
7975: end disable_refbal_trig;
7976: --
7977: procedure enable_refbal_trig is
7978: statem varchar2(256);

Line 7983: sql_cur := dbms_sql.open_cursor;

7979: sql_cur number;
7980: ignore number;
7981: begin
7982: statem := 'alter trigger ff_user_entities_bri enable';
7983: sql_cur := dbms_sql.open_cursor;
7984: dbms_sql.parse(sql_cur,
7985: statem,
7986: dbms_sql.v7);
7987: ignore := dbms_sql.execute(sql_cur);

Line 7984: dbms_sql.parse(sql_cur,

7980: ignore number;
7981: begin
7982: statem := 'alter trigger ff_user_entities_bri enable';
7983: sql_cur := dbms_sql.open_cursor;
7984: dbms_sql.parse(sql_cur,
7985: statem,
7986: dbms_sql.v7);
7987: ignore := dbms_sql.execute(sql_cur);
7988: dbms_sql.close_cursor(sql_cur);

Line 7986: dbms_sql.v7);

7982: statem := 'alter trigger ff_user_entities_bri enable';
7983: sql_cur := dbms_sql.open_cursor;
7984: dbms_sql.parse(sql_cur,
7985: statem,
7986: dbms_sql.v7);
7987: ignore := dbms_sql.execute(sql_cur);
7988: dbms_sql.close_cursor(sql_cur);
7989: statem := 'alter trigger ff_database_items_bri enable';
7990: sql_cur := dbms_sql.open_cursor;

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

7983: sql_cur := dbms_sql.open_cursor;
7984: dbms_sql.parse(sql_cur,
7985: statem,
7986: dbms_sql.v7);
7987: ignore := dbms_sql.execute(sql_cur);
7988: dbms_sql.close_cursor(sql_cur);
7989: statem := 'alter trigger ff_database_items_bri enable';
7990: sql_cur := dbms_sql.open_cursor;
7991: dbms_sql.parse(sql_cur,

Line 7988: dbms_sql.close_cursor(sql_cur);

7984: dbms_sql.parse(sql_cur,
7985: statem,
7986: dbms_sql.v7);
7987: ignore := dbms_sql.execute(sql_cur);
7988: dbms_sql.close_cursor(sql_cur);
7989: statem := 'alter trigger ff_database_items_bri enable';
7990: sql_cur := dbms_sql.open_cursor;
7991: dbms_sql.parse(sql_cur,
7992: statem,

Line 7990: sql_cur := dbms_sql.open_cursor;

7986: dbms_sql.v7);
7987: ignore := dbms_sql.execute(sql_cur);
7988: dbms_sql.close_cursor(sql_cur);
7989: statem := 'alter trigger ff_database_items_bri enable';
7990: sql_cur := dbms_sql.open_cursor;
7991: dbms_sql.parse(sql_cur,
7992: statem,
7993: dbms_sql.v7);
7994: ignore := dbms_sql.execute(sql_cur);

Line 7991: dbms_sql.parse(sql_cur,

7987: ignore := dbms_sql.execute(sql_cur);
7988: dbms_sql.close_cursor(sql_cur);
7989: statem := 'alter trigger ff_database_items_bri enable';
7990: sql_cur := dbms_sql.open_cursor;
7991: dbms_sql.parse(sql_cur,
7992: statem,
7993: dbms_sql.v7);
7994: ignore := dbms_sql.execute(sql_cur);
7995: dbms_sql.close_cursor(sql_cur);

Line 7993: dbms_sql.v7);

7989: statem := 'alter trigger ff_database_items_bri enable';
7990: sql_cur := dbms_sql.open_cursor;
7991: dbms_sql.parse(sql_cur,
7992: statem,
7993: dbms_sql.v7);
7994: ignore := dbms_sql.execute(sql_cur);
7995: dbms_sql.close_cursor(sql_cur);
7996: statem := 'alter trigger ff_rpv_bri enable';
7997: sql_cur := dbms_sql.open_cursor;

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

7990: sql_cur := dbms_sql.open_cursor;
7991: dbms_sql.parse(sql_cur,
7992: statem,
7993: dbms_sql.v7);
7994: ignore := dbms_sql.execute(sql_cur);
7995: dbms_sql.close_cursor(sql_cur);
7996: statem := 'alter trigger ff_rpv_bri enable';
7997: sql_cur := dbms_sql.open_cursor;
7998: dbms_sql.parse(sql_cur,

Line 7995: dbms_sql.close_cursor(sql_cur);

7991: dbms_sql.parse(sql_cur,
7992: statem,
7993: dbms_sql.v7);
7994: ignore := dbms_sql.execute(sql_cur);
7995: dbms_sql.close_cursor(sql_cur);
7996: statem := 'alter trigger ff_rpv_bri enable';
7997: sql_cur := dbms_sql.open_cursor;
7998: dbms_sql.parse(sql_cur,
7999: statem,

Line 7997: sql_cur := dbms_sql.open_cursor;

7993: dbms_sql.v7);
7994: ignore := dbms_sql.execute(sql_cur);
7995: dbms_sql.close_cursor(sql_cur);
7996: statem := 'alter trigger ff_rpv_bri enable';
7997: sql_cur := dbms_sql.open_cursor;
7998: dbms_sql.parse(sql_cur,
7999: statem,
8000: dbms_sql.v7);
8001: ignore := dbms_sql.execute(sql_cur);

Line 7998: dbms_sql.parse(sql_cur,

7994: ignore := dbms_sql.execute(sql_cur);
7995: dbms_sql.close_cursor(sql_cur);
7996: statem := 'alter trigger ff_rpv_bri enable';
7997: sql_cur := dbms_sql.open_cursor;
7998: dbms_sql.parse(sql_cur,
7999: statem,
8000: dbms_sql.v7);
8001: ignore := dbms_sql.execute(sql_cur);
8002: dbms_sql.close_cursor(sql_cur);

Line 8000: dbms_sql.v7);

7996: statem := 'alter trigger ff_rpv_bri enable';
7997: sql_cur := dbms_sql.open_cursor;
7998: dbms_sql.parse(sql_cur,
7999: statem,
8000: dbms_sql.v7);
8001: ignore := dbms_sql.execute(sql_cur);
8002: dbms_sql.close_cursor(sql_cur);
8003: end enable_refbal_trig;
8004: --

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

7997: sql_cur := dbms_sql.open_cursor;
7998: dbms_sql.parse(sql_cur,
7999: statem,
8000: dbms_sql.v7);
8001: ignore := dbms_sql.execute(sql_cur);
8002: dbms_sql.close_cursor(sql_cur);
8003: end enable_refbal_trig;
8004: --
8005: -- The following procedure recreates ALL dbis and UEs for all

Line 8002: dbms_sql.close_cursor(sql_cur);

7998: dbms_sql.parse(sql_cur,
7999: statem,
8000: dbms_sql.v7);
8001: ignore := dbms_sql.execute(sql_cur);
8002: dbms_sql.close_cursor(sql_cur);
8003: end enable_refbal_trig;
8004: --
8005: -- The following procedure recreates ALL dbis and UEs for all
8006: -- existing elements input values and balances. It is not intended to

Line 8642: ,p_languages in dbms_sql.varchar2s

8638: end gen_eiv_tl_dbi_prefix;
8639:
8640: procedure gen_et_dbi_prefixes
8641: (p_element_type_id in number
8642: ,p_languages in dbms_sql.varchar2s
8643: ,p_prefixes in out nocopy t_dbi_prefixes
8644: ) is
8645: l_prefix r_dbi_prefix;
8646: begin

Line 8664: ,p_languages in dbms_sql.varchar2s

8660:
8661: procedure gen_eiv_dbi_prefixes
8662: (p_input_value_id in number
8663: ,p_effective_date in date
8664: ,p_languages in dbms_sql.varchar2s
8665: ,p_prefixes in out nocopy t_dbi_prefixes
8666: ) is
8667: l_prefix r_dbi_prefix;
8668: begin

Line 9112: ,p_languages in dbms_sql.varchar2s

9108: -- Update all the dbis for a defined balance --
9109: -- ========================================= --
9110: procedure update_defined_balance
9111: (p_defined_balance_id in number
9112: ,p_languages in dbms_sql.varchar2s
9113: ) is
9114: l_leg_code varchar2(30);
9115: l_bg_id number;
9116: l_bal_id pay_defined_balances.balance_type_id%type;

Line 9190: ,p_languages in dbms_sql.varchar2s

9186: --
9187: procedure update_element_type
9188: (p_element_type_id in number
9189: ,p_effective_date in date
9190: ,p_languages in dbms_sql.varchar2s
9191: ,p_dbi_prefixes in t_dbi_prefixes
9192: ) is
9193: l_date_p varchar2(16);
9194: l_do_date_p boolean;

Line 9228: ,p_languages in dbms_sql.varchar2s

9224: ,p_prefix in out nocopy varchar2
9225: ,p_dbi_prefixes in t_dbi_prefixes
9226: ,p_date_p in varchar2
9227: ,p_startup_mode in varchar2
9228: ,p_languages in dbms_sql.varchar2s
9229: ,p_user_entity_id in out nocopy number
9230: ,p_suffix in varchar2
9231: ) is
9232: l_base_name ff_database_items.user_name%type;

Line 9623: ,p_languages in dbms_sql.varchar2s

9619: --
9620: procedure update_element_type
9621: (p_element_type_id in number
9622: ,p_effective_date in date
9623: ,p_languages in dbms_sql.varchar2s
9624: ) is
9625: l_prefixes t_dbi_prefixes;
9626: begin
9627: -- ========================== --

Line 9658: ,p_languages in dbms_sql.varchar2s

9654: --
9655: procedure update_input_value
9656: (p_input_value_id in number
9657: ,p_effective_date in date
9658: ,p_languages in dbms_sql.varchar2s
9659: ,p_dbi_prefixes in t_dbi_prefixes
9660: ) is
9661: --
9662: -- Cursor to get input value information.

Line 9704: ,p_languages in dbms_sql.varchar2s

9700: ,p_prefix in out nocopy varchar2
9701: ,p_dbi_prefixes in t_dbi_prefixes
9702: ,p_date_p in varchar2
9703: ,p_startup_mode in varchar2
9704: ,p_languages in dbms_sql.varchar2s
9705: ,p_user_entity_id in out nocopy number
9706: ,p_suffix in varchar2
9707: ) is
9708: l_base_name ff_database_items.user_name%type;

Line 10100: ,p_languages in dbms_sql.varchar2s

10096: --
10097: procedure update_input_value
10098: (p_input_value_id in number
10099: ,p_effective_date in date
10100: ,p_languages in dbms_sql.varchar2s
10101: ) is
10102: l_prefixes t_dbi_prefixes;
10103: begin
10104: -- ========================== --

Line 10148: (p_errors in out nocopy dbms_sql.varchar2_table

10144: --
10145: -- P_ERRORS collects errors in this procedure.
10146: --
10147: procedure process_leg_translations
10148: (p_errors in out nocopy dbms_sql.varchar2_table
10149: ) is
10150: l_dummy varchar2(1);
10151: l_package_name varchar2(1000);
10152: l_debug boolean := hr_utility.debug_enabled;

Line 10243: ,p_ids out nocopy dbms_sql.number_table

10239: -- Procedure to fetch changes for a particular entity type.
10240: --
10241: procedure fetch_dyndbi_changes
10242: (p_type in varchar2
10243: ,p_ids out nocopy dbms_sql.number_table
10244: ,p_languages out nocopy dbms_sql.varchar2s
10245: ) is
10246: cursor csr_dyndbi_changes
10247: (p_type in varchar2

Line 10244: ,p_languages out nocopy dbms_sql.varchar2s

10240: --
10241: procedure fetch_dyndbi_changes
10242: (p_type in varchar2
10243: ,p_ids out nocopy dbms_sql.number_table
10244: ,p_languages out nocopy dbms_sql.varchar2s
10245: ) is
10246: cursor csr_dyndbi_changes
10247: (p_type in varchar2
10248: ) is

Line 10270: (p_ids in dbms_sql.number_table

10266: -- _id to process, the list of languages, and the next index
10267: -- to start from.
10268: --
10269: procedure next_dyndbi_change
10270: (p_ids in dbms_sql.number_table
10271: ,p_languages in dbms_sql.varchar2s
10272: ,p_start in out nocopy binary_integer
10273: ,p_id out nocopy number
10274: ,p_id_langs out nocopy dbms_sql.varchar2s

Line 10271: ,p_languages in dbms_sql.varchar2s

10267: -- to start from.
10268: --
10269: procedure next_dyndbi_change
10270: (p_ids in dbms_sql.number_table
10271: ,p_languages in dbms_sql.varchar2s
10272: ,p_start in out nocopy binary_integer
10273: ,p_id out nocopy number
10274: ,p_id_langs out nocopy dbms_sql.varchar2s
10275: ) is

Line 10274: ,p_id_langs out nocopy dbms_sql.varchar2s

10270: (p_ids in dbms_sql.number_table
10271: ,p_languages in dbms_sql.varchar2s
10272: ,p_start in out nocopy binary_integer
10273: ,p_id out nocopy number
10274: ,p_id_langs out nocopy dbms_sql.varchar2s
10275: ) is
10276: i binary_integer;
10277: j binary_integer;
10278: l_id number;

Line 10310: l_ids dbms_sql.number_table;

10306: ,p_defined_balances in varchar2
10307: ,p_localization in varchar2
10308: ) is
10309: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10310: l_ids dbms_sql.number_table;
10311: l_languages dbms_sql.varchar2s;
10312: l_id number;
10313: l_id_langs dbms_sql.varchar2s;
10314: i binary_integer;

Line 10311: l_languages dbms_sql.varchar2s;

10307: ,p_localization in varchar2
10308: ) is
10309: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10310: l_ids dbms_sql.number_table;
10311: l_languages dbms_sql.varchar2s;
10312: l_id number;
10313: l_id_langs dbms_sql.varchar2s;
10314: i binary_integer;
10315: l_eff_date date;

Line 10313: l_id_langs dbms_sql.varchar2s;

10309: l_proc varchar2(2000) := 'PROCESS_PAY_DYNDBI_CHANGES:';
10310: l_ids dbms_sql.number_table;
10311: l_languages dbms_sql.varchar2s;
10312: l_id number;
10313: l_id_langs dbms_sql.varchar2s;
10314: i binary_integer;
10315: l_eff_date date;
10316: l_found boolean;
10317: l_cnt binary_integer;

Line 10319: l_rowids dbms_sql.varchar2s;

10315: l_eff_date date;
10316: l_found boolean;
10317: l_cnt binary_integer;
10318: l_dummy varchar2(1);
10319: l_rowids dbms_sql.varchar2s;
10320: l_messages dbms_sql.varchar2_table;
10321: l_errors dbms_sql.varchar2_table;
10322: l_debug boolean := hr_utility.debug_enabled;
10323: l_newline varchar2(10) := '

Line 10320: l_messages dbms_sql.varchar2_table;

10316: l_found boolean;
10317: l_cnt binary_integer;
10318: l_dummy varchar2(1);
10319: l_rowids dbms_sql.varchar2s;
10320: l_messages dbms_sql.varchar2_table;
10321: l_errors dbms_sql.varchar2_table;
10322: l_debug boolean := hr_utility.debug_enabled;
10323: l_newline varchar2(10) := '
10324: ';

Line 10321: l_errors dbms_sql.varchar2_table;

10317: l_cnt binary_integer;
10318: l_dummy varchar2(1);
10319: l_rowids dbms_sql.varchar2s;
10320: l_messages dbms_sql.varchar2_table;
10321: l_errors dbms_sql.varchar2_table;
10322: l_debug boolean := hr_utility.debug_enabled;
10323: l_newline varchar2(10) := '
10324: ';
10325: l_separator varchar2(100);