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 1214: l_mass_add_rec fa_mass_additions%ROWTYPE ;

1210: l_msg_data VARCHAR2(2000);
1211: l_msg_count NUMBER;
1212: l_trx_error_rec csi_datastructures_pub.transaction_error_rec ;
1213: l_txn_error_id NUMBER ;
1214: l_mass_add_rec fa_mass_additions%ROWTYPE ;
1215: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
1216:
1217: BEGIN
1218:

Line 4032: fa_mass_additions fma

4028:
4029: CURSOR cia_pending_in_fma(p_inst_id IN number) IS
4030: SELECT cia.instance_asset_id
4031: FROM csi_i_assets cia,
4032: fa_mass_additions fma
4033: WHERE cia.instance_id = p_inst_id
4034: AND cia.asset_quantity > 0
4035: AND cia.fa_asset_id is null
4036: AND fma.mass_addition_id = cia.fa_mass_addition_id

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

4124: LOOP
4125: FOR pending_rec IN cia_pending_in_fma(l_inst_tbl(l_ind).instance_id)
4126: LOOP
4127: px_action := 'NONE';
4128: debug('unprocessed fa mass additions record found. skipping.');
4129: exit;
4130: END LOOP;
4131: IF px_action = 'NONE' THEN
4132: exit;