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_DET_PF_HISTORY_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_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
   p_CC_Det_PF_Line_Num               IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
   p_CC_Acct_Line_Id                  IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
   p_Parent_Acct_Line_Id              IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
   p_Parent_Det_PF_Line_Id            IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
   p_Det_PF_Version_Num               IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
   p_Det_PF_Version_Action            IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
   p_CC_Det_PF_Entered_Amt            IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
   p_CC_Det_PF_Func_Amt               IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
   p_CC_Det_PF_Date                   IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
   p_CC_Det_PF_Billed_Amt             IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
   p_CC_Det_PF_Unbilled_Amt           IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
   p_CC_Det_PF_Encmbrnc_Amt           IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
   p_CC_Det_PF_Encmbrnc_Date          IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
   p_CC_Det_PF_Encmbrnc_Status        IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
   p_Last_Update_Date                 IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
   p_Last_Updated_By                  IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
   p_Last_Update_Login                IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
   p_Creation_Date                    IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
   p_Created_By                       IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
   p_Attribute1                       IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
   p_Attribute2                       IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
   p_Attribute3                       IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
   p_Attribute4                       IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
   p_Attribute5                       IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
   p_Attribute6                       IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
   p_Attribute7                       IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
   p_Attribute8                       IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
   p_Attribute9                       IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
   p_Attribute10                      IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
   p_Attribute11                      IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
   p_Attribute12                      IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
   p_Attribute13                      IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
   p_Attribute14                      IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
   p_Attribute15                      IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
   p_Context                          IGC_CC_DET_PF_HISTORY.Context%TYPE,
   G_FLAG                      IN OUT NOCOPY VARCHAR2
) IS

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

Line: 69


     SELECT Rowid
       FROM IGC_CC_DET_PF_HISTORY
      WHERE CC_Det_PF_Line_Id     = p_CC_Det_PF_Line_Id
        AND CC_Det_PF_Version_Num = p_Det_PF_Version_Num;

Line: 75


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 80


      SELECT SET_OF_BOOKS_ID,
             ORG_ID,CONVERSION_DATE
        FROM IGC_CC_HEADERS      ICH,
             IGC_CC_ACCT_LINES   IAL,
             IGC_CC_DET_PF       IDP
       WHERE ICH.CC_HEADER_ID       = IAL.CC_HEADER_ID
         AND IDP.CC_ACCT_LINE_ID    = IAL.CC_ACCT_LINE_ID
         AND IDP.CC_DET_PF_LINE_ID  = p_CC_Det_Pf_Line_Id;

Line: 92


   SAVEPOINT Insert_Row_Pvt ;

Line: 116


   INSERT
     INTO IGC_CC_DET_PF_HISTORY
             (CC_Det_PF_Line_Id,
              Parent_Det_PF_Line_Id,
              CC_Acct_Line_Id,
              Parent_Acct_Line_Id,
              CC_Det_PF_Line_Num,
              CC_Det_PF_Version_Num,
              CC_Det_PF_Version_Action,
              CC_Det_PF_Entered_Amt,
              CC_Det_PF_Func_Amt,
              CC_Det_PF_Date,
              CC_Det_PF_Billed_Amt,
              CC_Det_PF_Unbilled_Amt,
              CC_Det_PF_Encmbrnc_Amt,
              CC_Det_Pf_Encmbrnc_Date,
              CC_Det_PF_Encmbrnc_Status,
              Last_Update_Date,
              Last_Updated_By,
              Last_Update_Login,
              Creation_Date,
              Created_By,
              Attribute1,
              Attribute2,
              Attribute3,
              Attribute4,
              Attribute5,
              Attribute6,
              Attribute7,
              Attribute8,
              Attribute9,
              Attribute10,
              Attribute11,
              Attribute12,
              Attribute13,
              Attribute14,
              Attribute15,
              Context
             )
      VALUES
             (p_CC_Det_PF_Line_Id,
              p_Parent_Det_PF_Line_Id,
              p_CC_Acct_Line_Id,
              p_Parent_Acct_Line_Id,
              p_CC_Det_PF_Line_Num,
              p_Det_PF_Version_Num,
              p_Det_PF_Version_Action,
              p_CC_Det_PF_Entered_Amt,
              p_CC_Det_PF_Func_Amt,
              p_CC_Det_PF_Date,
              p_CC_Det_PF_Billed_Amt,
              p_CC_Det_PF_Unbilled_Amt,
              p_CC_Det_PF_Encmbrnc_Amt,
              p_CC_Det_PF_Encmbrnc_Date,
              p_CC_Det_PF_Encmbrnc_Status,
              p_Last_Update_Date,
              p_Last_Updated_By,
              p_Last_Update_Login,
              p_Creation_Date,
              p_Created_By,
              p_Attribute1,
              p_Attribute2,
              p_Attribute3,
              p_Attribute4,
              p_Attribute5,
              p_Attribute6,
              p_Attribute7,
              p_Attribute8,
              p_Attribute9,
              p_Attribute10,
              p_Attribute11,
              p_Attribute12,
              p_Attribute13,
              p_Attribute14,
              p_Attribute15,
              p_Context
             );

