DBA Data[Home] [Help]

APPS.JAI_PO_HA_ARIUD_T1 dependencies on JAI_PO_PROC_PKG

Line 393: IF jai_po_proc_pkg.rfq_quotation_related(pr_po_header => t_new_rec) = FALSE THEN

389: lv_action := jai_constants.deleting ;
390: END IF ;
391:
392: --Added by Wenqiong for 14040855/JAI Triggers Elimination on 1-Jun-2012 Begin
393: IF jai_po_proc_pkg.rfq_quotation_related(pr_po_header => t_new_rec) = FALSE THEN
394: RETURN;
395: END IF;
396: --Added by Wenqiong for 14040855/JAI Triggers Elimination on 1-Jun-2012 End
397: IF UPDATING THEN

Line 402: jai_po_proc_pkg.update_currency(

398:
399:
400: IF ( :OLD.Currency_Code <> :NEW.Currency_Code ) THEN
401: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start
402: jai_po_proc_pkg.update_currency(
403: pn_po_header_id => t_new_rec.po_header_id
404: ,pv_old_currency => :OLD.Currency_Code
405: ,pv_currency => :NEW.Currency_Code
406: ,pd_last_upd_dt => t_new_rec.LAST_UPDATE_DATE

Line 427: jai_po_proc_pkg.process_vendor_change(prec_po_header => t_new_rec,

423: END IF ;
424:
425: IF ( ( NVL( :OLD.Vendor_Id, -999 ) <> NVL( :NEW.Vendor_Id, -999 ) ) OR ( NVL( :OLD.Vendor_Site_Id, -999 ) <> NVL( :NEW.Vendor_Site_Id, -999 ) ) ) THEN
426: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start
427: jai_po_proc_pkg.process_vendor_change(prec_po_header => t_new_rec,
428: pn_old_vendor_id => :OLD.Vendor_Site_Id);
429: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 end
430: /* Comment out below trigger package and replace with JAI_PO_PROC_PKG.
431: JAI_PO_HA_TRIGGER_PKG.ARU_T3 (

Line 430: /* Comment out below trigger package and replace with JAI_PO_PROC_PKG.

426: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start
427: jai_po_proc_pkg.process_vendor_change(prec_po_header => t_new_rec,
428: pn_old_vendor_id => :OLD.Vendor_Site_Id);
429: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 end
430: /* Comment out below trigger package and replace with JAI_PO_PROC_PKG.
431: JAI_PO_HA_TRIGGER_PKG.ARU_T3 (
432: pr_old => t_old_rec ,
433: pr_new => t_new_rec ,
434: pv_action => lv_action ,