DBA Data[Home] [Help]

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_ALIAS_VALUES_API

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