APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 2081: type t_class_names_tab is table of pay_element_classifications.classification_name%TYPE index by binary_integer;

2077: procedure migrate_element_class is
2078: --
2079: type t_jp_class_name is table of VARCHAR2(200) index by binary_integer;
2080:
2081: type t_class_names_tab is table of pay_element_classifications.classification_name%TYPE index by binary_integer;
2082:
2083: type t_class_desc_tab is table of pay_element_classifications.description%TYPE index by binary_integer;
2084:
2085: l_jp_class_name t_jp_class_name;

Line 2083: type t_class_desc_tab is table of pay_element_classifications.description%TYPE index by binary_integer;

2079: type t_jp_class_name is table of VARCHAR2(200) index by binary_integer;
2080:
2081: type t_class_names_tab is table of pay_element_classifications.classification_name%TYPE index by binary_integer;
2082:
2083: type t_class_desc_tab is table of pay_element_classifications.description%TYPE index by binary_integer;
2084:
2085: l_jp_class_name t_jp_class_name;
2086: l_class_names_tab t_class_names_tab;
2087: l_class_desc_tab t_class_desc_tab;

Line 2476: UPDATE pay_element_classifications

2472: --
2473:
2474: FORALL l_tab_cnt IN 1..l_jp_class_name.COUNT
2475:
2476: UPDATE pay_element_classifications
2477: SET classification_name = l_class_names_tab(l_tab_cnt),
2478: description = l_class_desc_tab(l_tab_cnt)
2479: WHERE classification_name LIKE l_jp_class_name(l_tab_cnt)
2480: AND legislation_code = 'JP';

Line 5176: from pay_element_classifications pec

5172: --
5173: cursor csr_class_cnt
5174: is
5175: select count(pec.classification_id)
5176: from pay_element_classifications pec
5177: where pec.legislation_code = 'JP'
5178: and ascii(substr(pec.classification_name,8,1)) <= 127
5179: and exists(
5180: select null

Line 5181: from pay_element_classifications pec2

5177: where pec.legislation_code = 'JP'
5178: and ascii(substr(pec.classification_name,8,1)) <= 127
5179: and exists(
5180: select null
5181: from pay_element_classifications pec2
5182: where pec2.legislation_code = 'JP'
5183: and ascii(substr(pec2.classification_name,8,1)) > 127);
5184: --
5185: cursor csr_bal_cnt

Line 5689: -- from pay_element_classifications pec

5685: -- l_dummy := null;
5686: -- --
5687: -- select pec.classification_name
5688: -- into l_dummy
5689: -- from pay_element_classifications pec
5690: -- where pec.classification_name = l_class_tbl(l_class_ind)
5691: -- and pec.legislation_code = 'JP';
5692: -- --
5693: -- if (g_dbg) then

Line 5726: update pay_element_classifications

5722: -- end if;
5723: --
5724: -- use bulk collect
5725: forall l_class_ind in 1..l_class_tbl.count
5726: update pay_element_classifications
5727: set classification_name = substrb(classification_name,1,80-4)||'_OBS',
5728: description = substrb(description,1,80-11)||' (Obsolete)'
5729: where classification_name = l_class_tbl(l_class_ind)
5730: and legislation_code = 'JP';

Line 6904: FROM pay_element_classifications

6900: hr_utility.set_location(l_proc, 30);
6901:
6902: SELECT COUNT(1)
6903: INTO l_count
6904: FROM pay_element_classifications
6905: WHERE legislation_code = 'JP'
6906: AND ASCII(SUBSTR(classification_name,8,1)) > 127;
6907:
6908: IF (l_count > 0) THEN