eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FA_MASS_EXT_RETIREMENTS

Line 3193: l_prorate_convention fa_mass_ext_retirements.retirement_prorate_convention%TYPE;

3189: x_msg_count NUMBER;
3190: x_msg_data VARCHAR2(2000);
3191: l_group_asset_id NUMBER ;
3192: l_mass_external_retire_id NUMBER ;
3193: l_prorate_convention fa_mass_ext_retirements.retirement_prorate_convention%TYPE;
3194: l_batch_name fa_mass_ext_retirements.batch_name%TYPE ;
3195: l_init_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3196: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3197: l_sysdate DATE := SYSDATE ;

Line 3194: l_batch_name fa_mass_ext_retirements.batch_name%TYPE ;

3190: x_msg_data VARCHAR2(2000);
3191: l_group_asset_id NUMBER ;
3192: l_mass_external_retire_id NUMBER ;
3193: l_prorate_convention fa_mass_ext_retirements.retirement_prorate_convention%TYPE;
3194: l_batch_name fa_mass_ext_retirements.batch_name%TYPE ;
3195: l_init_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3196: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3197: l_sysdate DATE := SYSDATE ;
3198:

Line 3195: l_init_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;

3191: l_group_asset_id NUMBER ;
3192: l_mass_external_retire_id NUMBER ;
3193: l_prorate_convention fa_mass_ext_retirements.retirement_prorate_convention%TYPE;
3194: l_batch_name fa_mass_ext_retirements.batch_name%TYPE ;
3195: l_init_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3196: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3197: l_sysdate DATE := SYSDATE ;
3198:
3199: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.adjust_asset';

Line 3196: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;

3192: l_mass_external_retire_id NUMBER ;
3193: l_prorate_convention fa_mass_ext_retirements.retirement_prorate_convention%TYPE;
3194: l_batch_name fa_mass_ext_retirements.batch_name%TYPE ;
3195: l_init_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3196: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3197: l_sysdate DATE := SYSDATE ;
3198:
3199: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.adjust_asset';
3200: l_total_fa_units NUMBER ;

Line 3341: SELECT fa_mass_ext_retirements_s.nextval

3337: OPEN prorate_convention_cur ( p_asset_query_rec.book_type_code, p_asset_query_rec.asset_id ) ;
3338: FETCH prorate_convention_cur INTO l_prorate_convention ;
3339: CLOSE prorate_convention_cur ;
3340:
3341: SELECT fa_mass_ext_retirements_s.nextval
3342: INTO l_mass_external_retire_id
3343: FROM dual ;
3344:
3345: l_batch_name := 'BATCH'||TO_CHAR(l_mass_external_retire_id) ;