448: /*
449: || check for action in trigger and pass the same to the procedure
450: */
451: IF INSERTING THEN
452: lv_action := jai_constants.inserting ;
453: ELSIF UPDATING THEN
454: lv_action := jai_constants.updating ;
455: ELSIF DELETING THEN
456: lv_action := jai_constants.deleting ;
450: */
451: IF INSERTING THEN
452: lv_action := jai_constants.inserting ;
453: ELSIF UPDATING THEN
454: lv_action := jai_constants.updating ;
455: ELSIF DELETING THEN
456: lv_action := jai_constants.deleting ;
457: END IF ;
458:
452: lv_action := jai_constants.inserting ;
453: ELSIF UPDATING THEN
454: lv_action := jai_constants.updating ;
455: ELSIF DELETING THEN
456: lv_action := jai_constants.deleting ;
457: END IF ;
458:
459: IF INSERTING THEN
460: -- Modified by Jason Liu for retroactive price on 2008/01/07
468: pv_return_code => lv_return_code ,
469: pv_return_message => lv_return_message
470: );
471:
472: IF lv_return_code <> jai_constants.successful then
473: RAISE le_error;
474: END IF;
475:
476: END IF ;
505: , pv_action => lv_action
506: , pv_return_code => lv_return_code
507: , pv_return_message => lv_return_message
508: );
509: IF (lv_return_code <> jai_constants.successful)
510: THEN
511: RAISE le_error;
512: END IF; -- (lv_return_code <> jai_constants.successful)
513: END IF; -- (:NEW.line_type_lookup_code IN ('ITEM' , 'ACCRUAL' , 'RETROITEM')
508: );
509: IF (lv_return_code <> jai_constants.successful)
510: THEN
511: RAISE le_error;
512: END IF; -- (lv_return_code <> jai_constants.successful)
513: END IF; -- (:NEW.line_type_lookup_code IN ('ITEM' , 'ACCRUAL' , 'RETROITEM')
514: ----------------------------------------------------------------------
515: END IF; -- (INSERTING)
516: ----------------------------------------------------------------------------