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

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

Line: 10


                         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_Acct_Line_Id                 IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
     p_CC_Header_Id                    IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
     p_Parent_Header_Id                IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
     p_Parent_Acct_Line_Id             IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
     p_CC_Acct_Line_Num                IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
     p_CC_Acct_Version_Num             IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
     p_CC_Acct_Version_Action          IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
     p_CC_Charge_Code_Comb_Id          IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
     p_CC_Budget_Code_Comb_Id          IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
     p_CC_Acct_Entered_Amt             IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
     p_CC_Acct_Func_Amt                IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
     p_CC_Acct_Desc                    IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
     p_CC_Acct_Billed_Amt              IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
     p_CC_Acct_Unbilled_Amt            IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
     p_CC_Acct_Taxable_Flag            IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
     p_Tax_Id                          IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
     p_CC_Acct_Encmbrnc_Amt            IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
     p_CC_Acct_Encmbrnc_Date           IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
     p_CC_Acct_Encmbrnc_Status         IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
     p_Project_Id                      IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
     p_Task_Id                         IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
     p_Expenditure_Type                IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
     p_Expenditure_Org_Id              IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
     p_Expenditure_Item_Date           IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
     p_Last_Update_Date                IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
     p_Last_Updated_By                 IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
     p_Last_Update_Login               IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
     p_Creation_Date                   IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
     p_Created_By                      IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
     p_Attribute1                      IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
     p_Attribute2                      IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
     p_Attribute3                      IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
     p_Attribute4                      IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
     p_Attribute5                      IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
     p_Attribute6                      IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
     p_Attribute7                      IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
     p_Attribute8                      IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
     p_Attribute9                      IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
     p_Attribute10                     IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
     p_Attribute11                     IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
     p_Attribute12                     IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
     p_Attribute13                     IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
     p_Attribute14                     IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
     p_Attribute15                     IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
     p_Context                         IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
     p_cc_func_withheld_amt            IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
     p_cc_ent_withheld_amt             IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
     G_FLAG                     IN OUT NOCOPY VARCHAR2,
     P_Tax_Classif_Code                IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
) IS

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

Line: 84


     SELECT Rowid
       FROM IGC_CC_ACCT_LINE_HISTORY
      WHERE CC_Acct_Line_Id     = p_CC_Acct_Line_Id
        AND CC_Acct_Version_Num = p_CC_Acct_Version_Num;

Line: 90


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 95


     SELECT SET_OF_BOOKS_ID,
            ORG_ID,
            CONVERSION_DATE
       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: 106


   SAVEPOINT Insert_Row_Pvt ;

Line: 130


   INSERT
     INTO IGC_CC_ACCT_LINE_HISTORY
            (CC_Acct_Line_Id,
             CC_Header_Id,
             Parent_Header_Id,
             Parent_Acct_Line_Id,
             CC_Acct_Line_Num,
             CC_Acct_Version_Num,
             CC_Acct_Version_Action,
             CC_Charge_Code_Combination_Id,
             CC_Budget_Code_Combination_Id,
             CC_Acct_Entered_Amt,
             CC_Acct_Func_Amt,
             CC_Acct_Desc,
             CC_Acct_Billed_Amt,
             CC_Acct_Unbilled_Amt,
             CC_Acct_Taxable_Flag,
             Tax_Id,
             CC_Acct_Encmbrnc_Amt,
             CC_Acct_Encmbrnc_Date,
             CC_Acct_Encmbrnc_Status,
             Project_Id,
             Task_Id,
             Expenditure_Type,
             Expenditure_Org_Id,
             Expenditure_Item_Date,
             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 ,
             cc_func_withheld_amt,
             cc_ent_withheld_amt,
             Tax_Classif_Code
            )
     VALUES
            (p_CC_Acct_Line_Id,
             p_CC_Header_Id,
             p_Parent_Header_Id,
             p_Parent_Acct_Line_Id,
             p_CC_Acct_Line_Num,
             p_CC_Acct_Version_Num,
             p_CC_Acct_Version_Action,
             p_CC_Charge_Code_Comb_Id,
             p_CC_Budget_Code_Comb_Id,
             p_CC_Acct_Entered_Amt,
             p_CC_Acct_Func_Amt,
             p_CC_Acct_Desc,
             p_CC_Acct_Billed_Amt,
             p_CC_Acct_Unbilled_Amt,
             p_CC_Acct_Taxable_Flag,
             p_Tax_Id,
             p_CC_Acct_Encmbrnc_Amt,
             p_CC_Acct_Encmbrnc_Date,
             p_CC_Acct_Encmbrnc_Status,
             p_Project_Id,
             p_Task_Id,
             p_Expenditure_Type,
             p_Expenditure_Org_Id,
             p_Expenditure_Item_Date,
             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,
             p_cc_func_withheld_amt,
             p_cc_ent_withheld_amt,
             P_Tax_Classif_Code
            );

Line: 354


    ROLLBACK TO Insert_Row_Pvt ;

Line: 371


    ROLLBACK TO Insert_Row_Pvt ;

Line: 388


    ROLLBACK TO Insert_Row_Pvt ;

Line: 408


END Insert_Row;

Line: 450


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

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

Line: 483


     SELECT *
       FROM IGC_CC_ACCT_LINE_HISTORY
      WHERE Rowid = p_Rowid
        FOR UPDATE of CC_Acct_Line_Id NOWAIT;

