APPS.AHL_UMP_UNITMAINT_PUB SQL Statements

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

Line: 53

PROCEDURE Capture_MR_Updates (
    p_api_version           IN            NUMBER    := 1.0,
    p_init_msg_list         IN            VARCHAR2  := FND_API.G_TRUE,
    p_commit                IN            VARCHAR2  := FND_API.G_FALSE,
    p_validation_level      IN            NUMBER    := FND_API.G_VALID_LEVEL_FULL,
    p_unit_Effectivity_tbl  IN            AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
    p_x_unit_threshold_tbl  IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
    p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
    x_return_status         OUT    NOCOPY VARCHAR2,
    x_msg_count             OUT    NOCOPY NUMBER,
    x_msg_data              OUT    NOCOPY VARCHAR2)  IS


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

Line: 72

  SAVEPOINT Capture_MR_Updates_Pub;

Line: 89

  AHL_UMP_UNITMAINT_PVT.Capture_MR_Updates(
     	                      p_api_version           => 1.0,
                              p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
                              p_unit_Effectivity_tbl  => p_unit_Effectivity_tbl,
                              p_x_unit_threshold_tbl  => p_x_unit_threshold_tbl,
                              p_x_unit_accomplish_tbl => p_x_unit_accomplish_tbl,
                              x_return_status         => x_return_status,
                              x_msg_count             => x_msg_count,
                              x_msg_data              => x_msg_data );

Line: 122

   Rollback to Capture_MR_Updates_Pub;

Line: 131

   Rollback to Capture_MR_Updates_Pub;

Line: 139

    Rollback to Capture_MR_Updates_Pub;

Line: 151

END Capture_MR_Updates;