APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_ALIAS_VALUES

Line 1724: from hxc_alias_values

1720: cursor csr_value_exists(p_ele_type_id number,
1721: p_an_id number) is
1722: -- p_effective_date date) is
1723: select 'Y'
1724: from hxc_alias_values
1725: where alias_definition_id = p_an_id
1726: and attribute1 = to_char(p_ele_type_id);
1727: -- and p_effective_date between date_from and date_to;
1728:

Line 1744: from hxc_alias_values

1740:
1741: cursor csr_chk_repname_exists(p_an_id number,
1742: p_ele_rep_name varchar2) is
1743: select count(*)
1744: from hxc_alias_values
1745: where alias_definition_id = p_an_id
1746: AND (alias_value_name like '% ~ '||p_ele_rep_name or alias_value_name = p_ele_rep_name);
1747:
1748:

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