APPS.XLA_TB_DEFN_DETAIL_PVT SQL Statements

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

Line: 41

        ,p_last_update_date          IN VARCHAR2
        ,p_owner                     IN VARCHAR2
        ,p_custom_mode               IN VARCHAR2) IS

   CURSOR c_def IS
      SELECT definition_code
            ,object_version_number
            ,defined_by_code
            ,last_updated_by
            ,last_update_date
        FROM xla_tb_definitions_b
       WHERE definition_code = p_definition_code;

Line: 55

      SELECT 'Y'
        FROM xla_tb_defn_details
       WHERE definition_code     = p_definition_code
         AND code_combination_id = p_code_combination_id;

Line: 61

      SELECT 'Y'
        FROM xla_tb_defn_details
       WHERE definition_code     = p_definition_code
         AND code_combination_id = p_segment_value_to;

Line: 69

   l_last_updated_by                 NUMBER;  -- owner in file

Line: 70

   l_last_update_date                DATE;    -- last update date in file

Line: 72

   l_db_last_updated_by              NUMBER;  -- owner in db

Line: 73

   l_db_last_update_date             DATE;    -- last update date in db

Line: 79

   l_last_updated_by   := fnd_load_util.owner_id(p_owner);

Line: 80

   l_last_update_date  := NVL(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), SYSDATE);

Line: 87

          ,l_db_last_updated_by
          ,l_db_last_update_date;

Line: 98

         Insert_Row (
            p_rowid                  => l_rowid
           ,p_definition_code        => p_definition_code
           ,p_object_version_number  => l_db_object_version_number
           ,p_code_combination_id    => p_code_combination_id
           ,p_flexfield_segment_code => p_flexfield_segment_code
           ,p_segment_value_from     => p_segment_value_from
           ,p_segment_value_to       => p_segment_value_to
           ,p_creation_Date          => l_last_update_date
           ,p_Created_By             => l_last_updated_by
           ,p_Last_Update_Date       => l_last_update_date
           ,p_Last_Updated_By        => l_last_updated_by
           ,p_Last_Update_Login      =>  0);

Line: 125

         Insert_Row (
            p_rowid                  => l_rowid
           ,p_definition_code        => p_definition_code
           ,p_object_version_number  => l_db_object_version_number
           ,p_code_combination_id    => p_code_combination_id
           ,p_flexfield_segment_code => p_flexfield_segment_code
           ,p_segment_value_from     => p_segment_value_from
           ,p_segment_value_to       => p_segment_value_to
           ,p_creation_Date          => l_last_update_date
           ,p_Created_By             => l_last_updated_by
           ,p_Last_Update_Date       => l_last_update_date
           ,p_Last_Updated_By        => l_last_updated_by
           ,p_Last_Update_Login      =>  0);

Line: 145

                p_file_id     => l_last_updated_by
               ,p_file_lud    => l_last_update_date
               ,p_db_id       => l_db_last_updated_by
               ,p_db_lud      => l_db_last_update_date
               ,p_custom_mode => p_custom_mode))
         THEN

            BEGIN

               Delete_Row
                 (p_definition_code         => p_definition_code
                 ,p_flexfield_segment_code  => p_flexfield_segment_code
                 ,p_segment_value_from      => p_segment_value_from);

Line: 164

               Insert_Row (
                  p_rowid                  => l_rowid
                 ,p_definition_code        => p_definition_code
                 ,p_object_version_number  => l_db_object_version_number
                 ,p_code_combination_id    => p_code_combination_id
                 ,p_flexfield_segment_code => p_flexfield_segment_code
                 ,p_segment_value_from     => p_segment_value_from
                 ,p_segment_value_to       => p_segment_value_to
                 ,p_creation_Date          => l_last_update_date
                 ,p_Created_By             => l_last_updated_by
                 ,p_last_update_date       => l_last_update_date
                 ,p_last_updated_by        => l_last_updated_by
                 ,p_last_update_login      =>  0);

Line: 210

PROCEDURE Insert_Row
        (p_rowid                     IN OUT NOCOPY VARCHAR2
        ,p_definition_code           IN VARCHAR2
        ,p_object_version_number     IN NUMBER
        ,p_code_combination_id       IN NUMBER
        ,p_flexfield_segment_code    IN VARCHAR2
        ,p_segment_value_from        IN VARCHAR2
        ,p_segment_value_to          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

   CURSOR c_def IS
      SELECT defined_by_code
        FROM xla_tb_definitions_b
       WHERE definition_code = p_definition_code;

Line: 263

   INSERT INTO xla_tb_defn_details
         (
          definition_detail_id
         ,object_version_number
         ,definition_code
         ,flexfield_segment_code
         ,segment_value_from
         ,segment_value_to
         ,code_combination_id
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
         )
   VALUES
         (
          xla_tb_defn_details_s.nextval
         ,1                                 -- Ignore p_object_version_number
         ,p_definition_code
         ,l_flexfield_segment_code
         ,l_segment_value_from
         ,l_segment_value_to
         ,l_code_combination_id
         ,p_created_by
         ,p_creation_date
         ,p_last_updated_by
         ,p_last_update_date
         ,p_last_update_login
         )
  RETURNING rowid INTO p_rowid;

Line: 303

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

Line: 305

END Insert_Row;

Line: 332

PROCEDURE Delete_Row
        (p_definition_code           IN VARCHAR2
        ,p_code_combination_id       IN NUMBER) IS
BEGIN

   DELETE FROM xla_tb_defn_details
    WHERE definition_code     = p_definition_code
      AND code_combination_id = p_code_combination_id;

Line: 345

END Delete_Row;

Line: 359

PROCEDURE Delete_Row
         (p_definition_code           IN VARCHAR2
         ,p_flexfield_segment_code    IN VARCHAR2
         ,p_segment_value_from        IN VARCHAR2) IS
BEGIN

   DELETE FROM xla_tb_defn_details
    WHERE definition_code        = p_definition_code
      AND flexfield_segment_code = p_flexfield_segment_code
      AND segment_value_from     = p_segment_value_from;

Line: 374

END Delete_Row;