APPS.FA_MASSADD_PREPARE_PKG dependencies on FA_MASS_ADDITIONS

Line 16: TYPE mass_add_tbl IS TABLE OF fa_mass_additions%ROWTYPE

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
17: INDEX BY PLS_INTEGER;
18:
19: l_mass_add_tbl mass_add_tbl;
20:

Line 193: UPDATE fa_mass_additions

189: l_mass_add_tbl (counter).MATERIAL_INDICATOR_FLAG := p_mass_add_rec_tbl ( counter).MATERIAL_INDICATOR_FLAG;
190: END LOOP;
191:
192: FORALL i IN 1 .. l_mass_add_tbl.COUNT SAVE EXCEPTIONS
193: UPDATE fa_mass_additions
194: SET ROW = l_mass_add_tbl (i)
195: WHERE mass_addition_id = l_mass_add_id_tbl (i);
196:
197: l_mass_add_id_tbl.delete;

Line 447: FROM fa_mass_additions mass_add

443: FROM FA_MASSADD_DISTRIBUTIONS mass_dist
444: WHERE mass_dist.mass_addition_id =
445: mass_add.mass_addition_id) AS fa_mass_add_dist_tbl)
446: dists
447: FROM fa_mass_additions mass_add
448: WHERE posting_status IN ('NEW', 'ON HOLD')
449: AND book_type_code = l_book_type_code
450: AND NVL (merged_code, '1') NOT IN ('MC');
451: