DBA Data[Home] [Help]

APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_MC_ADJUSTMENTS

Line 1127: INSERT INTO FA_MC_ADJUSTMENTS(

1123: fetch c_get_new_thid into l_trans_rec.transaction_header_id
1124: , l_trans_rec.who_info.last_update_date;
1125: close c_get_new_thid;
1126:
1127: INSERT INTO FA_MC_ADJUSTMENTS(
1128: SET_OF_BOOKS_ID
1129: , TRANSACTION_HEADER_ID
1130: , SOURCE_TYPE_CODE
1131: , ADJUSTMENT_TYPE

Line 1215: from fa_mc_adjustments

1211: , TRACK_MEMBER_FLAG
1212: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
1213: , SOURCE_LINE_ID
1214: , SOURCE_DEST_CODE
1215: from fa_mc_adjustments
1216: where asset_id = p_asset_hdr_rec.asset_id
1217: and book_type_code = p_asset_hdr_rec.book_type_code
1218: and transaction_header_id = l_thid
1219: and set_of_books_id = p_asset_hdr_rec.set_of_books_id

Line 1411: delete from fa_mc_adjustments

1407: and transaction_header_id_out = l_thid;
1408:
1409: else
1410:
1411: delete from fa_mc_adjustments
1412: where asset_id = p_asset_hdr_rec.asset_id
1413: and book_type_code = p_asset_hdr_rec.book_type_code
1414: and transaction_header_id = g_l_thid
1415: and set_of_books_id = p_asset_hdr_rec.set_of_books_id ;