15: , x_description in varchar2
16: , x_mandatory_asset_flag in varchar2
17: , x_rule_set_level in varchar2
18: , x_permissible_levels in number
19: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
20: is
21: cursor C is select ROWID from FA_ASSET_HIERARCHY_PURPOSE
22: where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id ;
23:
78: , x_description in varchar2
79: , x_mandatory_asset_flag in varchar2
80: , x_rule_set_level in varchar2
81: , x_permissible_levels in number
82: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)is
83: cursor c1 is select
84: name
85: , purpose_type
86: , book_type_code
141: , x_description in varchar2
142: , x_mandatory_asset_flag in varchar2
143: , x_rule_set_level in varchar2
144: , x_permissible_levels in number
145: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
146: is
147: begin
148: update FA_ASSET_HIERARCHY_PURPOSE
149: set
163:
164:
165: procedure DELETE_ROW (
166: x_asset_hierarchy_purpose_id in number
167: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
168: is
169: begin
170: delete from FA_ASSET_HIERARCHY_PURPOSE
171: where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id;