eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PREPAYMENT_PVT dependencies on OE_ORDER_UTIL

Line 27: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --
25: BEGIN
26:
27: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
28: OE_ORDER_UTIL.G_Precision:=2;
29: END IF;
30:
31: -- Select the Tax Total and Outbound Extended Price

Line 28: OE_ORDER_UTIL.G_Precision:=2;

24: --
25: BEGIN
26:
27: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
28: OE_ORDER_UTIL.G_Precision:=2;
29: END IF;
30:
31: -- Select the Tax Total and Outbound Extended Price
32: SELECT

Line 33: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))

29: END IF;
30:
31: -- Select the Tax Total and Outbound Extended Price
32: SELECT
33: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))
34: , SUM(ROUND(nvl(ool.Ordered_Quantity,0)
35: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
36: INTO
37: l_tax_total

Line 35: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))

31: -- Select the Tax Total and Outbound Extended Price
32: SELECT
33: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))
34: , SUM(ROUND(nvl(ool.Ordered_Quantity,0)
35: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
36: INTO
37: l_tax_total
38: , l_order_total
39: FROM oe_order_lines_all ool

Line 55: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0), OE_ORDER_UTIL.G_Precision))

51: OR mti.invoice_enabled_flag = 'N'));
52:
53: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
54: -- Select the committment applied amount if Commitment Sequencing "On"
55: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0), OE_ORDER_UTIL.G_Precision))
56: INTO l_commitment_total
57: FROM oe_payments op
58: WHERE op.header_id = p_header_id
59: AND NOT EXISTS

Line 70: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))

66: AND (mti.invoiceable_item_flag = 'N'
67: OR mti.invoice_enabled_flag = 'N'));
68: ELSE
69: -- Select the Outbound Extended Price for lines that have committment
70: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
71: INTO l_commitment_total
72: FROM oe_order_lines_all ool
73: WHERE ool.header_id = p_header_id
74: AND ool.commitment_id is not null

Line 91: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND), OE_ORDER_UTIL.G_Precision

87:
88: -- Select the Outbound Charges Total
89: SELECT SUM(
90: ROUND(
91: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND), OE_ORDER_UTIL.G_Precision
92: )
93: )
94: INTO l_chgs_wo_line_id
95: FROM OE_PRICE_ADJUSTMENTS P

Line 112: ,OE_ORDER_UTIL.G_Precision

108: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
109: P.OPERAND,
110: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
111: )
112: ,OE_ORDER_UTIL.G_Precision
113: )
114: )
115: INTO l_chgs_w_line_id
116: FROM OE_PRICE_ADJUSTMENTS P,

Line 3774: OE_ORDER_UTIL.Update_Global_Picture

