APPS.AMW_COMPLIANCE_ENV_ASSOCS_PVT SQL Statements

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

Line: 25

   select count(*)
   into n
   from amw_compliance_env_assocs
   where pk1 = p_pk1
   and   object_type = p_object_type
   and   compliance_env_id = p_compliance_env_id;

Line: 61

   select count(*)
   into n
   from amw_compliance_env_assocs
   where pk1 = p_pk1
   and   object_type = p_object_type
   and   compliance_env_id = p_compliance_env_id;

Line: 68

   select meaning
   into yes
   from fnd_lookups
   where lookup_type='YES_NO'
   and lookup_code='Y';

Line: 74

   select meaning
   into no
   from fnd_lookups
   where lookup_type='YES_NO'
   and lookup_code='N';

Line: 117

      SELECT parent_setup_risk_type_id
        from amw_setup_risk_types_b
       where setup_risk_type_id  = l_setup_risk_type_id;

Line: 123

      SELECT count(*)
        from amw_compliance_env_assocs
       where pk1 = l_setup_risk_type_id
         and object_type = 'SETUP_RISK_TYPE'
         and compliance_env_id = p_compliance_env_id;

Line: 131

      SELECT count(*)
        from amw_compliance_env_assocs
       where pk1 in (
               select b.setup_risk_type_id
                 from amw_setup_risk_types_b b
                where b.parent_setup_risk_type_id = l_setup_risk_type_id
             )
         and object_type = 'SETUP_RISK_TYPE'
         and compliance_env_id = p_compliance_env_id;

Line: 223

                   p_select_flag         IN         VARCHAR2,
                   p_compliance_env_id   IN         NUMBER,
                   p_object_type         IN         VARCHAR2,
                   p_pk1                 IN         NUMBER,
                   p_pk2                 IN         NUMBER     := NULL,
                   p_pk3                 IN         NUMBER     := NULL,
                   p_pk4                 IN         NUMBER     := NULL,
                   p_pk5                 IN         NUMBER     := NULL,
                   x_return_status       OUT NOCOPY VARCHAR2,
                   x_msg_count           OUT NOCOPY NUMBER,
                   x_msg_data            OUT NOCOPY VARCHAR2
) IS

l_creation_date         date;

Line: 238

l_last_update_date      date;

Line: 239

l_last_updated_by       number;

Line: 240

l_last_update_login     number;

Line: 259

     delete from amw_compliance_env_assocs
     where pk1 = p_pk1
     and   object_type = p_object_type
     and   compliance_env_id = p_compliance_env_id;

Line: 264

     if (p_select_flag = 'Y') then
          l_creation_date := SYSDATE;

Line: 267

          l_last_update_date := SYSDATE;

Line: 268

          l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 269

          l_last_update_login := FND_GLOBAL.USER_ID;

Line: 272

          select amw_compliance_env_assoc_s.nextval into l_compliance_env_assoc_id from dual;

Line: 274

          insert into amw_compliance_env_assocs (compliance_env_assoc_id,
                                              compliance_env_id,
                                              object_type,
                                              pk1,
                                              pk2,
                                              pk3,
                                              pk4,
                                              pk5,
                                              creation_date,
                                              created_by,
                                              last_update_date,
                                              last_updated_by,
                                              last_update_login,
                                              object_version_number)
          values (l_compliance_env_assoc_id,
                  p_compliance_env_id,
                  p_object_type,
                  p_pk1,
                  p_pk2,
                  p_pk3,
                  p_pk4,
                  p_pk5,
                  l_creation_date,
                  l_created_by,
                  l_last_update_date,
                  l_last_updated_by,
                  l_last_update_login,
                  l_object_version_number);

Line: 350

   select count(*)
   into n
   from amw_compliance_env_assocs
   where compliance_env_id = p_compliance_env_id;