APPS.FA_MASSADD_SPECIAL_PKG dependencies on FA_MASS_ADDITIONS

Line 6: p_mass_add_rec IN FA_MASS_ADDITIONS%ROWTYPE,

2: /* $Header: FAMADSB.pls 120.4 2005/07/28 00:16:11 tkawamur noship $ */
3:
4: PROCEDURE Do_Validation
5: (p_posting_status IN VARCHAR2,
6: p_mass_add_rec IN FA_MASS_ADDITIONS%ROWTYPE,
7: x_return_status OUT NOCOPY VARCHAR2,
8: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
9:
10: l_inv number;

Line 40: fa_mass_additions mac,

36: mad.employee_id,
37: mad.deprn_expense_ccid,
38: mad.location_id
39: from fa_massadd_distributions mad,
40: fa_mass_additions mac,
41: fa_mass_additions map
42: where map.sum_units = 'YES'
43: and map.mass_addition_id = p_mass_add_rec.mass_addition_id
44: and map.mass_addition_id = mac.merge_parent_mass_additions_id

Line 41: fa_mass_additions map

37: mad.deprn_expense_ccid,
38: mad.location_id
39: from fa_massadd_distributions mad,
40: fa_mass_additions mac,
41: fa_mass_additions map
42: where map.sum_units = 'YES'
43: and map.mass_addition_id = p_mass_add_rec.mass_addition_id
44: and map.mass_addition_id = mac.merge_parent_mass_additions_id
45: and mad.mass_addition_id = mac.mass_addition_id;

Line 197: l_massadd_rec fa_mass_additions%ROWTYPE;

193: l_batch_size number;
194: l_queue_name char_tab;
195: l_posting_status char_tab;
196:
197: l_massadd_rec fa_mass_additions%ROWTYPE;
198:
199: -- dynamic sql
200: l_ret_val number;
201: l_cursor_id number;

Line 212: from fa_mass_additions

208: error_found2 exception; -- used in nested block
209:
210: cursor c_massadd is
211: select *
212: from fa_mass_additions
213: where rowid = l_rowid;
214:
215: BEGIN
216:

Line 229: ' from fa_mass_additions_v ' ||

225:
226: l_cursor_id := dbms_sql.open_cursor;
227:
228: l_sql_statement := 'select row_id ' ||
229: ' from fa_mass_additions_v ' ||
230: p_where_clause ||
231: ' and posting_status not in (''POSTED'', ''MERGED'', ''SPLIT''
232: )';
233:

Line 311: update fa_mass_additions

307: end loop;
308:
309: -- now do the update on the validated records
310: forall i in 1..l_upd_rowid.count
311: update fa_mass_additions
312: set posting_status = l_posting_status(i),
313: queue_name = l_queue_name(i)
314: where rowid = l_upd_rowid(i);
315: