APPS.CSE_ASSET_UTIL_PKG dependencies on FA_MASS_ADDITIONS

Line 1339: FROM fa_mass_additions fma

1335: IS
1336: SELECT SUM(NVL(fma.fixed_assets_cost,0)) cost ,
1337: SUM(fma.fixed_assets_units) total_units ,
1338: fma.mass_addition_id
1339: FROM fa_mass_additions fma
1340: ,fa_massadd_distributions fmd
1341: WHERE fmd.mass_addition_id = fma.mass_addition_id
1342: AND fma.posting_status = 'POST'
1343: AND fma.book_type_code = p_asset_query_rec.book_type_code

Line 1748: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,

1744: PROCEDURE insert_mass_add(
1745: p_api_version IN NUMBER,
1746: p_commit IN VARCHAR2,
1747: p_init_msg_list IN VARCHAR2,
1748: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
1749: x_return_status OUT NOCOPY VARCHAR2,
1750: x_msg_count OUT NOCOPY NUMBER,
1751: x_msg_data OUT NOCOPY VARCHAR2 )
1752: IS

Line 1793: SELECT fa_mass_additions_s.nextval

1789:
1790: BEGIN
1791: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
1792:
1793: SELECT fa_mass_additions_s.nextval
1794: INTO p_mass_add_rec.mass_addition_id
1795: FROM SYS.DUAL ;
1796:
1797: debug('inside api insert_mass_add');

Line 1832: INSERT INTO fa_mass_additions(

1828: p_mass_add_rec.transaction_date :=p_mass_add_rec.date_placed_in_service;
1829: p_mass_add_rec.TRANSACTION_TYPE_CODE:='FUTURE ADD';
1830: END IF;
1831:
1832: INSERT INTO fa_mass_additions(
1833: mass_addition_id,
1834: asset_number,
1835: tag_number,
1836: description,