APPS.EAM_FAILURECODES_PUB SQL Statements

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

Line: 77

PROCEDURE Update_Code
         (p_api_version     IN  NUMBER                                     ,
          p_init_msg_list   IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_commit          IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_failurecode_rec IN  EAM_FailureCodes_PUB.eam_failurecode_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_Code';

Line: 93

    SAVEPOINT Update_Code_PUB;

Line: 133

		ROLLBACK TO Update_Code_PUB;

Line: 147

END Update_Code;

Line: 149

PROCEDURE Delete_Code
         (p_api_version     IN  NUMBER                                     ,
          p_init_msg_list   IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_commit          IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_failurecode_rec IN  EAM_FailureCodes_PUB.eam_failurecode_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_Code';

Line: 165

    SAVEPOINT Delete_Code_PUB;

Line: 205

		ROLLBACK TO Delete_Code_PUB;

Line: 219

END Delete_Code;

Line: 273

       l_combination_rec.last_update_date       := sysdate;

Line: 274

       l_combination_rec.last_updated_by        := fnd_global.user_id;

Line: 275

       l_combination_rec.last_update_login      := p_combination_rec.last_update_login;

Line: 313

PROCEDURE Update_Combination
         (p_api_version     IN  NUMBER                                     ,
          p_init_msg_list   IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_commit          IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_combination_rec IN  EAM_FailureCodes_PUB.eam_combination_rec_type,
          x_return_status   OUT NOCOPY VARCHAR2                            ,
          x_msg_count       OUT NOCOPY NUMBER                              ,
          x_msg_data        OUT NOCOPY VARCHAR2,
          x_combination_id  OUT NOCOPY NUMBER
         )
IS
l_api_name            CONSTANT VARCHAR2(30) := 'Update_Combination';

Line: 331

    SAVEPOINT Update_Combination_PUB;

Line: 364

       l_combination_rec.last_update_date       := sysdate;

Line: 365

       l_combination_rec.last_updated_by        := fnd_global.user_id;

Line: 366

       l_combination_rec.last_update_login      := p_combination_rec.last_update_login;

Line: 388

		ROLLBACK TO Update_Combination_PUB;

Line: 402

END Update_Combination;

Line: 404

PROCEDURE Delete_Combination
         (p_api_version     IN  NUMBER                                     ,
          p_init_msg_list   IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_commit          IN  VARCHAR2 := FND_API.G_FALSE                ,
          p_combination_rec IN  EAM_FailureCodes_PUB.eam_combination_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_Combination';

Line: 421

    SAVEPOINT Delete_Combination_PUB;

Line: 461

		ROLLBACK TO Delete_Combination_PUB;

Line: 475

END Delete_Combination;