APPS.HR_INTEGRATION_UTILS SQL Statements

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

Line: 24

    SELECT resp_application_id, responsibility_id
      FROM hr_adi_intg_resp
     WHERE intg_application_id || ':' || integrator_code = p_intg_code;

Line: 70

    'SELECT pli.string_value ' ||
    '  FROM bne_param_lists_tl  plt ' ||
    '     , bne_param_list_items pli ' ||
    ' WHERE plt.application_id = 800 ' ||
    '   AND plt.user_name = ''' || p_form_name || ''' ' ||
    '   AND pli.application_id = plt.application_id ' ||
    '   AND pli.param_list_code = plt.param_list_code ';

Line: 149

    'SELECT pli.string_value ' ||
    '  FROM bne_param_lists_b plb ' ||
    '     , bne_param_list_items pli ' ||
    '     , bne_layouts_b lb ' ||
    '     , bne_layouts_tl lt ' ||
    ' WHERE plb.application_id = 800 ' ||
    '   AND plb.param_list_code = ''HR_LETTER'' ' ||
    '   AND pli.application_id = plb.application_id ' ||
    '   AND pli.param_list_code = plb.param_list_code ' ||
    '   AND lb.integrator_app_id = ' ||
    '       substr(pli.string_value,0,instr(pli.string_value,'':'')-1) ' ||
    '   AND lb.integrator_code = ' ||
    '       substr(pli.string_value,instr(pli.string_value,'':'')+1) ' ||
    '   AND lt.application_id = lb.application_id ' ||
    '   AND lt.layout_code = lb.layout_code ' ||
    '   AND lt.user_name = ''' || p_letter || ''' ';

Line: 221

PROCEDURE add_or_update_session(p_sess_date in date) is
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 225

  SELECT 'Y'
    FROM fnd_sessions
   WHERE session_id = userenv('sessionid');

Line: 233

  hr_utility.set_location('ADD_OR_UPDATE_SESSION',10);

Line: 239

     hr_utility.set_location('ADD_OR_UPDATE_SESSION - NO ROW',20);

Line: 242

     INSERT INTO fnd_sessions (session_id, effective_date)
     VALUES (userenv('sessionid'), p_sess_date);

Line: 245

     hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW ADDED',30);

Line: 249

     hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW EXISTS',40);

Line: 251

     UPDATE fnd_sessions
        SET effective_date = p_sess_date
      WHERE session_id = userenv('sessionid');

Line: 254

     hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW UPDATE',50);

Line: 261

END add_or_update_session;

Line: 270

l_update_sql      varchar2(2000);

Line: 274

  l_update_sql :=
    'BEGIN ' ||
    'UPDATE BNE_CONTENTS_B ' ||
    '  SET param_list_app_id = 800' ||
    '      , param_list_code = :1 ' ||
    ' WHERE application_id = :2 ' ||
    '   AND content_code = :3 ; ' ||

Line: 283

  EXECUTE IMMEDIATE l_update_sql
    USING IN l_param_list_name,
          IN to_char(p_application_id),
          IN p_content_code;

Line: 297

l_update_sql      varchar2(2000);

Line: 301

  l_update_sql :=
    'BEGIN ' ||
    'UPDATE BNE_INTEGRATORS_B ' ||
    '  SET upload_param_list_app_id = 800 ' ||
    '      , upload_param_list_code = :1 ' ||
    '      , upload_serv_param_list_app_id = 231 ' ||
    '      , upload_serv_param_list_code = ''UPL_SERV_JNLS'' ' ||
    ' WHERE application_id = :2 ' ||
    '   AND integrator_code = :3 ; ' ||

Line: 312

  EXECUTE IMMEDIATE l_update_sql
    USING IN l_param_list_name,
          IN to_char(p_application_id),
          IN p_integrator_code;

Line: 339

             '  SELECT count(*) ' ||
             '    INTO :1 ' ||
             '    FROM bne_param_lists_tl ' ||
             '   WHERE user_name = :2 ' ||
             '     AND param_list_code = :3 ' ||
             '     AND application_id = 800; ' ||

Line: 542

    'SELECT param_list_code ' ||
    '  FROM bne_param_lists_b ' ||
    ' WHERE param_list_code = ''' || l_param_list_code || ''' ' ||
    '   AND application_id  = ' || p_application_id || ' ';

Line: 854

    '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: 877

     'SELECT content_code ' ||
     '  FROM bne_contents_b ' ||
     ' WHERE integrator_app_id = ' || p_application_id ||
     ' AND integrator_code = ''' || l_integrator_code || '''';

Line: 893

  SELECT fnd_global.user_id
  INTO l_user_id
  FROM dual;

Line: 1016

   SELECT application_id
     FROM fnd_application
    WHERE upper(application_short_name) = upper(p_application_short_name);

Line: 1051

    'SELECT integrator_code ' ||
    '  FROM bne_integrators_tl ' ||
    ' WHERE user_name = ''' || p_integrator_user_name || ''' ' ||
    '   AND application_id = ' || l_application_id;

Line: 1069

           ' UPDATE bne_integrators_b ' ||
           '    SET enabled_flag = ''N'' ' ||
           '  WHERE integrator_code = :1 ' ||
           '    AND application_id = :2 ; ' ||

Line: 1082

           ' UPDATE bne_integrators_tl ' ||
           '    SET user_name = :1 ' ||
           '  WHERE integrator_code = :2 ' ||
           '    AND application_id = :3; ' ||

Line: 1096

           ' DELETE ' ||
           '   FROM bne_param_list_items ' ||
           '  WHERE string_value like :1 ' ||
           '    AND application_id = 800 ' ||
           '    AND param_list_code like ''HR%''; ' ||

Line: 1132

  SELECT application_id
    FROM fnd_application
   WHERE upper(application_short_name) = upper(l_app_short_name);

Line: 1138

  SELECT responsibility_id
    FROM fnd_responsibility_vl
   WHERE application_id = l_app_id
     AND responsibility_name = l_resp_name;

Line: 1170

    'SELECT integrator_code ' ||
    '  FROM bne_integrators_vl ' ||
    ' WHERE user_name = ''' || p_integrator_user_name || ''' ' ||
    '   AND application_id = ' || l_intg_application_id;

Line: 1201

  INSERT INTO hr_adi_intg_resp
    (resp_association_id,
     intg_application_id,
     integrator_code,
     resp_application_id,
     responsibility_id)
  VALUES
    (hr_adi_intg_resp_s.nextval
    ,l_intg_application_id
    ,l_integrator_code
    ,l_resp_application_id
    ,l_responsibility_id);

Line: 1238

    SELECT 'Y'
      FROM hr_adi_intg_resp
     WHERE resp_association_id = p_resp_association_id;

Line: 1243

   SELECT application_id
     FROM fnd_application
    WHERE upper(application_short_name) = upper(p_resp_application);

Line: 1248

     SELECT responsibility_id
       FROM fnd_responsibility_vl
      WHERE application_id = l_app_id
        AND responsibility_name = l_resp_name;

Line: 1273

     DELETE FROM hr_adi_intg_resp
      WHERE resp_association_id = p_resp_association_id;

Line: 1310

     UPDATE hr_adi_intg_resp
     SET resp_application_id = l_application_id,
         responsibility_id = l_responsibility_id
     WHERE resp_association_id = p_resp_association_id;

Line: 1346

   SELECT application_id
     FROM fnd_application
    WHERE upper(application_short_name) = upper(p_intg_application);

Line: 1354

  SELECT fnd_global.user_id
  INTO   l_user_id
  FROM   dual;

Line: 1386

    'SELECT integrator_code ' ||
    '  FROM bne_integrators_vl ' ||
    ' WHERE user_name = ''' || p_integrator_user_name || ''' ' ||
    '  AND application_id = ' || l_intg_app_id;

Line: 1403

  'SELECT security_rule_app_id ' ||
  '     , security_rule_code ' ||
  '  FROM bne_secured_objects ' ||
  ' WHERE application_id = ' || l_intg_app_id ||
  '   AND object_code = ''' || l_integrator_code || ''' ' ||
  '   AND object_type = ''INTEGRATOR''';

Line: 1431

       'BNE_SECURITY_UTILS_PKG.DELETE_OBJECT_RULES' ||
       '   (p_object_app_id   => :1 ' ||
       '   ,p_object_code     => :2 ' ||
       '   ,p_object_type     => ''' || 'INTEGRATOR' || ''' ' ||
       '   ,p_security_app_id => :3 ' ||
       '   ,p_security_code   => :4 ' ||
       '   ); ' ||

Line: 1454

       'BNE_SECURITY_UTILS_PKG.UPDATE_OBJECT_RULES' ||
       '   (p_object_app_id   => :1 ' ||
       '   ,p_object_code     => :2 ' ||
       '   ,p_object_type     => ''' || 'INTEGRATOR' || ''' ' ||
       '   ,p_security_app_id => :3 ' ||
       '   ,p_security_code   => :4 ' ||
       '   ,P_SECURITY_TYPE   => ''' || 'FUNCTION' || ''' ' ||
       '   ,P_SECURITY_VALUE  => :5 ' ||
       '   ,P_USER_ID         => :6 ' ||
       '   ); ' ||

Line: 1519

    'SELECT i.param_name, d.datatype, t.prompt_left ' ||
    '  FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
    ' WHERE i.application_id = ' || p_application_id ||
    '   AND i.param_list_code = ''' || p_param_list_code || ''' ' ||
    '   AND i.sequence_num = ' || p_number ||
    '   AND i.param_defn_code = d.param_defn_code ' ||
    '   AND i.param_defn_app_id = d.application_id ' ||
    '   AND i.param_defn_code = t.param_defn_code ' ||
    '   AND i.param_defn_app_id = t.application_id ';

Line: 1560

    'SELECT i.param_name, decode(d.datatype,1,''Varchar2'',' ||
    '                            2,''Number'',3,''Date'',''Varchar2''), t.prompt_left ' ||
    '  FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
    ' WHERE i.application_id = ' || p_application_id ||
    '   AND i.param_list_code = ''' || p_param_list_code || ''' ' ||
    '   AND i.sequence_num = ' || p_number ||
    '   AND i.param_defn_code = d.param_defn_code ' ||
    '   AND i.param_defn_app_id = d.application_id ' ||
    '   AND i.param_defn_code = t.param_defn_code ' ||
    '   AND i.param_defn_app_id = t.application_id ';

Line: 1572

    'SELECT i.param_name, decode(d.datatype, '||
    '                            1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
    '                            2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
    '                            3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
    '                            hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
    '                            t.prompt_left ' ||
    '  FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
    ' WHERE i.application_id = ' || p_application_id ||
    '   AND i.param_list_code = ''' || p_param_list_code || ''' ' ||
    '   AND i.sequence_num = ' || p_number ||
    '   AND i.param_defn_code = d.param_defn_code ' ||
    '   AND i.param_defn_app_id = d.application_id ' ||
    '   AND i.param_defn_code = t.param_defn_code ' ||
    '   AND i.param_defn_app_id = t.application_id ';

Line: 1618

    'SELECT i.param_name, d.datatype, t.prompt_left ' ||
    '  FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
    ' WHERE i.application_id = ' || p_application_id ||
    '   AND i.param_list_code = ''' || p_param_list_code || ''' ' ||
    '   AND i.sequence_num = ' || p_number ||
    '   AND i.param_defn_code = d.param_defn_code ' ||
    '   AND i.param_defn_app_id = d.application_id ' ||
    '   AND i.param_defn_code = t.param_defn_code ' ||
    '   AND i.param_defn_app_id = t.application_id ';