APPS.PV_COMMON_CHECKS_PVT SQL Statements

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

Line: 92

      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- validate NOT NULL column

          IF(p_OBJECT_VERSION_NUMBER is NULL or p_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
          THEN
              IF (AS_DEBUG_HIGH_ON) THEN

              AS_UTILITY_PVT.Debug_Message('ERROR', 'Private entyrout API: -Violate NOT NULL constraint(OBJECT_VERSION_NUMBER)');

Line: 130

      SELECT  'X'
      FROM  fnd_lookup_values
      WHERE lookup_type = C_Lookup_Type
            AND lookup_code = C_Lookup_Code
            AND enabled_flag = 'Y'
            AND (start_date_active IS NULL OR start_date_active < SYSDATE)
            AND (end_date_active IS NULL OR end_date_active > SYSDATE);

Line: 195

      SELECT 'X'
      FROM  pv_process_rules_b
      WHERE process_rule_id = c_process_rule_id;

Line: 259

      SELECT 'X'
      FROM  pv_attributes_b
      WHERE attribute_id = c_attribute_id;

Line: 325

      SELECT RETURN_TYPE
      FROM  pv_attributes_b
      WHERE attribute_id = c_attribute_id;