[Home] [Help]
PACKAGE: APPS.ETRM_PNAV
Source
1 package etrm_pnav as
2 ----------------------------------------------------------------------------
3 -- Copyright © 2001, 2014, Oracle and/or its affiliates. All rights reserved.
4 -- eTRM: Oracle Applications repository browser and dependency report
5 -- Author: Peter Goldthorp 9 October 2001
6 -----------------------------------------------------------------------------
7
8 procedure ls_apps;
9 procedure ls_apps(c_mode in varchar2);
10 procedure ls_object(c_name in dba_objects.object_name%type := '%'
11 , c_owner in dba_objects.owner%type := '%'
12 , c_type in dba_objects.object_type%type := '%'
13 , c_status in dba_objects.status%type := '%');
14 procedure show_object(c_name in dba_objects.object_name%type
15 , c_owner in dba_objects.owner%type
16 , c_type in dba_objects.object_type%type);
17 procedure show_details(c_name in dba_objects.object_name%type
18 , c_owner in dba_objects.owner%type
19 , c_type in dba_objects.object_type%type
20 , c_detail_type in varchar2);
21
22 procedure show_sql(n_object_id in dba_objects.object_id%type);
23 procedure show_dependent_code(n_object_id in dba_objects.object_id%type
24 , c_name in dba_objects.object_name%type);
25
26 procedure prn_object_type(c_name in dba_objects.object_name%type := '%'
27 , c_owner in dba_objects.owner%type := '%'
28 , c_type in dba_objects.object_type%type := '%'
29 , c_status in dba_objects.status%type := '%');
30
31 FUNCTION get_object_name(n_object_id in dba_objects.object_id%type
32 , c_mode in varchar2 := 'BOTH')
33 return varchar2;
34
35 end etrm_pnav;