APPS.FA_MASSADD_PREPARE_PKG dependencies on FA_MASS_ADDITIONS

Line 16: TYPE mass_add_tbl IS TABLE OF fa_mass_additions%ROWTYPE INDEX BY PLS_INTEGER;

12: /*===============================End Of FUNCTION/PROCEDURE===============================*/
13: function update_mass_additions(p_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl,
14: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
15: return boolean is
16: TYPE mass_add_tbl IS TABLE OF fa_mass_additions%ROWTYPE INDEX BY PLS_INTEGER;
17: l_mass_add_tbl mass_add_tbl;
18: type num_tbl is table of number index by pls_integer;
19: l_mass_add_id_tbl num_tbl;
20: l_debug_str varchar2(1000);

Line 337: update fa_mass_additions

333: .MATERIAL_INDICATOR_FLAG;
334: end loop;
335:
336: forall i in 1 .. l_mass_add_tbl.count SAVE EXCEPTIONS
337: update fa_mass_additions
338: set ROW = l_mass_add_tbl(i)
339: where mass_addition_id = l_mass_add_id_tbl(i);
340: l_mass_add_id_tbl.delete;
341: commit;

Line 587: FROM fa_mass_additions mass_add

583: from FA_MASSADD_DISTRIBUTIONS mass_dist
584: where mass_dist.mass_addition_id =
585: mass_add.mass_addition_id) as
586: fa_mass_add_dist_tbl) dists
587: FROM fa_mass_additions mass_add
588: where posting_status in ('NEW', 'ON HOLD', 'POST')
589: and book_type_code = l_book_type_code
590: and nvl(merged_code, '1') not in ('MC');
591: