eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHG_TRANSACTIONS_API_PKG dependencies on GHG_TRANSACTION_BATCHES

Line 399: FROM GHG_TRANSACTION_BATCHES

395: batch_type
396: INTO v_emission_batch_id
397: , v_batch_status
398: , v_batch_type
399: FROM GHG_TRANSACTION_BATCHES
400: WHERE transaction_batch_number = p_batch_number;
401:
402: IF v_batch_status = 'A' THEN
403: IF v_batch_type = 'INT_INVOICE' THEN

Line 749: SELECT GHG_TRANSACTION_BATCHES_s.NEXTVAL

745: -- Insert Row
746:
747: IF v_emission_batch_id is NULL THEN
748:
749: SELECT GHG_TRANSACTION_BATCHES_s.NEXTVAL
750: INTO v_emission_batch_id
751: FROM DUAL;
752:
753: GHG_TRANSACTION_BATCHES_PKG.insert_row (x_rowid => v_batch_rowid,

Line 753: GHG_TRANSACTION_BATCHES_PKG.insert_row (x_rowid => v_batch_rowid,

749: SELECT GHG_TRANSACTION_BATCHES_s.NEXTVAL
750: INTO v_emission_batch_id
751: FROM DUAL;
752:
753: GHG_TRANSACTION_BATCHES_PKG.insert_row (x_rowid => v_batch_rowid,
754: x_transaction_batch_id => v_emission_batch_id,
755: x_transaction_batch_number => p_batch_number,
756: x_batch_type => p_batch_type,
757: x_batch_sub_type => p_batch_sub_type,