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_GROUP_CHECKS_PVT SQL Statements

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

Line: 28


    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: 47


    X_GROUP_CHK_Rec.LAST_UPDATED_BY       := P_LAST_UPDATED_BY;

Line: 48


    X_GROUP_CHK_Rec.LAST_UPDATE_DATE      := P_LAST_UPDATE_DATE;

Line: 49


    X_GROUP_CHK_Rec.LAST_UPDATE_LOGIN     := P_LAST_UPDATE_LOGIN;

Line: 69


    P_LAST_UPDATED_BY          IN     NUMBER,
    P_LAST_UPDATE_DATE         IN     DATE,
    P_LAST_UPDATE_LOGIN        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_group_Chk_Rec Group_chk_Rec_Type;

Line: 93


    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: 176


      CSC_PROF_GROUP_CHECKS_PKG.Insert_Row(
          p_GROUP_ID  => p_GROUP_CHK_rec.GROUP_ID,
          p_CHECK_ID  => p_GROUP_CHK_rec.CHECK_ID,
          P_CHECK_SEQUENCE  => p_GROUP_CHK_rec.CHECK_SEQUENCE,
          p_END_DATE_ACTIVE  => p_GROUP_CHK_rec.END_DATE_ACTIVE,
          p_START_DATE_ACTIVE  => p_GROUP_CHK_rec.START_DATE_ACTIVE,
          p_CATEGORY_CODE  => p_GROUP_CHK_rec.CATEGORY_CODE,
          p_CATEGORY_SEQUENCE  => p_GROUP_CHK_rec.CATEGORY_SEQUENCE,
          p_THRESHOLD_FLAG  => p_GROUP_CHK_rec.THRESHOLD_FLAG,
	  p_CRITICAL_FLAG  => p_GROUP_CHK_rec.CRITICAL_FLAG,
          p_SEEDED_FLAG     => p_GROUP_CHK_rec.SEEDED_FLAG,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID);

Line: 242


PROCEDURE Update_group_checks(
    P_Api_Version_Number      IN   NUMBER,
    P_Init_Msg_List           IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                  IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level        IN   NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    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 DEFAULT NULL,
    P_CATEGORY_SEQUENCE        IN     NUMBER DEFAULT NULL ,
    P_THRESHOLD_FLAG           IN     VARCHAR2,
    P_CRITICAL_FLAG            IN     VARCHAR2,
    P_SEEDED_FLAG              IN     VARCHAR2 DEFAULT NULL,
    P_CREATED_BY               IN     NUMBER DEFAULT NULL,
    P_CREATION_DATE            IN     DATE DEFAULT NULL,
    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: 283


    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: 288


  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_Validation_Level           => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
      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: 299


 END Update_group_checks;

Line: 304


PROCEDURE Update_group_checks(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN  NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    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

Cursor C_Get_group_checks(c_GROUP_ID Number, C_CHECK_ID NUMBER) IS
    Select rowid,
           GROUP_ID,
           CHECK_ID,
           CHECK_SEQUENCE,
           END_DATE_ACTIVE,
           START_DATE_ACTIVE,
           CATEGORY_CODE,
           CATEGORY_SEQUENCE,
           THRESHOLD_FLAG,
	   CRITICAL_FLAG,
           SEEDED_FLAG,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN
    From  CSC_PROF_GROUP_CHECKS
    Where GROUP_ID  = c_GROUP_ID
    And   CHECK_ID = c_CHECK_ID
    For Update NOWAIT;

Line: 339


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

Line: 346


      SAVEPOINT UPDATE_GROUP_CHECKS_PVT;

Line: 389


               l_old_GROUP_CHK_rec.LAST_UPDATED_BY,
               l_old_GROUP_CHK_rec.LAST_UPDATE_DATE,
               l_old_GROUP_CHK_rec.LAST_UPDATE_LOGIN;

Line: 411


              p_validation_mode  => CSC_CORE_UTILS_PVT.G_UPDATE,
              P_GROUP_CHK_Rec  =>  P_GROUP_CHK_rec,
              x_return_status    => x_return_status,
              x_msg_count        => x_msg_count,
              x_msg_data         => x_msg_data);

Line: 422


      CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
          p_GROUP_ID  =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
          p_CHECK_ID  =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
          p_CHECK_SEQUENCE  =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
          p_END_DATE_ACTIVE  =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
          p_START_DATE_ACTIVE  =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
          p_CATEGORY_CODE  => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
          p_CATEGORY_SEQUENCE  =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
          p_THRESHOLD_FLAG  =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
	  p_CRITICAL_FLAG  =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),
          p_SEEDED_FLAG     =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID);

Line: 456


    		ROLLBACK TO Update_group_checks_PVT;

Line: 464


    		ROLLBACK TO Update_group_checks_PVT;

Line: 472


    		ROLLBACK TO Update_group_checks_PVT;

Line: 480


End Update_group_checks;

Line: 483


PROCEDURE Delete_group_checks(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN   NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    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: 500


      SAVEPOINT DELETE_GROUP_CHECKS_PVT;

Line: 528


       CSC_PROF_GROUP_CHECKS_PKG.Delete_Row(
           p_GROUP_ID  => p_GROUP_ID,
	     P_CHECK_ID  => P_CHECK_ID,
	     p_CHECK_SEQUENCE  => p_CHECK_SEQUENCE );

Line: 552


    		ROLLBACK TO Delete_group_checks_PVT;

Line: 560


    		ROLLBACK TO Delete_group_checks_PVT;

Line: 568


    		ROLLBACK TO Delete_group_checks_PVT;

Line: 576


End Delete_group_checks;

Line: 590


CURSOR C1 IS SELECT NULL
		 FROM csc_prof_groups_b
		 WHERE group_id = p_GROUP_ID;

Line: 634


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_GROUP_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 673


CURSOR C1 IS SELECT NULL
		 FROM csc_prof_checks_b
		 WHERE check_id = p_CHECK_ID;

Line: 718


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CHECK_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 787


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CHECK_SEQUENCE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 850


CURSOR C1 IS SELECT NULL
		 FROM csc_prof_group_Checks
		 WHERE check_id = p_CHECK_ID
		 AND category_sequence = p_CATEGORY_SEQUENCE;

Line: 874


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;