APPS.OE_BULK_ORDER_PVT dependencies on OE_ORDER_LINES

Line 63: DELETE from OE_ORDER_LINES

59: END IF;
60: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
61: -- Delete line records
62: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
63: DELETE from OE_ORDER_LINES
64: WHERE orig_sys_line_ref in
65: (select orig_sys_line_ref from oe_lines_iface_all a
66: where nvl(a.error_flag, 'N') = 'Y'
67: and a.orig_sys_document_ref=G_ERROR_REC.orig_sys_document_ref(i));

Line 73: and not exists (select 1 from oe_order_lines

69: -- Delete Header Records
70: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
71: DELETE from OE_ORDER_HEADERS
72: WHERE header_id = G_ERROR_REC.header_id(i)
73: and not exists (select 1 from oe_order_lines
74: where header_id=G_ERROR_REC.header_id(i));
75: else
76: -- Delete line records
77: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT

Line 78: DELETE from OE_ORDER_LINES

74: where header_id=G_ERROR_REC.header_id(i));
75: else
76: -- Delete line records
77: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
78: DELETE from OE_ORDER_LINES
79: WHERE header_id = G_ERROR_REC.header_id(i);
80:
81: -- Delete Header Records
82: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT