DBA Data[Home] [Help]

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 1170: FROM po_line_locations_draft_all

1166: FROM po_line_locations
1167: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1168: AND shipment_type = 'PRICE BREAK')
1169: OR EXISTS (SELECT 1
1170: FROM po_line_locations_draft_all
1171: WHERE po_line_id =
1172: x_lines.po_line_id_tbl(i)
1173: AND draft_id = x_lines.draft_id_tbl(i)
1174: AND shipment_type = 'PRICE BREAK')

Line 1364: -- insert line location rows into po_line_locations_draft_all

1360: END IF;
1361: */
1362: d_position := 40;
1363:
1364: -- insert line location rows into po_line_locations_draft_all
1365: insert_po_line_locs_draft_all
1366: (
1367: p_line_locs => p_line_locs
1368: );

Line 2781: -- po_line_locations_draft_all

2777: --Start of Comments
2778: --Name: insert_po_line_locs_draft_all
2779: --Function:
2780: -- insert new line location attribute values into
2781: -- po_line_locations_draft_all
2782: --Parameters:
2783: --IN:
2784: --p_line_locs
2785: -- record which contains processed line attributes in a batch;

Line 2828: INSERT INTO po_line_locations_draft_all

2824: l_valid_intf_loc_id_tbl);
2825: END IF;
2826:
2827: FORALL i IN 1..p_line_locs.rec_count
2828: INSERT INTO po_line_locations_draft_all
2829: (
2830: draft_id,
2831: org_id,
2832: delete_flag,