APPS.FA_ASSET_VAL_PVT dependencies on FA_MASS_ADDITIONS

Line 290: -- Need to check fa_mass_additions also. Only do this validation

286: name => 'FA_ADD_ASSET_NUMBER_USED');
287: return FALSE;
288: end if;
289:
290: -- Need to check fa_mass_additions also. Only do this validation
291: -- if it is being called from Prepare Mass Additions. Otherwise,
292: -- it fails during Post Mass Additions.
293: if (p_calling_fn = 'MASS_ADDITIONS_7.Check_S_Asset_Number') then
294: select count(*)

Line 296: from fa_mass_additions

292: -- it fails during Post Mass Additions.
293: if (p_calling_fn = 'MASS_ADDITIONS_7.Check_S_Asset_Number') then
294: select count(*)
295: into l_count
296: from fa_mass_additions
297: where asset_number = p_asset_number
298: and queue_name = 'POST'; -- fix for bug 3433702
299:
300: --if (l_count > 1) then

Line 2233: -- Make sure that tag_number does not already exist in fa_mass_additions.

2229: -- the additions api from mass additions - bug 2246577
2230: -- note that the unique index would catch any corner case
2231: -- violations resulting from this not caught by prepare form
2232:
2233: -- Make sure that tag_number does not already exist in fa_mass_additions.
2234: -- If this is called from mass additions post, we don't want to select
2235: -- the asset we're currently trying to post.
2236:
2237: select count(*)

Line 2239: from fa_mass_additions

2235: -- the asset we're currently trying to post.
2236:
2237: select count(*)
2238: into l_tag_number_count
2239: from fa_mass_additions
2240: where tag_number = p_tag_number
2241: and mass_addition_id <> nvl (p_mass_addition_id, -999);
2242:
2243: if (l_tag_number_count > 0) then

Line 2513: from fa_mass_additions

2509: BEGIN
2510:
2511: select count(*)
2512: into l_count
2513: from fa_mass_additions
2514: where book_type_code = p_book
2515: and add_to_asset_id = p_asset_id
2516: and posting_status not in ('POSTED','MERGED','SPLIT','DELETE')
2517: and rownum < 2;