Line: 516


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

Line: 701


                         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_Acct_Line_Id                 IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
   p_CC_Header_Id                    IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
   p_Parent_Header_Id                IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
   p_Parent_Acct_Line_Id             IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
   p_CC_Acct_Line_Num                IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
   p_CC_Acct_Version_Num             IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
   p_CC_Acct_Version_Action          IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
   p_CC_Charge_Code_Comb_Id          IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
   p_CC_Budget_Code_Comb_Id          IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
   p_CC_Acct_Entered_Amt             IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
   p_CC_Acct_Func_Amt                IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
   p_CC_Acct_Desc                    IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
   p_CC_Acct_Billed_Amt              IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
   p_CC_Acct_Unbilled_Amt            IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
   p_CC_Acct_Taxable_Flag            IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
   p_Tax_Id                          IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
   p_CC_Acct_Encmbrnc_Amt            IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
   p_CC_Acct_Encmbrnc_Date           IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
   p_CC_Acct_Encmbrnc_Status         IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
   p_Project_Id                      IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
   p_Task_Id                         IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
   p_Expenditure_Type                IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
   p_Expenditure_Org_Id              IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
   p_Expenditure_Item_Date           IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
   p_Last_Update_Date                IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
   p_Last_Updated_By                 IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
   p_Last_Update_Login               IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
   p_Creation_Date                   IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
   p_Created_By                      IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
   p_Attribute1                      IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
   p_Attribute2                      IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
   p_Attribute3                      IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
   p_Attribute4                      IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
   p_Attribute5                      IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
   p_Attribute6                      IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
   p_Attribute7                      IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
   p_Attribute8                      IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
   p_Attribute9                      IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
   p_Attribute10                     IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
   p_Attribute11                     IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
   p_Attribute12                     IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
   p_Attribute13                     IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
   p_Attribute14                     IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
   p_Attribute15                     IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
   p_Context                         IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
   p_cc_func_withheld_amt            IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
   p_cc_ent_withheld_amt             IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
   G_FLAG                     IN OUT NOCOPY VARCHAR2,
   P_Tax_Classif_Code                IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
) IS

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

Line: 769


   SAVEPOINT Update_Row_Pvt ;

Line: 786


   UPDATE IGC_CC_ACCT_LINE_HISTORY
      SET CC_Acct_Line_Id               =  p_CC_Acct_Line_Id,
          CC_Header_Id                  =  p_CC_Header_Id,
          Parent_Header_Id              =  p_Parent_Header_Id,
          Parent_Acct_Line_Id           =  p_Parent_Acct_Line_Id,
          CC_Acct_Line_Num              =  p_CC_Acct_Line_Num,
          CC_Acct_Version_Num           =  p_CC_Acct_Version_Num,
          CC_Acct_Version_Action        =  p_CC_Acct_Version_Action,
          CC_Charge_Code_Combination_Id =  p_CC_Charge_Code_Comb_Id,
          CC_Budget_Code_Combination_Id =  p_CC_Budget_Code_Comb_Id,
          CC_Acct_Entered_Amt           =  p_CC_Acct_Entered_Amt,
          CC_Acct_Func_Amt              =  p_CC_Acct_Func_Amt,
          CC_Acct_Desc                  =  p_CC_Acct_Desc,
          CC_Acct_Billed_Amt            =  p_CC_Acct_Billed_Amt,
          CC_Acct_Unbilled_Amt          =  p_CC_Acct_Unbilled_Amt,
          CC_Acct_Taxable_Flag          =  p_CC_Acct_Taxable_Flag,
          Tax_Id                        =  p_Tax_Id,
          CC_Acct_Encmbrnc_Amt          =  p_CC_Acct_Encmbrnc_Amt,
          CC_Acct_Encmbrnc_Date         =  p_CC_Acct_Encmbrnc_Date,
          CC_Acct_Encmbrnc_Status       =  p_CC_Acct_Encmbrnc_Status,
          Project_Id                    =  p_Project_Id,
          Task_Id                       =  p_Task_Id,
          Expenditure_Type              =  p_Expenditure_Type,
          Expenditure_Org_Id            =  p_Expenditure_Org_Id,
          Expenditure_Item_Date         =  p_Expenditure_Item_Date,
          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 ,
          cc_func_withheld_amt          =  p_cc_func_withheld_amt,
          cc_ent_withheld_amt           =  p_cc_ent_withheld_amt,
          Tax_Classif_Code              =  P_Tax_Classif_Code
    WHERE rowid = p_Rowid;

Line: 852


    ROLLBACK TO Update_Row_Pvt ;

Line: 859


    ROLLBACK TO Update_Row_Pvt ;

Line: 866


    ROLLBACK TO Update_Row_Pvt ;

Line: 877


  END Update_Row;

Line: 881


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


   SAVEPOINT Delete_Row_Pvt ;

Line: 922


   DELETE
     FROM IGC_CC_ACCT_LINE_HISTORY
    WHERE rowid = p_Rowid;

Line: 941


    ROLLBACK TO Delete_Row_Pvt ;

Line: 948


    ROLLBACK TO Delete_Row_Pvt ;

Line: 955


    ROLLBACK TO Delete_Row_Pvt ;

Line: 966


  END Delete_Row;