2020: ----------------
2021: l_trans_rec.transaction_type_code := G_ADD_TRX_TYPE_CODE; --optional
2022: --Big# 3156924
2023: --l_trans_rec.transaction_date_entered := p_talv_rec.in_service_date; --optional defaults to in_service_date
2024: l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
2025: --Bug# 3156924 :
2026: --l_trans_rec.calling_interface := l_api_name;
2027: l_trans_rec.calling_interface := p_calling_interface; --optional
2028: l_trans_rec.transaction_name := substr(p_trans_number,1,20);--optional
2520: -- prior period transfer
2521: l_trans_rec.transaction_date_entered := NULL;
2522: l_trans_rec.transaction_name := substr(p_trx_number,1,20);
2523: l_trans_rec.calling_interface := p_calling_interface;
2524: l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
2525: l_trans_rec.who_info.last_update_login := FND_GLOBAL.LOGIN_ID;
2526:
2527: open l_dist_curs(p_asset_id, p_book_type_code);
2528: Loop
2521: l_trans_rec.transaction_date_entered := NULL;
2522: l_trans_rec.transaction_name := substr(p_trx_number,1,20);
2523: l_trans_rec.calling_interface := p_calling_interface;
2524: l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
2525: l_trans_rec.who_info.last_update_login := FND_GLOBAL.LOGIN_ID;
2526:
2527: open l_dist_curs(p_asset_id, p_book_type_code);
2528: Loop
2529: Fetch l_dist_curs into l_units_assigned, l_location_id, l_distribution_id, l_code_combination_id;
2731: -- prior period transfer
2732: l_trans_rec.transaction_date_entered := NULL;
2733: l_trans_rec.transaction_name := substr(p_trx_number,1,20);
2734: l_trans_rec.calling_interface := p_calling_interface;
2735: l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
2736: l_trans_rec.who_info.last_update_login := FND_GLOBAL.LOGIN_ID;
2737:
2738: l_units_to_adjust := p_diff_in_units;
2739: i := 1;
2732: l_trans_rec.transaction_date_entered := NULL;
2733: l_trans_rec.transaction_name := substr(p_trx_number,1,20);
2734: l_trans_rec.calling_interface := p_calling_interface;
2735: l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
2736: l_trans_rec.who_info.last_update_login := FND_GLOBAL.LOGIN_ID;
2737:
2738: l_units_to_adjust := p_diff_in_units;
2739: i := 1;
2740: if (p_diff_in_units > 0) then
2926: -- prior period transfer
2927: l_trans_rec.transaction_date_entered := NULL;
2928: l_trans_rec.transaction_name := substr(p_trx_number,1,20);
2929: l_trans_rec.calling_interface := p_calling_interface;
2930: l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
2931: l_trans_rec.who_info.last_update_login := FND_GLOBAL.LOGIN_ID;
2932:
2933: l_asset_desc_rec.model_number := p_model_number;
2934: l_asset_desc_rec.manufacturer_name := p_manufacturer;
2927: l_trans_rec.transaction_date_entered := NULL;
2928: l_trans_rec.transaction_name := substr(p_trx_number,1,20);
2929: l_trans_rec.calling_interface := p_calling_interface;
2930: l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;
2931: l_trans_rec.who_info.last_update_login := FND_GLOBAL.LOGIN_ID;
2932:
2933: l_asset_desc_rec.model_number := p_model_number;
2934: l_asset_desc_rec.manufacturer_name := p_manufacturer;
2935: