APPS.FA_MASSADD_SPECIAL_PKG dependencies on FA_MASS_ADDITIONS

Line 8: p_mass_add_rec IN FA_MASS_ADDITIONS%ROWTYPE,

4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE Do_Validation
7: (p_posting_status IN VARCHAR2,
8: p_mass_add_rec IN FA_MASS_ADDITIONS%ROWTYPE,
9: x_return_status OUT NOCOPY VARCHAR2
10: ) IS
11:
12: l_inv number;

Line 46: fa_mass_additions mac,

42: mad.employee_id,
43: mad.deprn_expense_ccid,
44: mad.location_id
45: from fa_massadd_distributions mad,
46: fa_mass_additions mac,
47: fa_mass_additions map
48: where map.sum_units = 'YES'
49: and map.mass_addition_id = p_mass_add_rec.mass_addition_id
50: and map.mass_addition_id = mac.merge_parent_mass_additions_id

Line 47: fa_mass_additions map

43: mad.deprn_expense_ccid,
44: mad.location_id
45: from fa_massadd_distributions mad,
46: fa_mass_additions mac,
47: fa_mass_additions map
48: where map.sum_units = 'YES'
49: and map.mass_addition_id = p_mass_add_rec.mass_addition_id
50: and map.mass_addition_id = mac.merge_parent_mass_additions_id
51: and mad.mass_addition_id = mac.mass_addition_id;

Line 228: l_massadd_rec fa_mass_additions%ROWTYPE;

224: l_batch_size number;
225: l_queue_name char_tab;
226: l_posting_status char_tab;
227:
228: l_massadd_rec fa_mass_additions%ROWTYPE;
229:
230: -- dynamic sql
231: l_ret_val number;
232: l_cursor_id number;

Line 248: from fa_mass_additions

244: l_login_id number;
245:
246: cursor c_massadd is
247: select *
248: from fa_mass_additions
249: where rowid = l_rowid;
250:
251: BEGIN
252:

Line 273: ' from fa_mass_additions_v ' ||

269:
270: l_cursor_id := dbms_sql.open_cursor;
271:
272: l_sql_statement := 'select row_id ' ||
273: ' from fa_mass_additions_v ' ||
274: p_where_clause ||
275: ' and posting_status not in (''POSTED'', ''MERGED'', ''SPLIT'')';
276:
277: dbms_sql.parse(l_cursor_id, l_sql_statement, DBMS_SQL.NATIVE);

Line 357: update fa_mass_additions

353: l_login_id := fnd_global.login_id;
354:
355: -- now do the update on the validated records
356: forall i in 1..l_upd_rowid.count
357: update fa_mass_additions
358: set posting_status = l_posting_status(i),
359: queue_name = l_queue_name(i), /*Bug 7184647 added following 3 lines*/
360: last_updated_by = l_user_id,
361: last_update_date = l_date,