816: /*
817: || check for action in trigger and pass the same to the procedure
818: */
819: IF INSERTING THEN
820: lv_action := jai_constants.inserting ;
821: ELSIF UPDATING THEN
822: lv_action := jai_constants.updating ;
823: ELSIF DELETING THEN
824: lv_action := jai_constants.deleting ;
818: */
819: IF INSERTING THEN
820: lv_action := jai_constants.inserting ;
821: ELSIF UPDATING THEN
822: lv_action := jai_constants.updating ;
823: ELSIF DELETING THEN
824: lv_action := jai_constants.deleting ;
825: END IF ;
826:
820: lv_action := jai_constants.inserting ;
821: ELSIF UPDATING THEN
822: lv_action := jai_constants.updating ;
823: ELSIF DELETING THEN
824: lv_action := jai_constants.deleting ;
825: END IF ;
826:
827: IF INSERTING THEN
828:
833: pv_return_code => lv_return_code ,
834: pv_return_message => lv_return_message
835: );
836:
837: IF lv_return_code <> jai_constants.successful then
838: RAISE le_error;
839: END IF;
840:
841: END IF ;
849: pv_return_code => lv_return_code ,
850: pv_return_message => lv_return_message
851: );
852:
853: IF lv_return_code <> jai_constants.successful then
854: RAISE le_error;
855: END IF;
856:
857: END IF ;
865: pv_return_code => lv_return_code ,
866: pv_return_message => lv_return_message
867: );
868:
869: IF lv_return_code <> jai_constants.successful then
870: RAISE le_error;
871: END IF;
872:
873: END IF ;