APPS.AHL_APPR_SPACE_CAPB_PUB SQL Statements

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

Line: 140

         AHL_APPR_SPACE_CAPB_PVT.UPDATE_SPACE
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_module_type             => p_module_type,
            p_space_rec               => p_x_space_rec,
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );

Line: 157

         AHL_APPR_SPACE_CAPB_PVT.UPDATE_SPACE_CAPBLTS
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_module_type             => p_module_type,
            p_space_capblts_rec       => p_x_space_capbl_tbl(i),
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );

Line: 181

       AHL_DEBUG_PUB.debug( 'before delete 10');

Line: 186

         AHL_APPR_SPACE_CAPB_PVT.DELETE_SPACE
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_space_rec               => p_x_space_rec,
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );

Line: 199

       AHL_DEBUG_PUB.debug( 'before delete 20');

Line: 206

         AHL_APPR_SPACE_CAPB_PVT.DELETE_SPACE_CAPBLTS
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_space_capblts_rec       => p_x_space_capbl_tbl(i),
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );

Line: 231

       AHL_DEBUG_PUB.debug( 'before delete capb');

Line: 239

       AHL_DEBUG_PUB.debug( 'inside pub delete capb'||p_x_space_capbl_tbl(i).operation_flag);

Line: 243

         AHL_APPR_SPACE_CAPB_PVT.DELETE_SPACE_CAPBLTS
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_space_capblts_rec       => p_x_space_capbl_tbl(i),
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );