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_PKG SQL Statements

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

Line: 77


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

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

Line: 140


      SELECT Rowid
        FROM IGC_CC_DET_PF
       WHERE CC_Det_PF_Line_Id = p_CC_Det_PF_Line_Id;

Line: 145


      SELECT CC_Version_Num
        from IGC_CC_HEADERS     ICH,
             IGC_CC_ACCT_LINES  IAL
      WHERE ICH.CC_HEADER_ID    = IAL.CC_HEADER_ID
        and IAL.CC_ACCT_LINE_ID = p_cc_acct_line_id;

Line: 152


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 157


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


   SAVEPOINT Insert_Row_Pvt ;

Line: 171


l_full_path := g_path||'Insert_Row';--bug 3199488

Line: 202


      g_debug_msg := ' IGCCDPFB -- Begin Insert Payment Forcast for Account Line ID...'  || p_cc_acct_line_id;

Line: 209


   INSERT
     INTO IGC_CC_DET_PF
            (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_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
            ( NVL(p_CC_Det_PF_Line_Id,igc_cc_det_pf_s.NEXTVAL),
             p_Parent_Det_PF_Line_Id,
             p_CC_Acct_Line_Id,
             p_Parent_Acct_Line_Id,
             p_CC_Det_PF_Line_Num,
             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
            ) RETURNING CC_Det_PF_Line_Id INTO p_CC_Det_PF_Line_Id;

Line: 302


        IGC_CC_DET_PF_HISTORY_PKG.Insert_Row (
                       l_api_version,
                       FND_API.G_FALSE,
                       FND_API.G_FALSE,
                       p_validation_level,
                       l_return_status,
                       X_msg_count,
                       X_msg_data,
                       l_row_id,
                       p_CC_Det_PF_Line_Id,
                       p_CC_Det_PF_Line_Num,
                       p_CC_Acct_Line_Id,
                       p_Parent_Acct_Line_Id,
                       p_Parent_Det_PF_Line_Id,
                       l_version_num - 1,
                       l_action_flag,
                       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,
                       G_FLAG );

Line: 355


            g_debug_msg := ' IGCCDPFB -- Failure returned from History Insert Payment Forcast Row';

Line: 363


         g_debug_msg := ' IGCCDPFB -- Inserted Payment Forcast History Row';

Line: 407


         g_debug_msg := ' IGCCDPFB -- Failure getting Application ID in Payment FC Insert';

Line: 512


         g_debug_msg := ' IGCCDPFB -- Committing Payment Forcast Insert';

Line: 523


      g_debug_msg := ' IGCCDPFB -- End Payment Forcast Insert ID ...' || p_CC_Det_PF_Line_Id ||
                     ' For account Line ID ... ' || p_cc_acct_line_id;

Line: 534


    ROLLBACK TO Insert_Row_Pvt ;

Line: 559


    ROLLBACK TO Insert_Row_Pvt ;

Line: 584


    ROLLBACK TO Insert_Row_Pvt ;

Line: 619


END Insert_Row;

Line: 647


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

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

Line: 678


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

Line: 728


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

Line: 930


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

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

Line: 991


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 996


     SELECT ICH.SET_OF_BOOKS_ID,
            ICH.ORG_ID
       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: 1008


l_full_path := g_path||'Update_Row';--bug 3199488

Line: 1010


   SAVEPOINT Update_Row_Pvt ;

Line: 1040


      g_debug_msg := ' IGCCDPFB -- Starting Update Payment Forcast Line ID ...' || p_CC_Det_PF_Line_Id ||
                     ' For account Line ID ... ' || p_cc_acct_line_id;

Line: 1048


   UPDATE IGC_CC_DET_PF
      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_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: 1088


          g_debug_msg := ' IGCCDPFB -- Payment Forcast Line not found to update.....';

Line: 1108


         g_debug_msg := ' IGCCDPFB -- Failure getting application ID for Payment Forcast Update.....';

Line: 1127


         g_debug_msg := ' IGCCDPFB -- Failure getting Payment Forcast info for Update.....';

Line: 1157


         g_debug_msg := ' IGCCDPFB -- MRC enabled Payment Forcast Update.....';

Line: 1188


            g_debug_msg := ' IGCCDPFB -- Failure returned from MRC for update.....';

Line: 1203


         g_debug_msg := ' IGCCDPFB -- Committing work for Payment Forcast update.....';

Line: 1214


      g_debug_msg := ' IGCCDPFB -- End Payment Forcast Update Line ID ...' || p_CC_Det_PF_Line_Id ||
                     ' For account Line ID ... ' || p_cc_acct_line_id;

Line: 1225


    ROLLBACK TO Update_Row_Pvt ;

Line: 1229


       g_debug_msg := ' IGCCDPFB -- Failure Execute Payment Forcast Update.....';

Line: 1243


    ROLLBACK TO Update_Row_Pvt ;

Line: 1247


       g_debug_msg := ' IGCCDPFB -- Failure Unexpected Payment Forcast Update.....';

Line: 1261


    ROLLBACK TO Update_Row_Pvt ;

Line: 1265


       g_debug_msg := ' IGCCDPFB -- Failure Others Payment Forcast Update.....';

Line: 1290


  END Update_Row;

Line: 1293


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

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

Line: 1326


      SELECT *
        FROM IGC_CC_DET_PF
       WHERE Rowid = p_Rowid;

Line: 1331


      SELECT CC_Version_Num
        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 IAL.CC_ACCT_LINE_ID = IDP.CC_ACCT_LINE_ID
         AND IDP.ROWID           = p_rowid;

Line: 1342


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 1347


     SELECT ICH.SET_OF_BOOKS_ID,
            ICH.ORG_ID,
            ICH.CONVERSION_DATE
       FROM IGC_CC_HEADERS     ICH,
            IGC_CC_ACCT_LINES  CAL,
            IGC_CC_DET_PF      DPF
      WHERE ICH.CC_HEADER_ID      = CAL.CC_HEADER_ID
        AND CAL.CC_ACCT_LINE_ID   = DPF.CC_ACCT_LINE_ID
        AND DPF.CC_DET_PF_LINE_ID = Recinfo.cc_det_pf_line_id;

Line: 1360


l_full_path := g_path||'Delete_Row';--bug 3199488

Line: 1362


   SAVEPOINT Delete_Row_Pvt ;

Line: 1392


       g_debug_msg := ' IGCCDPFB -- Starting Payment Forcast delete Row ID ... ' || p_rowid;

Line: 1406


         g_debug_msg := ' IGCCDPFB -- Failed getting version num for Payment FC Delete.....';

Line: 1424


         g_debug_msg := ' IGCCDPFB -- Failrue getting Row for Payment FC Delete.....';

Line: 1432


   IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
                       l_api_version,
                       FND_API.G_FALSE,
                       FND_API.G_FALSE,
                       p_validation_level,
                       l_return_status,
                       X_msg_count,
                       X_msg_data,
                       l_det_pf_row_id,
                       Recinfo.CC_Det_PF_Line_Id,
                       Recinfo.CC_Det_PF_Line_Num,
                       Recinfo.CC_Acct_Line_Id,
                       Recinfo.Parent_Acct_Line_Id,
                       Recinfo.Parent_Det_PF_Line_Id,
                       l_version_num-1,
                       l_action_flag,
                       Recinfo.CC_Det_PF_Entered_Amt,
                       Recinfo.CC_Det_PF_Func_Amt,
                       Recinfo.CC_Det_PF_Date,
                       Recinfo.CC_Det_PF_Billed_Amt,
                       Recinfo.CC_Det_PF_Unbilled_Amt,
                       Recinfo.CC_Det_PF_Encmbrnc_Amt,
                       Recinfo.CC_Det_PF_Encmbrnc_Date,
                       Recinfo.CC_Det_PF_Encmbrnc_Status,
                       Recinfo.Last_Update_Date,
                       Recinfo.Last_Updated_By,
                       Recinfo.Last_Update_Login,
                       Recinfo.Creation_Date,
                       Recinfo.Created_By,
                       Recinfo.Attribute1,
                       Recinfo.Attribute2,
                       Recinfo.Attribute3,
                       Recinfo.Attribute4,
                       Recinfo.Attribute5,
                       Recinfo.Attribute6,
                       Recinfo.Attribute7,
                       Recinfo.Attribute8,
                       Recinfo.Attribute9,
                       Recinfo.Attribute10 ,
                       Recinfo.Attribute11,
                       Recinfo.Attribute12,
                       Recinfo.Attribute13,
                       Recinfo.Attribute14,
                       Recinfo.Attribute15,
                       Recinfo.Context,
                       G_FLAG
                      );

