APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 31: PO_LINE_LOCATIONS_DRAFT_ALL

27: Name: create_shipment_draft
28: Pre-reqs:
29: PO Line has been created
30: Modifies:
31: PO_LINE_LOCATIONS_DRAFT_ALL
32: Locks:
33: None
34: Function:
35: Derives,deaults the shipment info from available lines information and

Line 36: inserts/updates the PO_LINE_LOCATIONS_DRAFT_ALL.

32: Locks:
33: None
34: Function:
35: Derives,deaults the shipment info from available lines information and
36: inserts/updates the PO_LINE_LOCATIONS_DRAFT_ALL.
37: Parameters:
38: p_lines IN OUT Derived Line data after lines processing
39: Returns:
40: None

Line 328: FROM po_line_locations_draft_all poll, --

324: SELECT poll.line_location_id,
325: poll.secondary_unit_of_measure --
326: INTO x_line_location_id,
327: x_secondary_unit_of_measure
328: FROM po_line_locations_draft_all poll, --
329: po_lines_draft_all pol --
330: WHERE poll.po_header_id = p_lines.po_header_id_tbl(i)
331: AND pol.draft_id =po_autocreate_params.g_draft_id
332: AND poll.po_line_id = p_lines.po_line_id_tbl(i)

Line 486: UPDATE po_line_locations_draft_all --

482:
483: l_progress:='140';
484: --
485: -- replace interface.secondary_quantity with x_secondary_quantity
486: UPDATE po_line_locations_draft_all --
487: SET quantity = quantity + x_quantity,
488: secondary_quantity = secondary_quantity + x_secondary_quantity,
489: approved_flag = DECODE(approved_flag, 'N','N', 'R'),
490: last_update_date = p_lines.last_update_date_tbl(i),

Line 741: INTO po_line_locations_draft_all --

737: END IF;
738:
739: l_progress := '350';
740: INSERT
741: INTO po_line_locations_draft_all --
742: (
743: draft_id,
744: line_location_id,
745: last_update_date,

Line 1469: INTO po_line_locations_draft_all

1465: -- insert payitem into po_line_locations_all
1466: --SQL WHAT: Insert payitem, using info in po_line_locations_interface
1467: --SQL WHY : This allows us to insert all payitems in one location.
1468: INSERT
1469: INTO po_line_locations_draft_all
1470: (
1471: draft_id ,
1472: line_location_id ,
1473: last_update_date ,

Line 1770: PO_LINE_LOCATIONS_DRAFT_ALL

1766: Name: create_pricebreak_draft
1767: Pre-reqs:
1768: PO Line has been created
1769: Modifies:
1770: PO_LINE_LOCATIONS_DRAFT_ALL
1771: Locks:
1772: None
1773: Function:
1774: Derives,deaults the Price Breaks info from available lines information and

Line 1775: inserts/updates the PO_LINE_LOCATIONS_DRAFT_ALL.

1771: Locks:
1772: None
1773: Function:
1774: Derives,deaults the Price Breaks info from available lines information and
1775: inserts/updates the PO_LINE_LOCATIONS_DRAFT_ALL.
1776: Parameters:
1777: p_lines IN OUT Derived Line data after lines processing
1778: Returns:
1779: None

Line 1882: INTO po_line_locations_draft_all

1878: END IF;
1879:
1880: BEGIN
1881: INSERT
1882: INTO po_line_locations_draft_all
1883: (
1884: draft_id,
1885: line_location_id,
1886: last_update_date,