DBA Data[Home] [Help]

APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_ADJUSTMENTS_MRC_V

Line 929: INSERT INTO FA_ADJUSTMENTS_MRC_V(

925: fetch c_get_new_thid into l_trans_rec.transaction_header_id
926: , l_trans_rec.who_info.last_update_date;
927: close c_get_new_thid;
928:
929: INSERT INTO FA_ADJUSTMENTS_MRC_V(
930: TRANSACTION_HEADER_ID
931: , SOURCE_TYPE_CODE
932: , ADJUSTMENT_TYPE
933: , DEBIT_CREDIT_FLAG

Line 1015: from fa_adjustments_mrc_v

1011: , TRACK_MEMBER_FLAG
1012: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
1013: , SOURCE_LINE_ID
1014: , SOURCE_DEST_CODE
1015: from fa_adjustments_mrc_v
1016: where asset_id = p_asset_hdr_rec.asset_id
1017: and book_type_code = p_asset_hdr_rec.book_type_code
1018: and transaction_header_id = l_thid
1019: ;

Line 1192: delete from fa_adjustments_mrc_v

1188: and transaction_header_id_out = l_thid;
1189:
1190: else
1191:
1192: delete from fa_adjustments_mrc_v
1193: where asset_id = p_asset_hdr_rec.asset_id
1194: and book_type_code = p_asset_hdr_rec.book_type_code
1195: and transaction_header_id = l_thid;
1196: