APPS.IGC_CC_MC_HEADER_HST_PKG SQL Statements

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

Line: 8

                         PROCEDURE Insert_Row
   ===============================================================================*/

  PROCEDURE Insert_Row(
                       p_api_version               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,
                       X_return_status             OUT NOCOPY   VARCHAR2,
                       X_msg_count                 OUT NOCOPY   NUMBER,
                       X_msg_data                  OUT NOCOPY   VARCHAR2,
                       p_Rowid                  IN OUT NOCOPY   VARCHAR2,
                       p_CC_Header_Id                    IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
                       p_Set_Of_Books_Id                 IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
                       p_cc_version_num                  IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
                       p_cc_version_action               IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
                       p_Conversion_Type                 IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
                       p_Conversion_Date                 IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
                       p_Conversion_Rate                 IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
                      )

 IS

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

Line: 35

          IS SELECT Rowid
             FROM   IGC_CC_MC_HEADER_HISTORY
             WHERE  CC_Header_id = p_CC_Header_id;

Line: 41

       SAVEPOINT Insert_Row_Pvt ;

Line: 64

       INSERT INTO IGC_CC_MC_HEADER_HISTORY (
                           CC_Header_Id,
                           Set_Of_Books_Id,
                           cc_version_num,
                           cc_version_action,
		           Conversion_Type,
		           Conversion_Date,
		           Conversion_Rate

             ) VALUES (
                           p_CC_Header_Id,
                           p_Set_Of_Books_Id,
                           p_cc_version_num,
                           p_cc_version_action,
		           p_Conversion_Type,
		           p_Conversion_Date,
		           p_Conversion_Rate
             );

Line: 115

       ROLLBACK TO Insert_Row_Pvt ;

Line: 126

       ROLLBACK TO Insert_Row_Pvt ;

Line: 137

       ROLLBACK TO Insert_Row_Pvt ;

Line: 151

  END Insert_Row;

Line: 180

        SELECT *
        FROM   IGC_CC_MC_HEADER_HISTORY
        WHERE  rowid = p_Rowid
        FOR UPDATE of CC_Header_Id NOWAIT;

Line: 210

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 290

                         PROCEDURE Update_Row
   ===============================================================================*/

  PROCEDURE Update_Row(
                       p_api_version               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,
                       X_return_status             OUT NOCOPY   VARCHAR2,
                       X_msg_count                 OUT NOCOPY   NUMBER,
                       X_msg_data                  OUT NOCOPY   VARCHAR2,
                       p_Rowid                  IN OUT NOCOPY   VARCHAR2,
                       p_CC_Header_Id                    IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
                       p_Set_Of_Books_Id                 IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
                       p_cc_version_num                  IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
                       p_cc_version_action               IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
                       p_Conversion_Type                 IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
                       p_Conversion_Date                 IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
                       p_Conversion_Rate                 IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
  ) IS

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

Line: 316

    SAVEPOINT Update_Row_Pvt ;

Line: 333

    UPDATE IGC_CC_MC_HEADER_HISTORY
    SET
                       CC_Header_Id                 =      p_CC_Header_Id,
                       Set_Of_Books_Id              =      p_Set_Of_Books_Id,
                       cc_version_num               =      p_cc_version_num,
                       cc_version_action            =      p_cc_version_action,
		       Conversion_Type              =      p_Conversion_Type,
		       Conversion_Date              =      p_Conversion_Date,
		       Conversion_Rate              =      p_Conversion_Rate
    WHERE rowid = p_Rowid;

Line: 358

    ROLLBACK TO Update_Row_Pvt ;

Line: 365

    ROLLBACK TO Update_Row_Pvt ;

Line: 372

    ROLLBACK TO Update_Row_Pvt ;

Line: 383

  END Update_Row;

Line: 386

                         PROCEDURE Delete_Row
   ===============================================================================*/

 PROCEDURE Delete_Row(
  p_api_version               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,
  X_return_status             OUT NOCOPY      VARCHAR2,
  X_msg_count                 OUT NOCOPY      NUMBER,
  X_msg_data                  OUT NOCOPY      VARCHAR2,
  p_Rowid                   IN OUT NOCOPY     VARCHAR2

 ) IS

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

Line: 409

  SAVEPOINT Delete_Row_Pvt ;

Line: 426

  DELETE FROM IGC_CC_MC_HEADER_HISTORY
  WHERE rowid = p_Rowid;

Line: 444

    ROLLBACK TO Delete_Row_Pvt ;

Line: 451

    ROLLBACK TO Delete_Row_Pvt ;

Line: 458

    ROLLBACK TO Delete_Row_Pvt ;

Line: 470

  END Delete_Row;