APPS.GHG_ASSETS_PKG dependencies on GHG_ASSETS

Line 1: PACKAGE BODY ghg_assets_pkg AS

1: PACKAGE BODY ghg_assets_pkg AS
2: /*$Header: ghgasetb.pls 120.1 2011/10/31 09:03:13 pwaghmar noship $ */
3:
4:
5: PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,

Line 30: FROM GHG_ASSETS

26: v_debug_info VARCHAR2(100);
27:
28: CURSOR c IS
29: SELECT ROWID
30: FROM GHG_ASSETS
31: WHERE ghg_asset_id = x_ghg_asset_id;
32:
33: BEGIN
34:

Line 35: v_debug_info := 'Inserting into GHG_ASSETS';

31: WHERE ghg_asset_id = x_ghg_asset_id;
32:
33: BEGIN
34:
35: v_debug_info := 'Inserting into GHG_ASSETS';
36:
37: INSERT INTO GHG_ASSETS (ghg_asset_id,
38: asset_id,
39: asset_type_lookup_code,

Line 37: INSERT INTO GHG_ASSETS (ghg_asset_id,

33: BEGIN
34:
35: v_debug_info := 'Inserting into GHG_ASSETS';
36:
37: INSERT INTO GHG_ASSETS (ghg_asset_id,
38: asset_id,
39: asset_type_lookup_code,
40: book_type_code,
41: asset_number,

Line 127: v_debug_info := 'Updating GHG_ASSETS';

123: v_debug_info VARCHAR2(100);
124:
125: BEGIN
126:
127: v_debug_info := 'Updating GHG_ASSETS';
128:
129: UPDATE GHG_ASSETS
130: SET ghg_asset_id = x_ghg_asset_id,
131: asset_id = x_asset_id,

Line 129: UPDATE GHG_ASSETS

125: BEGIN
126:
127: v_debug_info := 'Updating GHG_ASSETS';
128:
129: UPDATE GHG_ASSETS
130: SET ghg_asset_id = x_ghg_asset_id,
131: asset_id = x_asset_id,
132: asset_type_lookup_code = x_asset_type_lookup_code,
133: book_type_code = x_book_type_code,

Line 172: DELETE FROM GHG_ASSETS

168: v_row_count NUMBER(15);
169:
170: BEGIN
171:
172: DELETE FROM GHG_ASSETS
173: WHERE ghg_asset_id = x_ghg_asset_id;
174:
175: IF (sql%notfound) THEN
176: RAISE no_data_found;

Line 224: FROM GHG_ASSETS

220: last_updated_by,
221: last_update_date,
222: last_update_login,
223: ghg_organization_id
224: FROM GHG_ASSETS
225: WHERE rowid = x_rowid
226: FOR UPDATE of ghg_asset_id NOWAIT;
227: recinfo C%ROWTYPE;
228:

Line 313: END GHG_ASSETS_pkg;

309: APP_EXCEPTION.RAISE_EXCEPTION;
310:
311: END lock_row;
312:
313: END GHG_ASSETS_pkg;