[Home] [Help]
PACKAGE: APPS.GHG_TRANSACTIONS_API_PKG
Source
1 PACKAGE GHG_TRANSACTIONS_API_PKG AUTHID CURRENT_USER AS
2 /*$Header: ghgtxnas.pls 120.2 2011/12/22 12:01:02 sriklaks noship $ */
3
4
5 PROCEDURE create_transaction (p_org_id NUMBER DEFAULT FND_PROFILE.value('ORG_ID'),
6 p_batch_type VARCHAR2 DEFAULT NULL,
7 p_batch_sub_type VARCHAR2 DEFAULT NULL,
8 p_batch_number VARCHAR2 DEFAULT NULL,
9 p_batch_description VARCHAR2 DEFAULT NULL,
10 p_facility VARCHAR2 DEFAULT NULL,
11 p_emission_source_name VARCHAR2 DEFAULT NULL ,
12 p_emission_scope VARCHAR DEFAULT NULL,
13 p_emission_location VARCHAR2 DEFAULT NULL ,
14 p_emission_usage NUMBER DEFAULT NULL,
15 p_emission_uom VARCHAR2 DEFAULT NULL,
16 p_emission_from_date DATE DEFAULT NULL,
17 p_emission_to_date DATE DEFAULT NULL,
18 p_emission_description VARCHAR2 DEFAULT NULL,
19 p_supplier VARCHAR2 DEFAULT NULL,
20 p_supplier_site_name VARCHAR2 DEFAULT NULL,
21 p_item_number VARCHAR2 DEFAULT NULL,
22 p_ghgas_asset VARCHAR2 DEFAULT NULL,
23 p_invoice_id NUMBER DEFAULT NULL,
24 p_invoice_line_num NUMBER DEFAULT NULL,
25 p_invoice_dist_num NUMBER DEFAULT NULL,
26 p_m_criteria VARCHAR2 DEFAULT NULL,
27 p_commit_flag VARCHAR2 DEFAULT 'Y',
28 p_manual_entry_flag VARCHAR2 DEFAULT 'N');
29
30
31 PROCEDURE rebuild_emissions (errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY NUMBER,
33 p_org_id IN NUMBER,
34 p_supplier_id IN NUMBER DEFAULT NULL,
35 p_invoice_id IN NUMBER DEFAULT NULL,
36 p_facility_id IN NUMBER DEFAULT NULL,
37 p_source_id IN NUMBER DEFAULT NULL,
38 p_emssion_from IN VARCHAR2 DEFAULT NULL,
39 p_emssion_to IN VARCHAR2 DEFAULT NULL
40 );
41
42 PROCEDURE run_etl (errbuf OUT NOCOPY VARCHAR2,
43 RETCODE OUT NOCOPY number,
44 P_ORG_ID in number);
45
46 PROCEDURE SEED_FORMULA_TO_ORGS (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER) ;
47
48
49 END GHG_TRANSACTIONS_API_PKG;