APPS.IGC_CC_MC_HEADERS_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_HEADERS.CC_Header_Id%TYPE,
                       p_Set_Of_Books_Id                 IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
                       p_Conversion_Type                 IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
                       p_Conversion_Date                 IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
                       p_Conversion_Rate                 IGC_CC_MC_HEADERS.Conversion_Rate%TYPE
                      )


 IS

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

Line: 33

    CURSOR C IS SELECT Rowid FROM IGC_CC_MC_HEADERS
                 WHERE CC_Header_id = p_CC_Header_id;

Line: 38

       SAVEPOINT Insert_Row_Pvt ;

Line: 55

       INSERT INTO IGC_CC_MC_HEADERS (
                       CC_Header_Id,
                       Set_Of_Books_Id,
		       Conversion_Type,
		       Conversion_Date,
		       Conversion_Rate

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

Line: 89

    ROLLBACK TO Insert_Row_Pvt ;

Line: 96

    ROLLBACK TO Insert_Row_Pvt ;

Line: 103

    ROLLBACK TO Insert_Row_Pvt ;

Line: 114

  END Insert_Row;

Line: 141

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

Line: 171

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

Line: 245

                         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_HEADERS.CC_Header_Id%TYPE,
                       p_Set_Of_Books_Id                 IGC_CC_MC_HEADERS.Set_Of_Books_Id%TYPE,
                       p_Conversion_Type                 IGC_CC_MC_HEADERS.Conversion_Type%TYPE,
                       p_Conversion_Date                 IGC_CC_MC_HEADERS.Conversion_Date%TYPE,
                       p_Conversion_Rate                 IGC_CC_MC_HEADERS.Conversion_Rate%TYPE

  ) IS

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

Line: 270

    SAVEPOINT Update_Row_Pvt ;

Line: 287

    UPDATE IGC_CC_MC_HEADERS
    SET
                       CC_Header_Id                 =      p_CC_Header_Id,
                       Set_Of_Books_Id              =      p_Set_Of_Books_Id,
		       Conversion_Type              =      p_Conversion_Type,
		       Conversion_Date              =      p_Conversion_Date,
		       Conversion_Rate              =      p_Conversion_Rate
    WHERE rowid = p_Rowid;

Line: 311

    ROLLBACK TO Update_Row_Pvt ;

Line: 318

    ROLLBACK TO Update_Row_Pvt ;

Line: 325

    ROLLBACK TO Update_Row_Pvt ;

Line: 336

  END Update_Row;

Line: 339

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

  SAVEPOINT Delete_Row_Pvt ;

Line: 379

  DELETE
    FROM IGC_CC_MC_HEADERS
   WHERE rowid = p_Rowid;

Line: 398

    ROLLBACK TO Delete_Row_Pvt ;

Line: 405

    ROLLBACK TO Delete_Row_Pvt ;

Line: 412

    ROLLBACK TO Delete_Row_Pvt ;

Line: 424

  END Delete_Row;