This discussion is archived
3 Replies Latest reply: Nov 12, 2012 4:16 AM by Cvele_new_account RSS

Check is field is changed on before doDML

969837 Newbie
Currently Being Moderated
I am using JDEVADF_11.1.2.2.0_GENERIC_120418.2212.6183.1

I have two pl/sql procedures to work with update of Entity:

First one is to update all attributes except the key, updateEntity, it accepts all attributes and updates them for provided keyAttribute;
Second one is for renaming key attribute, that involvig lots of in-database changes, renameEntity, it accepts oldKey and newKey values.

I see two cases here:
case 1: On doDML's "DML_UPDATE" I need to check is key attribute is changed and call renameEntity procedure first to rename entity and then updateEntity for attributes update.
How can I indicate that key attribute was changed and get old and new values of it?

OR

case 2: I can move renameEntity to application and call it from page dialog.
This looks better to me, but how can I refresh model after calling this procedure?

thanx in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points