APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FA_EXT_INV_RETIREMENTS

Line 303: from fa_ext_inv_retirements ext ,

299:
300: /** commented out for bugfix 2036777
301: Cursor Source_Lines_C Is
302: Select ext.*
303: from fa_ext_inv_retirements ext ,
304: fa_asset_invoices ai
305: where ext.mass_external_retire_id = L_Mass_External_Retire_ID
306: and ext.source_line_id = ai.source_line_id
307: and ai.date_ineffective is null

Line 317: from fa_ext_inv_retirements ext,

313: -- modified after 2036777, added fa_ai, so only invoices belonging
314: -- to current asset are treated.
315: Cursor Source_Lines_C Is
316: select ext.*, ext.ROWID row_id
317: from fa_ext_inv_retirements ext,
318: fa_asset_invoices ai
319: where ext.mass_external_retire_id = G_Mass_External_Retire_ID
320: and ext.source_line_id = ai.source_line_id
321: and ai.asset_id = g_asset_id

Line 935: update fa_ext_inv_retirements

931: l_inv_rec.fixed_assets_cost := source_lines_rec.cost_retired;
932: end if;
933: l_inv_rec.inv_indicator := k;
934:
935: update fa_ext_inv_retirements
936: set source_line_id_retired = l_inv_rec.source_line_id
937: where source_line_id = l_inv_rec.source_line_id;
938:
939: l_inv_tbl(k) := l_inv_rec;

Line 1540: from fa_ext_inv_retirements

1536: Fetch Assets_C into LV_Mass_External_Retire_ID;
1537: Exit when Assets_C%NOTFOUND;
1538:
1539: Select count(*) into LV_Inv_Count
1540: from fa_ext_inv_retirements
1541: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1542:
1543: if LV_Inv_Count > 0 then
1544: Delete from fa_ext_inv_retirements

Line 1544: Delete from fa_ext_inv_retirements

1540: from fa_ext_inv_retirements
1541: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1542:
1543: if LV_Inv_Count > 0 then
1544: Delete from fa_ext_inv_retirements
1545: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1546: end if;
1547:
1548: Delete from fa_mass_ext_retirements