APPS.AHL_UC_INSTANCE_PUB SQL Statements

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

Line: 10

SELECT object_version_number
  FROM csi_ii_relationships
 WHERE subject_id = c_subject_id
   AND relationship_type_code = 'COMPONENT-OF'
   AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
   AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line: 24

  SELECT unit_config_header_id
    FROM ahl_unit_config_headers
   WHERE name = p_uc_name;

Line: 28

  SELECT unit_config_header_id
    FROM ahl_unit_config_headers
   WHERE unit_config_header_id = p_uc_header_id;

Line: 84

  SELECT instance_id
    FROM csi_item_instances
   WHERE instance_number = p_instance_num;

Line: 88

  SELECT instance_id
    FROM csi_item_instances
   WHERE instance_id = p_instance_id;

Line: 465

PROCEDURE update_instance(
  p_api_version           IN  NUMBER := 1.0,
  p_init_msg_list         IN  VARCHAR2 := FND_API.G_FALSE,
  p_commit                IN  VARCHAR2 := FND_API.G_FALSE,
  p_validation_level      IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
  x_return_status         OUT NOCOPY VARCHAR2,
  x_msg_count             OUT NOCOPY NUMBER,
  x_msg_data              OUT NOCOPY VARCHAR2,
  p_uc_header_id          IN  NUMBER := NULL,
  p_uc_name               IN  VARCHAR2,
  p_uc_instance_rec       IN  ahl_uc_instance_pvt.uc_instance_rec_type,
  p_prod_user_flag        IN  VARCHAR2)
IS
  l_api_name       CONSTANT   VARCHAR2(30)   := 'update_instance';

Line: 492

  SAVEPOINT update_instance;

Line: 527

  ahl_uc_instance_pvt.update_instance_attr(
        p_api_version           => 1.0,
        p_init_msg_list         => FND_API.G_FALSE,
        p_commit                => FND_API.G_FALSE,
        p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
        x_return_status         => l_return_status,
        x_msg_count             => l_msg_count,
        x_msg_data              => l_msg_data,
        p_uc_header_id          => l_uc_header_id,
        p_uc_instance_rec       => p_uc_instance_rec,
        p_prod_user_flag        => p_prod_user_flag);

Line: 568

    ROLLBACK TO update_instance;

Line: 575

    ROLLBACK TO update_instance;

Line: 582

    ROLLBACK TO update_instance;

Line: 595

END update_instance;