APPS.ETRM_PNAV dependencies on DBA_OBJECTS

Line 10: procedure ls_object(c_name in dba_objects.object_name%type := '%'

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

Line 11: , c_owner in dba_objects.owner%type := '%'

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

Line 12: , c_type in dba_objects.object_type%type := '%'

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);

Line 13: , c_status in dba_objects.status%type := '%');

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

Line 14: procedure show_object(c_name in dba_objects.object_name%type

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

Line 15: , c_owner in dba_objects.owner%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

Line 16: , c_type in dba_objects.object_type%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);

Line 17: procedure show_details(c_name in dba_objects.object_name%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:

Line 18: , c_owner in dba_objects.owner%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);

Line 19: , c_type in dba_objects.object_type%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

Line 22: procedure show_sql(n_object_id in dba_objects.object_id%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 := '%'

Line 23: procedure show_dependent_code(n_object_id in dba_objects.object_id%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 := '%'

Line 24: , c_name in dba_objects.object_name%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 := '%'

Line 26: procedure prn_object_type(c_name in dba_objects.object_name%type := '%'

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:

Line 27: , c_owner in dba_objects.owner%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

Line 28: , c_type in dba_objects.object_type%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')

Line 29: , c_status in dba_objects.status%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;

Line 31: FUNCTION get_object_name(n_object_id in dba_objects.object_id%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;