SELECT OBJECT_NAME AS OBJECT_NAMES, OBJECT_ID AS OBJ_ID, OBJECT_TYPE FROM USER_PROCEDURES

• OBJECT_NAME .
• PROCEDURE_NAME
• AGGREGATE
• PIPELINED :
  • Pipelined functions are useful in streaming data from an external source to store to  a table using a PL/SQL statement. Please refer this  outstanding document http://www.oracle-developer.net/display.php?id=429
• IMPLTYPEOWNER
  IMPLTYPENAME
  PARALLEL
  INTERFACE
  DETERMINISTIC
  AUTHID