APPS.HXC_HTS_UPLOAD_PKG dependencies on HXC_TIME_SOURCES

Line 9: l_time_source_id hxc_time_sources.time_source_id%TYPE;

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

Line 10: l_ovn hxc_time_sources.object_version_number%TYPE;

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

Line 21: FROM hxc_time_sources

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

Line 41: l_time_source_id hxc_time_sources.time_source_id%TYPE;

37: , p_owner IN VARCHAR2
38: , p_custom_mode IN VARCHAR2
39: ,p_last_update_date IN VARCHAR2) IS
40:
41: l_time_source_id hxc_time_sources.time_source_id%TYPE;
42: l_ovn hxc_time_sources.object_version_number%TYPE;
43: l_owner VARCHAR2(6);
44:
45: BEGIN

Line 42: l_ovn hxc_time_sources.object_version_number%TYPE;

38: , p_custom_mode IN VARCHAR2
39: ,p_last_update_date IN VARCHAR2) IS
40:
41: l_time_source_id hxc_time_sources.time_source_id%TYPE;
42: l_ovn hxc_time_sources.object_version_number%TYPE;
43: l_owner VARCHAR2(6);
44:
45: BEGIN
46:

Line 53: FROM hxc_time_sources

49:
50: INTO l_time_source_id
51: , l_ovn
52:
53: FROM hxc_time_sources
54: WHERE name = P_NAME;
55:
56: -- NOTE - there is no update section since there is nothing to update
57: