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.OKS_BILL_REC_PUB dependencies on OKS_EXTWAR_UTIL_PVT

Line 761: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(abs(l_amount), hdr_rec.currency_code );

757: END IF;
758:
759: --dbms_output.put_line('Amount credited '|| l_amount);
760: IF (nvl(l_amount,0) > 0) THEN
761: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(abs(l_amount), hdr_rec.currency_code );
762: END IF;
763:
764: l_bslv_tbl_in(1).AMOUNT := -1 * (l_amount );
765: ELSE

Line 785: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, hdr_rec.currency_code );

781: -- l_amount := abs(bcl_rec.bsl_amount - abs(nvl(bcl_rec.line_existing_credit,0)));
782: --END IF;
783:
784: --rounded for bug # 2791940
785: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, hdr_rec.currency_code );
786: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;
787: --dbms_output.put_line('Amount credited after if'|| l_amount);
788:
789:

Line 875: l_bclv_tbl_in(1).AMOUNT := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

871:
872: --l_bclv_tbl_in(1).AMOUNT := (l_bclv_tbl_in(1).amount - nvl(l_amount,0));
873: --rounded for bug # 2791940
874: /*
875: l_bclv_tbl_in(1).AMOUNT := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
876: (nvl(l_bclv_tbl_in(1).amount,0) - nvl(abs(l_amount),0)),
877: hdr_rec.currency_code);
878: */
879:

Line 1856: X_Amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(final_amount ,

1852:
1853:
1854: END LOOP;
1855: END IF;
1856: X_Amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(final_amount ,
1857: l_currency_code);
1858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1859: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount',
1860: 'Returning Credit amount X_Amount '||X_Amount);

Line 2514: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

2510: l_bslv_tbl_in(1).date_to_interface := get_term_end_date (bcl_rec.cle_id , p_term_date );
2511:
2512: IF (l_stat = G_REGULAR) THEN
2513: IF (p_term_amt is not null) THEN
2514: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
2515: ((p_term_amt * bsl_rec.amount)/
2516: p_con_termination_amount),p_currency_code);
2517: l_round_amt := l_amount;
2518: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;

Line 2538: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

2534: G_NONREGULAR,
2535: l_amount);
2536:
2537: IF (p_term_amt is not null) Then
2538: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
2539: ((p_term_amt * l_amount)/
2540: p_con_termination_amount),p_currency_code);
2541: l_round_amt := l_amount;
2542: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;

Line 2545: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

2541: l_round_amt := l_amount;
2542: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;
2543:
2544: ELSE
2545: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
2546: l_amount, p_currency_code );
2547: l_round_amt := l_amount;
2548: l_bslv_tbl_in(1).AMOUNT := -1 * (l_amount );
2549: END IF;

Line 3814: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, bcl_rec.currency_code);

3810: l_amount := l_bslv_tbl_in(1).AMOUNT;
3811: Else
3812: --l_amount := p_termination_amount *(bsl_rec.amount/p_con_termination_amount);
3813: l_amount := l_amount_per_period;
3814: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, bcl_rec.currency_code);
3815: l_round_amount := l_round_amount + l_amount ;
3816: l_bslv_tbl_in(1).AMOUNT := -1* l_amount;
3817: l_amount := l_bslv_tbl_in(1).AMOUNT;
3818: End If;

Line 3837: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, bcl_rec.currency_code);

3833: End If;
3834: Else
3835: --l_amount := p_termination_amount *(bsl_rec.amount/p_con_termination_amount);
3836: l_amount := l_amount_per_period;
3837: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, bcl_rec.currency_code);
3838: --l_termination_amount := l_termination_amount - l_amount ;
3839: l_con_termination_amount := l_con_termination_amount - l_amount ;
3840: l_round_amount := l_round_amount + l_amount ;
3841: l_bslv_tbl_in(1).AMOUNT := -1* l_amount;

Line 3859: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt( l_bill_amount - l_ship_amount,

3855: OPEN ship_amount_cur( p_line_id,l_termination_date);
3856: FETCH ship_amount_cur into l_ship_amount;
3857: CLOSE ship_amount_cur;
3858:
3859: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt( l_bill_amount - l_ship_amount,
3860: bcl_rec.currency_code) ;
3861: l_round_amount := l_round_amount + l_amount;
3862: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3863: ELSE

Line 3864: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(( p_termination_amount *

3860: bcl_rec.currency_code) ;
3861: l_round_amount := l_round_amount + l_amount;
3862: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3863: ELSE
3864: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(( p_termination_amount *
3865: bsl_rec.amount ) / p_con_termination_amount ,
3866: bcl_rec.currency_code);
3867: l_round_amount := l_round_amount + l_amount;
3868: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;

Line 3872: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(( bsl_rec.amount -

3868: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3869: END IF;
3870: ELSE
3871: IF (p_termination_amount is NULL) THEN
3872: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(( bsl_rec.amount -
3873: OKS_SUBSCRIPTION_PUB.subs_termn_amount
3874: ( p_cle_id =>p_line_id ,
3875: p_termn_date =>p_termination_date )),
3876: bcl_rec.currency_code) ;

Line 3880: l_amount:= OKS_EXTWAR_UTIL_PVT.round_currency_amt

3876: bcl_rec.currency_code) ;
3877: l_round_amount := l_round_amount + l_amount;
3878: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3879: ELSE
3880: l_amount:= OKS_EXTWAR_UTIL_PVT.round_currency_amt
3881: ((p_termination_amount *(( bsl_rec.amount - OKS_SUBSCRIPTION_PUB.subs_termn_amount
3882: ( p_cle_id =>p_line_id ,
3883: p_termn_date =>p_termination_date ))
3884: ))/

Line 7004: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

7000: * function added to round off the amount depending on the
7001: * precision set in fnd_currency -- Hari 08/03/2001
7002: **/
7003:
7004: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
7005: l_amount_holder,
7006: l_cur_holder );
7007:
7008:

Line 7486: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

7482: * function added to round off the amount depending on the
7483: * precision set in fnd_currency -- Hari 08/03/2001
7484: **/
7485:
7486: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
7487: l_amount_holder,
7488: l_cur_holder );
7489:
7490: -----END IF;---- for amount > 0

Line 9456: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);

9452: ELSE
9453: l_overridden := 0;
9454: END IF;
9455:
9456: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);
9457:
9458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9459: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9460: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);

Line 9506: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,

9502: Else
9503: l_tax_value := 0;
9504: End If;
9505:
9506: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,
9507: l_currency_code);
9508: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9509: l_currency_code);
9510: l_suppressed_credit :=

Line 9508: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,

9504: End If;
9505:
9506: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,
9507: l_currency_code);
9508: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9509: l_currency_code);
9510: l_suppressed_credit :=
9511: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9512: l_currency_code);

Line 9511: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,

9507: l_currency_code);
9508: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9509: l_currency_code);
9510: l_suppressed_credit :=
9511: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9512: l_currency_code);
9513: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9514: l_currency_code);
9515:

Line 9513: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,

9509: l_currency_code);
9510: l_suppressed_credit :=
9511: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9512: l_currency_code);
9513: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9514: l_currency_code);
9515:
9516: UPDATE OKS_K_LINES_B
9517: SET UBT_AMOUNT = l_ubt_amount ,

Line 9638: l_true_value :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,

9634: ELSE
9635: l_overridden := 0;
9636: END IF;
9637:
9638: l_true_value :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,
9639: l_currency_code);
9640: UPDATE OKC_K_LINES_B
9641: SET price_negotiated = l_true_value
9642: WHERE id = l_top_line_rec.sub_line_id;

Line 9686: l_ubt_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);

9682: If l_suppressed_credit < 0 OR l_bill_amt < 0 then --Added the condition l_original_amt for bug 11773025
9683: l_suppressed_credit := l_suppressed_credit * -1 ;
9684: End if;
9685:
9686: l_ubt_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
9687: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9688: l_currency_code);
9689: l_suppressed_credit :=
9690: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,

Line 9687: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,

9683: l_suppressed_credit := l_suppressed_credit * -1 ;
9684: End if;
9685:
9686: l_ubt_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
9687: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9688: l_currency_code);
9689: l_suppressed_credit :=
9690: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9691: l_currency_code);

Line 9690: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,

9686: l_ubt_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
9687: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9688: l_currency_code);
9689: l_suppressed_credit :=
9690: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9691: l_currency_code);
9692: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9693: l_currency_code);
9694:

Line 9692: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,

9688: l_currency_code);
9689: l_suppressed_credit :=
9690: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9691: l_currency_code);
9692: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9693: l_currency_code);
9694:
9695: UPDATE OKS_K_LINES_B
9696: SET UBT_AMOUNT = l_ubt_amount ,

Line 9720: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,

9716: WHERE cle_id = l_top_line_id
9717: AND date_cancelled is null) --LLC BUG FIX 4742661
9718: WHERE id = p_true_value_tbl(1).p_top_line_id ;
9719:
9720: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9721: l_currency_code);
9722: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9723: l_currency_code);
9724: l_tot_suppressed_credit :=

Line 9722: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,

