APPS.GHG_SIC_MAPPING_PKG dependencies on GHG_ORG_SIC_MAPPINGS_ALL

Line 23: FROM GHG_ORG_SIC_MAPPINGS_ALL

19: v_debug_info VARCHAR2(100);
20:
21: CURSOR c IS
22: SELECT ROWID
23: FROM GHG_ORG_SIC_MAPPINGS_ALL
24: WHERE sic_mapping_id = x_sic_mapping_id;
25:
26: BEGIN
27:

Line 28: v_debug_info := 'Inserting into GHG_ORG_SIC_MAPPINGS_ALL';

24: WHERE sic_mapping_id = x_sic_mapping_id;
25:
26: BEGIN
27:
28: v_debug_info := 'Inserting into GHG_ORG_SIC_MAPPINGS_ALL';
29:
30: INSERT INTO GHG_ORG_SIC_MAPPINGS_ALL (sic_mapping_id,
31: ghg_organization_id,
32: sic_code,

Line 30: INSERT INTO GHG_ORG_SIC_MAPPINGS_ALL (sic_mapping_id,

26: BEGIN
27:
28: v_debug_info := 'Inserting into GHG_ORG_SIC_MAPPINGS_ALL';
29:
30: INSERT INTO GHG_ORG_SIC_MAPPINGS_ALL (sic_mapping_id,
31: ghg_organization_id,
32: sic_code,
33: division_code,
34: org_id,

Line 105: v_debug_info := 'Updating GHG_ORG_SIC_MAPPINGS_ALL';

101: v_debug_info VARCHAR2(100);
102:
103: BEGIN
104:
105: v_debug_info := 'Updating GHG_ORG_SIC_MAPPINGS_ALL';
106:
107: UPDATE GHG_ORG_SIC_MAPPINGS_ALL
108: SET sic_mapping_id = x_sic_mapping_id,
109: ghg_organization_id = x_ghg_organization_id,

Line 107: UPDATE GHG_ORG_SIC_MAPPINGS_ALL

103: BEGIN
104:
105: v_debug_info := 'Updating GHG_ORG_SIC_MAPPINGS_ALL';
106:
107: UPDATE GHG_ORG_SIC_MAPPINGS_ALL
108: SET sic_mapping_id = x_sic_mapping_id,
109: ghg_organization_id = x_ghg_organization_id,
110: sic_code = x_sic_code,
111: division_code = x_division_code,

Line 142: DELETE FROM GHG_ORG_SIC_MAPPINGS_ALL

138: PROCEDURE delete_row (x_sic_mapping_id VARCHAR2) IS
139:
140: BEGIN
141:
142: DELETE FROM GHG_ORG_SIC_MAPPINGS_ALL
143: WHERE sic_mapping_id = x_sic_mapping_id;
144:
145: IF (sql%notfound) THEN
146: RAISE no_data_found;

Line 182: FROM GHG_ORG_SIC_MAPPINGS_ALL

178: creation_date,
179: last_updated_by,
180: last_update_date,
181: last_update_login
182: FROM GHG_ORG_SIC_MAPPINGS_ALL
183: WHERE rowid = x_rowid
184: FOR UPDATE of sic_mapping_id NOWAIT;
185: recinfo C%ROWTYPE;
186: