APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 36: G_Distribution_id fa_distribution_history.distribution_id%TYPE;

32: G_Today_Datetime DATE := SYSDATE;
33: G_Currency_Code gl_sets_of_books.currency_code%TYPE;
34: G_Set_of_Books_ID fa_book_controls.set_of_books_id%TYPE;
35: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
36: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
37: -- bug 1857395
38: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
39: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
40: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;

Line 366: from fa_distribution_history

362: transaction_header_id_out,
363: transaction_units,
364: retirement_id,
365: last_update_login
366: from fa_distribution_history
367: where asset_id = G_asset_id
368: and code_combination_id = G_Code_Combination_id
369: and location_id = G_Location_id
370: and nvl(assigned_to,0) = nvl(G_Assigned_To,0)

Line 820: -- While ccid and location_id are mandatory in fa_distribution_history;

816: raise Fully_Reserved_Error;
817: end if;
818:
819: -- bug 1857395
820: -- While ccid and location_id are mandatory in fa_distribution_history;
821: -- if any of these two are entered; both must be.
822:
823: If nvl(G_Distribution_Id,0) = 0 then
824: If (nvl(G_Code_Combination_Id,0) <> 0