APPS.CSE_ASSET_MOVE_PKG dependencies on FA_MASS_EXT_RETIREMENTS

Line 418: -- It creates a record into FA_MASS_EXT_RETIREMENTS

414: END create_csi_txn;
415: -----------------------------------------------------------------------------------------
416: -- Derives the unit cost of the FA based on FA_UNITS and FA_COST
417: -- Prorates the same for p_units_to_retire
418: -- It creates a record into FA_MASS_EXT_RETIREMENTS
419: -----------------------------------------------------------------------------------------
420: PROCEDURE retire_asset (
421: p_fa_inst_dtls_rec IN fa_inst_dtls_rec ,
422: p_units_to_retire IN NUMBER,

Line 429: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;

425: IS
426:
427: l_mass_external_retire_id number ;
428: l_prorate_convention varchar2(10);
429: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
430: l_sysdate date ;
431: l_unit_cost number;
432: l_txn_rec csi_datastructures_pub.transaction_rec;
433:

Line 465: SELECT fa_mass_ext_retirements_s.nextval

461:
462: l_txn_rec.source_header_ref := 'CSI_TXN_ID';
463: l_txn_rec.source_header_ref_id := p_fa_inst_dtls_rec.transaction_id;
464:
465: SELECT fa_mass_ext_retirements_s.nextval
466: INTO l_mass_external_retire_id
467: FROM dual ;
468:
469: l_unit_cost := p_fa_inst_dtls_rec.fa_cost/p_fa_inst_dtls_rec.fa_units;

Line 588: SELECT 'X' FROM fa_mass_ext_retirements fmer

584: SELECT 'X' FROM fa_retirements fr
585: WHERE fdh.retirement_id = fr.retirement_id
586: AND fr.status IN ('PENDING','ERROR'))
587: AND NOT EXISTS (
588: SELECT 'X' FROM fa_mass_ext_retirements fmer
589: WHERE fdh.retirement_id = fmer.retirement_id
590: AND fmer.review_status IN ('POST','ERROR'))
591: ORDER BY fb.date_placed_in_service ;
592: