APPS.GHG_INTERESTED_PARTIES_PKG dependencies on GHG_INTERESTED_PARTIES_ALL

Line 24: FROM GHG_interested_parties_all

20: v_debug_info VARCHAR2(100);
21:
22: CURSOR c IS
23: SELECT ROWID
24: FROM GHG_interested_parties_all
25: WHERE interested_party_id = x_entity_detail_id;
26:
27: BEGIN
28:

Line 29: v_debug_info := 'Inserting into GHG_interested_parties_all';

25: WHERE interested_party_id = x_entity_detail_id;
26:
27: BEGIN
28:
29: v_debug_info := 'Inserting into GHG_interested_parties_all';
30:
31: INSERT INTO GHG_interested_parties_all (interested_party_id,
32: ghg_organization_id,
33: controlling_organization_id,

Line 31: INSERT INTO GHG_interested_parties_all (interested_party_id,

27: BEGIN
28:
29: v_debug_info := 'Inserting into GHG_interested_parties_all';
30:
31: INSERT INTO GHG_interested_parties_all (interested_party_id,
32: ghg_organization_id,
33: controlling_organization_id,
34: operational_control,
35: equity_share,

Line 106: v_debug_info := 'Updating GHG_interested_parties_all';

102: v_debug_info VARCHAR2(100);
103:
104: BEGIN
105:
106: v_debug_info := 'Updating GHG_interested_parties_all';
107:
108: UPDATE GHG_interested_parties_all
109: SET interested_party_id = x_entity_detail_id,
110: ghg_organization_id = x_facility_id,

Line 108: UPDATE GHG_interested_parties_all

104: BEGIN
105:
106: v_debug_info := 'Updating GHG_interested_parties_all';
107:
108: UPDATE GHG_interested_parties_all
109: SET interested_party_id = x_entity_detail_id,
110: ghg_organization_id = x_facility_id,
111: controlling_organization_id = x_controlling_company,
112: operational_control = x_operational_control,

Line 146: DELETE FROM GHG_interested_parties_all

142: v_row_count NUMBER(15);
143:
144: BEGIN
145:
146: DELETE FROM GHG_interested_parties_all
147: WHERE interested_party_id = x_entity_detail_id;
148:
149: IF (sql%notfound) THEN
150: RAISE no_data_found;

Line 188: FROM GHG_interested_parties_all

184: creation_date,
185: last_updated_by,
186: last_update_date,
187: last_update_login
188: FROM GHG_interested_parties_all
189: WHERE rowid = x_rowid
190: FOR UPDATE of ghg_organization_id NOWAIT;
191: recinfo C%ROWTYPE;
192: