DBA Data[Home] [Help]

APPS.HR_ADE_ADI_DATA_SETUP SQL Statements

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

Line: 27

    SELECT 'Y'
    FROM   all_tab_columns tc
    WHERE  tc.table_name = 'BNE_INTEGRATORS_B'
    AND    tc.column_name = 'NEW_SESSION_FLAG'
    AND    tc.owner = l_oracle_schema;
Line: 54

     ' UPDATE bne_integrators_b ' ||
     ' SET    new_session_flag = ''Y'' ' ||
     ' WHERE  application_id = :1 ' ||
     ' AND    integrator_code = :2; ' ||
Line: 116

       ' select FORM_NAME' ||
       ' from '||l_bne_value ||
       ' where FORM_NAME = '''||
        p_form_name || '''';
Line: 131

      ' select APPLICATION_SHORT_NAME' ||
      ' from '||l_bne_value ||
      ' where APPLICATION_ID ='||
       p_application_id;
Line: 145

      ' select USER_NAME' ||
      ' from '||l_bne_value ||
      ' where USER_NAME ='''||
       p_integrator_user_name ||'''';
Line: 159

   SELECT hr_adi_object_code_s.NEXTVAL
   INTO l_object_num
   FROM dual;
Line: 175

          'SELECT integrator_code' ||
          '   FROM ' || l_bne_value ||
          '   WHERE integrator_code =  ''' ||
                    l_object_code ||'_INTG'||
          ''' AND application_id = '
                    || p_application_id;
Line: 208

      'SELECT integrator_code' ||
      '   FROM ' || l_bne_value ||
      '   WHERE integrator_code =  ''' ||
                l_integrator_code ||
      ''' AND application_id = '
                || p_application_id;
Line: 249

      'SELECT content_code ' ||
      ' FROM ' || l_bne_value ||
      ' WHERE integrator_code =''' ||
         l_integrator_code ||
      ''' AND application_id = '|| p_application_id;
Line: 281

      'SELECT count(*) ' ||
      ' FROM '|| l_bne_value ||
      ' WHERE content_code =''' ||
      l_content_code ||''' AND ' ||
      '          application_id = '|| p_application_id;
Line: 316

      'SELECT count(*) ' ||
      ' FROM ' || l_bne_value ||
      ' WHERE interface_code = ' ||
      '  (SELECT interface_code' ||
      '   FROM bne_interfaces_b' ||
      '   WHERE integrator_code = ''' ||
           l_integrator_code ||
      ''' AND application_id = '||
           p_application_id || ')';
Line: 335

      '   SELECT mapping_code'||
      '   FROM ' || l_bne_value ||
      '   WHERE mapping_code = ''' ||
          l_mapping_code ||
      ''' AND application_id ='||
          p_application_id;
Line: 364

      'SELECT param_list_code ' ||
      ' FROM ' || l_bne_value ||
      ' WHERE content_code = ''' ||
          l_content_code ||
      ''' AND  application_id = '||
      p_application_id;
Line: 457

      ' select APPLICATION_SHORT_NAME' ||
      ' from '||l_bne_value ||
      ' where APPLICATION_ID ='||
       p_application_id;
Line: 470

      ' select USER_NAME' ||
      ' from '||l_bne_value ||
      ' where USER_NAME ='''||
       p_integrator_user_name ||'''';
Line: 484

         ' select 1' ||
         ' from '||l_bne_value ||
         ' where A.OBJ# = B.OBJECT_ID' ||
         ' AND   B.OBJECT_NAME = '''||P_API_PACKAGE_NAME ||
         ''' AND   A.PROCEDURE$ = ''' ||P_API_PROCEDURE_NAME || '''';
Line: 499

   SELECT hr_adi_object_code_s.NEXTVAL
   INTO l_object_num
   FROM dual;
Line: 509

     'SELECT integrator_code' ||
     '   FROM ' || l_bne_value ||
     '   WHERE integrator_code =  ''' ||
               l_object_code ||'_INTG'||
     ''' AND application_id = '
               || p_application_id;
Line: 543

     'SELECT integrator_code' ||
     '   FROM ' || l_bne_value ||
     '   WHERE integrator_code = '||
          '(SELECT integrator_code '||
             'FROM bne_integrators_b '||
             'WHERE integrator_code =''' ||
               l_integrator_code ||
             ''' AND application_id = ' ||
                  p_application_id||
     ')  AND application_id ='||
           p_application_id;
Line: 596

   ' SELECT interface_code '||
   ' FROM '|| l_bne_value ||
   ' WHERE interface_code = (' ||
        ' SELECT interface_code'||
        ' FROM bne_interfaces_b' ||
        ' WHERE interface_code = ''' ||
           l_interface_code ||
        ''' AND application_id ='||
            p_application_id ||
   ') AND application_id = '||
     p_application_id;
Line: 654

         '   SELECT content_code'||
         '   FROM ' || l_bne_value ||
         '   WHERE content_code = ''' ||
             l_content_code ||
         ''' AND application_id ='||
             p_application_id;
Line: 675

 PROCEDURE create_update_data
   (p_application_id         IN    number
   ,p_integrator_user_name   IN    varchar2
   ,p_api_package_name       IN    varchar2
   ,p_api_procedure_name     IN    varchar2
   ,p_interface_user_name    IN    varchar2
   ,p_interface_param_name   IN    varchar2
   ,p_api_type               IN    varchar2
   ,p_api_return_type        IN    varchar2
   ,p_view_name              IN    varchar2
   ,p_form_name              IN    varchar2
   ,p_language               IN    varchar2
   ,p_user_id                IN    number) IS
 --
 -- Upload api (update-style api's)
 --
 TYPE CSR_TYP IS REF CURSOR;
Line: 737

      ' select APPLICATION_SHORT_NAME' ||
      ' from '||l_bne_value ||
      ' where APPLICATION_ID ='||
       p_application_id;
Line: 751

        ' select FORM_NAME' ||
        ' from '||l_bne_value ||
        ' where FORM_NAME = '''||
         p_form_name || '''';
Line: 766

      ' select USER_NAME' ||
      ' from '||l_bne_value ||
      ' where USER_NAME ='''||
       p_integrator_user_name ||'''';
Line: 780

         ' select 1' ||
         ' from '||l_bne_value ||
         ' where A.OBJ# = B.OBJECT_ID' ||
         ' AND   B.OBJECT_NAME = '''||P_API_PACKAGE_NAME ||
         ''' AND   A.PROCEDURE$ = ''' ||P_API_PROCEDURE_NAME ||'''';
Line: 795

   SELECT hr_adi_object_code_s.NEXTVAL
   INTO l_object_num
   FROM dual;
Line: 811

     'SELECT integrator_code' ||
     '   FROM ' || l_bne_value ||
     '   WHERE integrator_code =  ''' ||
               l_object_code ||'_INTG'||
     ''' AND application_id = '
               || p_application_id;
Line: 844

     'SELECT integrator_code' ||
     '   FROM ' || l_bne_value ||
     '   WHERE integrator_code =  ''' ||
               l_integrator_code ||
     ''' AND application_id = '
               || p_application_id;
Line: 885

     'SELECT content_code ' ||
     ' FROM ' || l_bne_value ||
     ' WHERE integrator_code =''' ||
        l_integrator_code ||
     ''' AND application_id = '|| p_application_id;
Line: 917

     'SELECT count(*) ' ||
     ' FROM '|| l_bne_value ||
     ' WHERE content_code =''' ||
     l_content_code ||''' AND ' ||
     '          application_id = '|| p_application_id;
Line: 944

     'SELECT param_list_code ' ||
     ' FROM ' || l_bne_value ||
     ' WHERE content_code = ''' ||
         l_content_code ||
     ''' AND  application_id = '||
     p_application_id;
Line: 991

   ' SELECT interface_code '||
   ' FROM '|| l_bne_value ||
   ' WHERE interface_code = (' ||
        ' SELECT interface_code'||
        ' FROM bne_interfaces_b' ||
        ' WHERE interface_code = ''' ||
           l_interface_code ||
        ''' AND application_id ='||
            p_application_id ||
   ') AND application_id = '||
     p_application_id;
Line: 1039

 END create_update_data;
Line: 1068

   SELECT
      fnd_global.user_id,
      userenv('LANG')
   INTO
      l_user_id,
      l_language
   FROM
      dual;
Line: 1124

   ELSIF (UPPER(p_metadata_type) = 'UPDATE')
   THEN NULL;
Line: 1126

     create_update_data
        (p_application_id       => p_application_id
        ,p_integrator_user_name => p_integrator_user_name
        ,p_api_package_name     => l_package_name
        ,p_api_procedure_name   => l_procedure_name
        ,p_interface_user_name  => p_interface_user_name
        ,p_interface_param_name => p_interface_param_name
        ,p_api_type             => l_api_type
        ,p_api_return_type      => l_api_return_type
        ,p_view_name            => p_view_name
        ,p_form_name            => l_form_name
        ,p_language             => l_language
        ,p_user_id              => l_user_id);
Line: 1278

    'SELECT b.integrator_code ' ||
    '  FROM bne_integrators_tl t ' ||
    '     , bne_integrators_b b ' ||
    ' WHERE t.application_id = ' || p_application_id ||
    '   AND t.user_name = ''' || p_intg_user_name  || '''' ||
    '   AND t.integrator_code = b.integrator_code ' ||
    '   AND t.application_id = b.application_id ' ||
    '   AND t.integrator_code like ''GENERAL%'' ' ||
    '   AND b.enabled_flag = ''Y'' ';
Line: 1304

    'SELECT param_list_app_id, ' ||
    '       param_list_code, ' ||
    '       content_code ' ||
    '  FROM bne_contents_b ' ||
    ' WHERE integrator_app_id = '||p_application_id ||
    '   AND integrator_code = ''' ||l_integrator_code || ''' ';
Line: 1319

              '  DELETE FROM bne_param_list_items ' ||
              '  WHERE application_id = :1 ' ||
              '    AND param_list_code = :2 ;' ||
Line: 1328

              '  DELETE from bne_param_lists_tl ' ||
              '  WHERE application_id = :1 ' ||
              '    AND param_list_code = :2 ;' ||
Line: 1337

              '  DELETE from bne_param_lists_b ' ||
              '  WHERE application_id = :1 ' ||
              '    AND param_list_code = :2 ;' ||
Line: 1347

              '  UPDATE bne_contents_b ' ||
              '     SET param_list_app_id = 800 ' ||
              '       , param_list_code = ''HR_STANDARD'' ' ||
              '       , object_version_number = object_version_number + 1 ' ||
              '   WHERE integrator_app_id = :1 ' ||
              '     AND integrator_code = :2; ' ||
Line: 1388

                 ' DELETE FROM bne_stored_sql ' ||
                 '  WHERE content_code = :1 ' ||
                 '    AND application_id = :2; ' ||