Line: 1486


         g_debug_msg := ' IGCCDPFB -- Failure returned from Payment FC History insert.....';

Line: 1494


      g_debug_msg := ' IGCCDPFB -- History insert success for Payment FC Delete.....';

Line: 1512


         g_debug_msg := ' IGCCDPFB -- Failure obtaining application ID in delete operation...';

Line: 1536


         g_debug_msg := ' IGCCDPFB -- Failure obtaining CC Info conversion date in delete...';

Line: 1594


            g_debug_msg := ' IGCCACLB -- Failure returned from MC.get_rsobs_Acct_Lines delete...';

Line: 1605


   DELETE
     FROM IGC_CC_DET_PF
    WHERE rowid = p_Rowid;

Line: 1627


         g_debug_msg := ' IGCCDPFB -- Payment FC Delete being Committed.....';

Line: 1638


      g_debug_msg := ' IGCCDPFB -- End of Delete row ID ...' || p_rowid;

Line: 1648


    ROLLBACK TO Delete_Row_Pvt ;

Line: 1652


       g_debug_msg := ' IGCCDPFB -- Failure Delete Execute Error.....';

Line: 1666


    ROLLBACK TO Delete_Row_Pvt ;

Line: 1670


       g_debug_msg := ' IGCCDPFB -- Failure Delete Unexpected Error.....';

Line: 1684


    ROLLBACK TO Delete_Row_Pvt ;

Line: 1688


       g_debug_msg := ' IGCCDPFB -- Failure Delete Others Error.....';

Line: 1713


END Delete_Row;