DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_PKG dependencies on GHG_TRANSACTIONS_HISTORY_PKG

Line 690: GHG_transactions_history_pkg.insert_row(x_transaction_id => emission_rec.transaction_id);

686:
687:
688: -- If the current invoice has emissions, then archive them to history and then delete them.
689: FOR emission_rec IN get_emissions(p_invoice_id) LOOP
690: GHG_transactions_history_pkg.insert_row(x_transaction_id => emission_rec.transaction_id);
691: GHG_transactions_pkg.delete_row(x_emission_id => emission_rec.transaction_id);
692: delete from GHG_transaction_details_all where transaction_id = emission_rec.transaction_id;
693: END LOOP;
694:

Line 824: GHG_TRANSACTIONS_HISTORY_PKG.insert_row(cancel_emission.transaction_id);

820:
821: FOR cancel_emission IN cancel_emissions(x_invoice_id) LOOP
822:
823: -- Move emission to history
824: GHG_TRANSACTIONS_HISTORY_PKG.insert_row(cancel_emission.transaction_id);
825:
826: delete from GHG_transactions where transaction_id = cancel_emission.transaction_id;
827: delete from GHG_transaction_details_all where transaction_id = cancel_emission.transaction_id;
828: commit;