APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_SETS

Line 3207: type t_ele_set_names_tab is table of pay_element_sets.element_set_name%TYPE index by binary_integer;

3203: procedure migrate_element_sets is
3204: --
3205: type t_jp_ele_set_names_tab is table of VARCHAR2(50) index by binary_integer;
3206:
3207: type t_ele_set_names_tab is table of pay_element_sets.element_set_name%TYPE index by binary_integer;
3208:
3209: l_jp_ele_set_names_tab t_jp_ele_set_names_tab;
3210: l_ele_set_names_tab t_ele_set_names_tab;
3211:

Line 3241: UPDATE pay_element_sets

3237: --
3238:
3239: FORALL l_tab_cnt IN 1..l_jp_ele_set_names_tab.COUNT
3240:
3241: UPDATE pay_element_sets
3242: SET element_set_name = l_ele_set_names_tab(l_tab_cnt)
3243: WHERE element_set_name LIKE hr_jp_standard_pkg.hextochar(l_jp_ele_set_names_tab(l_tab_cnt),'AL32UTF8')
3244: AND legislation_code = 'JP';
3245:

Line 5225: from pay_element_sets pes

5221: --
5222: cursor csr_eset_cnt
5223: is
5224: select count(pes.element_set_id)
5225: from pay_element_sets pes
5226: where pes.legislation_code = 'JP'
5227: and ascii(pes.element_set_name) <= 127
5228: and exists(
5229: select null

Line 5230: from pay_element_sets pes2

5226: where pes.legislation_code = 'JP'
5227: and ascii(pes.element_set_name) <= 127
5228: and exists(
5229: select null
5230: from pay_element_sets pes2
5231: where pes2.legislation_code = 'JP'
5232: and ascii(pes2.element_set_name) > 127);
5233: --
5234: cursor csr_glb_cnt

Line 6072: -- from pay_element_sets pes

6068: -- l_dummy := null;
6069: -- --
6070: -- select pes.element_set_name
6071: -- into l_dummy
6072: -- from pay_element_sets pes
6073: -- where pes.element_set_name = l_eset_tbl(l_eset_ind)
6074: -- and pes.legislation_code = 'JP';
6075: -- --
6076: -- if (g_dbg) then

Line 6109: update pay_element_sets

6105: -- end if;
6106: --
6107: -- use bulk collect
6108: forall l_eset_ind in 1..l_eset_tbl.count
6109: update pay_element_sets
6110: set element_set_name = substrb(element_set_name,1,80-4)||'_OBS'
6111: where element_set_name = l_eset_tbl(l_eset_ind)
6112: and legislation_code = 'JP';
6113: --

Line 6941: FROM pay_element_sets

6937: hr_utility.set_location(l_proc, 60);
6938:
6939: SELECT COUNT(1)
6940: INTO l_count
6941: FROM pay_element_sets
6942: WHERE legislation_code = 'JP'
6943: AND ASCII(element_set_name) > 127;
6944:
6945: IF (l_count > 0) THEN