DBA Data[Home] [Help]

APPS.CSC_GROUP_CHECKS_PUB SQL Statements

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

Line: 26

    P_LAST_UPDATED_BY          IN     NUMBER,
    P_LAST_UPDATE_DATE         IN     DATE,
    P_LAST_UPDATE_LOGIN        IN     NUMBER,
    X_GROUP_CHK_Rec     	OUT NOCOPY    GROUP_CHK_Rec_Type
    )
   IS
BEGIN
    X_GROUP_CHK_Rec.GROUP_ID              :=  P_GROUP_ID;
Line: 44

    X_GROUP_CHK_Rec.LAST_UPDATED_BY       := P_LAST_UPDATED_BY;
Line: 45

    X_GROUP_CHK_Rec.LAST_UPDATE_DATE      := P_LAST_UPDATE_DATE;
Line: 46

    X_GROUP_CHK_Rec.LAST_UPDATE_LOGIN     := P_LAST_UPDATE_LOGIN;
Line: 68

    X_PVT_GROUP_CHK_Rec.LAST_UPDATED_BY       := P_GROUP_CHK_Rec.LAST_UPDATED_BY;
Line: 69

    X_PVT_GROUP_CHK_Rec.LAST_UPDATE_DATE      := P_GROUP_CHK_Rec.LAST_UPDATE_DATE;
Line: 70

    X_PVT_GROUP_CHK_Rec.LAST_UPDATE_LOGIN     := P_GROUP_CHK_Rec.LAST_UPDATE_LOGIN;
Line: 92

    P_LAST_UPDATED_BY          IN     NUMBER,
    P_LAST_UPDATE_DATE         IN     DATE,
    P_LAST_UPDATE_LOGIN        IN     NUMBER,
    X_Return_Status           OUT NOCOPY  VARCHAR2,
    X_Msg_Count               OUT NOCOPY  NUMBER,
    X_Msg_Data                OUT NOCOPY  VARCHAR2
    )
  IS
 l_group_Chk_Rec Group_chk_Rec_Type;
Line: 115

    P_LAST_UPDATED_BY         => P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE        => P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN       => P_LAST_UPDATE_LOGIN,
    X_GROUP_CHK_Rec     	=> l_GROUP_CHK_Rec
    );
Line: 246

PROCEDURE Update_group_checks(
    P_Api_Version_Number      IN   NUMBER,
    P_Init_Msg_List           IN   VARCHAR2,
    P_Commit                  IN   VARCHAR2,
    p_validation_level        IN   NUMBER,
    P_GROUP_ID                 IN     NUMBER,
    P_CHECK_ID                 IN     NUMBER,
    P_CHECK_SEQUENCE           IN     NUMBER,
    P_END_DATE_ACTIVE          IN     DATE,
    P_START_DATE_ACTIVE        IN     DATE,
    P_CATEGORY_CODE            IN     VARCHAR2,
    P_CATEGORY_SEQUENCE        IN     NUMBER,
    P_THRESHOLD_FLAG           IN     VARCHAR2,
    P_SEEDED_FLAG              IN     VARCHAR2,
    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_Return_Status           OUT NOCOPY  VARCHAR2,
    X_Msg_Count               OUT NOCOPY  NUMBER,
    X_Msg_Data                OUT NOCOPY  VARCHAR2
    )
  IS
l_GROUP_CHK_rec    GROUP_CHK_Rec_Type;
Line: 285

    P_LAST_UPDATED_BY         => P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE        => P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN       => P_LAST_UPDATE_LOGIN,
    X_GROUP_CHK_Rec     	=> l_GROUP_CHK_Rec
    );
Line: 291

  Update_group_checks(
      P_Api_Version_Number         => P_Api_Version_Number,
      P_Init_Msg_List              => CSC_CORE_UTILS_PVT.G_FALSE,
      P_Commit                     => CSC_CORE_UTILS_PVT.G_FALSE,
      P_GROUP_CHK_Rec     	     => l_Group_Chk_Rec,
      X_Return_Status              => x_return_status,
      X_Msg_Count                  => x_msg_count,
      X_Msg_Data                   => x_msg_data);
Line: 301

 END Update_group_checks;
Line: 304

PROCEDURE Update_group_checks(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_GROUP_CHK_Rec     IN    GROUP_CHK_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_group_checks';
Line: 320

      SAVEPOINT UPDATE_GROUP_CHECKS_PUB;
Line: 351

    	CSC_group_checks_PVT.Update_group_checks(
    	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_GROUP_CHK_Rec  =>  l_pvt_GROUP_CHK_Rec ,
    	X_Return_Status              => x_return_status,
    	X_Msg_Count                  => x_msg_count,
    	X_Msg_Data                   => x_msg_data);
Line: 389

    		ROLLBACK TO Update_group_checks_PUB;
Line: 396

    		ROLLBACK TO Update_group_checks_PUB;
Line: 403

    		ROLLBACK TO Update_group_checks_PUB;
Line: 412

End Update_group_checks;
Line: 415

PROCEDURE Delete_group_checks(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_GROUP_ID     		   IN   NUMBER,
    P_CHECK_ID			   IN   NUMBER,
    P_CHECK_SEQUENCE			   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_group_checks';
Line: 433

      SAVEPOINT DELETE_GROUP_CHECKS_PUB;
Line: 460

    CSC_group_checks_PVT.Delete_group_checks(
    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_GROUP_ID     		   => P_GROUP_ID,
    P_CHECK_ID			   => P_CHECK_ID,
    P_CHECK_SEQUENCE		   => P_CHECK_SEQUENCE,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);
Line: 499

    		ROLLBACK TO Delete_group_checks_PUB;
Line: 506

    		ROLLBACK TO Delete_group_checks_PUB;
Line: 513

    		ROLLBACK TO Delete_group_checks_PUB;
Line: 522

End Delete_group_checks;