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

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

Line: 78


           PROCEDURE Insert_Row Overloaded Procedure for CC_REF_NUM addition
   ===============================================================================*/

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_Header_Id                    IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
   p_Org_id                          IGC_CC_HEADERS_ALL.Org_id%TYPE,
   p_CC_Type                         IGC_CC_HEADERS_ALL.CC_Type%TYPE,
   p_CC_Num                          IGC_CC_HEADERS_ALL.CC_Num%TYPE,
   p_CC_Ref_Num                      IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
   p_CC_Version_num                  IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
   p_Parent_Header_Id                IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
   p_CC_State                        IGC_CC_HEADERS_ALL.CC_State%TYPE,
   p_CC_ctrl_status                  IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
   p_CC_Encmbrnc_Status              IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
   p_CC_Apprvl_Status                IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
   p_Vendor_Id                       IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
   p_Vendor_Site_Id                  IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
   p_Vendor_Contact_Id               IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
   p_Term_Id                         IGC_CC_HEADERS_ALL.Term_Id%TYPE,
   p_Location_Id                     IGC_CC_HEADERS_ALL.Location_Id%TYPE,
   p_Set_Of_Books_Id                 IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
   p_CC_Acct_Date                    IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
   p_CC_Desc                         IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
   p_CC_Start_Date                   IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
   p_CC_End_Date                     IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
   p_CC_Owner_User_Id                IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
   p_CC_Preparer_User_Id             IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
   p_Currency_Code                   IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
   p_Conversion_Type                 IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
   p_Conversion_Date                 IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
   p_Conversion_Rate                 IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
   p_Last_Update_Date                IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
   p_Last_Updated_By                 IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
   p_Last_Update_Login               IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
   p_Created_By                      IGC_CC_HEADERS_ALL.Created_By%TYPE,
   p_Creation_Date                   IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
   p_CC_Current_User_Id              IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
   p_Wf_Item_Type                    IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
   p_Wf_Item_Key                     IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
   p_Attribute1                      IGC_CC_HEADERS_ALL.Attribute1%TYPE,
   p_Attribute2                      IGC_CC_HEADERS_ALL.Attribute2%TYPE,
   p_Attribute3                      IGC_CC_HEADERS_ALL.Attribute3%TYPE,
   p_Attribute4                      IGC_CC_HEADERS_ALL.Attribute4%TYPE,
   p_Attribute5                      IGC_CC_HEADERS_ALL.Attribute5%TYPE,
   p_Attribute6                      IGC_CC_HEADERS_ALL.Attribute6%TYPE,
   p_Attribute7                      IGC_CC_HEADERS_ALL.Attribute7%TYPE,
   p_Attribute8                      IGC_CC_HEADERS_ALL.Attribute8%TYPE,
   p_Attribute9                      IGC_CC_HEADERS_ALL.Attribute9%TYPE,
   p_Attribute10                     IGC_CC_HEADERS_ALL.Attribute10%TYPE,
   p_Attribute11                     IGC_CC_HEADERS_ALL.Attribute11%TYPE,
   p_Attribute12                     IGC_CC_HEADERS_ALL.Attribute12%TYPE,
   p_Attribute13                     IGC_CC_HEADERS_ALL.Attribute13%TYPE,
   p_Attribute14                     IGC_CC_HEADERS_ALL.Attribute14%TYPE,
   p_Attribute15                     IGC_CC_HEADERS_ALL.Attribute15%TYPE,
   p_Context                         IGC_CC_HEADERS_ALL.Context%TYPE,
   p_CC_Guarantee_Flag               IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
   G_FLAG                    IN OUT NOCOPY  VARCHAR2
) IS

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

Line: 155


     SELECT Rowid
       FROM IGC_CC_HEADERS_ALL
      WHERE CC_Header_id = p_CC_Header_id;

Line: 160


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 168


   l_full_path := g_path || 'Insert_Row';

Line: 170


   SAVEPOINT Insert_Row_Pvt ;

Line: 201


      g_debug_msg := ' IGCCHDRB -- Begin Insert Header ID Overload .....' || p_cc_header_id;

Line: 208


   INSERT
     INTO IGC_CC_HEADERS_ALL
             (CC_Header_Id,
              Parent_Header_Id,
              Org_Id,
              CC_Type,
              CC_Num,
              CC_Ref_Num,
              CC_Version_Num,
              CC_State,
              CC_Ctrl_Status,
              CC_Encmbrnc_Status,
              CC_Apprvl_Status,
              Vendor_Id,
              Vendor_Site_Id,
              Vendor_Contact_Id,
              Term_Id,
              Location_Id,
              Set_Of_Books_Id,
              CC_Acct_Date,
              CC_Desc,
              CC_Start_Date,
              CC_End_Date,
              CC_Owner_User_Id,
              CC_Preparer_User_Id,
              Currency_Code,
              Conversion_Type,
              Conversion_Date,
              Conversion_Rate,
              Last_Update_Date,
              Last_Updated_By,
              Last_Update_Login,
              Created_By,
              Creation_Date,
              Wf_Item_Type,
              Wf_Item_Key,
              CC_Current_User_Id,
              Attribute1,
              Attribute2,
              Attribute3,
              Attribute4,
              Attribute5,
              Attribute6,
              Attribute7,
              Attribute8,
              Attribute9,
              Attribute10,
              Attribute11,
              Attribute12,
              Attribute13,
              Attribute14,
              Attribute15,
              Context,
              CC_Guarantee_Flag
             )
       VALUES
             (p_CC_Header_Id,
              p_Parent_Header_Id,
              p_Org_id,
              p_CC_Type,
              p_CC_Num,
              p_CC_Ref_Num,
              p_CC_Version_num,
              p_CC_State,
              p_CC_ctrl_status,
              p_CC_Encmbrnc_Status,
              p_CC_Apprvl_Status,
              p_Vendor_Id,
              p_Vendor_Site_Id,
              p_Vendor_Contact_Id,
              p_Term_Id,
              p_Location_Id,
              p_Set_Of_Books_Id,
              p_CC_Acct_Date,
              p_CC_Desc,
              p_CC_Start_Date,
              p_CC_End_Date,
              p_CC_Owner_User_Id,
              p_CC_Preparer_User_Id,
              p_Currency_Code,
              p_Conversion_Type,
              p_Conversion_Date,
              p_Conversion_Rate,
              p_Last_Update_Date,
              p_Last_Updated_By,
              p_Last_Update_Login,
              p_Created_By,
              p_Creation_Date,
              p_Wf_Item_Type,
              p_Wf_Item_Key,
              p_CC_Current_User_Id,
              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_Guarantee_Flag
             );

Line: 426


         g_debug_msg := ' IGCCHDRB -- Committing Insert Header ID Overload .....' || p_cc_header_id;

Line: 437


      g_debug_msg := ' IGCCHDRB -- Done Insert Header ID Overload .....' || p_cc_header_id;

Line: 447


    ROLLBACK TO Insert_Row_Pvt ;

Line: 468


    ROLLBACK TO Insert_Row_Pvt ;

Line: 489


    ROLLBACK TO Insert_Row_Pvt ;

Line: 518


  END Insert_Row;

Line: 521


                         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_Header_Id                    IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
   p_Org_id                          IGC_CC_HEADERS_ALL.Org_id%TYPE,
   p_CC_Type                         IGC_CC_HEADERS_ALL.CC_Type%TYPE,
   p_CC_Num                          IGC_CC_HEADERS_ALL.CC_Num%TYPE,
   p_CC_Version_num                  IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
   p_Parent_Header_Id                IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
   p_CC_State                        IGC_CC_HEADERS_ALL.CC_State%TYPE,
   p_CC_ctrl_status                  IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
   p_CC_Encmbrnc_Status              IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
   p_CC_Apprvl_Status                IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
   p_Vendor_Id                       IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
   p_Vendor_Site_Id                  IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
   p_Vendor_Contact_Id               IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
   p_Term_Id                         IGC_CC_HEADERS_ALL.Term_Id%TYPE,
   p_Location_Id                     IGC_CC_HEADERS_ALL.Location_Id%TYPE,
   p_Set_Of_Books_Id                 IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
   p_CC_Acct_Date                    IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
   p_CC_Desc                         IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
   p_CC_Start_Date                   IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
   p_CC_End_Date                     IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
   p_CC_Owner_User_Id                IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
   p_CC_Preparer_User_Id             IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
   p_Currency_Code                   IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
   p_Conversion_Type                 IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
   p_Conversion_Date                 IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
   p_Conversion_Rate                 IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
   p_Last_Update_Date                IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
   p_Last_Updated_By                 IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
   p_Last_Update_Login               IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
   p_Created_By                      IGC_CC_HEADERS_ALL.Created_By%TYPE,
   p_Creation_Date                   IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
   p_CC_Current_User_Id              IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
   p_Wf_Item_Type                    IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
   p_Wf_Item_Key                     IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
   p_Attribute1                      IGC_CC_HEADERS_ALL.Attribute1%TYPE,
   p_Attribute2                      IGC_CC_HEADERS_ALL.Attribute2%TYPE,
   p_Attribute3                      IGC_CC_HEADERS_ALL.Attribute3%TYPE,
   p_Attribute4                      IGC_CC_HEADERS_ALL.Attribute4%TYPE,
   p_Attribute5                      IGC_CC_HEADERS_ALL.Attribute5%TYPE,
   p_Attribute6                      IGC_CC_HEADERS_ALL.Attribute6%TYPE,
   p_Attribute7                      IGC_CC_HEADERS_ALL.Attribute7%TYPE,
   p_Attribute8                      IGC_CC_HEADERS_ALL.Attribute8%TYPE,
   p_Attribute9                      IGC_CC_HEADERS_ALL.Attribute9%TYPE,
   p_Attribute10                     IGC_CC_HEADERS_ALL.Attribute10%TYPE,
   p_Attribute11                     IGC_CC_HEADERS_ALL.Attribute11%TYPE,
   p_Attribute12                     IGC_CC_HEADERS_ALL.Attribute12%TYPE,
   p_Attribute13                     IGC_CC_HEADERS_ALL.Attribute13%TYPE,
   p_Attribute14                     IGC_CC_HEADERS_ALL.Attribute14%TYPE,
   p_Attribute15                     IGC_CC_HEADERS_ALL.Attribute15%TYPE,
   p_Context                         IGC_CC_HEADERS_ALL.Context%TYPE,
   p_CC_Guarantee_Flag               IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
   G_FLAG                    IN OUT NOCOPY  VARCHAR2
) IS

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

