APPS.AS_SCORECARD_RULES_PUB SQL Statements

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

Line: 167

Procedure Update_ScoreCard (
    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 := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
    x_return_status           OUT NOCOPY  VARCHAR2,
    x_msg_count               OUT NOCOPY  NUMBER,
    x_msg_data                OUT NOCOPY  VARCHAR2,
    P_SCORECARD_REC           IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
                                                          := G_MISS_SCORECARD_REC)
IS
    l_api_name                CONSTANT VARCHAR2(30) := 'Update_ScoreCard';

Line: 187

      SAVEPOINT UPDATE_SCORECARD_PUB;

Line: 220

                   'Public API: Calling AS_SALES_LEADS_PVT.Update_sales_lead');

Line: 222

      AS_SCORECARD_RULES_PVT.Update_ScoreCard(
         p_api_version              => p_api_version
       , p_init_msg_list            => p_init_msg_list
       , p_commit                   => p_commit
       , p_validation_level         => p_validation_level
       , p_scorecard_rec            => p_scorecard_rec
       , x_return_status            => x_return_status
       , x_msg_count                => x_msg_count
       , x_msg_data                 => x_msg_data
       );

Line: 291

END Update_ScoreCard;

Line: 295

Procedure Delete_ScoreCard (
    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 := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
    x_return_status           OUT NOCOPY  VARCHAR2,
    x_msg_count               OUT NOCOPY  NUMBER,
    x_msg_data                OUT NOCOPY  VARCHAR2,
    P_SCORECARD_ID            IN NUMBER)
IS

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

Line: 315

      SAVEPOINT DELETE_SCORECARD_PUB;

Line: 347

                   'Public API: Calling AS_SCORECARD_RULES_PVT.Delete_SCORECARD');

Line: 349

      AS_SCORECARD_RULES_PVT.Delete_ScoreCard(
              p_api_version              => p_api_version
            , p_init_msg_list            => p_init_msg_list
            , p_commit                   => p_commit
            , p_validation_level         => p_validation_level
            , p_scorecard_id             => l_scorecard_id
            , x_return_status            => l_return_status
            , x_msg_count                => l_msg_count
            , x_msg_data                 => l_msg_data
            );

Line: 419

END Delete_ScoreCard;

Line: 552

Procedure Update_CardRule_QUAL (
    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 := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
    x_return_status           OUT NOCOPY  VARCHAR2,
    x_msg_count               OUT NOCOPY  NUMBER,
    x_msg_data                OUT NOCOPY  VARCHAR2,
    p_CardRule_Qual_rec       IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE)
IS
    l_api_name                CONSTANT VARCHAR2(30) := 'Update_CARDRULE_QUAL';

Line: 571

      SAVEPOINT UPDATE_CARDRULE_QUAL_PUB;

Line: 604

                   'Public API: Calling AS_SCORECARD_RULES_PVT.Update_CardRule_Qual');

Line: 607

      AS_SCORECARD_RULES_PVT.Update_CardRule_Qual(
         p_api_version              => p_api_version
       , p_init_msg_list            => FND_API.G_FALSE
       , p_commit                   => p_commit
       , p_validation_level         => p_validation_level
       , p_cardrule_qual_rec        => p_cardrule_qual_rec
       , x_return_status            => x_return_status
       , x_msg_count                => x_msg_count
       , x_msg_data                 => x_msg_data
       );

Line: 675

END Update_CardRule_Qual;

Line: 680

Procedure Delete_CardRule_QUAL (
    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 := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
    x_return_status           OUT NOCOPY  VARCHAR2,
    x_msg_count               OUT NOCOPY  NUMBER,
    x_msg_data                OUT NOCOPY  VARCHAR2,
    p_qual_value_id           IN NUMBER)
IS
    l_api_name                CONSTANT VARCHAR2(30) := 'Delete_CARDRULE_QUAL';

Line: 698

      SAVEPOINT DELETE_CARD_RULE_PUB;

Line: 730

                   'Public API: Calling AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual');

Line: 732

      AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual(
         p_api_version              => p_api_version
       , p_init_msg_list            => FND_API.G_FALSE
       , p_commit                   => p_commit
       , p_validation_level         => p_validation_level
       , p_qual_value_id            => p_qual_value_id
       , x_return_status            => x_return_status
       , x_msg_count                => x_msg_count
       , x_msg_data                 => x_msg_data
       );

Line: 800

END Delete_CardRule_Qual;