[Home] [Help]
5227:
5228: IF l_header_id IS NULL or
5229: l_header_id = FND_API.G_MISS_NUM THEN
5230: SELECT /* MOAC_SQL_CHANGE */ header_id into l_header_id
5231: FROM OE_BLANKET_LINES_all
5232: WHERE line_id = p_line_id;
5233: END IF;
5234:
5235: --Versioning changes
6002:
6003: END IF;
6004:
6005: IF p_version_number IS NOT NULL THEN
6006: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE (header_id = p_header_id OR header_id = (select header_id from oe_blanket_lines_ALL where line_id = p_line_id));
6007: END IF;
6008:
6009:
6010: IF p_version_number IS NULL OR
6534: FOR UPDATE NOWAIT;
6535:
6536: CURSOR c_blanket_lines IS
6537: SELECT /* MOAC_SQL_CHANGE */ bl.line_id, bl.lock_control
6538: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX
6539: WHERE BL.LINE_ID = BLX.LINE_ID
6540: AND BLX.ORDER_NUMBER = l_blanket_id
6541: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
6542: AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'
9494: ship_to_org_id,
9495: deliver_to_org_id,
9496: invoice_to_org_id
9497: from
9498: oe_blanket_lines_all where header_id = p_header_id;
9499: mc1x c1%ROWTYPE;
9500:
9501: BEGIN
9502: OE_MSG_PUB.initialize;
9620:
9621: if x_return_status = FND_API.G_RET_STS_ERROR then
9622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9623: elsif l_dummy = 'VALID' then
9624: update oe_blanket_lines_all set sold_to_org_id = p_sold_to_org_id
9625: where header_id = p_header_id;
9626: end if;
9627: IF l_debug_level > 0 THEN
9628: oe_debug_pub.add('EXISTING OE_Blanket_util.validate_sold_to: '|| TO_CHAR (p_header_id) ,1);