98: /*
99: || check for action in trigger and pass the same to the procedure
100: */
101: IF INSERTING THEN
102: lv_action := jai_constants.inserting ;
103: ELSIF UPDATING THEN
104: lv_action := jai_constants.updating ;
105: ELSIF DELETING THEN
106: lv_action := jai_constants.deleting ;
100: */
101: IF INSERTING THEN
102: lv_action := jai_constants.inserting ;
103: ELSIF UPDATING THEN
104: lv_action := jai_constants.updating ;
105: ELSIF DELETING THEN
106: lv_action := jai_constants.deleting ;
107: END IF ;
108:
102: lv_action := jai_constants.inserting ;
103: ELSIF UPDATING THEN
104: lv_action := jai_constants.updating ;
105: ELSIF DELETING THEN
106: lv_action := jai_constants.deleting ;
107: END IF ;
108:
109: IF INSERTING THEN
110:
115: pv_return_code => lv_return_code ,
116: pv_return_message => lv_return_message
117: );
118:
119: IF lv_return_code <> jai_constants.successful then
120: RAISE le_error;
121: END IF;
122:
123: END IF ;