DBA Data[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;