DBA Data[Home] [Help]

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 1265: FROM po_line_locations_draft_all

1261: FROM po_line_locations
1262: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1263: AND shipment_type = 'PRICE BREAK')
1264: OR EXISTS (SELECT 1
1265: FROM po_line_locations_draft_all
1266: WHERE po_line_id =
1267: x_lines.po_line_id_tbl(i)
1268: AND draft_id = x_lines.draft_id_tbl(i)
1269: AND shipment_type = 'PRICE BREAK')

Line 1558: -- insert line location rows into po_line_locations_draft_all

1554: END IF;
1555: */
1556: d_position := 40;
1557:
1558: -- insert line location rows into po_line_locations_draft_all
1559: insert_po_line_locs_draft_all
1560: (
1561: p_line_locs => p_line_locs
1562: );

Line 3108: -- po_line_locations_draft_all

3104: --Start of Comments
3105: --Name: insert_po_line_locs_draft_all
3106: --Function:
3107: -- insert new line location attribute values into
3108: -- po_line_locations_draft_all
3109: --Parameters:
3110: --IN:
3111: --p_line_locs
3112: -- record which contains processed line attributes in a batch;

Line 3158: INSERT INTO po_line_locations_draft_all

3154: --Bug 8565385. If unit_meas_lookup_code is null for line_locations,
3155: --get the value from lines_draft. When code executed to this point, the
3156: --lines_draft has been inserted with derived and defaulted values
3157: FORALL i IN 1..p_line_locs.rec_count
3158: INSERT INTO po_line_locations_draft_all
3159: (
3160: draft_id,
3161: org_id,
3162: delete_flag,