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.IGC_CC_MC_DET_PF_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_DET_PF_Line_Id               IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
                p_Set_Of_Books_Id                 IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
                p_CC_DET_PF_Func_Amt              IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
                p_CC_DET_PF_Encmbrnc_Amt          IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
                p_CC_DET_PF_version_num           IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
                p_CC_DET_PF_version_action        IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
                p_Conversion_Type                 IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
                p_Conversion_Date                 IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
                p_Conversion_Rate                 IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE

              )

 IS

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

Line: 38


         IS SELECT Rowid
            FROM   IGC_CC_MC_DET_PF_HISTORY
            WHERE  CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id;

Line: 44


     SAVEPOINT Insert_Row_Pvt ;

Line: 66


     INSERT INTO IGC_CC_MC_DET_PF_HISTORY (
               CC_DET_PF_Line_Id,
               Set_Of_Books_Id,
               CC_DET_PF_Func_Amt,
               CC_DET_PF_Encmbrnc_Amt,
               CC_DET_PF_version_num,
               CC_DET_PF_version_action,
               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_CC_DET_PF_version_num,
               p_CC_DET_PF_version_action,
               p_Conversion_Type,
               p_Conversion_Date,
               p_Conversion_Rate
         );

Line: 116


     ROLLBACK TO Insert_Row_Pvt ;

Line: 127


     ROLLBACK TO Insert_Row_Pvt ;

Line: 138


     ROLLBACK TO Insert_Row_Pvt ;

Line: 151


END Insert_Row;

Line: 182


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

Line: 212


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

Line: 298


                       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_HISTORY.CC_DET_PF_Line_Id%TYPE,
                p_Set_Of_Books_Id                 IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
                p_CC_DET_PF_Func_Amt              IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
                p_CC_DET_PF_Encmbrnc_Amt          IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
                p_CC_DET_PF_version_num           IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
                p_CC_DET_PF_version_action        IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
                p_Conversion_Type                 IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
                p_Conversion_Date                 IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
                p_Conversion_Rate                 IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE

) IS

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

Line: 327


  SAVEPOINT Update_Row_Pvt ;

Line: 344


  UPDATE IGC_CC_MC_DET_PF_HISTORY
  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,
                     CC_DET_PF_version_num       =     p_CC_DET_PF_version_num,
                     CC_DET_PF_version_action       =     p_CC_DET_PF_version_action,
                     Conversion_Type              =      p_Conversion_Type,
		     Conversion_Date              =      p_Conversion_Date,
		     Conversion_Rate              =      p_Conversion_Rate
  WHERE rowid = p_Rowid;

Line: 371


  ROLLBACK TO Update_Row_Pvt ;

Line: 378


  ROLLBACK TO Update_Row_Pvt ;

Line: 385


  ROLLBACK TO Update_Row_Pvt ;

Line: 396


END Update_Row;

Line: 399


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


SAVEPOINT Delete_Row_Pvt ;

Line: 439


DELETE FROM IGC_CC_MC_DET_PF_HISTORY
WHERE rowid = p_Rowid;

Line: 457


  ROLLBACK TO Delete_Row_Pvt ;

Line: 464


  ROLLBACK TO Delete_Row_Pvt ;

Line: 471


  ROLLBACK TO Delete_Row_Pvt ;

Line: 483


END Delete_Row;