APPS.IGC_CC_MC_DET_PF_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_DET_PF_Line_Id               IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
               p_Set_Of_Books_Id                 IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
               p_CC_DET_PF_Func_Amt              IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
               p_CC_DET_PF_Encmbrnc_Amt          IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
               p_Conversion_Type                 IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
               p_Conversion_Date                 IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
               p_Conversion_Rate                 IGC_CC_MC_DET_PF.Conversion_Rate%TYPE

              )

 IS

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

Line: 35

  CURSOR C IS SELECT Rowid FROM IGC_CC_MC_DET_PF
               WHERE CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id;

Line: 40

     SAVEPOINT Insert_Row_Pvt ;

Line: 57

     INSERT INTO IGC_CC_MC_DET_PF (
               CC_DET_PF_Line_Id,
               Set_Of_Books_Id,
               CC_DET_PF_Func_Amt,
               CC_DET_PF_Encmbrnc_Amt,
               Conversion_Type,
               Conversion_Date,
               Conversion_Rate
           ) VALUES (
               p_CC_DET_PF_Line_Id,
               p_Set_Of_Books_Id,
               p_CC_DET_PF_Func_Amt,
               p_CC_DET_PF_Encmbrnc_Amt,
               p_Conversion_Type,
               p_Conversion_Date,
               p_Conversion_Rate
         );

Line: 94

  ROLLBACK TO Insert_Row_Pvt ;

Line: 101

  ROLLBACK TO Insert_Row_Pvt ;

Line: 108

  ROLLBACK TO Insert_Row_Pvt ;

Line: 119

END Insert_Row;

Line: 148

      SELECT *
      FROM   IGC_CC_MC_DET_PF
      WHERE  rowid = p_Rowid
      FOR UPDATE of CC_DET_PF_Line_Id NOWAIT;

Line: 178

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

Line: 258

                       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_DET_PF_Line_Id               IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
                p_Set_Of_Books_Id                 IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
                p_CC_DET_PF_Func_Amt              IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
                p_CC_DET_PF_Encmbrnc_Amt          IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
                p_Conversion_Type                 IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
                p_Conversion_Date                 IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
                p_Conversion_Rate                 IGC_CC_MC_DET_PF.Conversion_Rate%TYPE

) IS

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

Line: 285

  SAVEPOINT Update_Row_Pvt ;

Line: 302

  UPDATE IGC_CC_MC_DET_PF
  SET
                     CC_DET_PF_Line_Id            =      p_CC_DET_PF_Line_Id,
                     Set_Of_Books_Id              =      p_Set_Of_Books_Id,
		     CC_DET_PF_Func_Amt           =      p_CC_DET_PF_Func_Amt,
                     CC_DET_PF_Encmbrnc_Amt       =      p_CC_DET_PF_Encmbrnc_Amt,
                     Conversion_Type              =      p_Conversion_Type,
		     Conversion_Date              =      p_Conversion_Date,
		     Conversion_Rate              =      p_Conversion_Rate
  WHERE rowid = p_Rowid;

Line: 327

  ROLLBACK TO Update_Row_Pvt ;

Line: 334

  ROLLBACK TO Update_Row_Pvt ;

Line: 341

  ROLLBACK TO Update_Row_Pvt ;

Line: 352

END Update_Row;

Line: 355

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

SAVEPOINT Delete_Row_Pvt ;

Line: 395

DELETE FROM IGC_CC_MC_DET_PF
WHERE rowid = p_Rowid;

Line: 413

  ROLLBACK TO Delete_Row_Pvt ;

Line: 420

  ROLLBACK TO Delete_Row_Pvt ;

Line: 427

  ROLLBACK TO Delete_Row_Pvt ;

Line: 439

END Delete_Row;