171: /*
172: || check for action in trigger and pass the same to the procedure
173: */
174: IF INSERTING THEN
175: lv_action := jai_constants.inserting ;
176: ELSIF UPDATING THEN
177: lv_action := jai_constants.updating ;
178: ELSIF DELETING THEN
179: lv_action := jai_constants.deleting ;
173: */
174: IF INSERTING THEN
175: lv_action := jai_constants.inserting ;
176: ELSIF UPDATING THEN
177: lv_action := jai_constants.updating ;
178: ELSIF DELETING THEN
179: lv_action := jai_constants.deleting ;
180: END IF ;
181:
175: lv_action := jai_constants.inserting ;
176: ELSIF UPDATING THEN
177: lv_action := jai_constants.updating ;
178: ELSIF DELETING THEN
179: lv_action := jai_constants.deleting ;
180: END IF ;
181:
182: IF INSERTING THEN
183: -- Bug# 6366169
215: pv_return_code => lv_return_code ,
216: pv_return_message => lv_return_message
217: );
218:
219: IF lv_return_code <> jai_constants.successful then
220: RAISE le_error;
221: END IF;
222:
223: END IF ;
255: );
256:
257:
258:
259: IF lv_return_code <> jai_constants.successful then
260: RAISE le_error;
261: END IF;
262:
263: END IF ;