DBA Data[Home] [Help]

APPS.HXC_HTS_BUS dependencies on HXC_TIME_SOURCES

Line 101: p_name in hxc_time_sources.name%TYPE

97: -- {End Of Comments}
98: -- ----------------------------------------------------------------------------
99: Procedure chk_name
100: (
101: p_name in hxc_time_sources.name%TYPE
102: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
103: ) IS
104: --
105: l_proc varchar2(72);

Line 102: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE

98: -- ----------------------------------------------------------------------------
99: Procedure chk_name
100: (
101: p_name in hxc_time_sources.name%TYPE
102: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
103: ) IS
104: --
105: l_proc varchar2(72);
106: --

Line 114: FROM hxc_time_sources tr

110: SELECT 'error'
111: FROM sys.dual
112: WHERE EXISTS (
113: SELECT 'x'
114: FROM hxc_time_sources tr
115: WHERE tr.name = p_name
116: AND ( tr.time_source_id <> p_time_source_id
117: OR p_time_source_id IS NULL) );
118: --

Line 186: p_time_source_id in hxc_time_sources.time_source_id%TYPE

182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure chk_delete
185: (
186: p_time_source_id in hxc_time_sources.time_source_id%TYPE
187: ) IS
188:
189: l_used_elsewhere VARCHAR2(1) := 'N';
190: