eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROFILE_CHECK_PUB SQL Statements

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

Line: 26


    x_pvt_Check_rec.SELECT_TYPE := P_Check_Rec.SELECT_TYPE;

Line: 27


    x_pvt_Check_rec.SELECT_BLOCK_ID := P_Check_Rec.SELECT_BLOCK_ID;

Line: 37


    x_pvt_Check_rec.LAST_UPDATED_BY := P_Check_Rec.LAST_UPDATED_BY;

Line: 38


    x_pvt_Check_rec.LAST_UPDATE_DATE := P_Check_Rec.LAST_UPDATE_DATE;

Line: 39


    x_pvt_Check_rec.LAST_UPDATE_LOGIN := P_Check_Rec.LAST_UPDATE_LOGIN;

Line: 53


    p_SELECT_TYPE                IN   VARCHAR2,
    p_SELECT_BLOCK_ID            IN   NUMBER,
    p_DATA_TYPE                  IN   VARCHAR2,
    p_FORMAT_MASK                IN   VARCHAR2,
    p_THRESHOLD_GRADE            IN   VARCHAR2,
    p_THRESHOLD_RATING_CODE      IN   VARCHAR2,
    p_CHECK_UPPER_LOWER_FLAG     IN   VARCHAR2,
    p_THRESHOLD_COLOR_CODE       IN   VARCHAR2,
    p_CHECK_LEVEL                IN   VARCHAR2,
    -- p_CATEGORY_CODE              IN   VARCHAR2 := FND_API.G_MISS_CHAR,
    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_OBJECT_VERSION_NUMBER      IN   NUMBER DEFAULT NULL,
    p_APPLICATION_ID             IN   NUMBER,
    X_Check_Rec     		   OUT NOCOPY   Check_Rec_Type
    )
IS
BEGIN
    X_Check_Rec.CHECK_ID    := p_CHECK_ID;

Line: 81


    X_Check_Rec.SELECT_TYPE  := p_SELECT_TYPE;

Line: 82


    X_Check_Rec.SELECT_BLOCK_ID  := p_SELECT_BLOCK_ID;

Line: 93


    X_Check_Rec.LAST_UPDATED_BY := p_LAST_UPDATED_BY;

Line: 94


    X_Check_Rec.LAST_UPDATE_DATE := p_LAST_UPDATE_DATE;

Line: 95


    X_Check_Rec.LAST_UPDATE_LOGIN :=  p_LAST_UPDATE_LOGIN;

Line: 110


    p_SELECT_TYPE                IN   VARCHAR2,
    p_SELECT_BLOCK_ID            IN   NUMBER,
    p_DATA_TYPE                  IN   VARCHAR2,
    p_FORMAT_MASK                IN   VARCHAR2,
    p_THRESHOLD_GRADE            IN   VARCHAR2,
    p_THRESHOLD_RATING_CODE      IN   VARCHAR2,
    p_CHECK_UPPER_LOWER_FLAG     IN   VARCHAR2,
    p_THRESHOLD_COLOR_CODE       IN   VARCHAR2,
    p_CHECK_LEVEL                IN   VARCHAR2,
    --p_CATEGORY_CODE              IN   VARCHAR2 := FND_API.G_MISS_CHAR,
    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,
    X_OBJECT_VERSION_NUMBER      OUT NOCOPY   NUMBER,
    p_APPLICATION_ID             IN   NUMBER,
    X_CHECK_ID     		   OUT NOCOPY  NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS
  l_Check_Rec     Check_Rec_Type;

Line: 142


    p_SELECT_TYPE             => p_SELECT_TYPE,
    p_SELECT_BLOCK_ID         => p_SELECT_BLOCK_ID,
    p_DATA_TYPE               => p_DATA_TYPE,
    p_FORMAT_MASK             => p_FORMAT_MASK,
    p_THRESHOLD_GRADE         => p_THRESHOLD_GRADE,
    p_THRESHOLD_RATING_CODE   => p_THRESHOLD_RATING_CODE,
    p_CHECK_UPPER_LOWER_FLAG  => p_CHECK_UPPER_LOWER_FLAG,
    p_THRESHOLD_COLOR_CODE    => p_THRESHOLD_COLOR_CODE,
    p_CHECK_LEVEL             => p_CHECK_LEVEL,
    -- p_CATEGORY_CODE        => p_CATEGORY_CODE
    p_CREATED_BY              => p_CREATED_BY,
    p_CREATION_DATE           => p_CREATION_DATE,
    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_APPLICATION_ID          => p_APPLICATION_ID,
    X_Check_Rec	              => l_Check_rec
    );

Line: 287


PROCEDURE Update_Profile_Check(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_CHECK_ID     		   IN   NUMBER,
    p_CHECK_NAME                 IN   VARCHAR2,
    p_CHECK_NAME_CODE            IN   VARCHAR2,
    p_DESCRIPTION                IN   VARCHAR2,
    p_START_DATE_ACTIVE          IN   DATE,
    p_END_DATE_ACTIVE            IN   DATE,
    p_SEEDED_FLAG                IN   VARCHAR2,
    p_SELECT_TYPE                IN   VARCHAR2,
    p_SELECT_BLOCK_ID            IN   NUMBER,
    p_DATA_TYPE                  IN   VARCHAR2,
    p_FORMAT_MASK                IN   VARCHAR2,
    p_THRESHOLD_GRADE            IN   VARCHAR2,
    p_THRESHOLD_RATING_CODE      IN   VARCHAR2,
    p_CHECK_UPPER_LOWER_FLAG     IN   VARCHAR2,
    p_THRESHOLD_COLOR_CODE       IN   VARCHAR2,
    p_CHECK_LEVEL                IN   VARCHAR2,
    -- p_CATEGORY_CODE              IN   VARCHAR2 := FND_API.G_MISS_CHAR,
    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,
    px_OBJECT_VERSION_NUMBER      IN OUT NOCOPY  NUMBER ,
    p_APPLICATION_ID             IN   NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS
 l_Check_Rec   Check_Rec_Type;

Line: 331


    p_SELECT_TYPE             => p_SELECT_TYPE,
    p_SELECT_BLOCK_ID         => p_SELECT_BLOCK_ID,
    p_DATA_TYPE               => p_DATA_TYPE,
    p_FORMAT_MASK             => p_FORMAT_MASK,
    p_THRESHOLD_GRADE         => p_THRESHOLD_GRADE,
    p_THRESHOLD_RATING_CODE   => p_THRESHOLD_RATING_CODE,
    p_CHECK_UPPER_LOWER_FLAG  => p_CHECK_UPPER_LOWER_FLAG,
    p_THRESHOLD_COLOR_CODE    => p_THRESHOLD_COLOR_CODE,
    p_CHECK_LEVEL             => p_CHECK_LEVEL,
    -- p_CATEGORY_CODE        => p_CATEGORY_CODE
    p_CREATED_BY              => p_CREATED_BY,
    p_CREATION_DATE           => p_CREATION_DATE,
    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_OBJECT_VERSION_NUMBER   =>px_OBJECT_VERSION_NUMBER,
    p_APPLICATION_ID          => p_APPLICATION_ID,
    X_Check_Rec		      => l_Check_rec
    );

Line: 352


   Update_Profile_check(
    P_Api_Version_Number => P_Api_Version_Number,
    P_Init_Msg_List    => P_Init_Msg_List,
    P_Commit           => P_Commit,
    P_Check_Rec        => l_Check_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: 366


PROCEDURE Update_Profile_Check(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_CHECK_Rec     IN    CHECK_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_check';

Line: 384


      SAVEPOINT UPDATE_CHECK_PUB;

Line: 416


    CSC_Profile_check_PVT.Update_Profile_check(
    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,
    P_CHECK_Rec  		=>  l_pvt_CHECK_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: 454


    		ROLLBACK TO Update_Profile_Check_PUB;

Line: 461


    		ROLLBACK TO Update_Profile_Check_PUB;

Line: 468


    		ROLLBACK TO Update_Profile_Check_PUB;

Line: 477


End Update_Profile_check;

Line: 479


PROCEDURE Delete_Profile_check(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_Check_Id			   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';

Line: 495


      SAVEPOINT DELETE_CHECK_PUB;

Line: 521


    CSC_Profile_check_PVT.Delete_Profile_check(
    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,
    P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
    P_CHECK_Id  			   => p_CHECK_Id,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 559


    		ROLLBACK TO Delete_Profile_Check_PUB;

Line: 566


    		ROLLBACK TO Delete_Profile_Check_PUB;

Line: 573


    		ROLLBACK TO Delete_Profile_Check_PUB;

Line: 582


End Delete_Profile_check;