APPS.AHL_UC_UNITCONFIG_PUB SQL Statements

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

Line: 29

  SELECT u.object_version_number,
         c.object_version_number
    FROM ahl_unit_config_headers u,
         csi_item_instances c
   WHERE u.unit_config_header_id = c_uc_header_id
     AND u.csi_item_instance_id = c.instance_id
     AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line: 95

			       ': before calling ahl_uc_unitconfig_pvt.update_uc_header');

Line: 97

    ahl_uc_unitconfig_pvt.update_uc_header(
        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,
        p_module_type           => NULL,
        x_return_status         => l_return_status,
        x_msg_count             => l_msg_count,
        x_msg_data              => l_msg_data,
        p_x_uc_header_rec       => p_x_uc_header_rec,
        p_uc_instance_rec       => NULL);

Line: 112

			       ': before calling ahl_uc_unitconfig_pvt.delete_uc_header');

Line: 127

    ahl_uc_unitconfig_pvt.delete_uc_header(
        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          => p_x_uc_header_rec.uc_header_id,
        p_object_version_number => l_uc_header_ovn,
        p_csi_instance_ovn      => l_csi_instance_ovn);