440: /*
441: || check for action in trigger and pass the same to the procedure
442: */
443: IF INSERTING THEN
444: lv_action := jai_constants.inserting ;
445: ELSIF UPDATING THEN
446: lv_action := jai_constants.updating ;
447: ELSIF DELETING THEN
448: lv_action := jai_constants.deleting ;
442: */
443: IF INSERTING THEN
444: lv_action := jai_constants.inserting ;
445: ELSIF UPDATING THEN
446: lv_action := jai_constants.updating ;
447: ELSIF DELETING THEN
448: lv_action := jai_constants.deleting ;
449: END IF ;
450:
444: lv_action := jai_constants.inserting ;
445: ELSIF UPDATING THEN
446: lv_action := jai_constants.updating ;
447: ELSIF DELETING THEN
448: lv_action := jai_constants.deleting ;
449: END IF ;
450:
451: IF INSERTING THEN
452:
457: pv_return_code => lv_return_code ,
458: pv_return_message => lv_return_message
459: );
460:
461: IF lv_return_code <> jai_constants.successful then
462: RAISE le_error;
463: END IF;
464:
465: END IF ;
484: pv_return_code => lv_return_code ,
485: pv_return_message => lv_return_message
486: );
487:
488: IF lv_return_code <> jai_constants.successful then
489: RAISE le_error;
490: END IF;
491:
492: END IF ;
506: pv_return_code => lv_return_code ,
507: pv_return_message => lv_return_message
508: );
509:
510: IF lv_return_code <> jai_constants.successful then
511: RAISE le_error;
512: END IF;
513:
514: END IF ;
520: pv_return_code => lv_return_code ,
521: pv_return_message => lv_return_message
522: );
523:
524: IF lv_return_code <> jai_constants.successful then
525: RAISE le_error;
526: END IF;
527: END IF;
528: END IF ;