147: /*
148: || check for action in trigger and pass the same to the procedure
149: */
150: IF INSERTING THEN
151: lv_action := jai_constants.inserting ;
152: ELSIF UPDATING THEN
153: lv_action := jai_constants.updating ;
154: ELSIF DELETING THEN
155: lv_action := jai_constants.deleting ;
149: */
150: IF INSERTING THEN
151: lv_action := jai_constants.inserting ;
152: ELSIF UPDATING THEN
153: lv_action := jai_constants.updating ;
154: ELSIF DELETING THEN
155: lv_action := jai_constants.deleting ;
156: END IF ;
157:
151: lv_action := jai_constants.inserting ;
152: ELSIF UPDATING THEN
153: lv_action := jai_constants.updating ;
154: ELSIF DELETING THEN
155: lv_action := jai_constants.deleting ;
156: END IF ;
157:
158: IF INSERTING THEN
159:
164: pv_return_code => lv_return_code ,
165: pv_return_message => lv_return_message
166: );
167:
168: IF lv_return_code <> jai_constants.successful then
169: RAISE le_error;
170: END IF;
171:
172: END IF ;