206: /*
207: || check for action in trigger and pass the same to the procedure
208: */
209: IF INSERTING THEN
210: lv_action := jai_constants.inserting ;
211: ELSIF UPDATING THEN
212: lv_action := jai_constants.updating ;
213: ELSIF DELETING THEN
214: lv_action := jai_constants.deleting ;
208: */
209: IF INSERTING THEN
210: lv_action := jai_constants.inserting ;
211: ELSIF UPDATING THEN
212: lv_action := jai_constants.updating ;
213: ELSIF DELETING THEN
214: lv_action := jai_constants.deleting ;
215: END IF ;
216:
210: lv_action := jai_constants.inserting ;
211: ELSIF UPDATING THEN
212: lv_action := jai_constants.updating ;
213: ELSIF DELETING THEN
214: lv_action := jai_constants.deleting ;
215: END IF ;
216:
217: IF INSERTING THEN
218:
223: pv_return_code => lv_return_code ,
224: pv_return_message => lv_return_message
225: );
226:
227: IF lv_return_code <> jai_constants.successful then
228: RAISE le_error;
229: END IF;
230:
231: END IF ;
239: pv_return_code => lv_return_code ,
240: pv_return_message => lv_return_message
241: );
242:
243: IF lv_return_code <> jai_constants.successful then
244: RAISE le_error;
245: END IF;
246:
247: END IF ;