[Home] [Help]
3568:
3569: IF l_debug_level > 0 THEN
3570: oe_debug_pub.add( 'INSERT COMPLETED' , 1 ) ;
3571: END IF;
3572: IF OE_Commitment_Pvt.DO_Commitment_Sequencing
3573: AND p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
3574: IF l_debug_level > 0 THEN
3575: oe_debug_pub.add( 'BUILD UPDATE STATEMENT WITH PROMISED COMMITMENT AMOUNT' , 1 ) ;
3576: END IF;
6532: IF l_debug_level > 0 THEN
6533: oe_debug_pub.add( 'Service Billing Option: '||p_line_rec.service_bill_option_code , 5 ) ;
6534: END IF;
6535: -- sol_ord_er #16014165
6536: IF OE_Commitment_Pvt.DO_Commitment_Sequencing THEN-- commitment sequencing functionality ON
6537: IF p_line_rec.commitment_id IS NOT NULL THEN
6538: Get_Commitment_Info(p_line_rec
6539: ,l_commitment_applied
6540: ,l_commitment_interfaced);
6544: END IF;
6545: Rounded_Amount(p_currency_code => p_x_interface_line_rec.currency_code
6546: ,p_unrounded_amount => (p_line_rec.unit_selling_price * p_x_interface_line_rec.quantity)
6547: ,x_rounded_amount => l_partial_line_amount);
6548: IF OE_COMMITMENT_PVT.Get_Allocate_Tax_Freight(p_line_rec) = 'Y' THEN
6549: l_fulfilled_qty := NVL(p_line_rec.fulfilled_quantity, NVL(p_line_rec.shipped_quantity, NVL(p_line_rec.ordered_quantity, 0)));
6550: l_partial_line_tax_amount := nvl(p_line_rec.tax_value * (p_x_interface_line_rec.QUANTITY/l_fulfilled_qty), 0);
6551: SELECT nvl(sum(charge_amount), 0)
6552: INTO l_partial_line_freight_amount
8022: oe_debug_pub.add('Done with O2C Sync for flow status... ', 1);
8023: END IF;
8024: -- 8541809: End
8025:
8026: IF OE_Commitment_Pvt.DO_Commitment_Sequencing THEN --commitment sequencing ON
8027: IF p_line_rec.commitment_id IS NOT NULL AND
8028: p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
8029: IF l_debug_level > 0 THEN
8030: oe_debug_pub.add( 'UPDATING OE_PAYMENTS' , 3 ) ;