APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 3078: type t_dim_names_tab is table of pay_balance_dimensions.dimension_name%TYPE index by binary_integer;

3074: procedure migrate_bal_dimensions is
3075: --
3076: type t_jp_dim_names_tab is table of VARCHAR2(200) index by binary_integer;
3077:
3078: type t_dim_names_tab is table of pay_balance_dimensions.dimension_name%TYPE index by binary_integer;
3079:
3080: type t_dim_desc_tab is table of pay_balance_dimensions.description%TYPE index by binary_integer;
3081:
3082: type t_dim_suffix_tab is table of pay_balance_dimensions.database_item_suffix%TYPE index by binary_integer;

Line 3080: type t_dim_desc_tab is table of pay_balance_dimensions.description%TYPE index by binary_integer;

3076: type t_jp_dim_names_tab is table of VARCHAR2(200) index by binary_integer;
3077:
3078: type t_dim_names_tab is table of pay_balance_dimensions.dimension_name%TYPE index by binary_integer;
3079:
3080: type t_dim_desc_tab is table of pay_balance_dimensions.description%TYPE index by binary_integer;
3081:
3082: type t_dim_suffix_tab is table of pay_balance_dimensions.database_item_suffix%TYPE index by binary_integer;
3083:
3084: l_jp_dim_names_tab t_jp_dim_names_tab;

Line 3082: type t_dim_suffix_tab is table of pay_balance_dimensions.database_item_suffix%TYPE index by binary_integer;

3078: type t_dim_names_tab is table of pay_balance_dimensions.dimension_name%TYPE index by binary_integer;
3079:
3080: type t_dim_desc_tab is table of pay_balance_dimensions.description%TYPE index by binary_integer;
3081:
3082: type t_dim_suffix_tab is table of pay_balance_dimensions.database_item_suffix%TYPE index by binary_integer;
3083:
3084: l_jp_dim_names_tab t_jp_dim_names_tab;
3085: l_dim_names_tab t_dim_names_tab;
3086: l_dim_desc_tab t_dim_desc_tab;

Line 3175: UPDATE pay_balance_dimensions

3171: --
3172:
3173: FORALL l_tab_cnt IN 1..l_jp_dim_names_tab.COUNT
3174:
3175: UPDATE pay_balance_dimensions
3176: SET dimension_name = l_dim_names_tab(l_tab_cnt),
3177: database_item_suffix = l_dim_suffix_tab(l_tab_cnt),
3178: description = l_dim_desc_tab(l_tab_cnt)
3179: WHERE dimension_name LIKE hr_jp_standard_pkg.hextochar(l_jp_dim_names_tab(l_tab_cnt),'AL32UTF8')

Line 5210: from pay_balance_dimensions pbd

5206: --
5207: cursor csr_dim_cnt
5208: is
5209: select count(pbd.balance_dimension_id)
5210: from pay_balance_dimensions pbd
5211: where pbd.legislation_code = 'JP'
5212: and ascii(substr(pbd.dimension_name,3,1)) <= 127
5213: and pbd.dimension_name not in (
5214: '_ASG_ADV_RETRO_RUN',

Line 5218: from pay_balance_dimensions pbd2

5214: '_ASG_ADV_RETRO_RUN',
5215: '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01')
5216: and exists(
5217: select null
5218: from pay_balance_dimensions pbd2
5219: where pbd2.legislation_code = 'JP'
5220: and ascii(substr(pbd2.dimension_name,3,1)) > 127);
5221: --
5222: cursor csr_eset_cnt

Line 5984: -- from pay_balance_dimensions pbd

5980: -- l_dummy := null;
5981: -- --
5982: -- select pbd.dimension_name
5983: -- into l_dummy
5984: -- from pay_balance_dimensions pbd
5985: -- where pbd.dimension_name = l_dim_tbl(l_dim_ind)
5986: -- and pbd.legislation_code = 'JP';
5987: -- --
5988: -- if (g_dbg) then

Line 6021: update pay_balance_dimensions

6017: -- end if;
6018: --
6019: -- use bulk collect
6020: forall l_dim_ind in 1..l_dim_tbl.count
6021: update pay_balance_dimensions
6022: set dimension_name = substrb(dimension_name,1,80-4)||'_OBS',
6023: database_item_suffix = substrb(database_item_suffix,1,80-4)||'_OBS',
6024: description = substrb(description,1,240-11)||' (Obsolete)'
6025: where dimension_name = l_dim_tbl(l_dim_ind)

Line 6929: FROM pay_balance_dimensions

6925: hr_utility.set_location(l_proc, 50);
6926:
6927: SELECT COUNT(1)
6928: INTO l_count
6929: FROM pay_balance_dimensions
6930: WHERE legislation_code = 'JP'
6931: AND ASCII(SUBSTR(dimension_name,3,1)) > 127;
6932:
6933: IF (l_count > 0) THEN