484: IF INSERTING THEN
485:
486: /* Start bug#6012570 (5876390) */
487: if :new.line_type = 'LINE'
488: and JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context(:new.interface_line_context)
489: then
490: lv_object := 'jai_ar_rctla_trigger_pkg.is_this_projects_context(||'|| :new.customer_trx_id ||')';
491:
492: if lb_debug then
486: /* Start bug#6012570 (5876390) */
487: if :new.line_type = 'LINE'
488: and JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context(:new.interface_line_context)
489: then
490: lv_object := 'jai_ar_rctla_trigger_pkg.is_this_projects_context(||'|| :new.customer_trx_id ||')';
491:
492: if lb_debug then
493: fnd_file.put_line(fnd_file.log, lv_action||'-JAI_AR_RCTLA_ARIUD_T1. Before JAI_AR_RCTLA_TRIGGER_PKG.import_projects_taxes');
494: end if;
489: then
490: lv_object := 'jai_ar_rctla_trigger_pkg.is_this_projects_context(||'|| :new.customer_trx_id ||')';
491:
492: if lb_debug then
493: fnd_file.put_line(fnd_file.log, lv_action||'-JAI_AR_RCTLA_ARIUD_T1. Before JAI_AR_RCTLA_TRIGGER_PKG.import_projects_taxes');
494: end if;
495:
496: JAI_AR_RCTLA_TRIGGER_PKG.import_projects_taxes
497: (
492: if lb_debug then
493: fnd_file.put_line(fnd_file.log, lv_action||'-JAI_AR_RCTLA_ARIUD_T1. Before JAI_AR_RCTLA_TRIGGER_PKG.import_projects_taxes');
494: end if;
495:
496: JAI_AR_RCTLA_TRIGGER_PKG.import_projects_taxes
497: (
498: r_new => t_new_rec
499: , r_old => t_old_rec
500: , pv_action => lv_action
511:
512:
513: IF ((:NEW.inventory_item_id <> :OLD.inventory_item_id) OR (:OLD.inventory_item_id IS NULL)) THEN
514:
515: JAI_AR_RCTLA_TRIGGER_PKG.ARI_T1 (
516: pr_old => t_old_rec ,
517: pr_new => t_new_rec ,
518: pv_action => lv_action ,
519: pv_return_code => lv_return_code ,
527: END IF ;
528:
529: IF ( :NEW.LINE_TYPE = 'LINE' ) THEN
530:
531: JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2 (
532: pr_old => t_old_rec ,
533: pr_new => t_new_rec ,
534: pv_action => lv_action ,
535: pv_return_code => lv_return_code ,
543: END IF ;
544:
545: IF ( :NEW.LINE_TYPE = 'LINE' ) THEN
546:
547: JAI_AR_RCTLA_TRIGGER_PKG.ARI_T3 (
548: pr_old => t_old_rec ,
549: pr_new => t_new_rec ,
550: pv_action => lv_action ,
551: pv_return_code => lv_return_code ,
559: END IF ;
560:
561: IF ( (:NEW.LINE_TYPE in ('LINE')) AND ((NVL(:NEW.inventory_item_id,0) <> NVL(:OLD.inventory_item_id,0)) OR (:OLD.inventory_item_id IS NULL AND :OLD.Description IS NULL)) )THEN
562:
563: JAI_AR_RCTLA_TRIGGER_PKG.ARIU_T1 (
564: pr_old => t_old_rec ,
565: pr_new => t_new_rec ,
566: pv_action => lv_action ,
567: pv_return_code => lv_return_code ,
579: IF UPDATING THEN
580:
581: IF ((:OLD.LINE_TYPE = 'LINE') AND (:NEW.quantity_credited <> :OLD.quantity_credited OR :NEW.unit_selling_price <> :OLD.unit_selling_price OR :NEW.UOM_CODE <> :OLD.UOM_CODE) ) THEN
582:
583: JAI_AR_RCTLA_TRIGGER_PKG.ARU_T1 (
584: pr_old => t_old_rec ,
585: pr_new => t_new_rec ,
586: pv_action => lv_action ,
587: pv_return_code => lv_return_code ,
600: */
601: IF ((:OLD.LINE_TYPE = 'LINE') AND (nvl(:NEW.inventory_item_id,-99999) = nvl(:OLD.inventory_item_id,-99999) OR :old.inventory_item_id is null )
602: AND (:NEW.quantity_invoiced <> :OLD.quantity_invoiced OR :NEW.quantity_credited <> :OLD.quantity_credited OR :NEW.unit_selling_price <> :OLD.unit_selling_price OR :NEW.UOM_CODE <> :OLD.UOM_CODE) ) THEN
603:
604: JAI_AR_RCTLA_TRIGGER_PKG.ARU_T2 (
605: pr_old => t_old_rec ,
606: pr_new => t_new_rec ,
607: pv_action => lv_action ,
608: pv_return_code => lv_return_code ,
616: END IF ;
617:
618: IF ( (:NEW.LINE_TYPE in ('LINE')) AND ((NVL(:NEW.inventory_item_id,0) <> NVL(:OLD.inventory_item_id,0)) OR (:OLD.inventory_item_id IS NULL AND :OLD.Description IS NULL))) THEN
619:
620: JAI_AR_RCTLA_TRIGGER_PKG.ARIU_T1 (
621: pr_old => t_old_rec ,
622: pr_new => t_new_rec ,
623: pv_action => lv_action ,
624: pv_return_code => lv_return_code ,
636: IF DELETING THEN
637:
638: IF ( :OLD.LINE_TYPE = 'LINE' ) THEN
639:
640: JAI_AR_RCTLA_TRIGGER_PKG.ARD_T1 (
641: pr_old => t_old_rec ,
642: pr_new => t_new_rec ,
643: pv_action => lv_action ,
644: pv_return_code => lv_return_code ,