[Home] [Help]
226: X_ACTION_TYPE_ROWID in VARCHAR2,
227: X_END_DATE in DATE)
228: is
229: begin
230: update AME_ACTION_TYPES set
231: END_DATE = X_END_DATE
232: where ROWID = X_ACTION_TYPE_ROWID;
233: end UPDATE_ROW;
234:
322: );
323: begin
324: -- the current row was not found insert a new row
325: if X_ACTION_TYPE_ID is null then
326: select ame_action_types_s.nextval into X_ACTION_TYPE_ID from dual;
327: INSERT_ROW (
328: X_ACTION_TYPE_ID,
329: X_ACTION_TYPE_NAME,
330: X_PROCEDURE_NAME,