eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.SQLJUTL dependencies on ALL_ARGUMENTS

Line 15: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS

11: if pkg_nm IS NULL
12: then
13: if ovr is NULL
14: then
15: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
16: WHERE OBJECT_NAME = proc AND OWNER = l_owner
17: AND SEQUENCE = seq and OVERLOAD is NULL and PACKAGE_NAME is NULL;
18: else
19: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS

Line 19: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS

15: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
16: WHERE OBJECT_NAME = proc AND OWNER = l_owner
17: AND SEQUENCE = seq and OVERLOAD is NULL and PACKAGE_NAME is NULL;
18: else
19: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
20: WHERE OBJECT_NAME = proc AND OWNER = l_owner
21: AND SEQUENCE = seq and OVERLOAD = ovr and PACKAGE_NAME IS NULL;
22: end if;
23: else

Line 26: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS

22: end if;
23: else
24: if ovr is NULL
25: then
26: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
27: WHERE OBJECT_NAME = proc AND OWNER = l_owner
28: AND SEQUENCE = seq and OVERLOAD is NULL and PACKAGE_NAME = pkg_nm;
29: else
30: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS

Line 30: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS

26: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
27: WHERE OBJECT_NAME = proc AND OWNER = l_owner
28: AND SEQUENCE = seq and OVERLOAD is NULL and PACKAGE_NAME = pkg_nm;
29: else
30: select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
31: WHERE OBJECT_NAME = proc AND OWNER = l_owner
32: AND SEQUENCE = seq and OVERLOAD = ovr and PACKAGE_NAME = pkg_nm;
33: end if;
34: