APPS.EAM_FAILURESETS_PUB SQL Statements

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

Line: 84

PROCEDURE Update_FailureSet
       (p_api_version      IN  NUMBER                                     ,
        p_init_msg_list    IN  VARCHAR2 := FND_API.G_FALSE                ,
        p_commit           IN  VARCHAR2 := FND_API.G_FALSE                ,
        p_failureset_rec   IN  EAM_FailureSets_PUB.eam_failureset_rec_type,
        x_return_status    OUT NOCOPY VARCHAR2                            ,
        x_msg_count        OUT NOCOPY NUMBER                              ,
        x_msg_data         OUT NOCOPY VARCHAR2                            ,
        x_failureset_id    OUT NOCOPY NUMBER
       )
IS
l_api_name            CONSTANT VARCHAR2(30) := 'Update_FailureSet';

Line: 102

    SAVEPOINT Update_FailureSet_PUB;

Line: 144

		ROLLBACK TO Update_FailureSet_PUB;

Line: 158

END Update_FailureSet;

Line: 231

PROCEDURE Update_Association
       (p_api_version      IN  NUMBER                                         ,
        p_init_msg_list    IN  VARCHAR2 := FND_API.G_FALSE                    ,
        p_commit           IN  VARCHAR2 := FND_API.G_FALSE                    ,
        p_association_rec  IN  EAM_FailureSets_PUB.eam_set_association_rec_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) := 'Update_Association';

Line: 247

    SAVEPOINT Update_Association_PUB;

Line: 286

		ROLLBACK TO Update_Association_PUB;

Line: 300

END Update_Association;

Line: 302

PROCEDURE Delete_Association
       (p_api_version      IN  NUMBER                                         ,
        p_init_msg_list    IN  VARCHAR2 := FND_API.G_FALSE                    ,
        p_commit           IN  VARCHAR2 := FND_API.G_FALSE                    ,
        p_association_rec  IN  EAM_FailureSets_PUB.eam_set_association_rec_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) := 'Delete_Association';

Line: 318

    SAVEPOINT Delete_Association_PUB;

Line: 357

		ROLLBACK TO Delete_Association_PUB;

Line: 371

END Delete_Association;