Line: 597


     SELECT Rowid
       FROM IGC_CC_HEADERS_ALL
      WHERE CC_Header_id = p_CC_Header_id;

Line: 602


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 610


   l_full_path := g_path || 'Insert_Row';

Line: 612


   SAVEPOINT Insert_Row_Pvt ;

Line: 643


      g_debug_msg := ' IGCCHDRB -- Begin Insert Header ID .....' || p_cc_header_id;

Line: 650


   INSERT
     INTO IGC_CC_HEADERS_ALL
             (CC_Header_Id,
              Parent_Header_Id,
              Org_Id,
              CC_Type,
              CC_Num,
              CC_Version_Num,
              CC_State,
              CC_Ctrl_Status,
              CC_Encmbrnc_Status,
              CC_Apprvl_Status,
              Vendor_Id,
              Vendor_Site_Id,
              Vendor_Contact_Id,
              Term_Id,
              Location_Id,
              Set_Of_Books_Id,
              CC_Acct_Date,
              CC_Desc,
              CC_Start_Date,
              CC_End_Date,
              CC_Owner_User_Id,
              CC_Preparer_User_Id,
              Currency_Code,
              Conversion_Type,
              Conversion_Date,
              Conversion_Rate,
              Last_Update_Date,
              Last_Updated_By,
              Last_Update_Login,
              Created_By,
              Creation_Date,
              Wf_Item_Type,
              Wf_Item_Key,
              CC_Current_User_Id,
              Attribute1,
              Attribute2,
              Attribute3,
              Attribute4,
              Attribute5,
              Attribute6,
              Attribute7,
              Attribute8,
              Attribute9,
              Attribute10,
              Attribute11,
              Attribute12,
              Attribute13,
              Attribute14,
              Attribute15,
              Context,
              CC_Guarantee_Flag
             )
       VALUES
             (p_CC_Header_Id,
              p_Parent_Header_Id,
              p_Org_id,
              p_CC_Type,
              p_CC_Num,
              p_CC_Version_num,
              p_CC_State,
              p_CC_ctrl_status,
              p_CC_Encmbrnc_Status,
              p_CC_Apprvl_Status,
              p_Vendor_Id,
              p_Vendor_Site_Id,
              p_Vendor_Contact_Id,
              p_Term_Id,
              p_Location_Id,
              p_Set_Of_Books_Id,
              p_CC_Acct_Date,
              p_CC_Desc,
              p_CC_Start_Date,
              p_CC_End_Date,
              p_CC_Owner_User_Id,
              p_CC_Preparer_User_Id,
              p_Currency_Code,
              p_Conversion_Type,
              p_Conversion_Date,
              p_Conversion_Rate,
              p_Last_Update_Date,
              p_Last_Updated_By,
              p_Last_Update_Login,
              p_Created_By,
              p_Creation_Date,
              p_Wf_Item_Type,
              p_Wf_Item_Key,
              p_CC_Current_User_Id,
              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_Guarantee_Flag
             );

Line: 866


         g_debug_msg := ' IGCCHDRB -- Committing Insert Header ID .....' || p_cc_header_id;

Line: 877


      g_debug_msg := ' IGCCHDRB -- Done Insert Header ID .....' || p_cc_header_id;

Line: 887


    ROLLBACK TO Insert_Row_Pvt ;

Line: 908


    ROLLBACK TO Insert_Row_Pvt ;

Line: 930


    ROLLBACK TO Insert_Row_Pvt ;

Line: 958


  END Insert_Row;

Line: 999


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

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

Line: 1034


     SELECT *
       FROM IGC_CC_HEADERS_ALL
      WHERE rowid = p_Rowid
        FOR UPDATE of CC_Header_Id NOWAIT;

Line: 1085


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

Line: 1337


         PROCEDURE Update_Row Overloaded Procedure for CC_REF_NUM addition
   ===============================================================================*/

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_Header_Id                  IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
   p_Org_id                        IGC_CC_HEADERS_ALL.Org_id%TYPE,
   p_CC_Type                       IGC_CC_HEADERS_ALL.CC_Type%TYPE,
   p_CC_Num                        IGC_CC_HEADERS_ALL.CC_Num%TYPE,
   p_CC_Ref_Num                    IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
   p_CC_Version_num                IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
   p_Parent_Header_Id              IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
   p_CC_State                      IGC_CC_HEADERS_ALL.CC_State%TYPE,
   p_CC_ctrl_status                IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
   p_CC_Encmbrnc_Status            IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
   p_CC_Apprvl_Status              IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
   p_Vendor_Id                     IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
   p_Vendor_Site_Id                IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
   p_Vendor_Contact_Id             IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
   p_Term_Id                       IGC_CC_HEADERS_ALL.Term_Id%TYPE,
   p_Location_Id                   IGC_CC_HEADERS_ALL.Location_Id%TYPE,
   p_Set_Of_Books_Id               IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
   p_CC_Acct_Date                  IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
   p_CC_Desc                       IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
   p_CC_Start_Date                 IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
   p_CC_End_Date                   IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
   p_CC_Owner_User_Id              IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
   p_CC_Preparer_User_Id           IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
   p_Currency_Code                 IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
   p_Conversion_Type               IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
   p_Conversion_Date               IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
   p_Conversion_Rate               IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
   p_Last_Update_Date              IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
   p_Last_Updated_By               IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
   p_Last_Update_Login             IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
   p_Created_By                    IGC_CC_HEADERS_ALL.Created_By%TYPE,
   p_Creation_Date                 IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
   p_CC_Current_User_Id            IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
   p_Wf_Item_Type                  IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
   p_Wf_Item_Key                   IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
   p_Attribute1                    IGC_CC_HEADERS_ALL.Attribute1%TYPE,
   p_Attribute2                    IGC_CC_HEADERS_ALL.Attribute2%TYPE,
   p_Attribute3                    IGC_CC_HEADERS_ALL.Attribute3%TYPE,
   p_Attribute4                    IGC_CC_HEADERS_ALL.Attribute4%TYPE,
   p_Attribute5                    IGC_CC_HEADERS_ALL.Attribute5%TYPE,
   p_Attribute6                    IGC_CC_HEADERS_ALL.Attribute6%TYPE,
   p_Attribute7                    IGC_CC_HEADERS_ALL.Attribute7%TYPE,
   p_Attribute8                    IGC_CC_HEADERS_ALL.Attribute8%TYPE,
   p_Attribute9                    IGC_CC_HEADERS_ALL.Attribute9%TYPE,
   p_Attribute10                   IGC_CC_HEADERS_ALL.Attribute10%TYPE,
   p_Attribute11                   IGC_CC_HEADERS_ALL.Attribute11%TYPE,
   p_Attribute12                   IGC_CC_HEADERS_ALL.Attribute12%TYPE,
   p_Attribute13                   IGC_CC_HEADERS_ALL.Attribute13%TYPE,
   p_Attribute14                   IGC_CC_HEADERS_ALL.Attribute14%TYPE,
   p_Attribute15                   IGC_CC_HEADERS_ALL.Attribute15%TYPe,
   p_Context                       IGC_CC_HEADERS_ALL.Context%TYPE,
   p_CC_Guarantee_Flag             IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
   G_FLAG                   IN OUT NOCOPY VARCHAR2
) IS

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

Line: 1414


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 1422


   l_full_path := g_path || 'Update_Row';

Line: 1424


   SAVEPOINT Update_Row_Pvt ;

Line: 1454


      g_debug_msg := ' IGCCHDRB -- Begin Update Row Header ID Overload .....' || p_cc_header_id;

Line: 1461


   UPDATE IGC_CC_HEADERS_ALL
      SET CC_Header_Id        = p_CC_Header_Id,
          Parent_Header_Id    = p_Parent_Header_Id,
          Org_Id              = p_Org_id,
          CC_Type             = p_CC_Type,
          CC_Num              = p_CC_Num,
          CC_Ref_Num          = p_CC_Ref_Num,
          CC_Version_Num      = p_CC_Version_num,
          CC_State            = p_CC_State,
          CC_ctrl_status      = p_CC_ctrl_status ,
          CC_Encmbrnc_Status  = p_CC_Encmbrnc_Status,
          CC_Apprvl_Status    = p_CC_Apprvl_Status,
          Vendor_Id           = p_Vendor_Id,
          Vendor_Site_Id      = p_Vendor_Site_Id,
          Vendor_Contact_Id   = p_Vendor_Contact_Id,
          Term_Id             = p_Term_Id,
          Location_Id         = p_Location_Id,
          Set_Of_Books_Id     = p_Set_Of_Books_Id,
          CC_Acct_Date        = p_CC_Acct_Date,
          CC_Desc             = p_CC_Desc,
          CC_Start_Date       = p_CC_Start_Date,
          CC_End_Date         = p_CC_End_Date,
          CC_Owner_User_Id    = p_CC_Owner_User_Id,
          CC_Preparer_User_Id = p_CC_Preparer_User_Id,
          Currency_Code       = p_Currency_Code,
          Conversion_Type     = p_Conversion_Type,
          Conversion_Date     = p_Conversion_Date,
          Conversion_Rate     = p_Conversion_Rate,
          Last_Update_Date    = p_Last_Update_Date,
          Last_Updated_By     = p_Last_Updated_By,
          Last_Update_Login   = p_Last_Update_Login,
          Created_By          = p_Created_By,
          Creation_Date       = p_Creation_Date,
          Wf_Item_Type        = p_Wf_Item_Type,
          Wf_Item_Key         = p_Wf_Item_Key,
          CC_Current_User_Id  = p_CC_Current_User_Id,
          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_Guarantee_Flag   = p_CC_Guarantee_Flag
    WHERE rowid = p_Rowid;

Line: 1519


          g_debug_msg := ' IGCCHDRB -- Failure Update Row Header ID Overload .....' || p_cc_header_id;

Line: 1567


         g_debug_msg := ' IGCCHDRB -- MRC enabled for Update Row Header ID Overload .....' || p_cc_header_id;

Line: 1595


            g_debug_msg := ' IGCCHDRB -- Failure Update MRC return Header ID Overload .....' || p_cc_header_id;

Line: 1603


         g_debug_msg := ' IGCCHDRB -- MRC Updated Header ID Overload .....' || p_cc_header_id;

Line: 1616


         g_debug_msg := ' IGCCHDRB -- Committing Update Row Header ID Overload .....' || p_cc_header_id;

Line: 1627


      g_debug_msg := ' IGCCHDRB -- End Update Row Header ID Overload .....' || p_cc_header_id;

Line: 1637


    ROLLBACK TO Update_Row_Pvt ;

Line: 1641


       g_debug_msg := ' IGCCHDRB -- Failure Execute Update Header ID Overload .....' || p_cc_header_id;

Line: 1655


    ROLLBACK TO Update_Row_Pvt ;

Line: 1659


       g_debug_msg := ' IGCCHDRB -- Failure Unexpected Update Header ID Overload .....' || p_cc_header_id;

Line: 1673


    ROLLBACK TO Update_Row_Pvt ;

Line: 1677


       g_debug_msg := ' IGCCHDRB -- Failure Others Update Header ID Overload .....' || p_cc_header_id;

Line: 1698


END Update_Row;

