APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

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

2055: procedure migrate_element_class is
2056: --
2057: type t_jp_class_name is table of VARCHAR2(200) index by binary_integer;
2058:
2059: type t_class_names_tab is table of pay_element_classifications.classification_name%TYPE index by binary_integer;
2060:
2061: type t_class_desc_tab is table of pay_element_classifications.description%TYPE index by binary_integer;
2062:
2063: l_jp_class_name t_jp_class_name;

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

2057: type t_jp_class_name is table of VARCHAR2(200) index by binary_integer;
2058:
2059: type t_class_names_tab is table of pay_element_classifications.classification_name%TYPE index by binary_integer;
2060:
2061: type t_class_desc_tab is table of pay_element_classifications.description%TYPE index by binary_integer;
2062:
2063: l_jp_class_name t_jp_class_name;
2064: l_class_names_tab t_class_names_tab;
2065: l_class_desc_tab t_class_desc_tab;

Line 2454: UPDATE pay_element_classifications

2450: --
2451:
2452: FORALL l_tab_cnt IN 1..l_jp_class_name.COUNT
2453:
2454: UPDATE pay_element_classifications
2455: SET classification_name = l_class_names_tab(l_tab_cnt),
2456: description = l_class_desc_tab(l_tab_cnt)
2457: WHERE classification_name LIKE l_jp_class_name(l_tab_cnt)
2458: AND legislation_code = 'JP';

Line 4915: FROM pay_element_classifications

4911: hr_utility.set_location(l_proc, 30);
4912:
4913: SELECT COUNT(1)
4914: INTO l_count
4915: FROM pay_element_classifications
4916: WHERE legislation_code = 'JP'
4917: AND ASCII(SUBSTR(classification_name,8,1)) > 127;
4918:
4919: IF (l_count > 0) THEN