APPS.GHG_SEGMENT_MAPPINGS_PKG dependencies on GHG_SEGMENT_MAPPINGS_ALL

Line 51: FROM GHG_SEGMENT_MAPPINGS_ALL

47: v_debug_info VARCHAR2(100);
48:
49: CURSOR c IS
50: SELECT ROWID
51: FROM GHG_SEGMENT_MAPPINGS_ALL
52: WHERE org_id = x_org_id;
53:
54: BEGIN
55:

Line 56: v_debug_info := 'Inserting into GHG_SEGMENT_MAPPINGS_ALL';

52: WHERE org_id = x_org_id;
53:
54: BEGIN
55:
56: v_debug_info := 'Inserting into GHG_SEGMENT_MAPPINGS_ALL';
57:
58: INSERT INTO GHG_SEGMENT_MAPPINGS_ALL (map_accounts_flag,
59: map_operating_unit_flag,
60: map_projects_flag,

Line 58: INSERT INTO GHG_SEGMENT_MAPPINGS_ALL (map_accounts_flag,

54: BEGIN
55:
56: v_debug_info := 'Inserting into GHG_SEGMENT_MAPPINGS_ALL';
57:
58: INSERT INTO GHG_SEGMENT_MAPPINGS_ALL (map_accounts_flag,
59: map_operating_unit_flag,
60: map_projects_flag,
61: map_segment1_flag,
62: map_segment2_flag,

Line 211: v_debug_info := 'Updating GHG_SEGMENT_MAPPINGS_ALL';

207: v_debug_info VARCHAR2(100);
208:
209: BEGIN
210:
211: v_debug_info := 'Updating GHG_SEGMENT_MAPPINGS_ALL';
212:
213: UPDATE GHG_SEGMENT_MAPPINGS_ALL
214: SET map_accounts_flag = x_map_accounts_flag,
215: map_operating_unit_flag = x_map_operating_unit_flag,

Line 213: UPDATE GHG_SEGMENT_MAPPINGS_ALL

209: BEGIN
210:
211: v_debug_info := 'Updating GHG_SEGMENT_MAPPINGS_ALL';
212:
213: UPDATE GHG_SEGMENT_MAPPINGS_ALL
214: SET map_accounts_flag = x_map_accounts_flag,
215: map_operating_unit_flag = x_map_operating_unit_flag,
216: map_projects_flag = x_map_projects_flag,
217: map_segment1_flag = x_map_segment1_flag,

Line 277: DELETE FROM GHG_SEGMENT_MAPPINGS_ALL

273: v_row_count NUMBER(15);
274:
275: BEGIN
276:
277: DELETE FROM GHG_SEGMENT_MAPPINGS_ALL
278: WHERE org_id = x_org_id;
279:
280: IF (sql%notfound) THEN
281: RAISE no_data_found;

Line 371: FROM GHG_SEGMENT_MAPPINGS_ALL

367: creation_date,
368: last_updated_by,
369: last_update_date,
370: last_update_login
371: FROM GHG_SEGMENT_MAPPINGS_ALL
372: WHERE rowid = x_rowid
373: FOR UPDATE of org_id NOWAIT;
374: recinfo C%ROWTYPE;
375: