DBA Data[Home] [Help]

APPS.CSE_FA_TXN_PKG dependencies on FA_MASS_EXT_RETIREMENTS

Line 749: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE;

745: p_retirement_units IN number,
746: p_retirement_date IN date,
747: x_return_status OUT nocopy varchar2)
748: IS
749: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE;
750: l_batch_name varchar2(30);
751: l_mass_ext_retire_id number;
752: l_prorate_convention varchar2(20);
753:

Line 805: SELECT fa_mass_ext_retirements_s.nextval

801: LOOP
802:
803: l_units_retired := l_units_retired - fa_dist_rec.units_assigned;
804:
805: SELECT fa_mass_ext_retirements_s.nextval
806: INTO l_mass_ext_retire_id
807: FROM sys.dual ;
808:
809: debug(' fa_distribution_id : '||fa_dist_rec.distribution_id);