APPS.IGI_BUD_JOURNAL_HEADERS_PKG SQL Statements

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

Line: 17

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Be_Batch_Id                    NUMBER,
                       X_Be_Header_Id                   IN OUT NOCOPY NUMBER,
                       X_Budget_Entity_Id               NUMBER,
                       X_Budget_Version_Id              NUMBER,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Currency_Code                  VARCHAR2,
                       X_Je_Category_Name               VARCHAR2,
                       X_Name                           VARCHAR2,
                       X_Running_Total_Dr               NUMBER,
                       X_Running_Total_Cr               NUMBER,
                       X_Autocopy_Flag                  VARCHAR2,
                       X_Control_Total                  NUMBER,
                       X_Default_Reason_Code            VARCHAR2,
                       X_Description                    VARCHAR2,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM IGI_BUD_JOURNAL_HEADERS
                 WHERE be_header_id = X_Be_Header_Id;

Line: 40

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

Line: 48

       INSERT INTO IGI_BUD_JOURNAL_HEADERS(
              be_batch_id,
              be_header_id,
              budget_entity_id,
              budget_version_id,
              set_of_books_id,
              currency_code,
              je_category_name,
              name,
              running_total_dr,
              running_total_cr,
              autocopy_flag,
              control_total,
              default_reason_code,
              description,
              creation_date,
              created_by,
              last_update_date,
              last_updated_by,
              last_update_login
             ) VALUES (
              X_Be_Batch_Id,
              X_Be_Header_Id,
              X_Budget_Entity_Id,
              X_Budget_Version_Id,
              X_Set_Of_Books_Id,
              X_Currency_Code,
              X_Je_Category_Name,
              X_Name,
              X_Running_Total_Dr,
              X_Running_Total_Cr,
              X_Autocopy_Flag,
              X_Control_Total,
              X_Default_Reason_Code,
              X_Description,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Last_Update_Login
             );

Line: 97

  END Insert_Row;

Line: 117

        SELECT *
        FROM   IGI_BUD_JOURNAL_HEADERS
        WHERE  rowid = X_Rowid
        FOR UPDATE of Be_Header_Id NOWAIT;

Line: 129

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

Line: 174

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Be_Batch_Id                    NUMBER,
                       X_Be_Header_Id                   NUMBER,
                       X_Budget_Entity_Id               NUMBER,
                       X_Budget_Version_Id              NUMBER,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Currency_Code                  VARCHAR2,
                       X_Je_Category_Name               VARCHAR2,
                       X_Name                           VARCHAR2,
                       X_Running_Total_Dr               NUMBER,
                       X_Running_Total_Cr               NUMBER,
                       X_Autocopy_Flag                  VARCHAR2,
                       X_Control_Total                  NUMBER,
                       X_Default_Reason_Code            VARCHAR2,
                       X_Description                    VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER

  ) IS
  BEGIN
    UPDATE IGI_BUD_JOURNAL_HEADERS
    SET
       be_batch_id                     =     X_Be_Batch_Id,
       be_header_id                    =     X_Be_Header_Id,
       budget_entity_id                =     X_Budget_Entity_Id,
       budget_version_id               =     X_Budget_Version_Id,
       set_of_books_id                 =     X_Set_Of_Books_Id,
       currency_code                   =     X_Currency_Code,
       je_category_name                =     X_Je_Category_Name,
       name                            =     X_Name,
       running_total_dr                =     X_Running_Total_Dr,
       running_total_cr                =     X_Running_Total_Cr,
       autocopy_flag                   =     X_Autocopy_Flag,
       control_total                   =     X_Control_Total,
       default_reason_code             =     X_Default_Reason_Code,
       description                     =     X_Description,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 219

  END Update_Row;

Line: 221

  PROCEDURE Delete_Row(X_Rowid        VARCHAR2,
                       X_Be_Header_Id NUMBER) IS

    cursor related_lines is
      select l.rowid row_id, l.be_line_num
      from   igi_bud_journal_lines l
      where  l.be_header_id = X_Be_Header_Id;

Line: 230

    DELETE FROM IGI_BUD_JOURNAL_HEADERS
    WHERE rowid = X_Rowid;

Line: 234

      igi_bud_journal_lines_pkg.delete_row(lines.row_id,
                                             X_Be_Header_Id,
                                             lines.be_line_num);

Line: 242

  END Delete_Row;