[Home] [Help]
PACKAGE: APPS.GHG_UTILITIES_PKG
Source
1 PACKAGE GHG_UTILITIES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ghgutils.pls 120.1 2011/10/31 08:24:20 pwaghmar noship $ */
3
4 START_DATE date := To_Date('01-01-1900', 'DD-MM-YYYY');
5 END_DATE date := To_Date('31-12-4096', 'DD-MM-YYYY');
6
7
8 FUNCTION emissions_exist (x_invoice_id NUMBER) RETURN VARCHAR2;
9
10 FUNCTION get_conversion (x_from_uom VARCHAR2,
11 x_from_emission_source_id NUMBER,
12 x_from_type VARCHAR2,
13 x_calling_function VARCHAR2) RETURN NUMBER;
14
15 FUNCTION ghg_supplier (x_vendor_id NUMBER,
16 x_vendor_site_id NUMBER) RETURN VARCHAR2;
17
18 FUNCTION ghg_transaction (x_invoice_id NUMBER) RETURN VARCHAR2;
19
20 FUNCTION get_default_source (x_supplier_id NUMBER,
21 x_supplier_site_id NUMBER) RETURN VARCHAR2;
22
23 PROCEDURE automate_emissions (x_invoice_id NUMBER);
24
25 FUNCTION get_multiplier(x_invoice_id number,
26 x_inv_line_num number,
27 x_dist_line_num number) return number;
28
29 FUNCTION is_ghg_item (x_item_id NUMBER) RETURN VARCHAR2;
30
31
32 END GHG_UTILITIES_PKG;