[Home] [Help]
553: ma.prior_life_in_months,
554: ma.prior_basic_rate,
555: ma.prior_adjusted_rate -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy
556: ,ma.adjusted_cost ----bug#16426081
557: from fa_mass_additions ma
558: where ma.posting_status = 'POST'
559: and ma.book_type_code = p_book_type_code
560: and ma.request_id = p_parent_request_id
561: and ma.worker_id = p_request_number
604: child.material_indicator_flag,
605: child.invoice_distribution_id,
606: child.invoice_line_number,
607: child.po_distribution_id
608: FROM fa_mass_additions child
609: WHERE child.merge_parent_mass_additions_id = p_massadd_id;
610:
611: CURSOR c_distributions (p_massadd_id NUMBER) IS
612: select dist.employee_id,
624: mad.employee_id,
625: mad.deprn_expense_ccid,
626: mad.location_id
627: from fa_massadd_distributions mad,
628: fa_mass_additions mac,
629: fa_mass_additions map
630: where map.sum_units = 'YES'
631: and map.mass_addition_id = p_massadd_id
632: and map.mass_addition_id = mac.merge_parent_mass_additions_id
625: mad.deprn_expense_ccid,
626: mad.location_id
627: from fa_massadd_distributions mad,
628: fa_mass_additions mac,
629: fa_mass_additions map
630: where map.sum_units = 'YES'
631: and map.mass_addition_id = p_massadd_id
632: and map.mass_addition_id = mac.merge_parent_mass_additions_id
633: and mad.mass_addition_id = mac.mass_addition_id) dist
1755: else
1756: l_succ_asset_number := null;
1757: end if;
1758:
1759: update fa_mass_additions
1760: set posting_status = 'POSTED',
1761: queue_name = 'POSTED',
1762: post_batch_id = p_parent_request_id,
1763: asset_number = l_succ_asset_number,
1765: last_updated_by = fnd_global.user_id,
1766: last_update_login = fnd_global.login_id
1767: where mass_addition_id = l_mass_addition_id_tbl(i);
1768:
1769: update fa_mass_additions
1770: set posting_status = 'POSTED',
1771: queue_name = 'POSTED',
1772: post_batch_id = p_parent_request_id,
1773: asset_number = l_succ_asset_number,
1797: rollback to famapt;
1798: x_failure_count := x_failure_count + 1;
1799: l_fail_mass_addition_id_tbl(l_fail_mass_addition_id_tbl.count + 1) := l_mass_addition_id_tbl(i);
1800:
1801: update fa_mass_additions
1802: set posting_status = 'ON HOLD',
1803: queue_name = 'ON HOLD'
1804: where mass_addition_id = l_mass_addition_id_tbl(i);
1805:
1818: rollback to famapt;
1819: x_failure_count := x_failure_count + 1;
1820: l_fail_mass_addition_id_tbl(l_fail_mass_addition_id_tbl.count + 1) := l_mass_addition_id_tbl(i);
1821:
1822: update fa_mass_additions
1823: set posting_status = 'ON HOLD',
1824: queue_name = 'ON HOLD'
1825: where mass_addition_id = l_mass_addition_id_tbl(i);
1826:
2266:
2267: -- now update the rows in the interface with newly derived values
2268:
2269: forall i in 1..p_rowid_tbl.count
2270: update fa_mass_additions
2271: set description = px_description_tbl(i),
2272: date_placed_in_service = px_date_placed_in_service_tbl(i),
2273: asset_id = px_asset_id_tbl(i),
2274: add_to_asset_id = px_add_to_asset_id_tbl(i),
2347: mad.amortization_start_date,
2348: mad.description,
2349: mad.fixed_assets_units,
2350: mad.units_to_adjust
2351: from fa_mass_additions mad,
2352: fa_category_book_defaults cbd
2353: where mad.book_type_code = p_book_type_code
2354: and mad.posting_status = 'POST'
2355: and mad.add_to_asset_id is null
2377: mad.amortization_start_date,
2378: mad.description,
2379: mad.fixed_assets_units,
2380: mad.units_to_adjust
2381: from fa_mass_additions mad,
2382: fa_category_book_defaults cbd
2383: where mad.book_type_code = p_book_type_code
2384: and mad.posting_status = 'POST'
2385: and mad.add_to_asset_id is null
2534:
2535: -- update group asset information if we're not copying from corp
2536: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then
2537:
2538: update fa_mass_additions mad
2539: set group_asset_id =
2540: (select cbd.group_asset_id
2541: from fa_category_book_defaults cbd
2542: where mad.asset_category_id = cbd.category_id
2551: and mad.add_to_asset_id is null
2552: and mad.group_asset_id is null
2553: and nvl(mad.transaction_type_code, 'FUTURE ADD') not in ('FUTURE CAP', 'FUTURE REV');
2554:
2555: update fa_mass_additions mad
2556: set group_asset_id =
2557: (select group_asset_id
2558: from fa_books bk
2559: where bk.asset_id = mad.add_to_asset_id
2568:
2569:
2570: end if;
2571:
2572: update fa_mass_additions mad
2573: set mad.request_id = p_parent_request_id,
2574: mad.worker_id = mod(nvl(mad.group_asset_id,
2575: nvl(mad.add_to_asset_id,
2576: nvl(mad.asset_id,
2587:
2588: -- update group asset information if we're not copying from corp
2589: if nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' then
2590:
2591: update fa_mass_additions mad
2592: set group_asset_id =
2593: (select cbd.group_asset_id
2594: from fa_category_book_defaults cbd
2595: where mad.asset_category_id = cbd.category_id
2606: and mad.add_to_asset_id is null
2607: and mad.group_asset_id is null
2608: and nvl(mad.transaction_type_code, 'FUTURE ADD') not in ('FUTURE CAP', 'FUTURE REV');
2609:
2610: update fa_mass_additions mad
2611: set group_asset_id =
2612: (select group_asset_id
2613: from fa_books bk
2614: where bk.asset_id = mad.add_to_asset_id
2623: and nvl(mad.transaction_type_code, 'FUTURE ADD') not in ('FUTURE CAP', 'FUTURE REV');
2624:
2625: end if;
2626:
2627: update fa_mass_additions mad
2628: set mad.request_id = p_parent_request_id,
2629: mad.worker_id = mod(nvl(mad.group_asset_id,
2630: nvl(mad.add_to_asset_id,
2631: nvl(mad.asset_id,