APPS.GHG_PO_EMISSIONS_PKG dependencies on GHG_TRANSACTION_DETAILS_ALL
Line 109: delete from GHG_TRANSACTION_DETAILS_ALL where transaction_id = emission_rec.transaction_id;
105: -- If the current invoice has emissions, then archive them to history and then delete them.
106: FOR emission_rec IN get_emissions(x_invoice_id) LOOP
107: GHG_TRANSACTIONS_HISTORY_PKG.insert_row(x_transaction_id => emission_rec.transaction_id);
108: ghg_transactions_pkg.delete_row(x_emission_id => emission_rec.transaction_id); 109: delete from GHG_TRANSACTION_DETAILS_ALL where transaction_id = emission_rec.transaction_id; 110: END LOOP;
111:
112: v_debug_info := 'Get coa_id';
113: