APPS.ETRM_PNAV dependencies on DBA_METHOD_PARAMS

Line 1414: , c_method in dba_method_params.method_name%type

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
1418: , PARAM_NO

Line 1415: , n_methno in dba_method_params.method_no%type) is

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
1418: , PARAM_NO
1419: , PARAM_TYPE_NAME

Line 1420: FROM SYS.DBA_METHOD_PARAMS

1416:
1417: SELECT PARAM_NAME
1418: , PARAM_NO
1419: , PARAM_TYPE_NAME
1420: FROM SYS.DBA_METHOD_PARAMS
1421: where owner = c_owner
1422: and type_name = c_name
1423: and method_name = c_method
1424: and method_no = n_methno

Line 1429: , c_method in dba_method_params.method_name%type

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
1433: FROM SYS.DBA_METHOD_RESULTS

Line 1430: , n_methno in dba_method_params.method_no%type) is

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
1433: FROM SYS.DBA_METHOD_RESULTS
1434: where owner = c_owner