275: /*
276: || check for action in trigger and pass the same to the procedure
277: */
278: IF INSERTING THEN
279: lv_action := jai_constants.inserting ;
280: ELSIF UPDATING THEN
281: lv_action := jai_constants.updating ;
282: ELSIF DELETING THEN
283: lv_action := jai_constants.deleting ;
277: */
278: IF INSERTING THEN
279: lv_action := jai_constants.inserting ;
280: ELSIF UPDATING THEN
281: lv_action := jai_constants.updating ;
282: ELSIF DELETING THEN
283: lv_action := jai_constants.deleting ;
284: END IF ;
285:
279: lv_action := jai_constants.inserting ;
280: ELSIF UPDATING THEN
281: lv_action := jai_constants.updating ;
282: ELSIF DELETING THEN
283: lv_action := jai_constants.deleting ;
284: END IF ;
285:
286: IF INSERTING THEN
287:
292: pv_return_code => lv_return_code ,
293: pv_return_message => lv_return_message
294: );
295:
296: IF lv_return_code <> jai_constants.successful then
297: RAISE le_error;
298: END IF;
299:
300: END IF ;
308: pv_return_code => lv_return_code ,
309: pv_return_message => lv_return_message
310: );
311:
312: IF lv_return_code <> jai_constants.successful then
313: RAISE le_error;
314: END IF;
315:
316: END IF ;
324: pv_return_code => lv_return_code ,
325: pv_return_message => lv_return_message
326: );
327:
328: IF lv_return_code <> jai_constants.successful then
329: RAISE le_error;
330: END IF;
331:
332: END IF ;