160: /*
161: || check for action in trigger and pass the same to the procedure
162: */
163: IF INSERTING THEN
164: lv_action := jai_constants.inserting ;
165: ELSIF UPDATING THEN
166: lv_action := jai_constants.updating ;
167: ELSIF DELETING THEN
168: lv_action := jai_constants.deleting ;
162: */
163: IF INSERTING THEN
164: lv_action := jai_constants.inserting ;
165: ELSIF UPDATING THEN
166: lv_action := jai_constants.updating ;
167: ELSIF DELETING THEN
168: lv_action := jai_constants.deleting ;
169: END IF ;
170:
164: lv_action := jai_constants.inserting ;
165: ELSIF UPDATING THEN
166: lv_action := jai_constants.updating ;
167: ELSIF DELETING THEN
168: lv_action := jai_constants.deleting ;
169: END IF ;
170:
171: IF INSERTING THEN
172:
179: pv_return_code => lv_return_code ,
180: pv_return_message => lv_return_message
181: );
182:
183: IF lv_return_code <> jai_constants.successful then
184: RAISE le_error;
185: END IF;
186:
187: END IF ;
193: pv_return_code => lv_return_code ,
194: pv_return_message => lv_return_message
195: );
196:
197: IF lv_return_code <> jai_constants.successful then
198: RAISE le_error;
199: END IF;
200:
201: END IF ;
209: pv_return_code => lv_return_code ,
210: pv_return_message => lv_return_message
211: );
212:
213: IF lv_return_code <> jai_constants.successful then
214: RAISE le_error;
215: END IF;
216:
217: END IF ;
225: pv_return_code => lv_return_code ,
226: pv_return_message => lv_return_message
227: );
228:
229: IF lv_return_code <> jai_constants.successful then
230: RAISE le_error;
231: END IF;
232:
233: END IF ;