APPS.GHG_ORGANIZATIONS_PKG dependencies on GHG_ORGANIZATIONS_ALL

Line 52: FROM GHG_organizations_all

48: v_debug_info VARCHAR2(100);
49:
50: CURSOR c IS
51: SELECT ROWID
52: FROM GHG_organizations_all
53: WHERE ghg_organization_id = x_facility_id;
54:
55: BEGIN
56:

Line 57: v_debug_info := 'Inserting into GHG_organizations_all';

53: WHERE ghg_organization_id = x_facility_id;
54:
55: BEGIN
56:
57: v_debug_info := 'Inserting into GHG_organizations_all';
58:
59: INSERT INTO GHG_organizations_all (ghg_organization_id,
60: ghg_organization_code,
61: description,

Line 59: INSERT INTO GHG_organizations_all (ghg_organization_id,

55: BEGIN
56:
57: v_debug_info := 'Inserting into GHG_organizations_all';
58:
59: INSERT INTO GHG_organizations_all (ghg_organization_id,
60: ghg_organization_code,
61: description,
62: organization_size_lookup_code,
63: location_id,

Line 216: v_debug_info := 'Updating GHG_organizations_all';

212: v_debug_info VARCHAR2(100);
213:
214: BEGIN
215:
216: v_debug_info := 'Updating GHG_organizations_all';
217:
218: UPDATE GHG_organizations_all
219: SET ghg_organization_id = x_facility_id,
220: ghg_organization_code = x_facility_code,

Line 218: UPDATE GHG_organizations_all

214: BEGIN
215:
216: v_debug_info := 'Updating GHG_organizations_all';
217:
218: UPDATE GHG_organizations_all
219: SET ghg_organization_id = x_facility_id,
220: ghg_organization_code = x_facility_code,
221: description = x_description,
222: organization_size_lookup_code = x_facility_size_lookup_code,

Line 283: DELETE FROM GHG_organizations_all

279: v_row_count NUMBER(15);
280:
281: BEGIN
282:
283: DELETE FROM GHG_organizations_all
284: WHERE ghg_organization_id = x_facility_id;
285:
286: IF (sql%notfound) THEN
287: RAISE no_data_found;

Line 380: FROM GHG_organizations_all

376: organization_type,
377: allow_transactions,
378: ceo_name,
379: company_identifier
380: FROM GHG_organizations_all
381: WHERE rowid = x_rowid
382: FOR UPDATE of ghg_organization_id NOWAIT;
383: recinfo C%ROWTYPE;
384: