163: --
164: cursor actionitems (cp_action_context_id in number,
165: cp_action_context_type in varchar2) is
166: select action_information_id
167: from pay_action_information
168: where action_context_id = cp_action_context_id
169: and action_context_type = cp_action_context_type;
170: --
171: begin
172: for actionrec in actionitems(p_action_context_id,
173: p_action_context_type) loop
174:
175: /* delete Action Information */
176: delete from pay_action_information
177: where action_information_id = actionrec.action_information_id;
178:
179: end loop;
180: end remove_action_information;