DBA Data[Home] [Help]

APPS.IGC_CC_HEADER_HISTORY_PKG SQL Statements

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

Line: 9

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

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

     SELECT Rowid
       FROM IGC_CC_HEADER_HISTORY
      WHERE CC_Header_id   = p_CC_Header_id
        AND CC_Version_Num = P_CC_Version_Num ;
Line: 93

     SELECT Application_Id
       FROM   FND_APPLICATION
      WHERE  Application_Short_Name =  'IGC';
Line: 99

   SAVEPOINT Insert_Row_Pvt ;
Line: 123

   INSERT
     INTO IGC_CC_HEADER_HISTORY
             (CC_Header_Id,
              Parent_Header_Id,
              Org_Id,
              CC_Type,
              CC_Num,
              CC_Ref_Num,
              CC_Version_Num,
              CC_Version_Action,
              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_Version_Action,
              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: 333

    ROLLBACK TO Insert_Row_Pvt ;
Line: 347

    ROLLBACK TO Insert_Row_Pvt ;
Line: 361

    ROLLBACK TO Insert_Row_Pvt ;
Line: 379

  END Insert_Row;
Line: 382

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

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

     SELECT Rowid
       FROM IGC_CC_HEADER_HISTORY
      WHERE CC_Header_id   = p_CC_Header_id
        AND CC_Version_Num = P_CC_Version_Num ;
Line: 465

     SELECT Application_Id
       FROM   FND_APPLICATION
      WHERE  Application_Short_Name =  'IGC';
Line: 471

   SAVEPOINT Insert_Row_Pvt ;
Line: 495

   INSERT
     INTO IGC_CC_HEADER_HISTORY
             (CC_Header_Id,
              Parent_Header_Id,
              Org_Id,
              CC_Type,
              CC_Num,
              CC_Version_Num,
              CC_Version_Action,
              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_Version_Action,
              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: 703

    ROLLBACK TO Insert_Row_Pvt ;
Line: 717

    ROLLBACK TO Insert_Row_Pvt ;
Line: 731

    ROLLBACK TO Insert_Row_Pvt ;
Line: 749

  END Insert_Row;
Line: 791

   p_Last_Update_Date              IGC_CC_HEADER_HISTORY.Last_Update_Date%TYPE,
   p_Last_Updated_By               IGC_CC_HEADER_HISTORY.Last_Updated_By%TYPE,
   p_Last_Update_Login             IGC_CC_HEADER_HISTORY.Last_Update_Login%TYPE,
   p_Created_By                    IGC_CC_HEADER_HISTORY.Created_By%TYPE,
   p_Creation_Date                 IGC_CC_HEADER_HISTORY.Creation_Date%TYPE,
   p_Wf_Item_Type                  IGC_CC_HEADER_HISTORY.Wf_Item_Type%TYPE,
   p_Wf_Item_Key                   IGC_CC_HEADER_HISTORY.Wf_Item_Key%TYPE,
   p_CC_Current_User_Id            IGC_CC_HEADERS.CC_Current_User_Id%TYPE,
   p_Attribute1                    IGC_CC_HEADER_HISTORY.Attribute1%TYPE,
   p_Attribute2                    IGC_CC_HEADER_HISTORY.Attribute2%TYPE,
   p_Attribute3                    IGC_CC_HEADER_HISTORY.Attribute3%TYPE,
   p_Attribute4                    IGC_CC_HEADER_HISTORY.Attribute4%TYPE,
   p_Attribute5                    IGC_CC_HEADER_HISTORY.Attribute5%TYPE,
   p_Attribute6                    IGC_CC_HEADER_HISTORY.Attribute6%TYPE,
   p_Attribute7                    IGC_CC_HEADER_HISTORY.Attribute7%TYPE,
   p_Attribute8                    IGC_CC_HEADER_HISTORY.Attribute8%TYPE,
   p_Attribute9                    IGC_CC_HEADER_HISTORY.Attribute9%TYPE,
   p_Attribute10                   IGC_CC_HEADER_HISTORY.Attribute10%TYPE,
   p_Attribute11                   IGC_CC_HEADER_HISTORY.Attribute11%TYPE,
   p_Attribute12                   IGC_CC_HEADER_HISTORY.Attribute12%TYPE,
   p_Attribute13                   IGC_CC_HEADER_HISTORY.Attribute13%TYPE,
   p_Attribute14                   IGC_CC_HEADER_HISTORY.Attribute14%TYPE,
   p_Attribute15                   IGC_CC_HEADER_HISTORY.Attribute15%TYPE,
   p_Context                       IGC_CC_HEADER_HISTORY.Context%TYPE,
   p_CC_Guarantee_Flag             IGC_CC_HEADER_HISTORY.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: 825

     SELECT *
       FROM IGC_CC_HEADER_HISTORY
      WHERE rowid = p_Rowid
        FOR UPDATE of CC_Header_Id NOWAIT;
Line: 859

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
Line: 1058

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

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

   SAVEPOINT Update_Row_Pvt ;
Line: 1148

   UPDATE IGC_CC_HEADER_HISTORY
      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_Version_Action   = p_CC_Version_Action,
          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: 1219

    ROLLBACK TO Update_Row_Pvt ;
Line: 1226

    ROLLBACK TO Update_Row_Pvt ;
Line: 1233

    ROLLBACK TO Update_Row_Pvt ;
Line: 1245

  END Update_Row;
Line: 1248

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

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

   SAVEPOINT Update_Row_Pvt ;
Line: 1338

   UPDATE IGC_CC_HEADER_HISTORY
      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_Version_Action   =      p_CC_Version_Action,
          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: 1408

    ROLLBACK TO Update_Row_Pvt ;
Line: 1415

    ROLLBACK TO Update_Row_Pvt ;
Line: 1422

    ROLLBACK TO Update_Row_Pvt ;
Line: 1434

  END Update_Row;
Line: 1437

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

   SAVEPOINT Delete_Row_Pvt ;
Line: 1476

   DELETE
     FROM IGC_CC_HEADER_HISTORY
    WHERE rowid = p_Rowid;
Line: 1495

    ROLLBACK TO Delete_Row_Pvt ;
Line: 1502

    ROLLBACK TO Delete_Row_Pvt ;
Line: 1509

    ROLLBACK TO Delete_Row_Pvt ;
Line: 1520

  END Delete_Row;