APPS.AHL_UC_UTILIZATION_PUB SQL Statements

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

Line: 56

PROCEDURE Update_Utilization(p_api_version       IN            NUMBER,
                             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,
                             p_Utilization_tbl   IN            AHL_UC_Utilization_PVT.Utilization_Tbl_Type,
                             x_return_status     OUT  NOCOPY   VARCHAR2,
                             x_msg_count         OUT  NOCOPY   NUMBER,
                             x_msg_data          OUT  NOCOPY   VARCHAR2 ) IS

  l_api_version     CONSTANT NUMBER       := 1.0;

Line: 66

  l_api_name        CONSTANT VARCHAR2(30) := 'Update_Utilization';

Line: 71

  SAVEPOINT Update_Utilization_Pub;

Line: 87

  AHL_UC_UTILIZATION_PVT.Update_Utilization(
                             p_api_version     => 1.0,
                             p_Utilization_tbl => p_utilization_tbl,
                             x_return_status   => x_return_status,
                             x_msg_count       => x_msg_count,
                             x_msg_data        => x_msg_data);

Line: 118

   Rollback to Update_Utilization_Pub;

Line: 125

   Rollback to Update_Utilization_Pub;

Line: 132

   Rollback to Update_Utilization_Pub;

Line: 135

                               p_procedure_name => 'Update_Utilization',
                               p_error_text     => SUBSTR(SQLERRM,1,240));

Line: 142

END  Update_Utilization;