9718: WHERE id = p_true_value_tbl(1).p_top_line_id ;
9719:
9720: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9721: l_currency_code);
9722: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9723: l_currency_code);
9724: l_tot_suppressed_credit :=
9725: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9726: l_currency_code);

Line 9725: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,

9721: l_currency_code);
9722: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9723: l_currency_code);
9724: l_tot_suppressed_credit :=
9725: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9726: l_currency_code);
9727: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9728: l_currency_code);
9729:

Line 9727: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,

9723: l_currency_code);
9724: l_tot_suppressed_credit :=
9725: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9726: l_currency_code);
9727: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9728: l_currency_code);
9729:
9730: open l_check_for_full_credit(p_true_value_tbl(1).p_top_line_id);
9731: fetch l_check_for_full_credit into l_full_count;

Line 9784: l_tot_true_value:=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_true_value,

9780:
9781: l_tot_overridden :=p_true_value_tbl(1).p_con_terminate_amount -
9782: nvl(l_tot_credit,0) - nvl(l_tot_suppressed_credit,0);
9783:
9784: l_tot_true_value:=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_true_value,
9785: l_currency_code);
9786: UPDATE OKC_K_LINES_B
9787: SET price_negotiated = l_tot_true_value
9788: WHERE id = p_true_value_tbl(1).p_top_line_id;

Line 9823: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,

9819: l_tax_value := 0 ;
9820: l_tot_tax_value := nvl(l_tax_value,0) + l_tot_tax_value;
9821: End If;
9822:
9823: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9824: l_currency_code);
9825: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9826: l_currency_code);
9827: l_tot_suppressed_credit :=

Line 9825: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,

9821: End If;
9822:
9823: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9824: l_currency_code);
9825: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9826: l_currency_code);
9827: l_tot_suppressed_credit :=
9828: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9829: l_currency_code);

Line 9828: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,

9824: l_currency_code);
9825: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9826: l_currency_code);
9827: l_tot_suppressed_credit :=
9828: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9829: l_currency_code);
9830: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9831: l_currency_code);
9832:

Line 9830: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,

9826: l_currency_code);
9827: l_tot_suppressed_credit :=
9828: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9829: l_currency_code);
9830: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9831: l_currency_code);
9832:
9833:
9834: UPDATE OKS_K_LINES_B

Line 9913: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(((p_tot_amount * cur.amount) / p_break_amount),cur.currency_code);

9909: BEGIN
9910: l_running_total := 0;
9911: FOR cur in price_break_csr(p_bsl_id)
9912: LOOP
9913: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(((p_tot_amount * cur.amount) / p_break_amount),cur.currency_code);
9914: l_unit_price := round((l_amount / cur.quantity) ,29);
9915:
9916: l_running_total := l_running_total + l_amount;
9917: l_id := cur.id;

Line 9928: SET amount = OKS_EXTWAR_UTIL_PVT.round_currency_amt(amount + (P_TOT_AMOUNT - l_running_total),l_currency_code),

9924: END LOOP;
9925:
9926: IF ( l_running_total <> P_TOT_AMOUNT) THEN
9927: UPDATE oks_price_breaks
9928: SET amount = OKS_EXTWAR_UTIL_PVT.round_currency_amt(amount + (P_TOT_AMOUNT - l_running_total),l_currency_code),
9929: unit_price = round((amount + (P_TOT_AMOUNT - l_running_total)) / quantity,29)
9930: WHERE id = l_id;
9931: END IF;
9932: END prorate_price_breaks ;

Line 10265: l_new_price := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_new_price,l_currency_code);

10261: ELSE
10262: l_ubt_amount := cur.total_amount - l_new_price;
10263: END IF;
10264:
10265: l_new_price := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_new_price,l_currency_code);
10266: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
10267:
10268: UPDATE OKC_K_LINES_B
10269: SET price_negotiated = l_new_price

Line 10266: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);

10262: l_ubt_amount := cur.total_amount - l_new_price;
10263: END IF;
10264:
10265: l_new_price := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_new_price,l_currency_code);
10266: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
10267:
10268: UPDATE OKC_K_LINES_B
10269: SET price_negotiated = l_new_price
10270: WHERE id = cur.id;

Line 10296: l_credit_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit_amount,l_currency_code);

10292: ' l_credit_amount '||l_credit_amount);
10293: END IF;
10294:
10295: /*Added for bug 14250216 */
10296: l_credit_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit_amount,l_currency_code);
10297: /*Added for bug 14250216 */
10298:
10299: --Loop through All the sublines and tie the credit amount
10300: --starting from the last billed period upwards.