[Home] [Help]
3339:
3340: IF l_debug_level > 0 THEN
3341: oe_debug_pub.add( 'INSERT COMPLETED' , 1 ) ;
3342: END IF;
3343: IF OE_Commitment_Pvt.DO_Commitment_Sequencing
3344: AND p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
3345: IF l_debug_level > 0 THEN
3346: oe_debug_pub.add( 'BUILD UPDATE STATEMENT WITH PROMISED COMMITMENT AMOUNT' , 1 ) ;
3347: END IF;
6269: p_x_interface_line_rec.Term_Id := p_line_rec.payment_term_id;
6270: END IF;
6271: /* END PREPAYMENT */
6272: Get_Qty_To_Invoice(p_line_rec, p_x_interface_line_rec.QUANTITY, x_result_code);
6273: IF OE_Commitment_Pvt.DO_Commitment_Sequencing THEN-- commitment sequencing functionality ON
6274: IF p_line_rec.commitment_id IS NOT NULL THEN
6275: Get_Commitment_Info(p_line_rec
6276: ,l_commitment_applied
6277: ,l_commitment_interfaced);
6281: END IF;
6282: Rounded_Amount(p_currency_code => p_x_interface_line_rec.currency_code
6283: ,p_unrounded_amount => (p_line_rec.unit_selling_price * p_x_interface_line_rec.quantity)
6284: ,x_rounded_amount => l_partial_line_amount);
6285: IF OE_COMMITMENT_PVT.Get_Allocate_Tax_Freight(p_line_rec) = 'Y' THEN
6286: l_fulfilled_qty := NVL(p_line_rec.fulfilled_quantity, NVL(p_line_rec.shipped_quantity, NVL(p_line_rec.ordered_quantity, 0)));
6287: l_partial_line_tax_amount := nvl(p_line_rec.tax_value * (p_x_interface_line_rec.QUANTITY/l_fulfilled_qty), 0);
6288: SELECT nvl(sum(charge_amount), 0)
6289: INTO l_partial_line_freight_amount
7639: IF l_debug_level > 0 THEN
7640: oe_debug_pub.add( 'RETURN STATUS : ' ||X_RETURN_STATUS ) ;
7641: END IF;
7642:
7643: IF OE_Commitment_Pvt.DO_Commitment_Sequencing THEN --commitment sequencing ON
7644: IF p_line_rec.commitment_id IS NOT NULL AND
7645: p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
7646: IF l_debug_level > 0 THEN
7647: oe_debug_pub.add( 'UPDATING OE_PAYMENTS' , 3 ) ;