DBA Data[Home] [Help]

APPS.POS_ACK_PO dependencies on PO_LINE_LOCATIONS_ALL

Line 712: UPDATE PO_LINE_LOCATIONS_ALL PLL

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

Line 735: UPDATE PO_LINE_LOCATIONS_ALL PLL

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

Line 780: UPDATE po_line_locations_all pll

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

Line 804: UPDATE PO_LINE_LOCATIONS_ALL PLL

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