DBA Data[Home] [Help]

APPS.HXC_MAP_UPLOAD_PKG dependencies on HXC_MAPPINGS

Line 9: l_mapping_id hxc_mappings.mapping_id%TYPE;

5: p_name IN VARCHAR2
6: , p_owner IN VARCHAR2
7: , p_custom_mode IN VARCHAR2 ) IS
8:
9: l_mapping_id hxc_mappings.mapping_id%TYPE;
10: l_ovn hxc_mappings.object_version_number%TYPE;
11: l_owner VARCHAR2(6);
12:
13: BEGIN

Line 10: l_ovn hxc_mappings.object_version_number%TYPE;

6: , p_owner IN VARCHAR2
7: , p_custom_mode IN VARCHAR2 ) IS
8:
9: l_mapping_id hxc_mappings.mapping_id%TYPE;
10: l_ovn hxc_mappings.object_version_number%TYPE;
11: l_owner VARCHAR2(6);
12:
13: BEGIN
14:

Line 21: FROM hxc_mappings

17: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
18: INTO l_mapping_id
19: , l_ovn
20: , l_owner
21: FROM hxc_mappings
22: WHERE name = P_NAME;
23:
24: -- NOTE - there is no update section since there is nothing to update
25: