APPS.AMS_PS_RULE_PUB SQL Statements

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

Line: 160

PROCEDURE Update_Ps_Rule(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,

    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,

    p_ps_rules_rec               IN    ps_rules_rec_type,
    p_ps_filter_tbl              IN    ps_rules_tuple_tbl_type,
    p_ps_strategy_tbl            IN    ps_rules_tuple_tbl_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Ps_Rule';

Line: 184

      SAVEPOINT UPDATE_Ps_Rule_PUB;

Line: 214

    AMS_Ps_Rule_PVT.Update_Ps_Rule(
    p_api_version_number         => 1.0,
    p_init_msg_list              => FND_API.G_FALSE,
    p_commit                     => p_commit,
    p_validation_level           => FND_API.G_VALID_LEVEL_FULL,
    x_return_status              => x_return_status,
    x_msg_count                  => x_msg_count,
    x_msg_data                   => x_msg_data,
    p_ps_rules_rec               =>  l_pvt_ps_rules_rec,
    p_ps_filter_tbl         => l_ps_filter_tbl,
    p_ps_strategy_tbl       => l_ps_strategy_tbl,
    x_object_version_number      => l_object_version_number );

Line: 263

     ROLLBACK TO UPDATE_Ps_Rule_PUB;

Line: 273

     ROLLBACK TO UPDATE_Ps_Rule_PUB;

Line: 283

     ROLLBACK TO UPDATE_Ps_Rule_PUB;

Line: 295

End Update_Ps_Rule;

Line: 298

PROCEDURE Delete_Ps_Rule(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_rule_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Ps_Rule';

Line: 317

      SAVEPOINT DELETE_Ps_Rule_PUB;

Line: 347

    AMS_Ps_Rule_PVT.Delete_Ps_Rule(
    p_api_version_number         => 1.0,
    p_init_msg_list              => FND_API.G_FALSE,
    p_commit                     => p_commit,
    p_validation_level           => FND_API.G_VALID_LEVEL_FULL,
    x_return_status              => x_return_status,
    x_msg_count                  => x_msg_count,
    x_msg_data                   => x_msg_data,
    p_rule_id     => l_rule_id,
    p_object_version_number      => l_object_version_number );

Line: 394

     ROLLBACK TO DELETE_Ps_Rule_PUB;

Line: 404

     ROLLBACK TO DELETE_Ps_Rule_PUB;

Line: 414

     ROLLBACK TO DELETE_Ps_Rule_PUB;

Line: 426

End Delete_Ps_Rule;