APPS.XLA_TB_DEFN_JE_SOURCES_PVT SQL Statements

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

Line: 35

PROCEDURE Insert_Row
        (p_rowid                     IN OUT NOCOPY VARCHAR2
        ,p_definition_code           IN VARCHAR2
        ,p_object_version_number     IN NUMBER
        ,p_je_source_name            IN VARCHAR2
        ,p_creation_date             IN DATE
        ,p_created_by                IN NUMBER
        ,p_last_update_date          IN DATE
        ,p_last_updated_by           IN NUMBER
        ,p_last_update_login         IN NUMBER) IS

BEGIN

   IF p_definition_code IS NULL THEN
      RAISE no_data_found;

Line: 53

   INSERT INTO xla_tb_defn_je_sources
         (
          definition_code
         ,object_version_number
         ,je_source_name
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
         )
   VALUES
         (
          p_definition_code
         ,1                                 -- Ignore p_object_version_number
         ,p_je_source_name
         ,p_created_by
         ,p_creation_date
         ,p_last_updated_by
         ,p_last_update_date
         ,p_last_update_login
         )
  RETURNING rowid INTO p_rowid;

Line: 84

     ,'LOCATION'    ,  C_PACKAGE_NAME || '.' || 'insert_row'
     ,'ERROR'       ,  sqlerrm);

Line: 86

END Insert_Row;

Line: 112

PROCEDURE Delete_Row
        (p_definition_code           IN VARCHAR2
        ,p_je_source_name            IN VARCHAR2) IS
BEGIN

   DELETE FROM xla_tb_defn_je_sources
    WHERE definition_code     = p_definition_code
      AND je_source_name      = p_je_source_name;

Line: 125

END Delete_Row;