DBA Data[Home] [Help]

APPS.POS_ACK_PO dependencies on PO_LINE_LOCATIONS_ALL

Line 713: UPDATE PO_LINE_LOCATIONS_ALL PLL

709: IF p_po_release_id is null THEN
710:
711: IF p_line_location_id is not null THEN
712:
713: UPDATE PO_LINE_LOCATIONS_ALL PLL
714: SET pll.promised_date = pll.need_by_date,
715: pll.last_update_date = sysdate,
716: pll.last_updated_by = p_user_id
717: WHERE pll.po_header_id= p_po_header_id

Line 736: UPDATE PO_LINE_LOCATIONS_ALL PLL

732: WHERE plla2.line_location_id = plla.line_location_id
733: AND plla.revision_num <= p_revision_num);
734: ELSE
735:
736: UPDATE PO_LINE_LOCATIONS_ALL PLL
737: SET pll.promised_date = pll.need_by_date,
738: pll.last_update_date = sysdate,
739: pll.last_updated_by = p_user_id
740: WHERE pll.po_header_id = p_po_header_id

Line 781: UPDATE po_line_locations_all pll

777:
778:
779: IF p_line_location_id is not null THEN
780:
781: UPDATE po_line_locations_all pll
782: SET pll.promised_date =need_by_date,
783: pll.last_update_date = sysdate,
784: pll.last_updated_by = p_user_id
785: WHERE pll.po_header_id= p_po_header_id

Line 805: UPDATE PO_LINE_LOCATIONS_ALL PLL

801: AND plla.revision_num <= p_revision_num);
802:
803: ELSE
804:
805: UPDATE PO_LINE_LOCATIONS_ALL PLL
806: SET pll.promised_date =need_by_date,
807: pll.last_update_date = sysdate,
808: pll.last_updated_by = p_user_id
809: WHERE pll.po_header_id = p_po_header_id