PACKAGE: APPS.GHG_EMISSION_RATES_PKG

Source

1 PACKAGE GHG_EMISSION_RATES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ghgemrts.pls 120.2 2012/01/17 09:00:11 sriklaks noship $ */
3 
4 FUNCTION rate_in_use (x_rate_id NUMBER) RETURN BOOLEAN ;
5 
6 FUNCTION generate_rate_id RETURN NUMBER;
7 
8 FUNCTION get_max_factor_date (x_emission_source_id number ,
9                               x_code_combination_id number,
10                               x_scope_lookup_code number,
11                               x_location_code  varchar2,
12                               x_transport_type_lookup_code  varchar2,
13                               x_supplier_id number,
14                               x_supplier_site_id number,
15                               x_item_id number,
16                               x_item_type varchar2,
17                               x_facility_id number
18                               ) return date;
19 
20 FUNCTION lock_date (x_emission_source_id number,
21                     x_code_combination_id number,
22                     x_date date,
23                     x_supplier_id number,
24                     x_supplier_site_id number,
25                     x_item_id number,
26                     x_item_type varchar2,
27                     x_facility_id number
28                    ) return boolean;
29 
30 PROCEDURE calculate_emissions ( x_emission_id number );
31 
32 FUNCTION are_there_any_rates (x_source_id NUMBER,
33                               x_scope     VARCHAR2,
34                               x_location  VARCHAR2,
35                               x_start_date DATE,
36                               x_end_date   DATE,
37                               x_supplier_id NUMBER,
38                               x_supplier_site_id NUMBER,
39                               x_item_id          NUMBER,
40                               x_asset_id         NUMBER,
41                               x_facility_id      NUMBER
42                               ) RETURN BOOLEAN ;
43 
44 FUNCTION get_factor (x_source_id NUMBER,
45                      x_scope     VARCHAR2,
46                      x_location  VARCHAR2,
47                      x_emission_date DATE,
48                      x_supplier_id NUMBER,
49                      x_supplier_site_id NUMBER,
50                      x_item_id          NUMBER,
51                      x_asset_id         NUMBER,
52                      x_facility_id      NUMBER
53                      ) RETURN NUMBER;
54 
55 
56  procedure create_ledger_entry ( x_emission_id NUMBER,
57                                 x_factor_id  NUMBER,
58                                 x_quantity   NUMBER,
59                                 x_emission_date DATE,
60                                 x_uom_class VARCHAR2,
61 								x_org_id NUMBER) ;
62 
63 
64 FUNCTION are_there_any_rates_location (x_source_id NUMBER,
65                               x_scope     VARCHAR2,
66                               x_location  VARCHAR2,
67 							  x_user_location VARCHAR2,
68                               x_start_date DATE,
69                               x_end_date   DATE,
70                               x_supplier_id NUMBER,
71                               x_supplier_site_id NUMBER,
72                               x_item_id          NUMBER,
73                               x_asset_id         NUMBER,
74                               x_facility_id      NUMBER
75                               ) RETURN BOOLEAN;
76 
77 FUNCTION get_factor_user_location (x_source_id NUMBER,
78                      x_scope     VARCHAR2,
79                      x_location  VARCHAR2,
80 					 x_user_location VARCHAR2,
81                      x_emission_date DATE,
82                      x_supplier_id NUMBER ,
83                      x_supplier_site_id NUMBER ,
84                      x_item_id          NUMBER ,
85                      x_asset_id         NUMBER ,
86                      x_facility_id      NUMBER
87                      ) RETURN NUMBER;
88 
89 
90 
91 END GHG_emission_rates_pkg;