APPS.IGI_IGI_ITR_CHARGE_HEADERS_PKG SQL Statements

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

Line: 15

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_It_Header_Id                   IN OUT NOCOPY NUMBER,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Name                           VARCHAR2,
                       X_Description                    VARCHAR2,
                       X_It_Period_Name                 VARCHAR2,
                       X_Entered_Dr                     NUMBER,
                       X_Entered_Cr                     NUMBER,
                       X_Submit_Flag                    VARCHAR2,
                       X_It_Originator_Id               VARCHAR2,
                       X_It_Category                    VARCHAR2,
                       X_It_Source                      VARCHAR2,
                       X_Gl_Date                        DATE,
                       X_Submit_Date                    DATE,
                       X_Currency_Code                  VARCHAR2,
                       X_Code_Combination_Id            NUMBER,
                       X_Encumbrance_Type_Id            NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM IGI_itr_charge_headers
                 WHERE it_header_id = X_It_Header_Id;

Line: 40

      CURSOR C2 IS SELECT IGI_IGI_itr_charge_headers_s.nextval FROM sys.dual;

Line: 48

       INSERT INTO IGI_itr_charge_headers(
              it_header_id,
              set_of_books_id,
              name,
              description,
              it_period_name,
              entered_dr,
              entered_cr,
              submit_flag,
              it_originator_id,
              it_category,
              it_source,
              gl_date,
              submit_date,
              currency_code,
              code_combination_id,
              encumbrance_type_id,
              creation_date,
              created_by,
              last_update_login,
              last_update_date,
              last_updated_by
             ) VALUES (
              X_It_Header_Id,
              X_Set_Of_Books_Id,
              X_Name,
              X_Description,
              X_It_Period_Name,
              X_Entered_Dr,
              X_Entered_Cr,
              X_Submit_Flag,
              X_It_Originator_Id,
              X_It_Category,
              X_It_Source,
              X_Gl_Date,
              X_Submit_Date,
              X_Currency_Code,
              X_Code_Combination_Id,
              X_Encumbrance_Type_Id,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              X_Last_Update_Date,
              X_Last_Updated_By
             );

Line: 101

  END Insert_Row;

Line: 124

        SELECT *
        FROM   IGI_itr_charge_headers
        WHERE  rowid = X_Rowid
        FOR UPDATE of It_Header_Id NOWAIT;

Line: 136

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

Line: 186

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_It_Header_Id                   NUMBER,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Name                           VARCHAR2,
                       X_Description                    VARCHAR2,
                       X_It_Period_Name                 VARCHAR2,
                       X_Entered_Dr                     NUMBER,
                       X_Entered_Cr                     NUMBER,
                       X_Submit_Flag                    VARCHAR2,
                       X_It_Originator_Id               VARCHAR2,
                       X_It_Category                    VARCHAR2,
                       X_It_Source                      VARCHAR2,
                       X_Gl_Date                        DATE,
                       X_Submit_Date                    DATE,
                       X_Currency_Code                  VARCHAR2,
                       X_Code_Combination_Id            NUMBER,
                       X_Encumbrance_Type_Id            NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS
  BEGIN
    UPDATE IGI_itr_charge_headers
    SET
       it_header_id                    =     X_It_Header_Id,
       set_of_books_id                 =     X_Set_Of_Books_Id,
       name                            =     X_Name,
       description                     =     X_Description,
       it_period_name                  =     X_It_Period_Name,
       entered_dr                      =     X_Entered_Dr,
       entered_cr                      =     X_Entered_Cr,
       submit_flag                     =     X_Submit_Flag,
       it_originator_id                =     X_It_Originator_Id,
       it_category                     =     X_It_Category,
       it_source                       =     X_It_Source,
       gl_date                         =     X_Gl_Date,
       submit_date                     =     X_Submit_Date,
       currency_code                   =     X_Currency_Code,
       code_combination_id             =     X_Code_Combination_Id,
       encumbrance_type_id             =     X_Encumbrance_Type_Id,
       last_update_login               =     X_Last_Update_Login,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By
    WHERE rowid = X_Rowid;

Line: 234

  END Update_Row;

Line: 235

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM IGI_itr_charge_headers
    WHERE rowid = X_Rowid;

Line: 243

  END Delete_Row;