3770:
3771: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3772:
3773: -- call notification framework to get header index position
3774: OE_ORDER_UTIL.Update_Global_Picture
3775: (p_Upd_New_Rec_If_Exists =>FALSE
3776: , p_header_rec => l_header_rec
3777: , p_old_header_rec => l_old_header_rec
3778: , p_header_id => l_header_rec.header_id

Line 3788: OE_ORDER_UTIL.g_header_rec.payment_type_code:=

3784:
3785: IF l_index is not null then
3786: -- modify Global Picture
3787:
3788: OE_ORDER_UTIL.g_header_rec.payment_type_code:=
3789: l_header_rec.payment_type_code;
3790: OE_ORDER_UTIL.g_header_rec.payment_amount:=
3791: l_header_rec.payment_amount;
3792: OE_ORDER_UTIL.g_header_rec.check_number:=

Line 3790: OE_ORDER_UTIL.g_header_rec.payment_amount:=

3786: -- modify Global Picture
3787:
3788: OE_ORDER_UTIL.g_header_rec.payment_type_code:=
3789: l_header_rec.payment_type_code;
3790: OE_ORDER_UTIL.g_header_rec.payment_amount:=
3791: l_header_rec.payment_amount;
3792: OE_ORDER_UTIL.g_header_rec.check_number:=
3793: l_header_rec.check_number;
3794: OE_ORDER_UTIL.g_header_rec.credit_card_code:=

Line 3792: OE_ORDER_UTIL.g_header_rec.check_number:=

3788: OE_ORDER_UTIL.g_header_rec.payment_type_code:=
3789: l_header_rec.payment_type_code;
3790: OE_ORDER_UTIL.g_header_rec.payment_amount:=
3791: l_header_rec.payment_amount;
3792: OE_ORDER_UTIL.g_header_rec.check_number:=
3793: l_header_rec.check_number;
3794: OE_ORDER_UTIL.g_header_rec.credit_card_code:=
3795: l_header_rec.credit_card_code;
3796: OE_ORDER_UTIL.g_header_rec.credit_card_holder_name:=

Line 3794: OE_ORDER_UTIL.g_header_rec.credit_card_code:=

3790: OE_ORDER_UTIL.g_header_rec.payment_amount:=
3791: l_header_rec.payment_amount;
3792: OE_ORDER_UTIL.g_header_rec.check_number:=
3793: l_header_rec.check_number;
3794: OE_ORDER_UTIL.g_header_rec.credit_card_code:=
3795: l_header_rec.credit_card_code;
3796: OE_ORDER_UTIL.g_header_rec.credit_card_holder_name:=
3797: l_header_rec.credit_card_holder_name;
3798: OE_ORDER_UTIL.g_header_rec.credit_card_number:=

Line 3796: OE_ORDER_UTIL.g_header_rec.credit_card_holder_name:=

3792: OE_ORDER_UTIL.g_header_rec.check_number:=
3793: l_header_rec.check_number;
3794: OE_ORDER_UTIL.g_header_rec.credit_card_code:=
3795: l_header_rec.credit_card_code;
3796: OE_ORDER_UTIL.g_header_rec.credit_card_holder_name:=
3797: l_header_rec.credit_card_holder_name;
3798: OE_ORDER_UTIL.g_header_rec.credit_card_number:=
3799: l_header_rec.credit_card_number;
3800: OE_ORDER_UTIL.g_header_rec.credit_card_expiration_date:=

Line 3798: OE_ORDER_UTIL.g_header_rec.credit_card_number:=

3794: OE_ORDER_UTIL.g_header_rec.credit_card_code:=
3795: l_header_rec.credit_card_code;
3796: OE_ORDER_UTIL.g_header_rec.credit_card_holder_name:=
3797: l_header_rec.credit_card_holder_name;
3798: OE_ORDER_UTIL.g_header_rec.credit_card_number:=
3799: l_header_rec.credit_card_number;
3800: OE_ORDER_UTIL.g_header_rec.credit_card_expiration_date:=
3801: l_header_rec.credit_card_expiration_date;
3802: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=

Line 3800: OE_ORDER_UTIL.g_header_rec.credit_card_expiration_date:=

3796: OE_ORDER_UTIL.g_header_rec.credit_card_holder_name:=
3797: l_header_rec.credit_card_holder_name;
3798: OE_ORDER_UTIL.g_header_rec.credit_card_number:=
3799: l_header_rec.credit_card_number;
3800: OE_ORDER_UTIL.g_header_rec.credit_card_expiration_date:=
3801: l_header_rec.credit_card_expiration_date;
3802: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
3803: l_header_rec.credit_card_approval_code;
3804: OE_ORDER_UTIL.g_header_rec.lock_control:=

Line 3802: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=

3798: OE_ORDER_UTIL.g_header_rec.credit_card_number:=
3799: l_header_rec.credit_card_number;
3800: OE_ORDER_UTIL.g_header_rec.credit_card_expiration_date:=
3801: l_header_rec.credit_card_expiration_date;
3802: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
3803: l_header_rec.credit_card_approval_code;
3804: OE_ORDER_UTIL.g_header_rec.lock_control:=
3805: l_header_rec.lock_control;
3806:

Line 3804: OE_ORDER_UTIL.g_header_rec.lock_control:=

3800: OE_ORDER_UTIL.g_header_rec.credit_card_expiration_date:=
3801: l_header_rec.credit_card_expiration_date;
3802: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
3803: l_header_rec.credit_card_approval_code;
3804: OE_ORDER_UTIL.g_header_rec.lock_control:=
3805: l_header_rec.lock_control;
3806:
3807: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3808: RAISE FND_API.G_EXC_ERROR;

Line 4842: l_pr_return_value := OE_ORDER_UTIL.Get_Precision(p_currency_code);

4838: END IF;
4839:
4840: x_return_status := FND_API.G_RET_STS_SUCCESS;
4841:
4842: l_pr_return_value := OE_ORDER_UTIL.Get_Precision(p_currency_code);
4843:
4844:
4845: FOR i IN p_x_due_now_total_detail_tbl.FIRST.. p_x_due_now_total_detail_tbl.LAST LOOP
4846:

Line 4851: l_due_now_st_rnd := ROUND(nvl(l_due_now_subtotal,0), OE_ORDER_UTIL.G_Precision);

4847: OPEN due_now_cur(p_x_due_now_total_detail_tbl(i).term_id);
4848: FETCH due_now_cur INTO l_installment_option, l_percent;
4849: IF l_installment_option = 'ALLOCATE' THEN
4850: l_due_now_subtotal := p_x_due_now_total_detail_tbl(i).line_amount * l_percent;
4851: l_due_now_st_rnd := ROUND(nvl(l_due_now_subtotal,0), OE_ORDER_UTIL.G_Precision);
4852: l_due_now_tax := p_x_due_now_total_detail_tbl(i).tax_amount * l_percent;
4853: l_due_now_tax_rnd := ROUND(nvl(l_due_now_tax,0), OE_ORDER_UTIL.G_Precision);
4854: l_due_now_charges := p_x_due_now_total_detail_tbl(i).freight_amount * l_percent;
4855: l_due_now_chgs_rnd := ROUND(nvl(l_due_now_charges,0), OE_ORDER_UTIL.G_Precision);

Line 4853: l_due_now_tax_rnd := ROUND(nvl(l_due_now_tax,0), OE_ORDER_UTIL.G_Precision);

4849: IF l_installment_option = 'ALLOCATE' THEN
4850: l_due_now_subtotal := p_x_due_now_total_detail_tbl(i).line_amount * l_percent;
4851: l_due_now_st_rnd := ROUND(nvl(l_due_now_subtotal,0), OE_ORDER_UTIL.G_Precision);
4852: l_due_now_tax := p_x_due_now_total_detail_tbl(i).tax_amount * l_percent;
4853: l_due_now_tax_rnd := ROUND(nvl(l_due_now_tax,0), OE_ORDER_UTIL.G_Precision);
4854: l_due_now_charges := p_x_due_now_total_detail_tbl(i).freight_amount * l_percent;
4855: l_due_now_chgs_rnd := ROUND(nvl(l_due_now_charges,0), OE_ORDER_UTIL.G_Precision);
4856: l_due_now_total := l_due_now_st_rnd + l_due_now_tax_rnd + l_due_now_chgs_rnd;
4857:

Line 4855: l_due_now_chgs_rnd := ROUND(nvl(l_due_now_charges,0), OE_ORDER_UTIL.G_Precision);

4851: l_due_now_st_rnd := ROUND(nvl(l_due_now_subtotal,0), OE_ORDER_UTIL.G_Precision);
4852: l_due_now_tax := p_x_due_now_total_detail_tbl(i).tax_amount * l_percent;
4853: l_due_now_tax_rnd := ROUND(nvl(l_due_now_tax,0), OE_ORDER_UTIL.G_Precision);
4854: l_due_now_charges := p_x_due_now_total_detail_tbl(i).freight_amount * l_percent;
4855: l_due_now_chgs_rnd := ROUND(nvl(l_due_now_charges,0), OE_ORDER_UTIL.G_Precision);
4856: l_due_now_total := l_due_now_st_rnd + l_due_now_tax_rnd + l_due_now_chgs_rnd;
4857:
4858: ELSIF l_installment_option = 'INCLUDE' THEN
4859: l_due_now_subtotal := p_x_due_now_total_detail_tbl(i).line_amount* l_percent;

Line 4860: l_due_now_st_rnd := ROUND(nvl(l_due_now_subtotal,0), OE_ORDER_UTIL.G_Precision);

4856: l_due_now_total := l_due_now_st_rnd + l_due_now_tax_rnd + l_due_now_chgs_rnd;
4857:
4858: ELSIF l_installment_option = 'INCLUDE' THEN
4859: l_due_now_subtotal := p_x_due_now_total_detail_tbl(i).line_amount* l_percent;
4860: l_due_now_st_rnd := ROUND(nvl(l_due_now_subtotal,0), OE_ORDER_UTIL.G_Precision);
4861: l_due_now_tax := p_x_due_now_total_detail_tbl(i).tax_amount;
4862: l_due_now_charges := p_x_due_now_total_detail_tbl(i).freight_amount;
4863: l_due_now_total := l_due_now_st_rnd + l_due_now_tax + l_due_now_charges;
4864: END IF;