APPS.AS_SALES_LEAD_RANKS_PUB SQL Statements

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

Line: 47

    CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
      WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;

Line: 110

PROCEDURE Update_Rank (p_api_version         IN NUMBER := 2.0,
                       p_init_msg_list       IN VARCHAR2 := FND_API.G_FALSE,
                       p_commit              IN VARCHAR2 := FND_API.G_FALSE,
                       p_validation_level    IN NUMBER :=
                                                       FND_API.G_VALID_LEVEL_FULL,
                       x_return_status       OUT NOCOPY VARCHAR2,
                       x_msg_count           OUT NOCOPY NUMBER,
                       x_msg_data            OUT NOCOPY VARCHAR2,
                       p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type) IS

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

Line: 128

    CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
      WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;

Line: 133

     SAVEPOINT     Update_Rank_PVT;

Line: 151

    AS_SALES_LEAD_RANKS_PVT.Update_Rank (p_api_version  => l_api_version,
                                        p_commit        => p_commit,
                                        x_return_status       => l_return_status,
                                        x_msg_count           => l_msg_count,
                                        x_msg_data            => l_msg_data,
                                        p_sales_lead_rank_rec => l_sales_lead_rank_rec);

Line: 169

          ROLLBACK TO Update_Rank_PVT;

Line: 174

          ROLLBACK TO Update_Rank_PVT;

Line: 179

          ROLLBACK TO Update_Rank_PVT;

Line: 185

END Update_Rank;

Line: 187

Procedure Delete_Rank (p_api_version         IN NUMBER := 2.0,
                       p_init_msg_list       IN VARCHAR2 := FND_API.G_FALSE,
                       p_commit              IN VARCHAR2 := FND_API.G_FALSE,
                       p_validation_level    IN NUMBER :=
                                                       FND_API.G_VALID_LEVEL_FULL,
                       x_return_status       OUT NOCOPY VARCHAR2,
                       x_msg_count           OUT NOCOPY NUMBER,
                       x_msg_data            OUT NOCOPY VARCHAR2,
                       p_sales_lead_rank_id  IN NUMBER) IS

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

Line: 207

     SAVEPOINT     Delete_Rank_PVT;

Line: 226

        AS_SALES_LEAD_RANKS_PVT.Delete_Rank (p_api_version        => 2.0,
                                            p_commit              => p_commit,
                                            x_return_status       => l_return_status,
                                            x_msg_count           => l_msg_count,
                                            x_msg_data            => l_msg_data,
                                            p_sales_lead_rank_id  => l_sales_lead_rank_id);

Line: 245

          ROLLBACK TO Delete_Rank_PVT;

Line: 250

          ROLLBACK TO Delete_Rank_PVT;

Line: 255

          ROLLBACK TO Delete_Rank_PVT;

Line: 261

END DELETE_RANK;