[Home] [Help]
1136: 'fma.date_placed_in_service, '||
1137: 'fma.reviewer_comments, '||
1138: 'fma.feeder_system_name, '||
1139: 'cia.instance_asset_id '||
1140: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';
1141:
1142: l_where_clause varchar2(240);
1143: l_and_clause varchar2(540);
1144:
1558: l_child_posting_status varchar2(10) := 'MERGED';
1559: l_parent_merge_code varchar2(2) := 'MP';
1560: l_child_merge_code varchar2(2) := 'MC';
1561:
1562: l_p_mass_add_rec fa_mass_additions%rowtype;
1563: l_c_mass_add_rec fa_mass_additions%rowtype;
1564:
1565: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1566: l_msg_count number;
1559: l_parent_merge_code varchar2(2) := 'MP';
1560: l_child_merge_code varchar2(2) := 'MC';
1561:
1562: l_p_mass_add_rec fa_mass_additions%rowtype;
1563: l_c_mass_add_rec fa_mass_additions%rowtype;
1564:
1565: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1566: l_msg_count number;
1567: l_msg_data varchar2(2000);
1688:
1689: l_child_posting_status varchar2(10) := 'MERGED';
1690: l_child_merge_code varchar2(2) := 'MC';
1691:
1692: l_c_mass_add_rec fa_mass_additions%rowtype;
1693:
1694: l_asset_quantity number;
1695: l_obj_ver_num number;
1696:
1757: RAISE fnd_api.g_exc_error;
1758: END IF;
1759:
1760: -- when a child record is added the parent record does not get the cumulative quantity
1761: UPDATE fa_mass_additions
1762: SET payables_units = payables_units + NVL(l_c_mass_add_rec.payables_units,0),
1763: fixed_assets_units = fixed_assets_units + NVL(l_c_mass_add_rec.fixed_assets_units,0)
1764: WHERE mass_addition_id = p_mass_addition_id;
1765:
1769: x_error_message := cse_util_pkg.dump_error_stack;
1770: END add_to_mass_addition;
1771:
1772: PROCEDURE get_distribution_id(
1773: p_mass_add_rec IN fa_mass_additions%rowtype,
1774: x_distribution_id OUT NOCOPY number ,
1775: x_return_status OUT NOCOPY varchar2,
1776: x_error_message OUT NOCOPY varchar2 )
1777: IS
1804: END get_distribution_id;
1805:
1806:
1807: PROCEDURE create_distribution(
1808: p_mass_add_rec IN fa_mass_additions%rowtype,
1809: x_return_status OUT NOCOPY varchar2,
1810: x_error_message OUT NOCOPY varchar2)
1811: IS
1812:
1880: x_return_status OUT nocopy varchar2,
1881: x_error_message OUT nocopy varchar2)
1882: IS
1883:
1884: l_mass_add_rec fa_mass_additions%rowtype;
1885:
1886: l_asset_quantity number;
1887: l_obj_ver_num number;
1888:
2623:
2624:
2625: PROCEDURE find_distribution(
2626: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec
2627: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
2628: , x_new_dist OUT NOCOPY NUMBER
2629: , x_return_status OUT NOCOPY VARCHAR2
2630: , x_error_msg OUT NOCOPY VARCHAR2 )
2631: IS
2706: END find_distribution ;
2707:
2708: PROCEDURE create_fa_distribution(
2709: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec
2710: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
2711: , x_return_status OUT NOCOPY VARCHAR2
2712: , x_error_msg OUT NOCOPY VARCHAR2 )
2713: IS
2714: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
3177: END find_asset;
3178:
3179: PROCEDURE adjust_asset(
3180: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
3181: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
3182: p_mtl_percent IN NUMBER,
3183: x_return_status OUT NOCOPY VARCHAR2,
3184: x_error_msg OUT NOCOPY VARCHAR2 )
3185: IS
3182: p_mtl_percent IN NUMBER,
3183: x_return_status OUT NOCOPY VARCHAR2,
3184: x_error_msg OUT NOCOPY VARCHAR2 )
3185: IS
3186: l_mass_add_rec fa_mass_additions%ROWTYPE;
3187: l_mass_ext_trf_rec fa_mass_external_transfers%ROWTYPE;
3188:
3189: x_msg_count NUMBER;
3190: x_msg_data VARCHAR2(2000);