[Home] [Help]
1 PACKAGE GHG_TRANSACTIONS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ghgtxns.pls 120.1.12020000.2 2012/10/17 04:39:32 sasuren ship $ */
3
4
5 PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
6 x_txn_type_lookup_code VARCHAR2,
7 x_emission_id NUMBER,
8 x_emission_batch_id NUMBER,
9 x_emission_source_id NUMBER,
10 x_facility_id NUMBER,
11 x_emission_type_lookup_code VARCHAR2,
12 x_usage_quantity NUMBER,
13 x_unit_of_measure VARCHAR2,
14 x_uom_conversion NUMBER,
15 x_emission_quantity NUMBER,
16 x_energy_quantity NUMBER,
17 x_emission_date_from DATE,
18 x_emission_date_to DATE,
19 x_description VARCHAR2,
20 x_org_id NUMBER,
21 x_set_of_books_id NUMBER,
22 x_invoice_id NUMBER,
23 x_emission_line_number NUMBER,
24 x_distribution_line_number NUMBER,
25 x_invoice_line_number NUMBER,
26 x_vendor_id NUMBER,
27 x_vendor_site_id NUMBER,
28 x_inventory_item_id NUMBER,
29 x_ghg_asset_id NUMBER,
30 x_attribute1 VARCHAR2,
31 x_attribute2 VARCHAR2,
32 x_attribute3 VARCHAR2,
33 x_attribute4 VARCHAR2,
34 x_attribute5 VARCHAR2,
35 x_attribute6 VARCHAR2,
36 x_attribute7 VARCHAR2,
37 x_attribute8 VARCHAR2,
38 x_attribute9 VARCHAR2,
39 x_attribute10 VARCHAR2,
40 x_attribute11 VARCHAR2,
41 x_attribute12 VARCHAR2,
42 x_attribute13 VARCHAR2,
43 x_attribute14 VARCHAR2,
44 x_attribute15 VARCHAR2,
45 x_attribute16 VARCHAR2,
46 x_attribute17 VARCHAR2,
47 x_attribute18 VARCHAR2,
48 x_attribute19 VARCHAR2,
49 x_attribute20 VARCHAR2,
50 x_attribute_category VARCHAR2,
51 x_created_by NUMBER,
52 x_creation_date DATE,
53 x_last_updated_by NUMBER,
54 x_last_update_date DATE,
55 x_last_update_login NUMBER,
56 x_commit_flag VARCHAR2,
57 x_scope VARCHAR2,
58 x_location VARCHAR2,
59 x_measurement_criteria VARCHAR2,
60 x_called_from_api VARCHAR2 DEFAULT 'N');
61
62 PROCEDURE update_row (x_rowid IN OUT NOCOPY VARCHAR2,
63 x_txn_type_lookup_code VARCHAR2,
64 x_emission_id NUMBER,
65 x_emission_batch_id NUMBER,
66 x_emission_source_id NUMBER,
67 x_facility_id NUMBER,
68 x_emission_type_lookup_code VARCHAR2,
69 x_usage_quantity NUMBER,
70 x_unit_of_measure VARCHAR2,
71 x_uom_conversion NUMBER,
72 x_emission_quantity NUMBER,
73 x_energy_quantity NUMBER,
74 x_emission_date_from DATE,
75 x_emission_date_to DATE,
76 x_description VARCHAR2,
77 x_org_id NUMBER,
78 x_set_of_books_id NUMBER,
79 x_invoice_id NUMBER,
80 x_emission_line_number NUMBER,
81 x_distribution_line_number NUMBER,
82 x_invoice_line_number NUMBER,
83 x_vendor_id NUMBER,
84 x_vendor_site_id NUMBER,
85 x_inventory_item_id NUMBER,
86 x_ghg_asset_id NUMBER,
87 x_attribute1 VARCHAR2,
88 x_attribute2 VARCHAR2,
89 x_attribute3 VARCHAR2,
90 x_attribute4 VARCHAR2,
91 x_attribute5 VARCHAR2,
92 x_attribute6 VARCHAR2,
93 x_attribute7 VARCHAR2,
94 x_attribute8 VARCHAR2,
95 x_attribute9 VARCHAR2,
96 x_attribute10 VARCHAR2,
97 x_attribute11 VARCHAR2,
98 x_attribute12 VARCHAR2,
99 x_attribute13 VARCHAR2,
100 x_attribute14 VARCHAR2,
101 x_attribute15 VARCHAR2,
102 x_attribute16 VARCHAR2,
103 x_attribute17 VARCHAR2,
104 x_attribute18 VARCHAR2,
105 x_attribute19 VARCHAR2,
106 x_attribute20 VARCHAR2,
107 x_attribute_category VARCHAR2,
108 x_created_by NUMBER,
109 x_creation_date DATE,
110 x_last_updated_by NUMBER,
111 x_last_update_date DATE,
112 x_last_update_login NUMBER,
113 x_scope VARCHAR2,
114 x_location VARCHAR2,
115 x_measurement_criteria VARCHAR2);
116
117 PROCEDURE delete_row(x_emission_id NUMBER);
118
119 PROCEDURE lock_row (x_rowid IN OUT NOCOPY VARCHAR2,
120 x_txn_type_lookup_code VARCHAR2,
121 x_emission_id NUMBER,
122 x_emission_batch_id NUMBER,
123 x_emission_source_id NUMBER,
124 x_facility_id NUMBER,
125 x_emission_type_lookup_code VARCHAR2,
126 x_usage_quantity NUMBER,
127 x_unit_of_measure VARCHAR2,
128 x_uom_conversion NUMBER,
129 x_emission_quantity NUMBER,
130 x_energy_quantity NUMBER,
131 x_emission_date_from DATE,
132 x_emission_date_to DATE,
133 x_description VARCHAR2,
134 x_org_id NUMBER,
135 x_set_of_books_id NUMBER,
136 x_invoice_id NUMBER,
137 x_emission_line_number NUMBER,
138 x_distribution_line_number NUMBER,
139 x_invoice_line_number NUMBER,
140 x_vendor_id NUMBER,
141 x_vendor_site_id NUMBER,
142 x_inventory_item_id NUMBER,
143 x_ghg_asset_id NUMBER,
144 x_attribute1 VARCHAR2,
145 x_attribute2 VARCHAR2,
146 x_attribute3 VARCHAR2,
147 x_attribute4 VARCHAR2,
148 x_attribute5 VARCHAR2,
149 x_attribute6 VARCHAR2,
150 x_attribute7 VARCHAR2,
151 x_attribute8 VARCHAR2,
152 x_attribute9 VARCHAR2,
153 x_attribute10 VARCHAR2,
154 x_attribute11 VARCHAR2,
155 x_attribute12 VARCHAR2,
156 x_attribute13 VARCHAR2,
157 x_attribute14 VARCHAR2,
158 x_attribute15 VARCHAR2,
159 x_attribute16 VARCHAR2,
160 x_attribute17 VARCHAR2,
161 x_attribute18 VARCHAR2,
162 x_attribute19 VARCHAR2,
163 x_attribute20 VARCHAR2,
164 x_attribute_category VARCHAR2,
165 x_created_by NUMBER,
166 x_creation_date DATE,
167 x_last_updated_by NUMBER,
168 x_last_update_date DATE,
169 x_last_update_login NUMBER,
170 x_scope VARCHAR2,
171 x_location VARCHAR2,
172 x_measurement_criteria VARCHAR2);
173
174
175 FUNCTION get_emission_total (x_emission_id NUMBER) RETURN NUMBER;
176
177 FUNCTION get_energy_total (x_emission_id NUMBER) RETURN NUMBER;
178
179 PROCEDURE derive_emissions (P_ORG_ID number,
180 p_invoice_id NUMBER,
181 p_emission_source VARCHAR2,
182 p_scope VARCHAR2,
183 p_location VARCHAR2,
184 p_usage NUMBER,
185 p_uom VARCHAR2,
186 p_from_date DATE,
187 p_to_date DATE,
191
188 p_description VARCHAR2,
189 p_m_criteria VARCHAR2);
190
192 PROCEDURE cancel_invoice (x_invoice_id NUMBER,
193 x_mesg IN OUT NOCOPY VARCHAR2);
194
195
196 procedure derive_inv_emissions (p_material_trx_set_id number,
197 P_ITEM_ID NUMBER,
198 P_UOM VARCHAR2,
199 P_QUANTITY NUMBER,
200 P_TRANS_SOURCE VARCHAR2,
201 P_TRANS_DATE DATE,
202 p_TRANS_REF VARCHAR2,
203 p_org_id NUMBER,
204 p_m_criteria VARCHAR2);
205
206 FUNCTION get_inv_reference(
207 p_old_reference NUMBER --Bug 12646349 - SSURENDR
208 ) RETURN NUMBER;
209
210 FUNCTION get_inv_default_item (p_asset_num VARCHAR2) RETURN VARCHAR2;
211
212 END GHG_transactions_pkg;
|
|
|
|