DBA Data[Home] [Help]

APPS.CSC_PROFILE_CHECK_RULES_PUB SQL Statements

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

Line: 36

    x_pvt_chk_rules_rec.LAST_UPDATED_BY := P_chk_rules_rec.LAST_UPDATED_BY;
Line: 37

    x_pvt_chk_rules_rec.LAST_UPDATE_DATE := P_chk_rules_rec.LAST_UPDATE_DATE;
Line: 38

    x_pvt_chk_rules_rec.LAST_UPDATE_LOGIN := P_chk_rules_rec.LAST_UPDATE_LOGIN;
Line: 55

    P_LAST_UPDATED_BY            IN  NUMBER,
    P_LAST_UPDATE_DATE           IN  DATE,
    P_LAST_UPDATE_LOGIN          IN  NUMBER,
    P_LOGICAL_OPERATOR           IN  VARCHAR2,
    P_LEFT_PAREN                 IN  VARCHAR2,
    P_COMPARISON_OPERATOR        IN  VARCHAR2,
    P_EXPRESSION                 IN  VARCHAR2,
    P_EXPR_TO_BLOCK_ID           IN  NUMBER,
    P_RIGHT_PAREN                IN  VARCHAR2,
    P_SEEDED_FLAG                IN  VARCHAR2,
    X_CHK_RULES_Rec		   OUT NOCOPY CHK_RULES_Rec_Type
    )
IS
BEGIN
   X_CHK_RULES_rec.CHECK_ID := P_CHECK_ID;
Line: 80

   X_CHK_RULES_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;
Line: 81

   X_CHK_RULES_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;
Line: 82

   X_CHK_RULES_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;
Line: 95

    P_LAST_UPDATED_BY            IN  NUMBER,
    P_LAST_UPDATE_DATE           IN  DATE,
    P_LAST_UPDATE_LOGIN          IN  NUMBER,
    P_LOGICAL_OPERATOR           IN  VARCHAR2,
    P_LEFT_PAREN                 IN  VARCHAR2,
    P_COMPARISON_OPERATOR        IN  VARCHAR2,
    P_EXPRESSION                 IN  VARCHAR2,
    P_EXPR_TO_BLOCK_ID           IN  NUMBER,
    P_RIGHT_PAREN                IN  VARCHAR2,
    P_SEEDED_FLAG                IN  VARCHAR2,
    X_OBJECT_VERSION_NUMBER      OUT NOCOPY NUMBER,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )
IS
l_CHK_RULES_Rec CHK_RULES_Rec_Type;
Line: 120

    P_LAST_UPDATED_BY      => P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE     => P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN    => P_LAST_UPDATE_LOGIN,
    P_LOGICAL_OPERATOR     => P_LOGICAL_OPERATOR,
    P_LEFT_PAREN           => P_LEFT_PAREN,
    P_COMPARISON_OPERATOR  => P_COMPARISON_OPERATOR,
    P_EXPRESSION           => P_EXPRESSION,
    P_EXPR_TO_BLOCK_ID     => P_EXPR_TO_BLOCK_ID,
    P_RIGHT_PAREN          => P_RIGHT_PAREN,
    P_SEEDED_FLAG          => P_SEEDED_FLAG,
    X_CHK_RULES_Rec	   => l_CHK_RULES_Rec
    );
Line: 254

PROCEDURE Update_profile_check_rules(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_CHECK_ID     		   IN  NUMBER,
    P_BLOCK_ID     		   IN  NUMBER,
    P_SEQUENCE                   IN  NUMBER,
    P_CREATED_BY                 IN  NUMBER,
    P_CREATION_DATE              IN  DATE,
    P_LAST_UPDATED_BY            IN  NUMBER,
    P_LAST_UPDATE_DATE           IN  DATE,
    P_LAST_UPDATE_LOGIN          IN  NUMBER,
    P_LOGICAL_OPERATOR           IN  VARCHAR2,
    P_LEFT_PAREN                 IN  VARCHAR2,
    P_COMPARISON_OPERATOR        IN  VARCHAR2,
    P_EXPRESSION                 IN  VARCHAR2,
    P_EXPR_TO_BLOCK_ID           IN  NUMBER,
    P_RIGHT_PAREN                IN  VARCHAR2,
    P_SEEDED_FLAG                IN  VARCHAR2,
    PX_OBJECT_VERSION_NUMBER     IN OUT NOCOPY NUMBER,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )
IS
l_CHK_RULES_Rec CHK_RULES_Rec_Type;
Line: 288

    P_LAST_UPDATED_BY      => P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE     => P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN    => P_LAST_UPDATE_LOGIN,
    P_LOGICAL_OPERATOR     => P_LOGICAL_OPERATOR,
    P_LEFT_PAREN           => P_LEFT_PAREN,
    P_COMPARISON_OPERATOR  => P_COMPARISON_OPERATOR,
    P_EXPRESSION           => P_EXPRESSION,
    P_EXPR_TO_BLOCK_ID     => P_EXPR_TO_BLOCK_ID,
    P_RIGHT_PAREN          => P_RIGHT_PAREN,
    P_SEEDED_FLAG          => P_SEEDED_FLAG,
    X_CHK_RULES_Rec	   => l_CHK_RULES_Rec
    );
Line: 301

 Update_profile_check_rules(
    P_Api_Version_Number    => P_Api_Version_Number ,
    P_Init_Msg_List         => P_Init_Msg_List,
    P_Commit                => P_Commit,
    P_CHK_RULES_Rec         => l_CHK_RULES_Rec,
    PX_Object_Version_Number  => PX_OBJECT_VERSION_NUMBER,
    X_Return_Status           => X_Return_Status,
    X_Msg_Count               => X_Msg_Count,
    X_Msg_Data                => X_Msg_Data
    );
Line: 312

END Update_profile_check_rules;
Line: 314

PROCEDURE Update_profile_check_rules(
    P_Api_Version_Number         IN    NUMBER,
    P_Init_Msg_List              IN    VARCHAR2,
    P_Commit                     IN    VARCHAR2,
    P_CHK_RULES_Rec       	   IN    CHK_RULES_Rec_Type,
    px_OBJECT_VERSION_NUMBER     IN 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) := 'Update_profile_check_rules';
Line: 331

      SAVEPOINT UPDATE_PROFILE_CHECK_RULES_PUB;
Line: 362

    CSC_profile_check_rules_PVT.Update_profile_check_rules(
    P_Api_Version_Number      => P_Api_Version_Number ,
    P_Init_Msg_List           => P_Init_Msg_List,
    P_Commit                  => P_Commit,
    p_validation_level        => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    P_CHK_RULES_Rec           => l_PVT_CHK_RULES_Rec,
    PX_Object_Version_Number  => PX_OBJECT_VERSION_NUMBER,
    X_Return_Status           => X_Return_Status,
    X_Msg_Count               => X_Msg_Count,
    X_Msg_Data                => X_Msg_Data
    );
Line: 400

    		  ROLLBACK TO Update_profile_check_rules_PUB;
Line: 406

    		  ROLLBACK TO Update_profile_check_rules_PUB;
Line: 412

    		  ROLLBACK TO Update_profile_check_rules_PUB;
Line: 418

End Update_profile_check_rules;
Line: 421

PROCEDURE Delete_profile_check_rules(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_CHECK_ID			 IN   NUMBER,
    p_SEQUENCE                   IN   NUMBER,
    p_OBJECT_VERSION_NUMBER      IN   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) := 'Delete_profile_check_rules';
Line: 439

      SAVEPOINT DELETE_PROFILE_CHECK_RULES_PUB;
Line: 466

    CSC_profile_check_rules_PVT.Delete_profile_check_rules(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    P_CHECK_ID			 => P_CHECK_ID,
    p_SEQUENCE                 => P_SEQUENCE,
    p_OBJECT_VERSION_NUMBER    => p_OBJECT_VERSION_NUMBER,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);
Line: 504

    		  ROLLBACK TO Delete_profile_check_rules_PUB;
Line: 510

    		  ROLLBACK TO Delete_profile_check_rules_PUB;
Line: 516

    		  ROLLBACK TO Delete_profile_check_rules_PUB;
Line: 522

End Delete_profile_check_rules;