[Home] [Help]
1501: oe_debug_pub.add('Entering Tax line',1);
1502:
1503: BEGIN
1504:
1505: OE_LINE_UTIL.Query_Row(p_line_id => l_line_id,
1506: x_line_rec => l_line_rec);
1507: l_old_line_rec := l_line_rec;
1508:
1509: EXCEPTION
2563: IF l_debug_level > 0 THEN
2564: oe_debug_pub.ADD(' Both Header ID and Line ID cannot be passed ');
2565: END IF;
2566: ELSIF p_line_id IS NOT NULL THEN
2567: l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> p_line_id);
2568: -- OE_Order_Cache.Load_Order_Header(l_line_rec.header_id);
2569: l_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
2570: If NVL(l_line_rec.subscription_enable_flag,'N') = 'Y' then
2571: l_item_type := 'SUBSCRIPTION';
2651: END IF; -- on code release level
2652: End IF; -- end if for bill option FPOM
2653: ELSIF p_header_id IS NOT NULL THEN
2654: FOR l_rec IN l_servbill_lin(p_header_id) LOOP
2655: l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> l_rec.line_id);
2656: -- OE_Order_Cache.Load_Order_Header(l_line_rec.header_id);
2657: l_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
2658: If NVL(l_line_rec.subscription_enable_flag,'N') = 'Y' then
2659: l_item_type := 'SUBSCRIPTION';
3052: l_group_req_rec.old_ship_from_org_id := p_request_rec.param7;
3053: l_group_req_rec.old_ship_set_number := p_request_rec.param9;
3054: l_group_req_rec.old_arrival_set_number := p_request_rec.param10;
3055:
3056: OE_LINE_UTIL.Query_Row(p_line_id => p_request_rec.entity_id
3057: ,x_line_rec => l_line_rec);
3058:
3059: IF NVL(p_request_rec.param11,'N') = 'Y' THEN
3060:
3245: x_return_status := FND_API.G_RET_STS_SUCCESS;
3246:
3247: BEGIN
3248: -- query the return line and to see if it's a referenced line
3249: OE_Line_Util.query_row(p_line_id => p_line_id,
3250: x_line_rec => l_orig_line_rec);
3251: EXCEPTION
3252: WHEN NO_DATA_FOUND THEN
3253: RETURN;
3254: END;
3255:
3256: IF l_orig_line_rec.return_context is NOT NULL THEN
3257:
3258: OE_Line_Util.query_row(p_line_id => l_orig_line_rec.reference_line_id
3259: ,x_line_rec => l_reference_line_rec);
3260:
3261: IF l_reference_line_rec.item_type_code in ('STANDARD','OPTION',
3262: 'INCLUDED','CONFIG','SERVICE') THEN
3320: -- If COPY is calling and DFF is to be copied over
3321: IF OE_ORDER_COPY_UTIL.CALL_DFF_COPY_EXTN_API(l_orig_line_rec.org_id) AND
3322: l_copy_call
3323: THEN
3324: OE_Line_Util.query_row(p_line_id => l_child.line_id,
3325: x_line_rec => l_child_line_rec);
3326:
3327: IF OE_ORDER_COPY_UTIL.G_COPY_REC.line_descflex = FND_API.G_TRUE THEN
3328: -- Pre populate the DFF info from reference line
3602:
3603: x_return_status := FND_API.G_RET_STS_SUCCESS;
3604:
3605: BEGIN
3606: OE_Line_Util.query_row(p_line_id => p_line_id
3607: ,x_line_rec => l_orig_line_rec);
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: Return;
3657: IF l_reference_line_id IS NOT NULL AND
3658: l_reference_line_id <> FND_API.G_MISS_NUM THEN
3659:
3660: OE_DEBUG_PUB.ADD(' There is a reference Line',1);
3661: OE_Line_Util.query_row(p_line_id => l_reference_line_id,
3662: x_line_rec => l_reference_line_rec);
3663: l_inventory_item_id := l_reference_line_rec.inventory_item_id;
3664: l_ship_from_org_id := l_reference_line_rec.ship_from_org_id;
3665: oe_debug_pub.add(to_char(l_inventory_item_id)||':'||to_char(l_ship_from_org_id),2);
3898: l_fulfillment_base VARCHAR2(1);--ER#14763609
3899:
3900: BEGIN
3901: oe_debug_pub.add('Entering oe_delayed_requests_util.Validate_Line_Set',1);
3902: oe_line_util.query_rows(p_line_set_id => p_line_set_id,
3903: x_line_tbl => l_line_tbl);
3904:
3905: -- Start for bug 5754554
3906: IF l_line_tbl.count > 0 THEN
4303: END IF;
4304: oe_debug_pub.add('Do cascade services', 2);
4305:
4306: -- query the service line and to see if it's a referenced line
4307: OE_Line_Util.query_row(p_line_id => p_serviced_line_id,
4308: x_line_rec => l_orig_line_rec);
4309:
4310: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4311: INTO l_order_number
4316:
4317:
4318:
4319: IF l_orig_line_rec.service_reference_type_code is NOT NULL THEN
4320: OE_Line_Util.query_row(p_line_id => l_orig_line_rec.service_reference_line_id,
4321: x_line_rec => l_reference_line_rec);
4322: l_service_reference_line_id := l_orig_line_rec.service_reference_line_id;
4323: oe_debug_pub.add('JPN: Service Reference Line is' || l_service_reference_line_id,2);
4324:
4685: END IF;
4686: oe_debug_pub.add('Do cascade services', 2);
4687:
4688: -- query the option line
4689: OE_Line_Util.query_row(p_line_id => p_option_line_id,
4690: x_line_rec => l_orig_line_rec);
4691:
4692: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4693: INTO l_order_number
4997: l_request_rec := p_sch_set_tbl(I);
4998: -- Assiging miss rec.
4999: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
5000:
5001: OE_LINE_UTIL.Lock_Row(p_line_id => l_request_rec.entity_id,
5002: p_x_line_rec => l_line_rec,
5003: x_return_status => l_return_status);
5004:
5005: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5453: INTO l_old_total_tax
5454: FROM oe_order_lines_all
5455: WHERE line_id = p_entity_id_tbl(i).entity_id;
5456:
5457: l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> p_entity_id_tbl(i).entity_id );
5458:
5459:
5460: IF ( (l_old_total_tax IS NOT NULL AND l_total_tax IS NOT NULL AND l_old_total_tax = l_total_tax) OR (l_old_total_tax IS NULL AND l_total_tax IS NULL ) ) THEN
5461: NULL;
5469: SET TAX_VALUE = l_total_tax,
5470: TAX_LINE_VALUE = l_total_tax - l_tax_on_charge --TaxER
5471: WHERE line_id = p_entity_id_tbl(i).entity_id;
5472: /* getting line record*/
5473: --TaxER l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> p_entity_id_tbl(i).entity_id );
5474: SELECT payment_type_code
5475: INTO l_payment_type_code
5476: FROM oe_order_lines_all
5477: WHERE line_id = l_line_rec.line_id;