APPS.JTF_QUALIFIER_PUB SQL Statements

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

Line: 252

PROCEDURE Update_Qualifier
(p_api_version         IN    NUMBER,
 p_Init_Msg_List       IN    VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
 p_Commit              IN    VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
 x_Return_Status       OUT NOCOPY   VARCHAR2,
 x_Msg_Count           OUT NOCOPY   NUMBER,
 x_Msg_Data            OUT NOCOPY   VARCHAR2,
 p_Seed_Qual_Rec       IN    Seed_Qual_Rec_Type,
 p_Qual_Usgs_Rec       IN    Qual_Usgs_All_Rec_Type,
 x_Seed_Qual_Rec       OUT NOCOPY   Seed_Qual_Out_Rec_Type,
 x_Qual_Usgs_Rec       OUT NOCOPY   Qual_Usgs_All_Out_Rec_Type
  )
IS

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

Line: 281

    SAVEPOINT UPDATE_QUALIFIER_PUB;

Line: 316

    JTF_QUALIFIER_PVT.Update_Qualifier ( p_api_version         => 1.0,
                                         p_Init_Msg_List       => FND_API.G_FALSE,
                                         p_Commit              => FND_API.G_FALSE,
                                         p_validation_level    => FND_API.G_VALID_LEVEL_FULL,
                                         x_Return_Status       => l_return_status,
                                         x_Msg_Count           => x_msg_count,
                                         x_Msg_Data            => x_msg_data,
                                         p_Seed_Qual_Rec       => p_seed_qual_rec,
                                         p_Qual_Usgs_Rec       => p_qual_usgs_rec,
                                         x_Seed_Qual_Rec       => x_seed_qual_rec,
                                         x_Qual_Usgs_Rec       => x_qual_usgs_rec);

Line: 366

         ROLLBACK TO UPDATE_QUALIFIER_PUB;

Line: 375

         ROLLBACK TO UPDATE_QUALIFIER_PUB;

Line: 385

         ROLLBACK TO UPDATE_QUALIFIER_PUB;

Line: 397

END Update_Qualifier;

Line: 435

PROCEDURE Delete_Qualifier
(p_api_version         IN    NUMBER,
 p_Init_Msg_List       IN    VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
 p_Commit              IN    VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
 x_Return_Status       OUT NOCOPY   VARCHAR2,
 x_Msg_Count           OUT NOCOPY   NUMBER,
 x_Msg_Data            OUT NOCOPY   VARCHAR2,
 p_Seeded_Qual_Id      IN    NUMBER,
 p_Qual_Usg_Id         IN    NUMBER
  )
IS

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

Line: 455

    SAVEPOINT DELETE_QUALIFIER_PUB;

Line: 489

    JTF_QUALIFIER_PVT.Delete_Qualifier ( p_api_version         => 1.0,
                                         p_Init_Msg_List       => FND_API.G_FALSE,
                                         p_Commit              => FND_API.G_FALSE,
                                         p_validation_level    => FND_API.G_VALID_LEVEL_FULL,
                                         x_Return_Status       => l_return_status,
                                         x_Msg_Count           => x_msg_count,
                                         x_Msg_Data            => x_msg_data,
                                         p_Seeded_Qual_Id      => p_seeded_qual_id,
                                         p_Qual_Usg_Id         => p_qual_usg_id);

Line: 537

         ROLLBACK TO DELETE_QUALIFIER_PUB;

Line: 546

         ROLLBACK TO DELETE_QUALIFIER_PUB;

Line: 556

         ROLLBACK TO DELETE_QUALIFIER_PUB;

Line: 568

END Delete_Qualifier;