APPS.OE_BULK_PRICE_PVT dependencies on OE_ORDER_HEADERS

Line 238: , OE_ORDER_HEADERS h

234: ,nvl(a.OPERAND_PER_PQTY,ll.operand)
235: ,a.ADJUSTED_AMOUNT_PER_PQTY
236: ,1
237: FROM OE_PRICE_ADJS_IFACE_ALL a
238: , OE_ORDER_HEADERS h
239: , QP_LIST_HEADERS lh
240: , QP_LIST_LINES ll
241: , OE_ORDER_LINES_ALL l -- Changes for SQL Id 14876372
242: WHERE h.batch_id = p_batch_id

Line 522: UPDATE oe_order_headers_all

518: -- Update the booked flag only if real Time CC is required
519: -- else the booked_flag is already set on the record
520:
521: IF OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED = 'Y' THEN
522: UPDATE oe_order_headers_all
523: SET booked_flag = p_header_rec.booked_flag(i)
524: WHERE header_id = p_header_rec.header_id(i);
525: END IF;
526:

Line 722: UPDATE oe_order_headers_all

718: -- Update the booked flag only if real Time CC is required
719: -- else the booked_flag is already set on the record
720:
721: IF OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED = 'Y' THEN
722: UPDATE oe_order_headers_all
723: SET booked_flag = p_header_rec.booked_flag(i)
724: WHERE header_id = p_header_rec.header_id(i);
725: END IF;
726:

Line 784: UPDATE OE_ORDER_HEADERS

780: SET booked_flag = 'N'
781: ,flow_status_code = 'ENTERED'
782: WHERE header_id = p_header_rec.header_id(p_index);
783:
784: UPDATE OE_ORDER_HEADERS
785: SET booked_flag = 'N'
786: ,booked_date = NULL
787: ,flow_status_code = 'ENTERED'
788: WHERE header_id = p_header_rec.header_id(p_index);