Line: 312


    ROLLBACK TO Insert_Row_Pvt ;

Line: 329


    ROLLBACK TO Insert_Row_Pvt ;

Line: 346


    ROLLBACK TO Insert_Row_Pvt ;

Line: 366


END Insert_Row;

Line: 397


   p_Last_Update_Date                 IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
   p_Last_Updated_By                  IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
   p_Last_Update_Login                IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
   p_Creation_Date                    IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
   p_Created_By                       IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
   p_Attribute1                       IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
   p_Attribute2                       IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
   p_Attribute3                       IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
   p_Attribute4                       IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
   p_Attribute5                       IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
   p_Attribute6                       IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
   p_Attribute7                       IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
   p_Attribute8                       IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
   p_Attribute9                       IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
   p_Attribute10                      IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
   p_Attribute11                      IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
   p_Attribute12                      IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
   p_Attribute13                      IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
   p_Attribute14                      IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
   p_Attribute15                      IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
   p_Context                          IGC_CC_DET_PF_HISTORY.Context%TYPE,
   X_row_locked                   OUT NOCOPY VARCHAR2,
   G_FLAG                      IN OUT NOCOPY VARCHAR2
) IS

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

Line: 427


     SELECT *
       FROM IGC_CC_DET_PF_HISTORY
      WHERE Rowid = p_Rowid
        FOR UPDATE of CC_Det_PF_Line_Id NOWAIT;

Line: 460


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

Line: 610


                         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_DET_PF_HISTORY.CC_Det_PF_Line_Id%TYPE,
   p_CC_Det_PF_Line_Num               IGC_CC_DET_PF_HISTORY.CC_Det_PF_Line_Num%TYPE,
   p_CC_Acct_Line_Id                  IGC_CC_DET_PF_HISTORY.CC_Acct_Line_Id%TYPE,
   p_Parent_Acct_Line_Id              IGC_CC_DET_PF_HISTORY.Parent_Acct_Line_Id%TYPE,
   p_Parent_Det_PF_Line_Id            IGC_CC_DET_PF_HISTORY.Parent_Det_PF_Line_Id%TYPE,
   p_Det_PF_Version_Num               IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Num%TYPE,
   p_Det_PF_Version_Action            IGC_CC_DET_PF_HISTORY.CC_Det_PF_Version_Action%TYPE,
   p_CC_Det_PF_Entered_Amt            IGC_CC_DET_PF_HISTORY.CC_Det_PF_Entered_Amt%TYPE,
   p_CC_Det_PF_Func_Amt               IGC_CC_DET_PF_HISTORY.CC_Det_PF_Func_Amt%TYPE,
   p_CC_Det_PF_Date                   IGC_CC_DET_PF_HISTORY.CC_Det_PF_Date%TYPE,
   p_CC_Det_PF_Billed_Amt             IGC_CC_DET_PF_HISTORY.CC_Det_PF_Billed_Amt%TYPE,
   p_CC_Det_PF_Unbilled_Amt           IGC_CC_DET_PF_HISTORY.CC_Det_PF_Unbilled_Amt%TYPE,
   p_CC_Det_PF_Encmbrnc_Amt           IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Amt%TYPE,
   p_CC_Det_PF_Encmbrnc_Date          IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Date%TYPE,
   p_CC_Det_PF_Encmbrnc_Status        IGC_CC_DET_PF_HISTORY.CC_Det_PF_Encmbrnc_Status%TYPE,
   p_Last_Update_Date                 IGC_CC_DET_PF_HISTORY.Last_Update_Date%TYPE,
   p_Last_Updated_By                  IGC_CC_DET_PF_HISTORY.Last_Updated_By%TYPE,
   p_Last_Update_Login                IGC_CC_DET_PF_HISTORY.Last_Update_Login%TYPE,
   p_Creation_Date                    IGC_CC_DET_PF_HISTORY.Creation_Date%TYPE,
   p_Created_By                       IGC_CC_DET_PF_HISTORY.Created_By%TYPE,
   p_Attribute1                       IGC_CC_DET_PF_HISTORY.Attribute1%TYPE,
   p_Attribute2                       IGC_CC_DET_PF_HISTORY.Attribute2%TYPE,
   p_Attribute3                       IGC_CC_DET_PF_HISTORY.Attribute3%TYPE,
   p_Attribute4                       IGC_CC_DET_PF_HISTORY.Attribute4%TYPE,
   p_Attribute5                       IGC_CC_DET_PF_HISTORY.Attribute5%TYPE,
   p_Attribute6                       IGC_CC_DET_PF_HISTORY.Attribute6%TYPE,
   p_Attribute7                       IGC_CC_DET_PF_HISTORY.Attribute7%TYPE,
   p_Attribute8                       IGC_CC_DET_PF_HISTORY.Attribute8%TYPE,
   p_Attribute9                       IGC_CC_DET_PF_HISTORY.Attribute9%TYPE,
   p_Attribute10                      IGC_CC_DET_PF_HISTORY.Attribute10%TYPE,
   p_Attribute11                      IGC_CC_DET_PF_HISTORY.Attribute11%TYPE,
   p_Attribute12                      IGC_CC_DET_PF_HISTORY.Attribute12%TYPE,
   p_Attribute13                      IGC_CC_DET_PF_HISTORY.Attribute13%TYPE,
   p_Attribute14                      IGC_CC_DET_PF_HISTORY.Attribute14%TYPE,
   p_Attribute15                      IGC_CC_DET_PF_HISTORY.Attribute15%TYPE,
   p_Context                          IGC_CC_DET_PF_HISTORY.Context%TYPE,
   G_FLAG                      IN OUT NOCOPY VARCHAR2
) IS

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

