APPS.CSE_ASSET_MOVE_PKG dependencies on FA_MASS_ADDITIONS

Line 595: FROM fa_mass_additions fma

591: ORDER BY fb.date_placed_in_service ;
592:
593: CURSOR unposted_famass_add_cur(c_asset_id IN NUMBER, c_book_type_code IN VARCHAR2) IS
594: SELECT SUM(NVL(fma.fixed_assets_cost,0)) cost
595: FROM fa_mass_additions fma
596: WHERE fma.posting_status = 'POST'
597: AND fma.book_type_code = c_book_type_code
598: AND fma.add_to_asset_id = c_asset_id;
599:

Line 1229: l_mass_add_rec fa_mass_additions%ROWTYPE ;

1225: l_msg_data VARCHAR2(2000);
1226: l_msg_count NUMBER;
1227: l_trx_error_rec csi_datastructures_pub.transaction_error_rec ;
1228: l_txn_error_id NUMBER ;
1229: l_mass_add_rec fa_mass_additions%ROWTYPE ;
1230: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
1231:
1232: BEGIN
1233:

Line 4256: fa_mass_additions fma

4252:
4253: CURSOR cia_pending_in_fma(p_inst_id IN number) IS
4254: SELECT cia.instance_asset_id
4255: FROM csi_i_assets cia,
4256: fa_mass_additions fma
4257: WHERE cia.instance_id = p_inst_id
4258: AND cia.asset_quantity > 0
4259: AND cia.fa_asset_id is null
4260: AND fma.mass_addition_id = cia.fa_mass_addition_id

Line 4352: debug('unprocessed fa mass additions record found. skipping.');

4348: LOOP
4349: FOR pending_rec IN cia_pending_in_fma(l_inst_tbl(l_ind).instance_id)
4350: LOOP
4351: px_action := 'NONE';
4352: debug('unprocessed fa mass additions record found. skipping.');
4353: exit;
4354: END LOOP;
4355: IF px_action = 'NONE' THEN
4356: exit;