APPS.FA_CUA_HR_RULE_DETAILS_PKG dependencies on FA_HIERARCHY_RULE_DETAILS

Line 25: cursor C is select ROWID from FA_HIERARCHY_RULE_DETAILS

21: , X_LAST_UPDATED_BY in number
22: , X_LAST_UPDATE_LOGIN in number
23: )
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
28: and book_type_code = x_book_type_code ;
29: begin

Line 30: Insert into FA_HIERARCHY_RULE_DETAILS

26: where hierarchy_rule_set_id = X_hierarchy_rule_set_id
27: and attribute_name = x_attribute_name
28: and book_type_code = x_book_type_code ;
29: begin
30: Insert into FA_HIERARCHY_RULE_DETAILS
31: ( hierarchy_rule_set_id
32: , attribute_name
33: , book_type_code
34: , include_hierarchy_flag

Line 109: from fa_hierarchy_rule_details

105: , basis_code
106: , precedence_level
107: , override_allowed_flag
108: , target_flag
109: from fa_hierarchy_rule_details
110: where rowid = x_rowid
111: for update of hierarchy_rule_set_id nowait;
112: tlinfo c1%rowtype;
113:

Line 188: update fa_hierarchy_rule_details

184: , X_LAST_UPDATE_LOGIN in number
185: )
186: is
187: begin
188: update fa_hierarchy_rule_details
189: set hierarchy_rule_set_id = x_hierarchy_rule_set_id
190: , attribute_name = x_attribute_name
191: , book_type_code = x_book_type_code
192: , include_hierarchy_flag = x_include_hierarchy_flag

Line 217: delete from FA_HIERARCHY_RULE_DETAILS

213: procedure DELETE_ROW (
214: x_rowid in varchar2
215: ) is
216: begin
217: delete from FA_HIERARCHY_RULE_DETAILS
218: where rowid = x_rowid;
219: if (sql%notfound) then
220: raise no_data_found;
221: end if;