APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_BALANCE_TYPES

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

2503: procedure migrate_balance_types is
2504: --
2505: type t_jp_bal_names_tab is table of VARCHAR2(200) index by binary_integer;
2506:
2507: type t_bal_names_tab is table of pay_balance_types.balance_name%TYPE index by binary_integer;
2508:
2509: type t_bal_rep_tab is table of pay_balance_types.reporting_name%TYPE index by binary_integer;
2510:
2511: l_jp_bal_names_tab t_jp_bal_names_tab;

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

2505: type t_jp_bal_names_tab is table of VARCHAR2(200) index by binary_integer;
2506:
2507: type t_bal_names_tab is table of pay_balance_types.balance_name%TYPE index by binary_integer;
2508:
2509: type t_bal_rep_tab is table of pay_balance_types.reporting_name%TYPE index by binary_integer;
2510:
2511: l_jp_bal_names_tab t_jp_bal_names_tab;
2512: l_bal_names_tab t_bal_names_tab;
2513: l_bal_rep_tab t_bal_rep_tab;

Line 3042: UPDATE pay_balance_types

3038: --
3039:
3040: FORALL l_tab_cnt IN 1..l_jp_bal_names_tab.COUNT
3041:
3042: UPDATE pay_balance_types
3043: SET balance_name = l_bal_names_tab(l_tab_cnt),
3044: reporting_name = l_bal_rep_tab(l_tab_cnt)
3045: WHERE balance_name LIKE hr_jp_standard_pkg.hextochar(l_jp_bal_names_tab(l_tab_cnt),'AL32UTF8')
3046: AND legislation_code = 'JP';

Line 3048: UPDATE pay_balance_types

3044: reporting_name = l_bal_rep_tab(l_tab_cnt)
3045: WHERE balance_name LIKE hr_jp_standard_pkg.hextochar(l_jp_bal_names_tab(l_tab_cnt),'AL32UTF8')
3046: AND legislation_code = 'JP';
3047:
3048: UPDATE pay_balance_types
3049: SET reporting_name = reporting_name || 'Obsoleted'
3050: WHERE ASCII(reporting_name) > 127
3051: AND legislation_code = 'JP';
3052:

Line 5188: from pay_balance_types pbt

5184: --
5185: cursor csr_bal_cnt
5186: is
5187: select count(pbt.balance_type_id)
5188: from pay_balance_types pbt
5189: where pbt.legislation_code = 'JP'
5190: and ascii(substr(pbt.balance_name,3,1)) <= 127
5191: and pbt.balance_name not in (
5192: 'B_BON_HI_STD_BON',

Line 5202: from pay_balance_types pbt2

5198: 'B_PAYSLIP_NET_PAY',
5199: 'B_YEA_SAL_DCT_EARTHQUAKE_INS_PREM')
5200: and exists(
5201: select null
5202: from pay_balance_types pbt2
5203: where pbt2.legislation_code = 'JP'
5204: and ascii(substr(pbt2.balance_name,3,1)) > 127
5205: and pbt2.reporting_name not like '%Obsoleted');
5206: --

Line 5893: -- from pay_balance_types pbt

5889: -- l_dummy := null;
5890: -- --
5891: -- select pbt.balance_name
5892: -- into l_dummy
5893: -- from pay_balance_types pbt
5894: -- where pbt.balance_name = l_bal_tbl(l_bal_ind)
5895: -- and pbt.legislation_code = 'JP';
5896: -- --
5897: -- if (g_dbg) then

Line 5930: update pay_balance_types

5926: -- end if;
5927: --
5928: -- use bulk collect
5929: forall l_bal_ind in 1..l_bal_tbl.count
5930: update pay_balance_types
5931: set balance_name = substrb(balance_name,1,80-4)||'_OBS',
5932: reporting_name = substrb(reporting_name,1,80-11)||' (Obsolete)'
5933: where balance_name = l_bal_tbl(l_bal_ind)
5934: and legislation_code = 'JP';

Line 6916: FROM pay_balance_types

6912: hr_utility.set_location(l_proc, 40);
6913:
6914: SELECT COUNT(1)
6915: INTO l_count
6916: FROM pay_balance_types
6917: WHERE legislation_code = 'JP'
6918: AND ASCII(SUBSTR(balance_name,3,1)) > 127
6919: AND reporting_name NOT LIKE '%Obsoleted';
6920: