APPS.FA_CUA_HIERARCHY_VALUES_PKG dependencies on FA_ASSET_HIERARCHY_VALUES

Line 20: Cursor C1 is Select ROWID from FA_ASSET_HIERARCHY_VALUES

16: , X_LAST_UPDATED_BY in number
17: , X_LAST_UPDATE_LOGIN in number
18: )
19: is
20: Cursor C1 is Select ROWID from FA_ASSET_HIERARCHY_VALUES
21: where asset_hierarchy_id = x_asset_hierarchy_id
22: and book_type_code = x_book_type_code;
23: begin
24: insert into FA_ASSET_HIERARCHY_VALUES

Line 24: insert into FA_ASSET_HIERARCHY_VALUES

20: Cursor C1 is Select ROWID from FA_ASSET_HIERARCHY_VALUES
21: where asset_hierarchy_id = x_asset_hierarchy_id
22: and book_type_code = x_book_type_code;
23: begin
24: insert into FA_ASSET_HIERARCHY_VALUES
25: ( asset_hierarchy_id
26: , book_type_code
27: , asset_category_id
28: , lease_id

Line 105: from FA_ASSET_HIERARCHY_VALUES

101: , asset_key_ccid
102: , serial_number
103: , life_end_date
104: , dist_set_id
105: from FA_ASSET_HIERARCHY_VALUES
106: where rowid = x_rowid
107: for update nowait;
108: tlinfo C1%ROWTYPE;
109: begin

Line 163: update FA_ASSET_HIERARCHY_VALUES

159: , X_LAST_UPDATE_LOGIN in number
160: )
161: is
162: begin
163: update FA_ASSET_HIERARCHY_VALUES
164: set book_type_code = x_book_type_code
165: , asset_category_id = x_asset_category_id
166: , lease_id = x_lease_id
167: , asset_key_ccid = x_asset_key_ccid

Line 185: delete from FA_ASSET_HIERARCHY_VALUES

181: x_rowid in VARCHAR2
182: )
183: is
184: begin
185: delete from FA_ASSET_HIERARCHY_VALUES
186: where rowid = x_rowid;
187: if (sql%notfound) then
188: raise no_data_found;
189: end if;