DBA Data[Home] [Help]

APPS.JAI_PO_LLA_ARIUD_T1 dependencies on JAI_PO_PROC_PKG

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

389: ELSIF DELETING THEN
390: lv_action := jai_constants.deleting ;
391: END IF ;
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_line_loc => 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 INSERTING THEN

Line 399: jai_po_proc_pkg.process_quotation_line_loc(po_line_loc_rec => t_new_rec,

395: END IF;
396: --Added by Wenqiong for 14040855/JAI Triggers Elimination on 1-Jun-2012 End
397: IF INSERTING THEN
398: --Added by Wenqiong for 14040855/JAI Triggers Elimination on 1-Jun-2012 Begin
399: jai_po_proc_pkg.process_quotation_line_loc(po_line_loc_rec => t_new_rec,
400: pv_action => lv_action ,
401: pv_return_code => lv_return_code ,
402: pv_return_message => lv_return_message
403: );

Line 426: jai_po_proc_pkg.process_quotation_line_loc(po_line_loc_rec => t_new_rec,

422:
423: IF ( nvl( :NEW.quantity, 0 ) <> nvl( :OLD.quantity, 0 ) /*OR ( nvl(:OLD.cancel_flag,'N') <> 'Y' AND nvl(:NEW.cancel_flag,'N') = 'Y' ) Move to separate branch*/
424: OR nvl(:NEW.price_override, 0 ) <> nvl( :OLD.price_override, 0 ) OR nvl( :NEW.unit_meas_lookup_code, 'X' ) <> nvl( :OLD.unit_meas_lookup_code, 'X' ) ) THEN
425: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start
426: jai_po_proc_pkg.process_quotation_line_loc(po_line_loc_rec => t_new_rec,
427: pv_action => lv_action ,
428: pv_return_code => lv_return_code ,
429: pv_return_message => lv_return_message
430: );

Line 448: jai_po_proc_pkg.cancel_po_shipment_line(t_new_rec);

444:
445: END IF ;
446: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start
447: IF nvl(:OLD.cancel_flag,'N') <> 'Y' AND nvl(:NEW.cancel_flag,'N') = 'Y' THEN
448: jai_po_proc_pkg.cancel_po_shipment_line(t_new_rec);
449: END IF;
450: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 end
451: END IF ;
452:

Line 455: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => t_old_rec.LINE_LOCATION_ID);

451: END IF ;
452:
453: IF DELETING THEN
454: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start
455: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => t_old_rec.LINE_LOCATION_ID);
456: jai_po_proc_pkg.delete_po_taxes( pn_po_line_id => t_old_rec.PO_LINE_ID,
457: pn_line_loc_id => t_old_rec.LINE_LOCATION_ID);
458: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 end
459:

Line 456: jai_po_proc_pkg.delete_po_taxes( pn_po_line_id => t_old_rec.PO_LINE_ID,

452:
453: IF DELETING THEN
454: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start
455: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => t_old_rec.LINE_LOCATION_ID);
456: jai_po_proc_pkg.delete_po_taxes( pn_po_line_id => t_old_rec.PO_LINE_ID,
457: pn_line_loc_id => t_old_rec.LINE_LOCATION_ID);
458: --Added by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 end
459:
460: /*Comment out by Wenqiong for 15968958/JAI Triggers Replacement on 06-Dec-2012 start