Line: 666


   SAVEPOINT Update_Row_Pvt ;

Line: 683


   UPDATE IGC_CC_DET_PF_HISTORY
      SET CC_Det_PF_Line_Id         =  p_CC_Det_PF_Line_Id,
          Parent_Det_PF_Line_Id     =  p_Parent_Det_PF_Line_Id,
          CC_Acct_Line_Id           =  p_CC_Acct_Line_Id,
          Parent_Acct_Line_Id       =  p_Parent_Acct_Line_Id,
          CC_Det_PF_Line_Num        =  p_CC_Det_PF_Line_Num,
          CC_Det_PF_Version_Num     =  p_Det_PF_Version_Num,
          CC_Det_PF_Version_Action  =  p_Det_PF_Version_Action,
          CC_Det_PF_Entered_Amt     =  p_CC_Det_PF_Entered_Amt,
          CC_Det_PF_Func_Amt        =  p_CC_Det_PF_Func_Amt,
          CC_Det_PF_Date            =  p_CC_Det_PF_Date,
          CC_Det_PF_Billed_Amt      =  p_CC_Det_PF_Billed_Amt,
          CC_Det_PF_Unbilled_Amt    =  p_CC_Det_PF_Unbilled_Amt,
          CC_Det_PF_Encmbrnc_Amt    =  p_CC_Det_PF_Encmbrnc_Amt,
          CC_Det_PF_Encmbrnc_Date   =  p_CC_Det_PF_Encmbrnc_Date,
          CC_Det_PF_Encmbrnc_Status =  p_CC_Det_PF_Encmbrnc_Status,
          Last_Update_Date          =  p_Last_Update_Date,
          Last_Updated_By           =  p_Last_Updated_By,
          Last_Update_Login         =  p_Last_Update_Login,
          Creation_Date             =  p_Creation_Date,
          Created_By                =  p_Created_By,
          Attribute1                =  p_Attribute1,
          Attribute2                =  p_Attribute2,
          Attribute3                =  p_Attribute3,
          Attribute4                =  p_Attribute4,
          Attribute5                =  p_Attribute5,
          Attribute6                =  p_Attribute6,
          Attribute7                =  p_Attribute7,
          Attribute8                =  p_Attribute8,
          Attribute9                =  p_Attribute9,
          Attribute10               =  p_Attribute10,
          Attribute11               =  p_Attribute11,
          Attribute12               =  p_Attribute12,
          Attribute13               =  p_Attribute13,
          Attribute14               =  p_Attribute14,
          Attribute15               =  p_Attribute15,
          Context                   =  p_Context
    WHERE rowid = p_Rowid;

Line: 737


    ROLLBACK TO Update_Row_Pvt ;

Line: 744


    ROLLBACK TO Update_Row_Pvt ;

Line: 751


    ROLLBACK TO Update_Row_Pvt ;

Line: 762


  END Update_Row;

Line: 765


                         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                        VARCHAR2,
   G_FLAG                  IN OUT NOCOPY VARCHAR2
) IS

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

Line: 790


   SAVEPOINT Delete_Row_Pvt ;

Line: 806


   DELETE
     FROM IGC_CC_DET_PF_HISTORY
    WHERE rowid = p_Rowid;

Line: 825


    ROLLBACK TO Delete_Row_Pvt ;

Line: 832


    ROLLBACK TO Delete_Row_Pvt ;

Line: 839


    ROLLBACK TO Delete_Row_Pvt ;

Line: 850


END Delete_Row;