APPS.GHG_TRANSACTIONS_PKG dependencies on GHG_TRANSACTION_DETAILS_ALL

Line 365: DELETE FROM GHG_transaction_details_all

361:
362: DELETE FROM GHG_transactions_all
363: WHERE transaction_id = x_emission_id;
364:
365: DELETE FROM GHG_transaction_details_all
366: WHERE transaction_id = x_emission_id;
367:
368: IF (sql%notfound) THEN
369: RAISE no_data_found;

Line 590: FROM GHG_transaction_details_all

586: v_total NUMBER;
587: BEGIN
588: SELECT sum(transaction_value)
589: INTO v_total
590: FROM GHG_transaction_details_all
591: where transaction_id = x_emission_id
592: AND transaction_type = 'E';
593:
594: RETURN v_total;

Line 607: FROM GHG_transaction_details_all

603: v_total NUMBER;
604: BEGIN
605: SELECT sum(transaction_value)
606: INTO v_total
607: FROM GHG_transaction_details_all
608: where transaction_id = x_emission_id
609: AND transaction_type = 'N';
610:
611: RETURN v_total;

Line 692: delete from GHG_transaction_details_all where transaction_id = emission_rec.transaction_id;

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:
695: SELECT asp.org_id,
696: asp.set_of_books_id,

Line 827: delete from GHG_transaction_details_all where transaction_id = cancel_emission.transaction_id;

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;
829: END LOOP ;
830: END;
831: