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_TYPES

Line 2485: type t_bal_names_tab is table of pay_balance_types.balance_name%TYPE index by binary_integer;

2481: procedure migrate_balance_types is
2482: --
2483: type t_jp_bal_names_tab is table of VARCHAR2(200) index by binary_integer;
2484:
2485: type t_bal_names_tab is table of pay_balance_types.balance_name%TYPE index by binary_integer;
2486:
2487: type t_bal_rep_tab is table of pay_balance_types.reporting_name%TYPE index by binary_integer;
2488:
2489: l_jp_bal_names_tab t_jp_bal_names_tab;

Line 2487: type t_bal_rep_tab is table of pay_balance_types.reporting_name%TYPE index by binary_integer;

2483: type t_jp_bal_names_tab is table of VARCHAR2(200) index by binary_integer;
2484:
2485: type t_bal_names_tab is table of pay_balance_types.balance_name%TYPE index by binary_integer;
2486:
2487: type t_bal_rep_tab is table of pay_balance_types.reporting_name%TYPE index by binary_integer;
2488:
2489: l_jp_bal_names_tab t_jp_bal_names_tab;
2490: l_bal_names_tab t_bal_names_tab;
2491: l_bal_rep_tab t_bal_rep_tab;

Line 3020: UPDATE pay_balance_types

3016: --
3017:
3018: FORALL l_tab_cnt IN 1..l_jp_bal_names_tab.COUNT
3019:
3020: UPDATE pay_balance_types
3021: SET balance_name = l_bal_names_tab(l_tab_cnt),
3022: reporting_name = l_bal_rep_tab(l_tab_cnt)
3023: WHERE balance_name LIKE hr_jp_standard_pkg.hextochar(l_jp_bal_names_tab(l_tab_cnt),'AL32UTF8')
3024: AND legislation_code = 'JP';

Line 3026: UPDATE pay_balance_types

3022: reporting_name = l_bal_rep_tab(l_tab_cnt)
3023: WHERE balance_name LIKE hr_jp_standard_pkg.hextochar(l_jp_bal_names_tab(l_tab_cnt),'AL32UTF8')
3024: AND legislation_code = 'JP';
3025:
3026: UPDATE pay_balance_types
3027: SET reporting_name = reporting_name || 'Obsoleted'
3028: WHERE ASCII(reporting_name) > 127
3029: AND legislation_code = 'JP';
3030:

Line 4927: FROM pay_balance_types

4923: hr_utility.set_location(l_proc, 40);
4924:
4925: SELECT COUNT(1)
4926: INTO l_count
4927: FROM pay_balance_types
4928: WHERE legislation_code = 'JP'
4929: AND ASCII(SUBSTR(balance_name,3,1)) > 127
4930: AND reporting_name NOT LIKE '%Obsoleted';
4931: