APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_ALIAS_VALUES_API

Line 2282: hxc_alias_values_api.create_alias_value

2278: l_cnt_repname:=0;
2279: open csr_chk_repname_exists(l_an_en_id,nvl(ele_rec.reporting_name,ele_rec.element_name));
2280: fetch csr_chk_repname_exists into l_cnt_repname;
2281: IF l_cnt_repname=0 THEN
2282: hxc_alias_values_api.create_alias_value
2283: (p_alias_value_id => l_av_id
2284: ,p_alias_value_name => nvl(ele_rec.reporting_name,
2285: ele_rec.element_name)
2286: ,p_date_from => hr_general.start_of_time

Line 2296: hxc_alias_values_api.create_alias_value

2292: ,p_object_version_number => l_av_ovn);
2293: ELSE
2294: /*Bug fix 3353252 Modifying the alternate name to be unique by prefixing the number */
2295: l_new_en_repname:=l_cnt_repname ||' ~ ' || nvl(ele_rec.reporting_name,ele_rec.element_name);
2296: hxc_alias_values_api.create_alias_value
2297: (p_alias_value_id => l_av_id
2298: ,p_alias_value_name => l_new_en_repname
2299: ,p_date_from => hr_general.start_of_time
2300: ,p_date_to => NULL

Line 2324: hxc_alias_values_api.create_alias_value

2320: open csr_chk_repname_exists(l_an_dis_id,nvl(ele_rec.reporting_name,ele_rec.element_name));
2321: fetch csr_chk_repname_exists into l_cnt_repname;
2322:
2323: IF l_cnt_repname=0 THEN
2324: hxc_alias_values_api.create_alias_value
2325: (p_alias_value_id => l_av_id
2326: ,p_alias_value_name => nvl(ele_rec.reporting_name,
2327: ele_rec.element_name)
2328: ,p_date_from => hr_general.start_of_time

Line 2338: hxc_alias_values_api.create_alias_value

2334: ,p_object_version_number => l_av_ovn);
2335: ELSE
2336: /*Bug fix 3353252 Modifying the alternate name to be unique by prefixing the number */
2337: l_new_dis_repname:=l_cnt_repname ||' ~ ' || nvl(ele_rec.reporting_name,ele_rec.element_name);
2338: hxc_alias_values_api.create_alias_value
2339: (p_alias_value_id => l_av_id
2340: ,p_alias_value_name => l_new_dis_repname
2341: ,p_date_from => hr_general.start_of_time
2342: ,p_date_to => NULL