APPS.GHG_ORG_PROJECT_MAPPINGS_PKG dependencies on GHG_ORG_PROJECT_MAPPINGS_ALL

Line 25: FROM GHG_org_project_mappings_all

21: v_debug_info VARCHAR2(100);
22:
23: CURSOR c IS
24: SELECT ROWID
25: FROM GHG_org_project_mappings_all
26: WHERE project_mapping_id = x_project_mapping_id;
27:
28: BEGIN
29:

Line 30: v_debug_info := 'Inserting into GHG_org_project_mappings_all';

26: WHERE project_mapping_id = x_project_mapping_id;
27:
28: BEGIN
29:
30: v_debug_info := 'Inserting into GHG_org_project_mappings_all';
31:
32: INSERT INTO GHG_org_project_mappings_all (project_mapping_id,
33: ghg_organization_id,
34: from_project_id,

Line 32: INSERT INTO GHG_org_project_mappings_all (project_mapping_id,

28: BEGIN
29:
30: v_debug_info := 'Inserting into GHG_org_project_mappings_all';
31:
32: INSERT INTO GHG_org_project_mappings_all (project_mapping_id,
33: ghg_organization_id,
34: from_project_id,
35: to_project_id,
36: from_task_number,

Line 110: v_debug_info := 'Updating GHG_org_project_mappings_all';

106: v_debug_info VARCHAR2(100);
107:
108: BEGIN
109:
110: v_debug_info := 'Updating GHG_org_project_mappings_all';
111:
112: UPDATE GHG_org_project_mappings_all
113: SET project_mapping_id = x_project_mapping_id,
114: ghg_organization_id = x_facility_id,

Line 112: UPDATE GHG_org_project_mappings_all

108: BEGIN
109:
110: v_debug_info := 'Updating GHG_org_project_mappings_all';
111:
112: UPDATE GHG_org_project_mappings_all
113: SET project_mapping_id = x_project_mapping_id,
114: ghg_organization_id = x_facility_id,
115: from_project_id = x_from_project_id,
116: to_project_id = x_to_project_id,

Line 151: DELETE FROM GHG_org_project_mappings_all

147: v_row_count NUMBER(15);
148:
149: BEGIN
150:
151: DELETE FROM GHG_org_project_mappings_all
152: WHERE project_mapping_id = x_project_mapping_id;
153:
154: IF (sql%notfound) THEN
155: RAISE no_data_found;

Line 195: FROM GHG_org_project_mappings_all

191: creation_date,
192: last_updated_by,
193: last_update_date,
194: last_update_login
195: FROM GHG_org_project_mappings_all
196: WHERE rowid = x_rowid
197: FOR UPDATE of project_mapping_id NOWAIT;
198: recinfo C%ROWTYPE;
199: