APPS.JAI_AR_RCTA_ARIUD_T1 dependencies on JAI_AR_RCTA_TRIGGER_PKG

Line 12: Fix: Added the code to call the procedure JAI_AR_RCTA_TRIGGER_PKG.ARD_T1

8: CHANGE HISTORY:
9: S.No Date Author and Details
10: 1 07/11/200b CSahoo For Bug#7450481, File Version 120.7.12010000.2
11: Issue: AUTOINVOICE IMPORT PROGRAM ENDING IN ERROR FOR BILL ONLY ORDERS
12: Fix: Added the code to call the procedure JAI_AR_RCTA_TRIGGER_PKG.ARD_T1
13: when the base table gets deleted.
14: --------------------------------------------------------------------------------------------*/
15: t_old_rec RA_CUSTOMER_TRX_ALL%rowtype ;
16: t_new_rec RA_CUSTOMER_TRX_ALL%rowtype ;

Line 463: JAI_AR_RCTA_TRIGGER_PKG.ARI_T1 (

459: IF ( :NEW.CREATED_FROM <> 'RAXTRX' ) THEN
460:
461: jai_cmn_utils_pkg.print_log ('jai_ar_rcta.log', :NEW.CREATED_FROM || '<> ''RAXTRX''');
462:
463: JAI_AR_RCTA_TRIGGER_PKG.ARI_T1 (
464: pr_old => t_old_rec ,
465: pr_new => t_new_rec ,
466: pv_action => lv_action ,
467: pv_return_code => lv_return_code ,

Line 483: JAI_AR_RCTA_TRIGGER_PKG.ARU_T1 (

479: IF UPDATING THEN
480:
481: IF ( :NEW.complete_flag = 'Y' ) THEN
482:
483: JAI_AR_RCTA_TRIGGER_PKG.ARU_T1 (
484: pr_old => t_old_rec ,
485: pr_new => t_new_rec ,
486: pv_action => lv_action ,
487: pv_return_code => lv_return_code ,

Line 500: JAI_AR_RCTA_TRIGGER_PKG.ARU_T2 (

496: END IF ;
497:
498: IF ((:NEW.TRX_NUMBER <> :OLD.TRX_NUMBER) OR (:NEW.CUSTOMER_TRX_ID <> :OLD.CUSTOMER_TRX_ID)) THEN
499:
500: JAI_AR_RCTA_TRIGGER_PKG.ARU_T2 (
501: pr_old => t_old_rec ,
502: pr_new => t_new_rec ,
503: pv_action => lv_action ,
504: pv_return_code => lv_return_code ,

Line 516: JAI_AR_RCTA_TRIGGER_PKG.ARU_T3 (

512: END IF ;
513:
514: IF ( :NEW.COMPLETE_FLAG = 'Y' AND NVL(:NEW.CREATED_FROM,'###') IN ('ARXTWMAI','ARXTWCMI') ) THEN
515:
516: JAI_AR_RCTA_TRIGGER_PKG.ARU_T3 (
517: pr_old => t_old_rec ,
518: pr_new => t_new_rec ,
519: pv_action => lv_action ,
520: pv_return_code => lv_return_code ,

Line 556: JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 (

552: END IF ;
553:
554: IF ( :NEW.COMPLETE_FLAG = 'Y' ) THEN
555:
556: JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 (
557: pr_old => t_old_rec ,
558: pr_new => t_new_rec ,
559: pv_action => lv_action ,
560: pv_return_code => lv_return_code ,

Line 572: JAI_AR_RCTA_TRIGGER_PKG.ARU_T5 (

568: END IF ;
569:
570: IF ( NVL(:NEW.COMPLETE_FLAG,'$') ='N' AND :NEW.TRX_DATE <> :OLD.TRX_DATE ) THEN
571:
572: JAI_AR_RCTA_TRIGGER_PKG.ARU_T5 (
573: pr_old => t_old_rec ,
574: pr_new => t_new_rec ,
575: pv_action => lv_action ,
576: pv_return_code => lv_return_code ,

Line 590: JAI_AR_RCTA_TRIGGER_PKG.ARU_T6 (

586: END IF ;
587:
588: IF ( (NVL(:NEW.Ship_To_Customer_ID,0) <> NVL(:OLD.Ship_To_Customer_ID,0)) OR (NVL(:NEW.Ship_To_Site_Use_ID,0) <> NVL(:OLD.Ship_To_Site_Use_ID,0)) OR :NEW.invoice_currency_code <> :OLD.invoice_currency_code ) THEN
589:
590: JAI_AR_RCTA_TRIGGER_PKG.ARU_T6 (
591: pr_old => t_old_rec ,
592: pr_new => t_new_rec ,
593: pv_action => lv_action ,
594: pv_return_code => lv_return_code ,

Line 609: JAI_AR_RCTA_TRIGGER_PKG.ARU_T7 (

605: -- Start 5631784
606: IF ( NVL(:OLD.COMPLETE_FLAG,'N') = 'N' AND NVL(:NEW.COMPLETE_FLAG,'$') ='Y' ) -- COMPLETION
607: OR ( NVL(:OLD.COMPLETE_FLAG,'N') = 'Y' AND NVL(:NEW.COMPLETE_FLAG,'$') ='N' ) -- INCOMPLETION
608: THEN
609: JAI_AR_RCTA_TRIGGER_PKG.ARU_T7 (
610: pr_old => t_old_rec ,
611: pr_new => t_new_rec ,
612: pv_action => lv_action ,
613: pv_return_code => lv_return_code ,

Line 627: JAI_AR_RCTA_TRIGGER_PKG.ARD_T1 (

623:
624: --added the following IF block for bug#7450481
625: IF DELETING THEN
626:
627: JAI_AR_RCTA_TRIGGER_PKG.ARD_T1 (
628: pr_old => t_old_rec ,
629: pv_action => lv_action ,
630: pv_return_code => lv_return_code ,
631: pv_return_message => lv_return_message