Line: 1701


                         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_Header_Id                  IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
   p_Org_id                        IGC_CC_HEADERS_ALL.Org_id%TYPE,
   p_CC_Type                       IGC_CC_HEADERS_ALL.CC_Type%TYPE,
   p_CC_Num                        IGC_CC_HEADERS_ALL.CC_Num%TYPE,
   p_CC_Version_num                IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
   p_Parent_Header_Id              IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
   p_CC_State                      IGC_CC_HEADERS_ALL.CC_State%TYPE,
   p_CC_ctrl_status                IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
   p_CC_Encmbrnc_Status            IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
   p_CC_Apprvl_Status              IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
   p_Vendor_Id                     IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
   p_Vendor_Site_Id                IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
   p_Vendor_Contact_Id             IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
   p_Term_Id                       IGC_CC_HEADERS_ALL.Term_Id%TYPE,
   p_Location_Id                   IGC_CC_HEADERS_ALL.Location_Id%TYPE,
   p_Set_Of_Books_Id               IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
   p_CC_Acct_Date                  IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
   p_CC_Desc                       IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
   p_CC_Start_Date                 IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
   p_CC_End_Date                   IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
   p_CC_Owner_User_Id              IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
   p_CC_Preparer_User_Id           IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
   p_Currency_Code                 IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
   p_Conversion_Type               IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
   p_Conversion_Date               IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
   p_Conversion_Rate               IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
   p_Last_Update_Date              IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
   p_Last_Updated_By               IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
   p_Last_Update_Login             IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
   p_Created_By                    IGC_CC_HEADERS_ALL.Created_By%TYPE,
   p_Creation_Date                 IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
   p_CC_Current_User_Id            IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
   p_Wf_Item_Type                  IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
   p_Wf_Item_Key                   IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
   p_Attribute1                    IGC_CC_HEADERS_ALL.Attribute1%TYPE,
   p_Attribute2                    IGC_CC_HEADERS_ALL.Attribute2%TYPE,
   p_Attribute3                    IGC_CC_HEADERS_ALL.Attribute3%TYPE,
   p_Attribute4                    IGC_CC_HEADERS_ALL.Attribute4%TYPE,
   p_Attribute5                    IGC_CC_HEADERS_ALL.Attribute5%TYPE,
   p_Attribute6                    IGC_CC_HEADERS_ALL.Attribute6%TYPE,
   p_Attribute7                    IGC_CC_HEADERS_ALL.Attribute7%TYPE,
   p_Attribute8                    IGC_CC_HEADERS_ALL.Attribute8%TYPE,
   p_Attribute9                    IGC_CC_HEADERS_ALL.Attribute9%TYPE,
   p_Attribute10                   IGC_CC_HEADERS_ALL.Attribute10%TYPE,
   p_Attribute11                   IGC_CC_HEADERS_ALL.Attribute11%TYPE,
   p_Attribute12                   IGC_CC_HEADERS_ALL.Attribute12%TYPE,
   p_Attribute13                   IGC_CC_HEADERS_ALL.Attribute13%TYPE,
   p_Attribute14                   IGC_CC_HEADERS_ALL.Attribute14%TYPE,
   p_Attribute15                   IGC_CC_HEADERS_ALL.Attribute15%TYPe,
   p_Context                       IGC_CC_HEADERS_ALL.Context%TYPE,
   p_CC_Guarantee_Flag             IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
   G_FLAG                   IN OUT NOCOPY VARCHAR2
) IS

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

Line: 1777


     SELECT Application_Id
       FROM FND_APPLICATION
      WHERE Application_Short_Name =  'IGC';

Line: 1785


   l_full_path := g_path || 'Update_Row';

Line: 1787


   SAVEPOINT Update_Row_Pvt ;

Line: 1817


      g_debug_msg := ' IGCCHDRB -- Begin Update Row Header ID .....' || p_cc_header_id;

Line: 1824


   UPDATE IGC_CC_HEADERS_ALL
      SET CC_Header_Id                 =      p_CC_Header_Id,
          Parent_Header_Id             =      p_Parent_Header_Id,
          Org_Id                       =      p_Org_id,
          CC_Type                      =      p_CC_Type,
          CC_Num                       =      p_CC_Num,
          CC_Version_Num               =      p_CC_Version_num,
          CC_State                     =      p_CC_State,
          CC_ctrl_status               =      p_CC_ctrl_status ,
          CC_Encmbrnc_Status           =      p_CC_Encmbrnc_Status,
          CC_Apprvl_Status             =      p_CC_Apprvl_Status,
          Vendor_Id                    =      p_Vendor_Id,
          Vendor_Site_Id               =      p_Vendor_Site_Id,
          Vendor_Contact_Id            =      p_Vendor_Contact_Id,
          Term_Id                      =      p_Term_Id,
          Location_Id                  =      p_Location_Id,
          Set_Of_Books_Id              =      p_Set_Of_Books_Id,
          CC_Acct_Date                 =      p_CC_Acct_Date,
          CC_Desc                      =      p_CC_Desc,
          CC_Start_Date                =      p_CC_Start_Date,
          CC_End_Date                  =      p_CC_End_Date,
          CC_Owner_User_Id             =      p_CC_Owner_User_Id,
          CC_Preparer_User_Id          =      p_CC_Preparer_User_Id,
          Currency_Code                =      p_Currency_Code,
          Conversion_Type              =      p_Conversion_Type,
          Conversion_Date              =      p_Conversion_Date,
          Conversion_Rate              =      p_Conversion_Rate,
          Last_Update_Date             =      p_Last_Update_Date,
          Last_Updated_By              =      p_Last_Updated_By,
          Last_Update_Login            =      p_Last_Update_Login,
          Created_By                   =      p_Created_By,
          Creation_Date                =      p_Creation_Date,
          Wf_Item_Type                 =      p_Wf_Item_Type,
          Wf_Item_Key                  =      p_Wf_Item_Key,
          CC_Current_User_Id           =      p_CC_Current_User_Id,
          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_Guarantee_Flag            =      p_CC_Guarantee_Flag
    WHERE rowid = p_Rowid;

Line: 1881


          g_debug_msg := ' IGCCHDRB -- Failure Update Row Header ID .....' || p_cc_header_id;

Line: 1928


         g_debug_msg := ' IGCCHDRB -- MRC enabled for Update Row Header ID .....' || p_cc_header_id;

Line: 1956


            g_debug_msg := ' IGCCHDRB -- Failure Update MRC return Header ID .....' || p_cc_header_id;

Line: 1964


         g_debug_msg := ' IGCCHDRB -- MRC Updated Header ID .....' || p_cc_header_id;

Line: 1977


         g_debug_msg := ' IGCCHDRB -- Committing Update Row Header ID .....' || p_cc_header_id;

Line: 1988


      g_debug_msg := ' IGCCHDRB -- End Update Row Header ID .....' || p_cc_header_id;

Line: 1998


    ROLLBACK TO Update_Row_Pvt ;

Line: 2002


       g_debug_msg := ' IGCCHDRB -- Failure Execute Update Header ID .....' || p_cc_header_id;

Line: 2016


    ROLLBACK TO Update_Row_Pvt ;

Line: 2020


       g_debug_msg := ' IGCCHDRB -- Failure Unexpected Update Header ID .....' || p_cc_header_id;

Line: 2034


    ROLLBACK TO Update_Row_Pvt ;

Line: 2038


       g_debug_msg := ' IGCCHDRB -- Failure Others Update Header ID .....' || p_cc_header_id;

Line: 2061


END Update_Row;

Line: 2064


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


     SELECT *
       FROM IGC_CC_HEADERS_ALL
      WHERE Rowid = p_Rowid;

Line: 2105


   l_full_path := g_path || 'Delete_Row';

Line: 2107


   SAVEPOINT Delete_Row_Pvt ;

Line: 2137


       g_debug_msg := ' IGCCHDRB -- Starting Header delete Rowid ...' || p_rowid;

Line: 2154


         g_debug_msg := ' IGCCHDRB -- Failure getting Header Rec delete Rowid ...' || p_rowid;

Line: 2210


   DELETE
     FROM igc_cc_mc_det_pf_history DPH
    WHERE DPH.cc_det_pf_line_id IN
          ( SELECT DPF.cc_det_pf_line_id
              FROM igc_cc_det_pf DPF
             WHERE DPF.cc_acct_line_id IN
                   ( SELECT ACL.cc_acct_line_id
                       FROM igc_cc_acct_lines ACL
                      WHERE ACL.cc_header_id = Recinfo.cc_header_id
                   )
          )
       OR DPH.cc_det_pf_line_id IN
          ( SELECT DPFH.cc_det_pf_line_id
              FROM igc_cc_det_pf_history DPFH
             WHERE DPFH.cc_acct_line_id IN
                   ( SELECT ACLH.cc_acct_line_id
                       FROM igc_cc_acct_line_history ACLH
                      WHERE ACLH.cc_header_id = Recinfo.cc_header_id
                   )
          );

Line: 2233


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_DET_PF_HISTORY for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2241


   DELETE
     FROM igc_cc_mc_det_pf DP
    WHERE DP.cc_det_pf_line_id IN
          ( SELECT DPF.cc_det_pf_line_id
              FROM igc_cc_det_pf DPF
             WHERE DPF.cc_acct_line_id IN
                   ( SELECT ACL.cc_acct_line_id
                       FROM igc_cc_acct_lines ACL
                      WHERE ACL.cc_header_id = Recinfo.cc_header_id
                   )
          )
       OR DP.cc_det_pf_line_id IN
          ( SELECT DPFH.cc_det_pf_line_id
              FROM igc_cc_det_pf_history DPFH
             WHERE DPFH.cc_acct_line_id IN
                   ( SELECT ACLH.cc_acct_line_id
                       FROM igc_cc_acct_line_history ACLH
                      WHERE ACLH.cc_header_id = Recinfo.cc_header_id
                   )
          );

Line: 2264


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_DET_PF for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2272


   DELETE
     FROM igc_cc_mc_acct_line_history CALH
    WHERE CALH.cc_acct_line_id IN
          ( SELECT ACL.cc_acct_line_id
              FROM igc_cc_acct_lines ACL
             WHERE ACL.cc_header_id = Recinfo.cc_header_id
          )
       OR CALH.cc_acct_line_id IN
          ( SELECT ACLH.cc_acct_line_id
              FROM igc_cc_acct_line_history ACLH
             WHERE ACLH.cc_header_id = Recinfo.cc_header_id
          );

Line: 2287


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_ACCT_LINE_HISTORY for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2295


   DELETE
     FROM igc_cc_mc_acct_lines CAL
    WHERE CAL.cc_acct_line_id IN
          ( SELECT ACL.cc_acct_line_id
              FROM igc_cc_acct_lines ACL
             WHERE ACL.cc_header_id = Recinfo.cc_header_id
          )
       OR CAL.cc_acct_line_id IN
          ( SELECT ACLH.cc_acct_line_id
              FROM igc_cc_acct_line_history ACLH
             WHERE ACLH.cc_header_id = Recinfo.cc_header_id
          );

Line: 2310


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_ACCT_LINES for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2318


   DELETE
     FROM igc_cc_mc_header_history
    WHERE cc_header_id = Recinfo.cc_header_id;

Line: 2324


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_HEADER_HISTORY for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2332


   DELETE
     FROM igc_cc_mc_headers
    WHERE cc_header_id = Recinfo.cc_header_id;

Line: 2338


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_HEADERS for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2346


   DELETE
     FROM igc_cc_actions
    WHERE cc_header_id = Recinfo.cc_header_id;

Line: 2352


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACTIONS for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2360


   DELETE
     FROM igc_cc_det_pf_history CDPH
    WHERE CDPH.cc_acct_line_id IN
          ( SELECT ACL.cc_acct_line_id
              FROM igc_cc_acct_lines ACL
             WHERE ACL.cc_header_id = Recinfo.cc_header_id
          )
       OR CDPH.cc_acct_line_id IN
          ( SELECT ACLH.cc_acct_line_id
              FROM igc_cc_acct_line_history ACLH
             WHERE ACLH.cc_header_id = Recinfo.cc_header_id
          );

Line: 2375


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_DET_PF_HISTORY for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2383


   DELETE
     FROM igc_cc_det_pf CDP
    WHERE CDP.cc_acct_line_id IN
          ( SELECT ACL.cc_acct_line_id
              FROM igc_cc_acct_lines ACL
             WHERE ACL.cc_header_id = Recinfo.cc_header_id
          )
       OR CDP.cc_acct_line_id IN
          ( SELECT ACLH.cc_acct_line_id
              FROM igc_cc_acct_line_history ACLH
             WHERE ACLH.cc_header_id = Recinfo.cc_header_id
          );

Line: 2398


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_DET_PF for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2406


   DELETE
     FROM igc_cc_acct_line_history ALH
    WHERE ALH.cc_header_id = Recinfo.cc_header_id;

Line: 2412


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACCT_LINE_HISTORY for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2420


   DELETE
     FROM igc_cc_acct_lines AL
    WHERE AL.cc_header_id = Recinfo.cc_header_id;

Line: 2426


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACCT_LINES for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2434


   DELETE
     FROM igc_cc_interface CI
    WHERE CI.cc_header_id    = Recinfo.cc_header_id;

Line: 2440


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_INTERFACE for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2448


   DELETE
     FROM igc_cc_access CA
    WHERE CA.cc_header_id    = Recinfo.cc_header_id;

Line: 2454


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_ACCESS for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2462


   DELETE
     FROM igc_cc_header_history CHH
    WHERE CHH.cc_header_id    = Recinfo.cc_header_id;

Line: 2468


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_HEADER_HISTORY for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2476


   DELETE
     FROM IGC_CC_HEADERS_ALL
    WHERE cc_header_id = Recinfo.cc_header_id;

Line: 2482


      g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_HEADER for CC Header ID : ' ||
                     Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);

Line: 2496


         g_debug_msg := ' IGCCHDRB -- Committing Header delete Rowid ...' || p_rowid;

Line: 2507


      g_debug_msg := ' IGCCHDRB -- End Header delete Rowid ...' || p_rowid;

Line: 2517


    ROLLBACK TO Delete_Row_Pvt ;

Line: 2521


       g_debug_msg := ' IGCCHDRB -- Failure Execute Header delete Rowid ...' || p_rowid;

Line: 2535


    ROLLBACK TO Delete_Row_Pvt ;

Line: 2539


       g_debug_msg := ' IGCCHDRB -- Failure Unexpected Header delete Rowid ...' || p_rowid;

Line: 2553


    ROLLBACK TO Delete_Row_Pvt ;

Line: 2557


       g_debug_msg := ' IGCCHDRB -- Failure Others Header delete Rowid ...' || p_rowid;

Line: 2579


END Delete_Row;