[Home] [Help]
1177: 'fma.date_placed_in_service, '||
1178: 'fma.reviewer_comments, '||
1179: 'fma.feeder_system_name, '||
1180: 'cia.instance_asset_id '||
1181: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';
1182:
1183: l_where_clause varchar2(240);
1184: l_and_clause varchar2(540);
1185:
1599: l_child_posting_status varchar2(10) := 'MERGED';
1600: l_parent_merge_code varchar2(2) := 'MP';
1601: l_child_merge_code varchar2(2) := 'MC';
1602:
1603: l_p_mass_add_rec fa_mass_additions%rowtype;
1604: l_c_mass_add_rec fa_mass_additions%rowtype;
1605:
1606: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1607: l_msg_count number;
1600: l_parent_merge_code varchar2(2) := 'MP';
1601: l_child_merge_code varchar2(2) := 'MC';
1602:
1603: l_p_mass_add_rec fa_mass_additions%rowtype;
1604: l_c_mass_add_rec fa_mass_additions%rowtype;
1605:
1606: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1607: l_msg_count number;
1608: l_msg_data varchar2(2000);
1762:
1763: l_child_posting_status varchar2(10) := 'MERGED';
1764: l_child_merge_code varchar2(2) := 'MC';
1765:
1766: l_c_mass_add_rec fa_mass_additions%rowtype;
1767:
1768: l_asset_quantity number;
1769: l_obj_ver_num number;
1770:
1866: RAISE fnd_api.g_exc_error;
1867: END IF;
1868:
1869: -- when a child record is added the parent record does not get the cumulative quantity
1870: UPDATE fa_mass_additions
1871: SET payables_units = payables_units + NVL(l_c_mass_add_rec.payables_units,0),
1872: fixed_assets_units = fixed_assets_units + NVL(l_c_mass_add_rec.fixed_assets_units,0)
1873: WHERE mass_addition_id = p_mass_addition_id;
1874:
1878: x_error_message := cse_util_pkg.dump_error_stack;
1879: END add_to_mass_addition;
1880:
1881: PROCEDURE get_distribution_id(
1882: p_mass_add_rec IN fa_mass_additions%rowtype,
1883: x_distribution_id OUT NOCOPY number ,
1884: x_return_status OUT NOCOPY varchar2,
1885: x_error_message OUT NOCOPY varchar2 )
1886: IS
1913: END get_distribution_id;
1914:
1915:
1916: PROCEDURE create_distribution(
1917: p_mass_add_rec IN fa_mass_additions%rowtype,
1918: x_return_status OUT NOCOPY varchar2,
1919: x_error_message OUT NOCOPY varchar2)
1920: IS
1921:
1989: x_return_status OUT nocopy varchar2,
1990: x_error_message OUT nocopy varchar2)
1991: IS
1992:
1993: l_mass_add_rec fa_mass_additions%rowtype;
1994:
1995: l_asset_quantity number;
1996: l_obj_ver_num number;
1997:
2959:
2960:
2961: PROCEDURE find_distribution(
2962: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec
2963: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
2964: , x_new_dist OUT NOCOPY NUMBER
2965: , x_return_status OUT NOCOPY VARCHAR2
2966: , x_error_msg OUT NOCOPY VARCHAR2 )
2967: IS
3042: END find_distribution ;
3043:
3044: PROCEDURE create_fa_distribution(
3045: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec
3046: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
3047: , x_return_status OUT NOCOPY VARCHAR2
3048: , x_error_msg OUT NOCOPY VARCHAR2 )
3049: IS
3050: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
3513: END find_asset;
3514:
3515: PROCEDURE adjust_asset(
3516: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
3517: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
3518: p_mtl_percent IN NUMBER,
3519: x_return_status OUT NOCOPY VARCHAR2,
3520: x_error_msg OUT NOCOPY VARCHAR2 )
3521: IS
3518: p_mtl_percent IN NUMBER,
3519: x_return_status OUT NOCOPY VARCHAR2,
3520: x_error_msg OUT NOCOPY VARCHAR2 )
3521: IS
3522: l_mass_add_rec fa_mass_additions%ROWTYPE;
3523: l_mass_ext_trf_rec fa_mass_external_transfers%ROWTYPE;
3524:
3525: x_msg_count NUMBER;
3526: x_msg_data VARCHAR2(2000);