348: /*
349: || check for action in trigger and pass the same to the procedure
350: */
351: IF INSERTING THEN
352: lv_action := jai_constants.inserting ;
353: ELSIF UPDATING THEN
354: lv_action := jai_constants.updating ;
355: ELSIF DELETING THEN
356: lv_action := jai_constants.deleting ;
350: */
351: IF INSERTING THEN
352: lv_action := jai_constants.inserting ;
353: ELSIF UPDATING THEN
354: lv_action := jai_constants.updating ;
355: ELSIF DELETING THEN
356: lv_action := jai_constants.deleting ;
357: END IF ;
358:
352: lv_action := jai_constants.inserting ;
353: ELSIF UPDATING THEN
354: lv_action := jai_constants.updating ;
355: ELSIF DELETING THEN
356: lv_action := jai_constants.deleting ;
357: END IF ;
358:
359: IF INSERTING THEN
360:
367: pv_return_code => lv_return_code ,
368: pv_return_message => lv_return_message
369: );
370:
371: IF lv_return_code <> jai_constants.successful then
372: RAISE le_error;
373: END IF;
374:
375: END IF ;
385: pv_return_code => lv_return_code ,
386: pv_return_message => lv_return_message
387: );
388:
389: IF lv_return_code <> jai_constants.successful then
390: RAISE le_error;
391: END IF;
392:
393: END IF ;
401: pv_return_code => lv_return_code ,
402: pv_return_message => lv_return_message
403: );
404:
405: IF lv_return_code <> jai_constants.successful then
406: RAISE le_error;
407: END IF;
408:
409: END IF ;