APPS.SPLIT_MASS_ADDITIONS_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 696: from fa_massadd_distributions

692: h_child_units_so_far number;
693:
694: cursor split_dists is
695: select units, deprn_expense_ccid, location_id, employee_id
696: from fa_massadd_distributions
697: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
698:
699:
700: Begin

Line 862: select count(*) into h_num_dists from fa_massadd_distributions

858:
859: select fixed_assets_units into h_total_units from fa_mass_additions
860: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
861:
862: select count(*) into h_num_dists from fa_massadd_distributions
863: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
864:
865: if (I_Sum_Units = 'YES') then
866: select round((FIXED_ASSETS_UNITS-I_Merge_Child_fa_Units)/I_Total_fa_Units,2)

Line 891: select fa_massadd_distributions_s.nextval into h_dist_id from dual;

887: fetch split_dists into h_parent_dist_units, h_ccid, h_location, h_employee;
888:
889: if (split_dists%NOTFOUND) then return; end if;
890:
891: select fa_massadd_distributions_s.nextval into h_dist_id from dual;
892:
893: if (h_iter = h_num_dists) then
894: h_child_dist_units := h_child_total_units - h_child_units_so_far;
895: else

Line 900: insert into fa_massadd_distributions (massadd_dist_id, mass_addition_id,

896: h_child_dist_units := round( h_parent_dist_units/h_divisor_units, 2 );
897: h_child_units_so_far := h_child_units_so_far + h_child_dist_units;
898: end if;
899:
900: insert into fa_massadd_distributions (massadd_dist_id, mass_addition_id,
901: units, deprn_expense_ccid, location_id, employee_id) values (
902: h_dist_id, I_New_Mass_Addition_Id,
903: h_child_dist_units, h_ccid, h_location, h_employee);
904: