APPS.AHL_MC_RULE_PUB SQL Statements

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

Line: 33

PROCEDURE Insert_Rule (
    p_api_version         IN               NUMBER,
    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,
    p_module		  IN               VARCHAR2  := 'JSP',
    p_rule_stmt_tbl       IN               AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
    p_x_rule_rec 	  IN OUT NOCOPY    AHL_MC_RULE_PVT.Rule_Rec_Type,
    x_return_status       OUT    NOCOPY    VARCHAR2,
    x_msg_count           OUT    NOCOPY    NUMBER,
    x_msg_data            OUT    NOCOPY    VARCHAR2
) IS

--
l_api_version  CONSTANT NUMBER       := 1.0;

Line: 48

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

Line: 60

    SAVEPOINT Insert_Rule_Pub;

Line: 117

    AHL_MC_RULE_PVT.Insert_Rule(
        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_module              => p_module,
        p_rule_stmt_tbl       => l_rule_stmt_tbl,
        p_x_rule_rec          => p_x_rule_rec,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data
    );

Line: 162

        Rollback to Insert_Rule_Pub;

Line: 169

        Rollback to Insert_Rule_Pub;

Line: 176

        Rollback to Insert_Rule_Pub;

Line: 185

END Insert_Rule;

Line: 201

PROCEDURE Update_Rule (
    p_api_version         IN            NUMBER,
    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,
    p_module		  IN            VARCHAR2  := 'JSP',
    p_rule_rec            IN            AHL_MC_RULE_PVT.Rule_Rec_Type,
    p_rule_stmt_tbl       IN            AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
    x_return_status       OUT    NOCOPY VARCHAR2,
    x_msg_count           OUT    NOCOPY NUMBER,
    x_msg_data            OUT    NOCOPY VARCHAR2
) IS

--
l_api_version  CONSTANT NUMBER       := 1.0;

Line: 216

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

Line: 229

    SAVEPOINT Update_Rule_Pub;

Line: 293

    AHL_MC_RULE_PVT.Update_Rule(
        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_module              => p_module,
        p_rule_rec            => l_rule_rec,
        p_rule_stmt_tbl       => l_rule_stmt_tbl,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data
    );

Line: 338

        Rollback to Update_Rule_Pub;

Line: 345

        Rollback to Update_Rule_Pub;

Line: 352

        Rollback to Update_Rule_Pub;

Line: 361

END Update_Rule;

Line: 384

PROCEDURE Delete_Rule (
    p_api_version         IN             NUMBER,
    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,
    p_rule_rec            IN             AHL_MC_RULE_PVT.Rule_Rec_Type,
    x_return_status       OUT    NOCOPY  VARCHAR2,
    x_msg_count           OUT    NOCOPY  NUMBER,
    x_msg_data            OUT    NOCOPY  VARCHAR2
) IS

--
l_api_version  CONSTANT NUMBER       := 1.0;

Line: 397

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

Line: 409

    SAVEPOINT Delete_Rule_Pub;

Line: 460

    AHL_MC_RULE_PVT.Delete_Rule(
        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_rule_rec            => l_rule_rec,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data
    );

Line: 503

        Rollback to Delete_Rule_Pub;

Line: 510

        Rollback to Delete_Rule_Pub;

Line: 517

        Rollback to Delete_Rule_Pub;

Line: 526

END Delete_Rule;

Line: 566

    SELECT 'X'
    FROM   AHL_MC_HEADERS_B
    WHERE  mc_header_id = p_mc_header_id;

Line: 571

    SELECT mc_header_id
    FROM   AHL_MC_HEADERS_B
    WHERE  name     = p_mc_name
    AND    revision = p_revision;

Line: 802

PROCEDURE Delete_Rules_For_MC (
    p_api_version         IN           NUMBER,
    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,
    p_mc_header_id	  IN 	       NUMBER,
    p_mc_name             IN           VARCHAR2,
    p_revision              IN           VARCHAR2,
    x_return_status       OUT  NOCOPY  VARCHAR2,
    x_msg_count           OUT  NOCOPY  NUMBER,
    x_msg_data            OUT  NOCOPY  VARCHAR2
) IS

CURSOR chk_mc_header_id_csr (p_mc_header_id NUMBER) IS
    SELECT 'X'
    FROM   AHL_MC_HEADERS_B
    WHERE  mc_header_id = p_mc_header_id;

Line: 821

    SELECT mc_header_id
    FROM   AHL_MC_HEADERS_B
    WHERE  name     = p_mc_name
    AND    revision = p_revision;

Line: 827

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

Line: 840

    SAVEPOINT Delete_Rules_For_MC_Pub;

Line: 917

    AHL_MC_RULE_PVT.Delete_Rules_For_MC(
        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_mc_header_id        => l_mc_header_id,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data
    );

Line: 960

        Rollback to Delete_Rules_For_MC_Pub;

Line: 967

        Rollback to Delete_Rules_For_MC_Pub;

Line: 974

        Rollback to Delete_Rules_For_MC_Pub;

Line: 983

END Delete_Rules_For_MC;

Line: 1021

    SELECT 'X'
    FROM   AHL_MC_HEADERS_B
    WHERE  mc_header_id = p_mc_header_id;

Line: 1026

    SELECT mc_header_id
    FROM   AHL_MC_HEADERS_B
    WHERE  name     = p_mc_name
    AND    revision = p_revision;

Line: 1223

    SELECT 'X'
    FROM   AHL_MC_HEADERS_B
    WHERE  mc_header_id = p_mc_header_id;

Line: 1228

    SELECT mc_header_id
    FROM   AHL_MC_HEADERS_B
    WHERE  name     = p_mc_name
    AND    revision = p_revision;

Line: 1234

    SELECT 'X'
    FROM   AHL_MC_RULES_B
    WHERE  rule_id = p_rule_id;

Line: 1239

    SELECT rule_id
    FROM   AHL_MC_RULES_B
    WHERE  rule_name    = p_rule_name
    AND    mc_header_id = p_mc_header_id;

Line: 1245

    SELECT 'X'
    FROM   FND_LOOKUPS
    WHERE  lookup_type = p_lookup_type
    AND    lookup_code = p_lookup_code;

Line: 1482

    SELECT 'X'
    FROM   MTL_SYSTEM_ITEMS_B KFV
    WHERE  inventory_item_id = p_item_id
    AND    EXISTS
           (SELECT 'X'
            FROM   MTL_PARAMETERS MP
            WHERE  MP.master_organization_id = KFV.organization_id
            AND    MP.eam_enabled_flag       = 'Y');

Line: 1492

    SELECT inventory_item_id
    FROM   MTL_SYSTEM_ITEMS_KFV KFV
    WHERE  concatenated_segments = p_item_name
    AND    EXISTS
           (SELECT 'X'
            FROM   MTL_PARAMETERS MP
            WHERE  MP.master_organization_id = KFV.organization_id
            AND    MP.eam_enabled_flag       = 'Y');

Line: 1502

    SELECT 'X'
    FROM   AHL_MC_HEADERS_B
    WHERE  mc_id = p_mc_id;

Line: 1507

    SELECT mc_id
    FROM   AHL_MC_HEADERS_B
    WHERE  name = p_mc_name;

Line: 1512

    SELECT 'X'
    FROM   AHL_MC_RULE_STATEMENTS
    WHERE  rule_statement_id = p_rule_stmt_id;

Line: 1517

    SELECT 'X'
    FROM   FND_LOOKUPS
    WHERE  lookup_type = p_lookup_type
    AND    lookup_code = p_lookup_code;