APPS.OZF_CLAIMS_INT_PUB SQL Statements

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

Line: 75

	l_pvt_claims_int_rec.last_update_date := l_claims_int_rec.last_update_date;

Line: 76

	l_pvt_claims_int_rec.last_updated_by := l_claims_int_rec.last_updated_by;

Line: 79

	l_pvt_claims_int_rec.last_update_login := l_claims_int_rec.last_update_login;

Line: 82

	l_pvt_claims_int_rec.program_update_date := l_claims_int_rec.program_update_date;

Line: 283

PROCEDURE Update_Claims_Int(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,

    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,

    p_claims_int_rec               IN    claims_int_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Claims_Int';

Line: 303

      SAVEPOINT UPDATE_Claims_Int_PUB;

Line: 332

    OZF_Claims_Int_PVT.Update_Claims_Int(
    p_api_version_number         => 1.0,
    p_init_msg_list              => FND_API.G_FALSE,
    p_commit                     => p_commit,
    p_validation_level           => FND_API.G_VALID_LEVEL_FULL,
    x_return_status              => x_return_status,
    x_msg_count                  => x_msg_count,
    x_msg_data                   => x_msg_data,
    p_claims_int_rec  =>  l_pvt_claims_int_rec,
    x_object_version_number      => l_object_version_number );

Line: 378

     ROLLBACK TO UPDATE_Claims_Int_PUB;

Line: 388

     ROLLBACK TO UPDATE_Claims_Int_PUB;

Line: 398

     ROLLBACK TO UPDATE_Claims_Int_PUB;

Line: 410

End Update_Claims_Int;

Line: 413

PROCEDURE Delete_Claims_Int(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_interface_claim_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Claims_Int';

Line: 432

      SAVEPOINT DELETE_Claims_Int_PUB;

Line: 461

    OZF_Claims_Int_PVT.Delete_Claims_Int(
    p_api_version_number         => 1.0,
    p_init_msg_list              => FND_API.G_FALSE,
    p_commit                     => p_commit,
    p_validation_level           => FND_API.G_VALID_LEVEL_FULL,
    x_return_status              => x_return_status,
    x_msg_count                  => x_msg_count,
    x_msg_data                   => x_msg_data,
    p_interface_claim_id     => l_interface_claim_id,
    p_object_version_number      => l_object_version_number );

Line: 507

     ROLLBACK TO DELETE_Claims_Int_PUB;

Line: 517

     ROLLBACK TO DELETE_Claims_Int_PUB;

Line: 527

     ROLLBACK TO DELETE_Claims_Int_PUB;

Line: 539

End Delete_Claims_Int;