APPS.GCS_ICM_INTG_PROF_PKG SQL Statements

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

Line: 16

             p_force_update   VARCHAR2)
  IS
    l_profile_option_id  NUMBER;

Line: 27

    SELECT application_id,
           profile_option_id
    INTO l_application_id,
         l_profile_option_id
    FROM fnd_profile_options
    WHERE profile_option_name = p_option_name;

Line: 35

    USING (SELECT 1 FROM DUAL) src
    ON (pov.application_id = l_application_id AND
        pov.profile_option_id = l_profile_option_id AND
        pov.level_id = 10001)
    WHEN MATCHED THEN
      UPDATE SET profile_option_value = decode(profile_option_value,
                                               NULL, p_option_value,
                                               decode(p_force_update,
                                                      'Y', p_option_value,
                                                      profile_option_value)),
                 last_update_date = sysdate,
                 last_updated_by = fnd_global.user_id,
                 last_update_login = fnd_global.login_id
    WHEN NOT MATCHED THEN
      INSERT(
        application_id,
        profile_option_id,
        level_id,
        level_value,
        creation_date,
        created_by,
        last_update_date,
        last_updated_by,
        last_update_login,
        profile_option_value)
      VALUES(
        l_application_id,
        l_profile_option_id,
        10001,
        0,
        sysdate,
        fnd_global.user_id,
        sysdate,
        fnd_global.user_id,
        fnd_global.login_id,
        p_option_value);

Line: 106

    SELECT to_char(flex_value_set_id)
    INTO l_vs_id
    FROM fnd_flex_value_sets
    WHERE flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';

Line: 146

    SELECT flex_value_set_name
    FROM fnd_flex_value_sets ffv
    WHERE ffv.flex_value_set_id = to_number(fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT'));

Line: 172

      'SELECT amw_fin_stmnt_selection_s.nextval ' ||
      'FROM DUAL'
    INTO l_run_id;

Line: 177

      'INSERT INTO amw_fin_stmnt_selection ' ||
      '(run_id, ' ||
      ' financial_statement_id, ' ||
      ' creation_date, ' ||
      ' created_by, ' ||
      ' last_update_date, ' ||
      ' last_updated_by, ' ||
      ' last_update_login, ' ||
      ' security_group_id, ' ||
      ' object_version_number) ' ||
      'SELECT :1, ' ||
      '       hierarchy_id, ' ||
      '       sysdate, ' ||
      '       fnd_global.user_id, ' ||
      '       sysdate, ' ||
      '       fnd_global.user_id, ' ||
      '       fnd_global.login_id, ' ||
      '       null, ' ||
      '       1 ' ||
      'FROM gcs_hierarchies_b ' ||
      'WHERE certification_flag = ''Y'''
    USING l_run_id;