99: /*
100: || check for action in trigger and pass the same to the procedure
101: */
102: IF INSERTING THEN
103: lv_action := jai_constants.inserting ;
104: ELSIF UPDATING THEN
105: lv_action := jai_constants.updating ;
106: ELSIF DELETING THEN
107: lv_action := jai_constants.deleting ;
101: */
102: IF INSERTING THEN
103: lv_action := jai_constants.inserting ;
104: ELSIF UPDATING THEN
105: lv_action := jai_constants.updating ;
106: ELSIF DELETING THEN
107: lv_action := jai_constants.deleting ;
108: END IF ;
109:
103: lv_action := jai_constants.inserting ;
104: ELSIF UPDATING THEN
105: lv_action := jai_constants.updating ;
106: ELSIF DELETING THEN
107: lv_action := jai_constants.deleting ;
108: END IF ;
109:
110: IF UPDATING THEN
111:
122: pv_return_code => lv_return_code ,
123: pv_return_message => lv_return_message
124: );
125:
126: IF lv_return_code <> jai_constants.successful then
127: RAISE le_error;
128: END IF;
129:
130: END IF ;