APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_ALIAS_VALUES

Line 1497: from hxc_alias_values

1493: cursor csr_value_exists(p_ele_type_id number,
1494: p_an_id number) is
1495: -- p_effective_date date) is
1496: select 'Y'
1497: from hxc_alias_values
1498: where alias_definition_id = p_an_id
1499: and attribute1 = to_char(p_ele_type_id);
1500: -- and p_effective_date between date_from and date_to;
1501:

Line 1517: from hxc_alias_values

1513:
1514: cursor csr_chk_repname_exists(p_an_id number,
1515: p_ele_rep_name varchar2) is
1516: select count(*)
1517: from hxc_alias_values
1518: where alias_definition_id = p_an_id
1519: AND (alias_value_name like '% ~ '||p_ele_rep_name or alias_value_name = p_ele_rep_name);
1520:
1521: l_attr_prompt pay_input_values_f.name%TYPE;

Line 1794: hxc_alias_values_api.create_alias_value

1790: l_cnt_repname:=0;
1791: open csr_chk_repname_exists(l_an_en_id,nvl(ele_rec.reporting_name,ele_rec.element_name));
1792: fetch csr_chk_repname_exists into l_cnt_repname;
1793: IF l_cnt_repname=0 THEN
1794: hxc_alias_values_api.create_alias_value
1795: (p_alias_value_id => l_av_id
1796: ,p_alias_value_name => nvl(ele_rec.reporting_name,
1797: ele_rec.element_name)
1798: ,p_date_from => hr_general.start_of_time

Line 1808: hxc_alias_values_api.create_alias_value

1804: ,p_object_version_number => l_av_ovn);
1805: ELSE
1806: /*Bug fix 3353252 Modifying the alternate name to be unique by prefixing the number */
1807: l_new_en_repname:=l_cnt_repname ||' ~ ' || nvl(ele_rec.reporting_name,ele_rec.element_name);
1808: hxc_alias_values_api.create_alias_value
1809: (p_alias_value_id => l_av_id
1810: ,p_alias_value_name => l_new_en_repname
1811: ,p_date_from => hr_general.start_of_time
1812: ,p_date_to => NULL

Line 1835: hxc_alias_values_api.create_alias_value

1831: l_cnt_repname:=0;
1832: open csr_chk_repname_exists(l_an_dis_id,nvl(ele_rec.reporting_name,ele_rec.element_name));
1833: fetch csr_chk_repname_exists into l_cnt_repname;
1834: IF l_cnt_repname=0 THEN
1835: hxc_alias_values_api.create_alias_value
1836: (p_alias_value_id => l_av_id
1837: ,p_alias_value_name => nvl(ele_rec.reporting_name,
1838: ele_rec.element_name)
1839: ,p_date_from => hr_general.start_of_time

Line 1849: hxc_alias_values_api.create_alias_value

1845: ,p_object_version_number => l_av_ovn);
1846: ELSE
1847: /*Bug fix 3353252 Modifying the alternate name to be unique by prefixing the number */
1848: l_new_dis_repname:=l_cnt_repname ||' ~ ' || nvl(ele_rec.reporting_name,ele_rec.element_name);
1849: hxc_alias_values_api.create_alias_value
1850: (p_alias_value_id => l_av_id
1851: ,p_alias_value_name => l_new_dis_repname
1852: ,p_date_from => hr_general.start_of_time
1853: ,p_date_to => NULL