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.

[Home] [Help]

APPS.ETRM_PNAV dependencies on DBA_TYPES

Line 1165: summary="dba_types information">

1161: for t_rec in cur_mview(c_name=>c_name, c_owner =>c_owner) loop
1162: htp.p(
1163: '

M-View Details

1164: 1165: summary="dba_types information">
1166:
1168:

Line 1222: summary="dba_types information">

1218: for t_rec in cur_trigger(c_name=>c_name, c_owner =>c_owner) loop
1219: htp.p(
1220: '

Trigger Details

1221:

Container:	' 1167: \|\|t_rec.container_name\|\|'
Updatable:	' 1169: \|\|t_rec.updatable\|\|'

1222: summary="dba_types information">
1223:

Base Object:

');
1224: uiutil.a_href_gen(c_type => t_rec.base_object_type
1225: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name
1226: ||'&c_owner='|| t_rec.table_owner

Line 1254: summary="dba_types information">

1250: for t_rec in cur_index(c_name=>c_name, c_owner =>c_owner) loop
1251: htp.p(
1252: '

Index Details

1253: 1254: summary="dba_types information">
1255:

Base Object:

');
1256: uiutil.a_href_gen(c_type => t_rec.table_type
1257: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name
1258: ||'&c_owner='|| t_rec.table_owner

Line 1344: procedure ls_type(c_name in dba_types.type_name%type

1340: end loop;
1341: end ls_queue;
1342:
1343:
1344: procedure ls_type(c_name in dba_types.type_name%type
1345: , c_owner in dba_types.owner%type) is
1346:
1347: cursor cur_type(c_name in dba_types.type_name%type
1348: , c_owner in dba_types.owner%type) is

Line 1345: , c_owner in dba_types.owner%type) is

1341: end ls_queue;
1342:
1343:
1344: procedure ls_type(c_name in dba_types.type_name%type
1345: , c_owner in dba_types.owner%type) is
1346:
1347: cursor cur_type(c_name in dba_types.type_name%type
1348: , c_owner in dba_types.owner%type) is
1349: SELECT TYPECODE

Line 1347: cursor cur_type(c_name in dba_types.type_name%type

1343:
1344: procedure ls_type(c_name in dba_types.type_name%type
1345: , c_owner in dba_types.owner%type) is
1346:
1347: cursor cur_type(c_name in dba_types.type_name%type
1348: , c_owner in dba_types.owner%type) is
1349: SELECT TYPECODE
1350: , ATTRIBUTES
1351: , METHODS

Line 1348: , c_owner in dba_types.owner%type) is

1344: procedure ls_type(c_name in dba_types.type_name%type
1345: , c_owner in dba_types.owner%type) is
1346:
1347: cursor cur_type(c_name in dba_types.type_name%type
1348: , c_owner in dba_types.owner%type) is
1349: SELECT TYPECODE
1350: , ATTRIBUTES
1351: , METHODS
1352: , PREDEFINED

Line 1354: FROM SYS.DBA_TYPES

1350: , ATTRIBUTES
1351: , METHODS
1352: , PREDEFINED
1353: , INCOMPLETE
1354: FROM SYS.DBA_TYPES
1355: where owner = c_owner
1356: and type_name = c_name;
1357:
1358: cursor cur_collection(c_name in dba_types.type_name%type

Line 1358: cursor cur_collection(c_name in dba_types.type_name%type

1354: FROM SYS.DBA_TYPES
1355: where owner = c_owner
1356: and type_name = c_name;
1357:
1358: cursor cur_collection(c_name in dba_types.type_name%type
1359: , c_owner in dba_types.owner%type) is
1360: SELECT OWNER
1361: , TYPE_NAME
1362: , COLL_TYPE

Line 1359: , c_owner in dba_types.owner%type) is

1355: where owner = c_owner
1356: and type_name = c_name;
1357:
1358: cursor cur_collection(c_name in dba_types.type_name%type
1359: , c_owner in dba_types.owner%type) is
1360: SELECT OWNER
1361: , TYPE_NAME
1362: , COLL_TYPE
1363: , UPPER_BOUND

Line 1380: cursor cur_attribute(c_name in dba_types.type_name%type

1376:
1377:
1378:
1379:
1380: cursor cur_attribute(c_name in dba_types.type_name%type
1381: , c_owner in dba_types.owner%type) is
1382: SELECT OWNER
1383: , TYPE_NAME
1384: , ATTR_NAME

Line 1381: , c_owner in dba_types.owner%type) is

1377:
1378:
1379:
1380: cursor cur_attribute(c_name in dba_types.type_name%type
1381: , c_owner in dba_types.owner%type) is
1382: SELECT OWNER
1383: , TYPE_NAME
1384: , ATTR_NAME
1385: , ATTR_TYPE_MOD

Line 1398: cursor cur_method(c_name in dba_types.type_name%type

1394: where owner = c_owner
1395: and type_name = c_name
1396: order by attr_no;
1397:
1398: cursor cur_method(c_name in dba_types.type_name%type
1399: , c_owner in dba_types.owner%type) is
1400: SELECT OWNER
1401: , TYPE_NAME
1402: , METHOD_NAME

Line 1399: , c_owner in dba_types.owner%type) is

1395: and type_name = c_name
1396: order by attr_no;
1397:
1398: cursor cur_method(c_name in dba_types.type_name%type
1399: , c_owner in dba_types.owner%type) is
1400: SELECT OWNER
1401: , TYPE_NAME
1402: , METHOD_NAME
1403: , METHOD_NO

Line 1412: cursor cur_mparam(c_name in dba_types.type_name%type

1408: where owner = c_owner
1409: and type_name = c_name
1410: order by method_no;
1411:
1412: cursor cur_mparam(c_name in dba_types.type_name%type
1413: , c_owner in dba_types.owner%type
1414: , c_method in dba_method_params.method_name%type
1415: , n_methno in dba_method_params.method_no%type) is
1416:

Line 1413: , c_owner in dba_types.owner%type

1409: and type_name = c_name
1410: order by method_no;
1411:
1412: cursor cur_mparam(c_name in dba_types.type_name%type
1413: , c_owner in dba_types.owner%type
1414: , c_method in dba_method_params.method_name%type
1415: , n_methno in dba_method_params.method_no%type) is
1416:
1417: SELECT PARAM_NAME

Line 1427: cursor cur_mresult(c_name in dba_types.type_name%type

1423: and method_name = c_method
1424: and method_no = n_methno
1425: order by param_no;
1426:
1427: cursor cur_mresult(c_name in dba_types.type_name%type
1428: , c_owner in dba_types.owner%type
1429: , c_method in dba_method_params.method_name%type
1430: , n_methno in dba_method_params.method_no%type) is
1431:

Line 1428: , c_owner in dba_types.owner%type

1424: and method_no = n_methno
1425: order by param_no;
1426:
1427: cursor cur_mresult(c_name in dba_types.type_name%type
1428: , c_owner in dba_types.owner%type
1429: , c_method in dba_method_params.method_name%type
1430: , n_methno in dba_method_params.method_no%type) is
1431:
1432: SELECT RESULT_TYPE_NAME

Line 1448: summary="dba_types information">

1444: for t_rec in cur_type(c_name=>c_name, c_owner =>c_owner) loop
1445: htp.p(
1446: '

Type Details

1447: 1448: summary="dba_types information">
1449:
1451:

Type Code:	' 1450: \|\|t_rec.typecode\|\|'
Predefined:	' 1452: \|\|t_rec.predefined\|\|'