APPS.SPLIT_MASS_ADDITIONS_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 663: from fa_massadd_distributions

659: h_child_units_so_far number;
660:
661: cursor split_dists is
662: select units, deprn_expense_ccid, location_id, employee_id
663: from fa_massadd_distributions
664: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
665:
666:
667: Begin

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

815:
816: select fixed_assets_units into h_total_units from fa_mass_additions
817: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
818:
819: select count(*) into h_num_dists from fa_massadd_distributions
820: where mass_addition_id = I_Split_Parent_Mass_Add_Id;
821:
822: if (I_Sum_Units = 'YES') then
823: select round((FIXED_ASSETS_UNITS-I_Merge_Child_fa_Units)/I_Total_fa_Units,2)

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

844: fetch split_dists into h_parent_dist_units, h_ccid, h_location, h_employee;
845:
846: if (split_dists%NOTFOUND) then return; end if;
847:
848: select fa_massadd_distributions_s.nextval into h_dist_id from dual;
849:
850: if (h_iter = h_num_dists) then
851: h_child_dist_units := h_child_total_units - h_child_units_so_far;
852: else

Line 857: insert into fa_massadd_distributions (massadd_dist_id, mass_addition_id,

853: h_child_dist_units := round( h_parent_dist_units/h_divisor_units, 2 );
854: h_child_units_so_far := h_child_units_so_far + h_child_dist_units;
855: end if;
856:
857: insert into fa_massadd_distributions (massadd_dist_id, mass_addition_id,
858: units, deprn_expense_ccid, location_id, employee_id) values (
859: h_dist_id, I_New_Mass_Addition_Id,
860: h_child_dist_units, h_ccid, h_location, h_employee);
861: