APPS.GHG_SOURCES_PKG dependencies on GHG_SOURCES

Line 1: PACKAGE BODY GHG_SOURCES_PKG AS

1: PACKAGE BODY GHG_SOURCES_PKG AS
2: /*$Header: ghgsourb.pls 120.2.12020000.2 2013/03/11 07:23:45 mgijare ship $ */
3:
4: PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
5: x_source_id NUMBER,

Line 44: FROM GHG_SOURCES

40: v_debug_info VARCHAR2(100);
41:
42: CURSOR c IS
43: SELECT ROWID
44: FROM GHG_SOURCES
45: WHERE source_id = x_source_id;
46:
47: BEGIN
48:

Line 49: v_debug_info := 'Inserting into GHG_SOURCES';

45: WHERE source_id = x_source_id;
46:
47: BEGIN
48:
49: v_debug_info := 'Inserting into GHG_SOURCES';
50:
51: INSERT INTO GHG_SOURCES (source_id,
52: source_name,
53: unit_of_measure,

Line 51: INSERT INTO GHG_SOURCES (source_id,

47: BEGIN
48:
49: v_debug_info := 'Inserting into GHG_SOURCES';
50:
51: INSERT INTO GHG_SOURCES (source_id,
52: source_name,
53: unit_of_measure,
54: attribute1,
55: attribute2,

Line 189: v_debug_info := 'Updating GHG_SOURCES';

185: v_debug_info VARCHAR2(100);
186:
187: BEGIN
188:
189: v_debug_info := 'Updating GHG_SOURCES';
190:
191: UPDATE GHG_SOURCES
192: SET source_id = x_source_id,
193: source_name = x_source_name,

Line 191: UPDATE GHG_SOURCES

187: BEGIN
188:
189: v_debug_info := 'Updating GHG_SOURCES';
190:
191: UPDATE GHG_SOURCES
192: SET source_id = x_source_id,
193: source_name = x_source_name,
194: unit_of_measure = x_unit_of_measure,
195: attribute1 = x_attribute1,

Line 253: DELETE FROM GHG_SOURCES

249: v_debug_info VARCHAR2(100);
250:
251: BEGIN
252:
253: DELETE FROM GHG_SOURCES
254: WHERE source_id = x_source_id;
255:
256: IF (sql%notfound) THEN
257: RAISE no_data_found;

Line 349: FROM GHG_SOURCES

345: enabled,
346: formula_id,
347: ghg_uom_class_code,
348: energy_type
349: FROM GHG_SOURCES
350: WHERE rowid = x_rowid
351: FOR UPDATE of source_id NOWAIT;
352: recinfo C%ROWTYPE;
353:

Line 490: FROM GHG_SOURCES_ALL

486: v_row_count number;
487: BEGIN
488: SELECT count(*)
489: into v_row_count
490: FROM GHG_SOURCES_ALL
491: where source_name = x_source_name
492: and org_id = x_org_id
493: and source_id <> NVL(x_source_id,-1);
494:

Line 532: select GHG_SOURCES_S.NEXTVAL

528:
529: FUNCTION generate_source_id RETURN NUMBER IS
530: v_source_id NUMBER;
531: BEGIN
532: select GHG_SOURCES_S.NEXTVAL
533: into v_source_id
534: from dual;
535:
536: RETURN v_source_id;

Line 539: END GHG_SOURCES_PKG;

535:
536: RETURN v_source_id;
537: END;
538:
539: END GHG_SOURCES_PKG;