APPS.PV_SELCRIT_PUB SQL Statements

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

Line: 25

    X_SELECTION_CRITERIA_ID      OUT NOCOPY  NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Create_selcrit';

Line: 84

         X_SELECTION_CRITERIA_ID      => x_SELECTION_CRITERIA_ID,
         X_Return_Status              => x_return_status,
         X_Msg_Count                  => x_msg_count,
         X_Msg_Data                   => x_msg_data);

Line: 165

PROCEDURE Update_selcrit(
    P_Api_Version_Number         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_Identity_Resource_Id       IN   NUMBER,
    P_SELCRIT_Rec                IN   PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_selcrit';

Line: 182

      SAVEPOINT UPDATE_SELCRIT_PUB;

Line: 222

    PV_selcrit_PVT.Update_selcrit(
       P_Api_Version_Number         => 2.0,
       P_Init_Msg_List              => FND_API.G_FALSE,
       P_Commit                     => p_commit,
       P_Validation_Level           => P_Validation_Level,
       P_Identity_Resource_Id       => P_Identity_Resource_Id,
       P_SELCRIT_Rec                => p_SELCRIT_Rec ,
       X_Return_Status              => x_return_status,
       X_Msg_Count                  => x_msg_count,
       X_Msg_Data                   => x_msg_data);

Line: 303

End Update_selcrit;

Line: 308

PROCEDURE Delete_selcrit(
    P_Api_Version_Number         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_Identity_Resource_Id       IN   NUMBER,
    P_SELCRIT_Rec                IN   PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_selcrit';

Line: 325

      SAVEPOINT DELETE_SELCRIT_PUB;

Line: 365

    PV_selcrit_PVT.Delete_selcrit(
       P_Api_Version_Number         => 2.0,
       P_Init_Msg_List              => FND_API.G_FALSE,
       P_Commit                     => p_commit,
       P_Validation_Level           => p_Validation_Level,
       P_Identity_Resource_Id       => P_Identity_Resource_Id,
       P_SELCRIT_Rec                => p_SELCRIT_Rec,
       X_Return_Status              => x_return_status,
       X_Msg_Count                  => x_msg_count,
       X_Msg_Data                   => x_msg_data);

Line: 447

End Delete_selcrit;