APPS.HRDU_DO_API_TRANSLATE SQL Statements

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

Line: 25

  PROCEDURE hrdu_insert_mapping( p_api_module           IN VarChar2,
                                 p_column_name          IN VarChar2,
                                 p_mapped_to_name       IN VarChar2,
                                 p_mapping_type         IN VarChar2   DEFAULT 'D',
                                 p_parent_api_module    IN VarChar2   DEFAULT NULL,
                                 p_parent_table         IN VarChar2   DEFAULT NULL,
                                 p_last_update_date     IN Date       DEFAULT SYSDATE,
                                 p_last_updated_by      IN Number     DEFAULT 1,
                                 p_last_update_login    IN Number     DEFAULT 1,
                                 p_created_by           IN Number     DEFAULT 1,
                                 p_creation_date        IN Date       DEFAULT SYSDATE)
  IS
    cursor api_id_csr is
      select api_module_id
      from   hr_api_modules
      where  module_name = upper(p_api_module);

Line: 43

      select api_module_id
      from   hr_api_modules
      where  module_name = upper(p_parent_api_module);

Line: 63

    INSERT INTO hr_du_column_mappings( column_mapping_id, api_module_id,    column_name,
                                       mapped_to_name,    mapping_type,     parent_api_module_id,
                                       parent_table,      last_update_date, last_updated_by,
                                       last_update_login, created_by,       creation_date )
    SELECT hr_du_column_mappings_s.NEXTVAL,
             l_api_id,
             p_column_name,
             p_mapped_to_name,
             p_mapping_type,
             l_parent_api_id,
             p_parent_table,
             p_last_update_date,
             p_last_updated_by,
             p_last_update_login,
             p_created_by,
             p_creation_date
    FROM dual
    WHERE NOT EXISTS
      (SELECT NULL FROM hr_du_column_mappings
         WHERE api_module_id = l_api_id
           AND column_name = p_column_name
           AND NVL(mapped_to_name,'') = NVL(p_mapped_to_name,'')
           AND mapping_type = p_mapping_type
           AND NVL(parent_api_module_id,-24926578) = NVL(l_parent_api_id,-24926578)
           AND NVL(parent_table,'') = NVL(p_parent_table,''));

Line: 92

      raise_application_error( -20000, 'Failed to insert item - ' || p_column_name ||
                              ' : ' || sqlerrm(sqlcode));

Line: 114

      select distinct column_id, lower( substr(column_name, 3, length(column_name) - 2) ) column_headings
      from   user_tab_columns
      where  table_name = substr( upper( 'HRDPV_' || p_api_name ), 1, 30 )
      and    column_name like 'P_%'
      order by column_headings;

Line: 173

      utl_file.put_line(l_scripthandle, 'REM  HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );

Line: 199

        utl_file.put_line(l_scripthandle, '  HRDU_DO_API_TRANSLATE.hrdu_insert_mapping(' );

Line: 248

      select api_module_id
      from   hr_api_modules
      where  module_name = upper(p_api_name);