APPS.FA_MASSADD_DIST_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 27: delete from fa_massadd_distributions

23:
24: begin
25: X_success := FALSE;
26:
27: delete from fa_massadd_distributions
28: where mass_addition_id = X_mass_addition_id;
29:
30: open dist_defaults;
31: loop

Line 39: select fa_massadd_distributions_s.nextval

35: if (dist_defaults%NOTFOUND) then exit; end if;
36:
37: h_dist_units := X_total_units * h_unit_percentage / 100;
38:
39: select fa_massadd_distributions_s.nextval
40: into h_massadd_dist_id from dual;
41:
42: insert into fa_massadd_distributions (
43: massadd_dist_id, mass_addition_id, units,

Line 42: insert into fa_massadd_distributions (

38:
39: select fa_massadd_distributions_s.nextval
40: into h_massadd_dist_id from dual;
41:
42: insert into fa_massadd_distributions (
43: massadd_dist_id, mass_addition_id, units,
44: deprn_expense_ccid, location_id, employee_id) values (
45: h_massadd_dist_id, X_mass_addition_id, h_dist_units,
46: h_ccid, h_location_id, h_employee_id);