19: , X_CREATED_BY in number
20: , X_LAST_UPDATE_DATE in date
21: , X_LAST_UPDATED_BY in number
22: , X_LAST_UPDATE_LOGIN in number
23: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
24: is
25: cursor C is select ROWID from FA_HIERARCHY_RULE_DETAILS
26: where hierarchy_rule_set_id = X_hierarchy_rule_set_id
27: and attribute_name = x_attribute_name
89: , x_basis_code in varchar2
90: , x_precedence_level in varchar2
91: , x_override_allowed_flag in varchar2
92: , x_target_flag in varchar2
93: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
94: is
95: cursor c1 is
96: select hierarchy_rule_set_id
97: , attribute_name
181: , x_target_flag in varchar2
182: , X_LAST_UPDATE_DATE in date
183: , X_LAST_UPDATED_BY in number
184: , X_LAST_UPDATE_LOGIN in number
185: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
186: is
187: begin
188: update fa_hierarchy_rule_details
189: set hierarchy_rule_set_id = x_hierarchy_rule_set_id
211:
212:
213: procedure DELETE_ROW (
214: x_rowid in varchar2
215: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
216: begin
217: delete from FA_HIERARCHY_RULE_DETAILS
218: where rowid = x_rowid;
219: if (sql%notfound) then