DBA Data[Home] [Help]

APPS.HR_API_USER_HOOKS dependencies on USER_SOURCE

Line 3056: from user_source

3052: -- Cursor to obtain the arcs header line from the hook package header
3053: --
3054: cursor csr_second_line (p_pkg_name VARCHAR2, p_pkg_type VARCHAR2) is
3055: select text
3056: from user_source
3057: where name = p_pkg_name
3058: and type = p_pkg_type
3059: and line = 2;
3060: --

Line 3062: -- derived from the user_source.

3058: and type = p_pkg_type
3059: and line = 2;
3060: --
3061: l_source_line varchar2(2000); -- Source header line which was
3062: -- derived from the user_source.
3063: l_header_line varchar2(2000); -- Header line string which is being
3064: -- built for inclusion into the
3065: -- user hook package body code.
3066: l_hook_pkg_type varchar2(30); -- The third and second last letters