741: /*
742: || check for action in trigger and pass the same to the procedure
743: */
744: IF inserting THEN
745: lv_action := jai_constants.inserting ;
746: ELSIF updating THEN
747: lv_action := jai_constants.updating ;
748: ELSIF deleting THEN
749: lv_action := jai_constants.deleting ;
743: */
744: IF inserting THEN
745: lv_action := jai_constants.inserting ;
746: ELSIF updating THEN
747: lv_action := jai_constants.updating ;
748: ELSIF deleting THEN
749: lv_action := jai_constants.deleting ;
750: END IF ;
751:
745: lv_action := jai_constants.inserting ;
746: ELSIF updating THEN
747: lv_action := jai_constants.updating ;
748: ELSIF deleting THEN
749: lv_action := jai_constants.deleting ;
750: END IF ;
751:
752: IF inserting THEN
753:
775: pv_return_code => lv_return_code ,
776: pv_return_message => lv_return_message
777: );
778:
779: IF lv_return_code <> jai_constants.successful THEN
780: RAISE le_error;
781: END IF;
782:
783: END IF ;
815: pv_return_code => lv_return_code ,
816: pv_return_message => lv_return_message
817: );
818:
819: IF lv_return_code <> jai_constants.successful then
820: RAISE le_error;
821: END IF;
822:
823: END IF ;
845: pv_return_code => lv_return_code ,
846: pv_return_message => lv_return_message
847: );
848:
849: IF lv_return_code <> jai_constants.successful then
850: RAISE le_error;
851: END IF;
852:
853: END IF ;
863: pv_return_code => lv_return_code ,
864: pv_return_message => lv_return_message
865: );
866:
867: IF lv_return_code <> jai_constants.successful then
868: RAISE le_error;
869: END IF;
870:
871: END IF ;