APPS.CSE_ASSET_UTIL_PKG dependencies on FA_MASS_ADDITIONS

Line 1464: FROM fa_mass_additions fma

1460: IS
1461: SELECT SUM(NVL(fma.fixed_assets_cost,0)) cost ,
1462: SUM(fma.fixed_assets_units) total_units ,
1463: fma.mass_addition_id
1464: FROM fa_mass_additions fma
1465: ,fa_massadd_distributions fmd
1466: WHERE fmd.mass_addition_id = fma.mass_addition_id
1467: AND fma.posting_status = 'POST'
1468: AND fma.book_type_code = p_asset_query_rec.book_type_code

Line 1934: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,

1930: PROCEDURE insert_mass_add(
1931: p_api_version IN NUMBER,
1932: p_commit IN VARCHAR2,
1933: p_init_msg_list IN VARCHAR2,
1934: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
1935: x_return_status OUT NOCOPY VARCHAR2,
1936: x_msg_count OUT NOCOPY NUMBER,
1937: x_msg_data OUT NOCOPY VARCHAR2 )
1938: IS

Line 1983: SELECT fa_mass_additions_s.nextval

1979:
1980: BEGIN
1981: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1982:
1983: SELECT fa_mass_additions_s.nextval
1984: INTO p_mass_add_rec.mass_addition_id
1985: FROM SYS.DUAL ;
1986:
1987: debug('inside api insert_mass_add');

Line 2031: INSERT INTO fa_mass_additions(

2027: p_mass_add_rec.transaction_date :=p_mass_add_rec.date_placed_in_service;
2028: p_mass_add_rec.TRANSACTION_TYPE_CODE:='FUTURE ADD';
2029: END IF;
2030:
2031: INSERT INTO fa_mass_additions(
2032: mass_addition_id,
2033: asset_number,
2034: tag_number,
2035: description,