APPS.HXC_HTR_BUS dependencies on HXC_TIME_RECIPIENTS

Line 38: p_name in hxc_time_recipients.name%TYPE

34: -- {End Of Comments}
35: -- ----------------------------------------------------------------------------
36: Procedure chk_name
37: (
38: p_name in hxc_time_recipients.name%TYPE
39: ,p_time_recipient_id in hxc_time_recipients.time_recipient_id%TYPE
40: ) IS
41: --
42: l_proc varchar2(72);

Line 39: ,p_time_recipient_id in hxc_time_recipients.time_recipient_id%TYPE

35: -- ----------------------------------------------------------------------------
36: Procedure chk_name
37: (
38: p_name in hxc_time_recipients.name%TYPE
39: ,p_time_recipient_id in hxc_time_recipients.time_recipient_id%TYPE
40: ) IS
41: --
42: l_proc varchar2(72);
43: --

Line 51: FROM hxc_time_recipients tr

47: SELECT 'error'
48: FROM sys.dual
49: WHERE EXISTS (
50: SELECT 'x'
51: FROM hxc_time_recipients tr
52: WHERE tr.name = p_name
53: AND ( tr.time_recipient_id <> p_time_recipient_id
54: OR p_time_recipient_id IS NULL) );
55: --

Line 124: p_application_id in hxc_time_recipients.application_id%TYPE

120: -- {End Of Comments}
121: -- ----------------------------------------------------------------------------
122: Procedure chk_application_id
123: (
124: p_application_id in hxc_time_recipients.application_id%TYPE
125: ) IS
126:
127: l_invalid_id VARCHAR2(1) := 'Y';
128:

Line 172: p_time_recipient_id in hxc_time_recipients.time_recipient_id%TYPE

168: -- {End Of Comments}
169: -- ----------------------------------------------------------------------------
170: Procedure chk_delete
171: (
172: p_time_recipient_id in hxc_time_recipients.time_recipient_id%TYPE
173: ) IS
174:
175: l_used_elsewhere VARCHAR2(1) := 'N';
176: