APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_DEBUG

Line 155: DELETE FROM hxc_debug_text

151: , p_type VARCHAR2)
152: IS
153: PRAGMA AUTONOMOUS_TRANSACTION;
154: BEGIN
155: DELETE FROM hxc_debug_text
156: WHERE process = 'RETRIEVAL' AND TYPE = p_type;
157:
158: INSERT INTO hxc_debug_text
159: (process, TYPE, text

Line 158: INSERT INTO hxc_debug_text

154: BEGIN
155: DELETE FROM hxc_debug_text
156: WHERE process = 'RETRIEVAL' AND TYPE = p_type;
157:
158: INSERT INTO hxc_debug_text
159: (process, TYPE, text
160: )
161: VALUES ('RETRIEVAL', p_type, p_query
162: );

Line 610: FROM hxc_debug_text

606:
607: CURSOR csr_get_range (p_range VARCHAR2)
608: IS
609: SELECT TYPE
610: FROM hxc_debug_text
611: WHERE process = p_range;
612:
613: -- Bug 8888911
614: -- Cursor to pick up all application sets for this process.

Line 6827: FROM hxc_debug

6823:
6824: CURSOR csr_debug
6825: IS
6826: SELECT 'Y'
6827: FROM hxc_debug
6828: WHERE process = 'RETRIEVAL' AND TRUNC (debug_date) =
6829: TRUNC (SYSDATE);
6830:
6831: l_sql VARCHAR2 (2000);