[Home] [Help]
13: x_facility_id number
14: ) return date IS
15: v_max_date date;
16: BEGIN
17: select max(nvl(end_date+1,start_date)) --ssurendr: Changed GHG_UTILITIES_PKG.end_date to start_date so that duplicate record validation correctly happens.
18: into v_max_date
19: from GHG_source_combinations_all
20: where /*code_combination_id = x_code_combination_id --Lakshmi 04/27/11 - nvl is removed so that correct start date is returned.
21: ssurendr 05/06 - code combination removed from join
28: and nvl(scope_lookup_code, -1) = nvl(x_scope_lookup_code, -1)
29: and nvl(location_code, -1) = nvl(x_location_code, -1)
30: and nvl(transport_type_lookup_code, -1) = nvl(x_transport_type_lookup_code, -1);
31:
32: return nvl(v_max_date,GHG_UTILITIES_PKG.start_date);
33:
34: END;
35:
36: FUNCTION lock_date (x_emission_source_id number,
314: AND NVL(item_id,nvl(x_item_id,-1)) = nvl(x_item_id,-1)
315: AND NVL(supplier_id,NVL(x_supplier_id,-1)) = NVL(x_supplier_id,-1)
316: AND NVL(supplier_site_id,NVL(x_supplier_site_id,-1)) = NVL(x_supplier_site_id,-1)
317: AND x_emission_date BETWEEN TRUNC(start_date)
318: AND TRUNC(NVL(end_date,GHG_UTILITIES_PKG.end_date))
319: ORDER BY
320: scope_lookup_code,
321: CASE
322: WHEN item_id IS NOT NULL
639: AND NVL(item_id,nvl(x_item_id,-1)) = nvl(x_item_id,-1)
640: AND NVL(supplier_id,NVL(x_supplier_id,-1)) = NVL(x_supplier_id,-1)
641: AND NVL(supplier_site_id,NVL(x_supplier_site_id,-1)) = NVL(x_supplier_site_id,-1)
642: AND x_emission_date BETWEEN TRUNC(start_date)
643: AND TRUNC(NVL(end_date,GHG_UTILITIES_PKG.end_date))
644: ORDER BY
645: scope_lookup_code,
646: CASE
647: WHEN item_id IS NOT NULL