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_TRANSACTIONS

Line 1: PACKAGE BODY GHG_TRANSACTIONS_API_PKG AS

1: PACKAGE BODY GHG_TRANSACTIONS_API_PKG AS
2: /*$Header: ghgtxnab.pls 120.3.12020000.4 2013/05/21 06:49:15 neechand ship $ */
3:
4: raise_error EXCEPTION; --Bug 13507113 (sasuren): Moved exception to package body context
5: /* lvenkatr 12/6/2011 - Added validations for batch sub type, supplier and

Line 181: FROM GHG_TRANSACTIONS_V txn

177: -- Check if transactions exist for the Emission Dates
178: x_debug('Check if transactions exist for the Emission Dates');
179: SELECT COUNT(*)
180: INTO v_row_count
181: FROM GHG_TRANSACTIONS_V txn
182: WHERE (p_emission_from_date between txn.transaction_date_from
183: and txn.transaction_date_to )
184: OR (p_emission_to_date between txn.transaction_date_from
185: and txn.transaction_date_to )

Line 192: FND_MESSAGE.SET_NAME('GHG', 'GHG_TRANSACTIONS_EXIST');

188: OR (txn.transaction_date_to between p_emission_from_date
189: and p_emission_to_date );
190:
191: IF v_row_count > 0 THEN
192: FND_MESSAGE.SET_NAME('GHG', 'GHG_TRANSACTIONS_EXIST');
193: RAISE raise_error;
194: ELSE
195: v_row_count := 0;
196: END IF;

Line 723: SELECT GHG_TRANSACTIONS_S.NEXTVAL

719: x_debug('After rate check');
720:
721: -- Get Key Data
722: -----------------------------------------------------------------------------------------
723: SELECT GHG_TRANSACTIONS_S.NEXTVAL
724: into v_emission_id
725: FROM dual;
726:
727: v_uom_conversion := GHG_UTILITIES_PKG.get_conversion(p_emission_uom, v_emission_source_id, 'GENERAL','API');

Line 731: FROM GHG_TRANSACTIONS

727: v_uom_conversion := GHG_UTILITIES_PKG.get_conversion(p_emission_uom, v_emission_source_id, 'GENERAL','API');
728:
729: SELECT NVL(MAX(transaction_line_number),0)+1
730: INTO v_max_line_no
731: FROM GHG_TRANSACTIONS
732: WHERE transaction_batch_id = v_emission_batch_id;
733:
734: IF p_batch_type <> 'INT_INVOICE' THEN
735: v_status := 'U';

Line 780: GHG_TRANSACTIONS_PKG.insert_row (x_rowid => v_batch_rowid,

776: v_supplier_id:= p_supplier;
777: v_supplier_site_id := p_supplier_site_name;
778: END IF;
779:
780: GHG_TRANSACTIONS_PKG.insert_row (x_rowid => v_batch_rowid,
781: x_txn_type_lookup_code => p_batch_type,
782: x_emission_id => v_emission_id,
783: x_emission_batch_id => v_emission_batch_id,
784: x_facility_id => v_facility_id,

Line 891: FROM GHG_TRANSACTIONS_all em

887: v_msg varchar2(500) ; --bug 14741401--neechand
888:
889: CURSOR emissions_records IS
890: SELECT *
891: FROM GHG_TRANSACTIONS_all em
892: WHERE org_id = p_org_id
893: AND nvl(em.vendor_id,-1) = nvl(p_supplier_id, nvl(em.vendor_id,-1))
894: AND nvl(em.invoice_id,-1) = nvl(p_invoice_id, nvl(em.invoice_id,-1) )
895: AND em.ghg_organization_id = nvl(p_facility_id, em.ghg_organization_id)

Line 901: FROM GHG_TRANSACTIONS_all em

897: AND (trunc(em.transaction_date_from) between nvl(v_emission_from_date, em.transaction_date_from) and nvl(v_emission_to_date, em.transaction_date_to)
898: OR trunc(em.transaction_date_to) between nvl(v_emission_from_date, em.transaction_date_from) and nvl(v_emission_to_date, em.transaction_date_to))
899: UNION ALL
900: SELECT *
901: FROM GHG_TRANSACTIONS_all em
902: WHERE org_id = p_org_id
903: AND nvl(em.vendor_id,-1) = nvl(p_supplier_id, nvl(em.vendor_id,-1))
904: AND nvl(em.invoice_id,-1) = nvl(p_invoice_id, nvl(em.invoice_id,-1) )
905: AND em.ghg_organization_id = nvl(p_facility_id, em.ghg_organization_id)

Line 1022: clear_table('GHG_TRANSACTIONS_D', v_dblink);

1018: clear_table('GHG_ORG_HIERARCHY_STRUCTURES_D', v_dblink);
1019: clear_table('GHG_ORGANIZATIONS_D', v_dblink);
1020:
1021:
1022: clear_table('GHG_TRANSACTIONS_D', v_dblink);
1023: clear_table('GHG_TRANSACTION_DETAILS_F', v_dblink);
1024: clear_table('GHG_TRANSACTIONS_BY_MONTH_F', v_dblink);
1025: clear_table('GHG_ORGANIZATION_INTERESTS_D', v_dblink);
1026: clear_table('GHG_ORGANIZATION_CONTROL_D', v_dblink);

Line 1024: clear_table('GHG_TRANSACTIONS_BY_MONTH_F', v_dblink);

1020:
1021:
1022: clear_table('GHG_TRANSACTIONS_D', v_dblink);
1023: clear_table('GHG_TRANSACTION_DETAILS_F', v_dblink);
1024: clear_table('GHG_TRANSACTIONS_BY_MONTH_F', v_dblink);
1025: clear_table('GHG_ORGANIZATION_INTERESTS_D', v_dblink);
1026: clear_table('GHG_ORGANIZATION_CONTROL_D', v_dblink);
1027: clear_table('GHG_KPI_TRANSACTIONS_F', v_dblink);
1028: clear_table('GHG_KPI_DEFINITIONS_D', v_dblink);

Line 1526: write_to_log('Inserting into GHG_TRANSACTIONS_D_TMP');

1522:
1523:
1524:
1525:
1526: write_to_log('Inserting into GHG_TRANSACTIONS_D_TMP');
1527: v_stmt :=
1528: 'INSERT INTO GHG_TRANSACTIONS_D_TMP ' ||
1529: '( ' ||
1530: 'SOURCE_APPLICATION_CODE, ' ||

Line 1528: 'INSERT INTO GHG_TRANSACTIONS_D_TMP ' ||

1524:
1525:
1526: write_to_log('Inserting into GHG_TRANSACTIONS_D_TMP');
1527: v_stmt :=
1528: 'INSERT INTO GHG_TRANSACTIONS_D_TMP ' ||
1529: '( ' ||
1530: 'SOURCE_APPLICATION_CODE, ' ||
1531: 'TRANSACTION_ID, ' ||
1532: 'DOCUMENT_TYPE, ' ||

Line 1587: 'FROM GHG_TRANSACTIONS_ALL tr ' ||

1583: ', tr.measurement_criteria measurement_criteria_code ' ||
1584: ', tr.measurement_criteria measurement_criteria_desc ' ||
1585: ', nvl(tr.usage_quantity,0) ' ||
1586: ', tr.unit_of_measure ' ||
1587: 'FROM GHG_TRANSACTIONS_ALL tr ' ||
1588: ', ap_invoices ap ' ||
1589: ', GHG_PERIODS_D@' || v_dblink || ' rp ' ||
1590: ', fnd_currencies_tl cur ' ||
1591: ', GHG_TRANSACTION_DETAILS_ALL em ' ||

Line 1604: write_to_log('Inserting into GHG_TRANSACTIONS_D');

1600:
1601:
1602: EXECUTE IMMEDIATE v_stmt;
1603:
1604: write_to_log('Inserting into GHG_TRANSACTIONS_D');
1605: v_stmt :=
1606: 'INSERT INTO GHG_TRANSACTIONS_D@' || v_dblink ||
1607: ' ( ' ||
1608: 'SOURCE_APPLICATION_CODE, ' ||

Line 1606: 'INSERT INTO GHG_TRANSACTIONS_D@' || v_dblink ||

1602: EXECUTE IMMEDIATE v_stmt;
1603:
1604: write_to_log('Inserting into GHG_TRANSACTIONS_D');
1605: v_stmt :=
1606: 'INSERT INTO GHG_TRANSACTIONS_D@' || v_dblink ||
1607: ' ( ' ||
1608: 'SOURCE_APPLICATION_CODE, ' ||
1609: 'TRANSACTION_ID, ' ||
1610: 'DOCUMENT_TYPE, ' ||

Line 1666: 'FROM GHG_TRANSACTIONS_D_TMP WHERE SOURCE_APPLICATION_CODE='|| p_org_id ||'';

1662: 'measurement_criteria_code, ' ||
1663: 'measurement_criteria_desc, ' ||
1664: 'ENTERED_USAGE_QUANTITY, ' ||
1665: 'ENTERED_USAGE_UOM ' ||
1666: 'FROM GHG_TRANSACTIONS_D_TMP WHERE SOURCE_APPLICATION_CODE='|| p_org_id ||'';
1667:
1668:
1669:
1670: EXECUTE IMMEDIATE v_stmt;

Line 1700: 'from GHG_TRANSACTIONS_all em ' ||

1696: ', em.ghg_asset_id ' ||
1697: ', em.vendor_id ' ||
1698: ', em.inventory_item_id ' ||
1699: ', em.ghg_organization_id ' ||
1700: 'from GHG_TRANSACTIONS_all em ' ||
1701: ', GHG_TRANSACTION_DETAILS_all ld ' ||
1702: 'where em.transaction_id = ld.transaction_id ' ||
1703: 'and ld.transaction_type = ''E''';
1704:

Line 1714: 'insert INTO GHG_TRANSACTIONS_BY_MONTH_F@' || v_dblink ||

1710: EXECUTE IMMEDIATE v_stmt;
1711:
1712: write_to_log('Inserting into GHG_TRANSACTION_DETAILS_F');
1713: v_stmt :=
1714: 'insert INTO GHG_TRANSACTIONS_BY_MONTH_F@' || v_dblink ||
1715: '( ' ||
1716: 'LEVEL3_ID, ' ||
1717: 'SOURCE_APPLICATION_CODE, ' ||
1718: 'TRANSACTION_VALUE, ' ||

Line 1786: 'from GHG_TRANSACTIONS_D@' || v_dblink || ' tr ' ||

1782: 'location_county, ' ||
1783: 'ORGANIZATION_ID, ' ||
1784: 'measurement_criteria_code, ' ||
1785: 'measurement_criteria_desc ' ||
1786: 'from GHG_TRANSACTIONS_D@' || v_dblink || ' tr ' ||
1787: 'group by source_application_code, trunc(transaction_date), ' ||
1788: 'transaction_value, transaction_currency_code, ' ||
1789: 'transaction_currency_desc, emission_source_id, ' ||
1790: 'emission_source_usage_uom, emission_scope_id, energy_type, ' ||

Line 1971: ', GHG_TRANSACTIONS_D@' || v_dblink || ' trx ' ||

1967: ' (select meaning from fnd_lookup_values lv where lv.language='||concat(''''||v_language||'','''') || ' and lv.lookup_type = ''GHG_BI_TRANSACTION_TYPE'' and lv.lookup_code=''ACT'') transaction_type ' ||
1968: 'from GHG_KPI_DEFINITIONS_all kpd ' ||
1969: ', GHG_KPI_COMPONENTS kpc ' ||
1970: ', GHG_SOURCES_D@' || v_dblink || ' src ' ||
1971: ', GHG_TRANSACTIONS_D@' || v_dblink || ' trx ' ||
1972: ', GHG_UOM_CLASSES_all umn ' ||
1973: ', GHG_UOM_CLASSES_all umd ' ||
1974: 'where kpd.kpi_id = kpc.kpi_id ' ||
1975: 'and kpc.source_id = src.source_info_code_1 ' ||

Line 2010: ', GHG_TRANSACTIONS_D@' || v_dblink || ' trx ' ||

2006: '''Actuals'' transaction_type ' ||
2007: 'from GHG_KPI_DEFINITIONS_all kpd ' ||
2008: ', GHG_KPI_COMPONENTS kpc ' ||
2009: ', GHG_SOURCES_D@' || v_dblink || ' src ' ||
2010: ', GHG_TRANSACTIONS_D@' || v_dblink || ' trx ' ||
2011: ', GHG_UOM_CLASSES_all umn ' ||
2012: ', GHG_UOM_CLASSES_all umd ' ||
2013: 'where kpd.kpi_id = kpc.kpi_id ' ||
2014: 'and kpc.source_id = src.source_info_code_1 ' ||

Line 2138: END GHG_TRANSACTIONS_API_PKG;

2134:
2135:
2136:
2137:
2138: END GHG_TRANSACTIONS_API_PKG;