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_PKG dependencies on GHG_TRANSACTIONS

Line 1: PACKAGE BODY GHG_TRANSACTIONS_PKG AS

1: PACKAGE BODY GHG_TRANSACTIONS_PKG AS
2: /*$Header: ghgtxnb.pls 120.3.12020000.2 2012/10/17 04:35:54 sasuren ship $ */
3:
4: PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
5: x_txn_type_lookup_code VARCHAR2,

Line 65: FROM GHG_transactions_all

61: v_debug_info VARCHAR2(100);
62:
63: CURSOR c IS
64: SELECT ROWID
65: FROM GHG_transactions_all
66: WHERE transaction_id = x_emission_id;
67:
68: BEGIN
69:

Line 70: v_debug_info := 'Inserting into GHG_transactions_all';

66: WHERE transaction_id = x_emission_id;
67:
68: BEGIN
69:
70: v_debug_info := 'Inserting into GHG_transactions_all';
71:
72: begin
73: INSERT INTO GHG_transactions_all (txn_type_lookup_code,
74: transaction_id,

Line 73: INSERT INTO GHG_transactions_all (txn_type_lookup_code,

69:
70: v_debug_info := 'Inserting into GHG_transactions_all';
71:
72: begin
73: INSERT INTO GHG_transactions_all (txn_type_lookup_code,
74: transaction_id,
75: transaction_batch_id,
76: transaction_source_id,
77: ghg_organization_id,

Line 283: v_debug_info := 'Updating GHG_transactions_all';

279: v_debug_info VARCHAR2(100);
280:
281: BEGIN
282:
283: v_debug_info := 'Updating GHG_transactions_all';
284:
285: UPDATE GHG_transactions_all
286: SET txn_type_lookup_code = x_txn_type_lookup_code,
287: transaction_id = x_emission_id,

Line 285: UPDATE GHG_transactions_all

281: BEGIN
282:
283: v_debug_info := 'Updating GHG_transactions_all';
284:
285: UPDATE GHG_transactions_all
286: SET txn_type_lookup_code = x_txn_type_lookup_code,
287: transaction_id = x_emission_id,
288: transaction_batch_id = x_emission_batch_id,
289: transaction_source_id = x_emission_source_id,

Line 362: DELETE FROM GHG_transactions_all

358: PROCEDURE delete_row (x_emission_id NUMBER) IS
359:
360: BEGIN
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;

Line 486: FROM GHG_transactions_all

482: last_update_date,
483: last_update_login,
484: emission_scope_lookup_code,
485: location_code
486: FROM GHG_transactions_all
487: WHERE rowid = x_rowid
488: FOR UPDATE of transaction_id NOWAIT;
489: recinfo C%ROWTYPE;
490:

Line 633: FROM GHG_transactions_v

629: p_m_criteria VARCHAR2) IS
630:
631: CURSOR get_emissions (p_invoice_id NUMBER) IS
632: SELECT transaction_id
633: FROM GHG_transactions_v
634: WHERE invoice_id = p_invoice_id;
635:
636: CURSOR get_invoice_distributions (p_invoice_id NUMBER) IS
637: SELECT ai.vendor_id ,

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 691: GHG_transactions_pkg.delete_row(x_emission_id => emission_rec.transaction_id);

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

Line 774: GHG_TRANSACTIONS_API_PKG.create_transaction(

770: FROM GHG_organizations
771: WHERE ghg_organization_id = v_facility_id;
772:
773:
774: GHG_TRANSACTIONS_API_PKG.create_transaction(
775: p_org_id => v_org_id,
776: p_batch_type => 'INT_INVOICE' ,
777: p_batch_sub_type => NULL ,
778: p_batch_number =>

Line 816: FROM GHG_transactions

812: x_mesg IN OUT NOCOPY VARCHAR2) is
813:
814: CURSOR cancel_emissions (p_invoice_id number) IS
815: SELECT TRANSACTION_ID
816: FROM GHG_transactions
817: WHERE invoice_id = p_invoice_id;
818: BEGIN
819:
820:

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;

Line 826: delete from GHG_transactions where transaction_id = cancel_emission.transaction_id;

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

Line 885: GHG_TRANSACTIONS e

881:
882: select count(*)
883: into v_count
884: from GHG_transaction_batches b,
885: GHG_TRANSACTIONS e
886: where b.transaction_batch_id = e.transaction_batch_id
887: and b.transaction_batch_number = 'INV Issue:'||P_MATERIAL_TRX_SET_ID
888: and e.description = p_TRANS_REF;
889:

Line 897: GHG_TRANSACTIONS e

893: delete from ghg_transaction_details d
894: where exists (
895: select 1
896: from GHG_transaction_batches b,
897: GHG_TRANSACTIONS e
898: where b.transaction_batch_id = e.transaction_batch_id
899: and b.transaction_batch_number = 'INV Issue:'||P_MATERIAL_TRX_SET_ID
900: and e.description = p_TRANS_REF
901: and e.transaction_id = d.transaction_id

Line 904: delete from ghg_transactions e

900: and e.description = p_TRANS_REF
901: and e.transaction_id = d.transaction_id
902: );
903:
904: delete from ghg_transactions e
905: where e.description = p_TRANS_REF
906: and exists (
907: select 1
908: from GHG_transaction_batches b

Line 962: GHG_TRANSACTIONS_API_PKG.create_transaction(

958:
959: vl_debug := '1:';
960:
961:
962: GHG_TRANSACTIONS_API_PKG.create_transaction(
963: p_org_id => v_org_id,
964: p_batch_type => 'ITEM' ,
965: p_batch_sub_type => NULL ,
966: p_batch_number => 'INV Issue:'||P_MATERIAL_TRX_SET_ID,

Line 1008: select GHG_TRANSACTIONS_S.NEXTVAL

1004: BEGIN
1005: IF p_old_reference IS NOT NULL THEN --Bug 12646349 - SSURENDR
1006: vl_nextval := p_old_reference;
1007: ELSE
1008: select GHG_TRANSACTIONS_S.NEXTVAL
1009: into vl_nextval
1010: from dual;
1011: END IF;
1012:

Line 1034: END GHG_transactions_pkg;

1030: RETURN vl_item_number;
1031: END;
1032:
1033:
1034: END GHG_transactions_pkg;