APPS.FA_MASSADD_SPECIAL_PKG SQL Statements

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

Line: 28

     select mad.units,
            mad.employee_id,
            mad.deprn_expense_ccid,
            mad.location_id
       from fa_massadd_distributions mad
      where mad.mass_addition_id = p_mass_add_rec.mass_addition_id
      union all
     select mad.units,
            mad.employee_id,
            mad.deprn_expense_ccid,
            mad.location_id
       from fa_massadd_distributions mad,
            fa_mass_additions mac,
            fa_mass_additions map
      where map.sum_units = 'YES'
        and map.mass_addition_id = p_mass_add_rec.mass_addition_id
        and map.mass_addition_id = mac.merge_parent_mass_additions_id
        and mad.mass_addition_id = mac.mass_addition_id;

Line: 171

PROCEDURE Update_All_Records
            (p_posting_status    IN     VARCHAR2,
             p_where_clause      IN     VARCHAR2,
             x_success_count        OUT NOCOPY NUMBER,
             x_failure_count        OUT NOCOPY NUMBER,
             x_return_status        OUT NOCOPY VARCHAR2,
	     p_log_level_rec     IN  FA_API_TYPES.log_level_rec_type default null) IS

   TYPE cursor_ref   IS REF cursor;

Line: 205

   l_calling_fn            varchar2(40) := 'fa_massadd_special_pkg.update_all';

Line: 211

   select *
     from fa_mass_additions
    where rowid = l_rowid;

Line: 228

   l_sql_statement := 'select row_id ' ||
                       ' from fa_mass_additions_v ' ||
                      p_where_clause              ||
                        ' and posting_status not in (''POSTED'', ''MERGED'', ''SPLIT''
)';

Line: 311

      update fa_mass_additions
         set posting_status   = l_posting_status(i),
             queue_name       = l_queue_name(i)
       where rowid            = l_upd_rowid(i);

Line: 320

      l_rowid_tbl.delete;

Line: 321

      l_upd_rowid.delete;

Line: 351

END Update_All_Records;