APPS.XLA_CMP_CREATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

|     08-JUN-05 W.Chan          Updated dump_package to loop the package from|
|                               user_source only if the log level is stmt    |
|                                                                            |
+===========================================================================*/

--
--+==========================================================================+
--|                                                                          |
--| Private global constants                                                 |
--|                                                                          |
--+==========================================================================+
--
C_CREATED_ERROR      CONSTANT BOOLEAN := FALSE;

Line: 187

SELECT us.text
     , us.line
  FROM user_source us
 WHERE us.name = UPPER(p_package_name)
   AND us.type = UPPER(p_package_type)
 ORDER BY line
;

Line: 280

SELECT SUBSTR(ue.text,1,2000) error
     , ue.line
  FROM user_errors ue
 WHERE ue.name = UPPER(p_package_name)
   AND ue.type = UPPER(p_package_type)
 ORDER BY line
;

Line: 417

SELECT uo.status
  INTO l_status
  FROM user_objects uo
 WHERE uo.object_name = UPPER(p_package_name)
   AND uo.object_type = UPPER(p_package_type)
;