[Home] [Help]
452:
453: x_return_status := fnd_api.g_ret_sts_success;
454: debug('Inside API retire_asset');
455:
456: SELECT sysdate INTO l_sysdate FROM sys.dual ;
457:
458: OPEN prorate_convention_cur ( p_fa_inst_dtls_rec.fa_book_type_code, p_fa_inst_dtls_rec.fa_asset_id ) ;
459: FETCH prorate_convention_cur INTO l_prorate_convention ;
460: CLOSE prorate_convention_cur ;
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;
470:
471: l_ext_ret_rec.asset_id := p_fa_inst_dtls_rec.fa_asset_id ;
717: l_time_stamp := NULL ;
718:
719: SELECT sysdate
720: INTO l_sysdate
721: FROM sys.DUAL ;
722:
723: l_csi_txn_rec := p_csi_txn_rec ;
724: l_inst_asset_rec := p_inst_asset_rec ;
725:
1414: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
1415: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
1416: l_txn_error_id);
1417: ELSE
1418: SELECT sysdate INTO l_sysdate FROM DUAL ;
1419: UPDATE csi_txn_errors
1420: SET error_text = l_trx_error_rec.error_text ,
1421: source_group_ref_id = p_conc_request_id,
1422: last_update_date = l_sysdate
2757:
2758: debug ('Begin - Process Misc. Move Transactions');
2759: l_adj_units := 0;
2760: l_units_to_be_adjusted := 0;
2761: SELECT sysdate into l_sysdate from dual ;
2762:
2763: FOR src_misc_move_trans_rec IN src_misc_move_trans_cur
2764: LOOP
2765: BEGIN ---for src_misc_move_trans loop
3473: BEGIN
3474:
3475: debug('======== Begin : process_srl_nosrl_xorg_txn for CSI Txn ID :'|| p_transaction_id||' =========');
3476:
3477: SELECT sysdate INTO l_sysdate FROM DUAL ;
3478: i := 0;
3479: j := 0;
3480: x_return_status := fnd_api.g_ret_sts_success;
3481: