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.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_BALANCE_DIMENSIONS

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

3052: procedure migrate_bal_dimensions is
3053: --
3054: type t_jp_dim_names_tab is table of VARCHAR2(200) index by binary_integer;
3055:
3056: type t_dim_names_tab is table of pay_balance_dimensions.dimension_name%TYPE index by binary_integer;
3057:
3058: type t_dim_desc_tab is table of pay_balance_dimensions.description%TYPE index by binary_integer;
3059:
3060: type t_dim_suffix_tab is table of pay_balance_dimensions.database_item_suffix%TYPE index by binary_integer;

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

3054: type t_jp_dim_names_tab is table of VARCHAR2(200) index by binary_integer;
3055:
3056: type t_dim_names_tab is table of pay_balance_dimensions.dimension_name%TYPE index by binary_integer;
3057:
3058: type t_dim_desc_tab is table of pay_balance_dimensions.description%TYPE index by binary_integer;
3059:
3060: type t_dim_suffix_tab is table of pay_balance_dimensions.database_item_suffix%TYPE index by binary_integer;
3061:
3062: l_jp_dim_names_tab t_jp_dim_names_tab;

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

3056: type t_dim_names_tab is table of pay_balance_dimensions.dimension_name%TYPE index by binary_integer;
3057:
3058: type t_dim_desc_tab is table of pay_balance_dimensions.description%TYPE index by binary_integer;
3059:
3060: type t_dim_suffix_tab is table of pay_balance_dimensions.database_item_suffix%TYPE index by binary_integer;
3061:
3062: l_jp_dim_names_tab t_jp_dim_names_tab;
3063: l_dim_names_tab t_dim_names_tab;
3064: l_dim_desc_tab t_dim_desc_tab;

Line 3153: UPDATE pay_balance_dimensions

3149: --
3150:
3151: FORALL l_tab_cnt IN 1..l_jp_dim_names_tab.COUNT
3152:
3153: UPDATE pay_balance_dimensions
3154: SET dimension_name = l_dim_names_tab(l_tab_cnt),
3155: database_item_suffix = l_dim_suffix_tab(l_tab_cnt),
3156: description = l_dim_desc_tab(l_tab_cnt)
3157: WHERE dimension_name LIKE hr_jp_standard_pkg.hextochar(l_jp_dim_names_tab(l_tab_cnt),'AL32UTF8')

Line 4940: FROM pay_balance_dimensions

4936: hr_utility.set_location(l_proc, 50);
4937:
4938: SELECT COUNT(1)
4939: INTO l_count
4940: FROM pay_balance_dimensions
4941: WHERE legislation_code = 'JP'
4942: AND ASCII(SUBSTR(dimension_name,3,1)) > 127;
4943:
4944: IF (l_count > 0) THEN