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 742: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(abs(l_amount), hdr_rec.currency_code );

738: END IF;
739:
740: --dbms_output.put_line('Amount credited '|| l_amount);
741: IF (nvl(l_amount,0) > 0) THEN
742: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(abs(l_amount), hdr_rec.currency_code );
743: END IF;
744:
745: l_bslv_tbl_in(1).AMOUNT := -1 * (l_amount );
746: ELSE

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

762: -- l_amount := abs(bcl_rec.bsl_amount - abs(nvl(bcl_rec.line_existing_credit,0)));
763: --END IF;
764:
765: --rounded for bug # 2791940
766: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, hdr_rec.currency_code );
767: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;
768: --dbms_output.put_line('Amount credited after if'|| l_amount);
769:
770:

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

852:
853: --l_bclv_tbl_in(1).AMOUNT := (l_bclv_tbl_in(1).amount - nvl(l_amount,0));
854: --rounded for bug # 2791940
855: /*
856: l_bclv_tbl_in(1).AMOUNT := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
857: (nvl(l_bclv_tbl_in(1).amount,0) - nvl(abs(l_amount),0)),
858: hdr_rec.currency_code);
859: */
860:

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

1838:
1839:
1840: END LOOP;
1841: END IF;
1842: X_Amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(final_amount ,
1843: l_currency_code);
1844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1845: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount',
1846: 'Returning Credit amount X_Amount '||X_Amount);

Line 2500: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

2496: l_bslv_tbl_in(1).date_to_interface := get_term_end_date (bcl_rec.cle_id , p_term_date );
2497:
2498: IF (l_stat = G_REGULAR) THEN
2499: IF (p_term_amt is not null) THEN
2500: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
2501: ((p_term_amt * bsl_rec.amount)/
2502: p_con_termination_amount),p_currency_code);
2503: l_round_amt := l_amount;
2504: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;

Line 2524: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

2520: G_NONREGULAR,
2521: l_amount);
2522:
2523: IF (p_term_amt is not null) Then
2524: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
2525: ((p_term_amt * l_amount)/
2526: p_con_termination_amount),p_currency_code);
2527: l_round_amt := l_amount;
2528: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;

Line 2531: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

2527: l_round_amt := l_amount;
2528: l_bslv_tbl_in(1).AMOUNT := -1 * l_amount;
2529:
2530: ELSE
2531: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
2532: l_amount, p_currency_code );
2533: l_round_amt := l_amount;
2534: l_bslv_tbl_in(1).AMOUNT := -1 * (l_amount );
2535: END IF;

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

3784: l_amount := l_bslv_tbl_in(1).AMOUNT;
3785: Else
3786: --l_amount := p_termination_amount *(bsl_rec.amount/p_con_termination_amount);
3787: l_amount := l_amount_per_period;
3788: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, bcl_rec.currency_code);
3789: l_round_amount := l_round_amount + l_amount ;
3790: l_bslv_tbl_in(1).AMOUNT := -1* l_amount;
3791: l_amount := l_bslv_tbl_in(1).AMOUNT;
3792: End If;

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

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

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

3829: OPEN ship_amount_cur( p_line_id,l_termination_date);
3830: FETCH ship_amount_cur into l_ship_amount;
3831: CLOSE ship_amount_cur;
3832:
3833: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt( l_bill_amount - l_ship_amount,
3834: bcl_rec.currency_code) ;
3835: l_round_amount := l_round_amount + l_amount;
3836: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3837: ELSE

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

3834: bcl_rec.currency_code) ;
3835: l_round_amount := l_round_amount + l_amount;
3836: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3837: ELSE
3838: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(( p_termination_amount *
3839: bsl_rec.amount ) / p_con_termination_amount ,
3840: bcl_rec.currency_code);
3841: l_round_amount := l_round_amount + l_amount;
3842: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;

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

3842: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3843: END IF;
3844: ELSE
3845: IF (p_termination_amount is NULL) THEN
3846: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(( bsl_rec.amount -
3847: OKS_SUBSCRIPTION_PUB.subs_termn_amount
3848: ( p_cle_id =>p_line_id ,
3849: p_termn_date =>p_termination_date )),
3850: bcl_rec.currency_code) ;

Line 3854: l_amount:= OKS_EXTWAR_UTIL_PVT.round_currency_amt

3850: bcl_rec.currency_code) ;
3851: l_round_amount := l_round_amount + l_amount;
3852: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3853: ELSE
3854: l_amount:= OKS_EXTWAR_UTIL_PVT.round_currency_amt
3855: ((p_termination_amount *(( bsl_rec.amount - OKS_SUBSCRIPTION_PUB.subs_termn_amount
3856: ( p_cle_id =>p_line_id ,
3857: p_termn_date =>p_termination_date ))
3858: ))/

Line 6972: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

6968: * function added to round off the amount depending on the
6969: * precision set in fnd_currency -- Hari 08/03/2001
6970: **/
6971:
6972: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
6973: l_amount_holder,
6974: l_cur_holder );
6975:
6976:

Line 7454: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

7450: * function added to round off the amount depending on the
7451: * precision set in fnd_currency -- Hari 08/03/2001
7452: **/
7453:
7454: round_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
7455: l_amount_holder,
7456: l_cur_holder );
7457:
7458: -----END IF;---- for amount > 0

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

9400: ELSE
9401: l_overridden := 0;
9402: END IF;
9403:
9404: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);
9405:
9406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9407: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9408: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);

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

9440: Else
9441: l_tax_value := 0;
9442: End If;
9443:
9444: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,
9445: l_currency_code);
9446: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9447: l_currency_code);
9448: l_suppressed_credit :=

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

9442: End If;
9443:
9444: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,
9445: l_currency_code);
9446: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9447: l_currency_code);
9448: l_suppressed_credit :=
9449: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9450: l_currency_code);

Line 9449: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,

9445: l_currency_code);
9446: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9447: l_currency_code);
9448: l_suppressed_credit :=
9449: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9450: l_currency_code);
9451: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9452: l_currency_code);
9453:

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

9447: l_currency_code);
9448: l_suppressed_credit :=
9449: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9450: l_currency_code);
9451: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9452: l_currency_code);
9453:
9454: UPDATE OKS_K_LINES_B
9455: SET UBT_AMOUNT = l_ubt_amount ,

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

9564: ELSE
9565: l_overridden := 0;
9566: END IF;
9567:
9568: l_true_value :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,
9569: l_currency_code);
9570: UPDATE OKC_K_LINES_B
9571: SET price_negotiated = l_true_value
9572: WHERE id = l_top_line_rec.sub_line_id;

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

9603: If l_suppressed_credit < 0 then
9604: l_suppressed_credit := l_suppressed_credit * -1 ;
9605: End if;
9606:
9607: l_ubt_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
9608: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9609: l_currency_code);
9610: l_suppressed_credit :=
9611: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,

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

9604: l_suppressed_credit := l_suppressed_credit * -1 ;
9605: End if;
9606:
9607: l_ubt_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
9608: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9609: l_currency_code);
9610: l_suppressed_credit :=
9611: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9612: l_currency_code);

Line 9611: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,

9607: l_ubt_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
9608: l_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_credit,
9609: l_currency_code);
9610: l_suppressed_credit :=
9611: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9612: l_currency_code);
9613: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9614: l_currency_code);
9615:

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

9609: l_currency_code);
9610: l_suppressed_credit :=
9611: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_suppressed_credit,
9612: l_currency_code);
9613: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9614: l_currency_code);
9615:
9616: UPDATE OKS_K_LINES_B
9617: SET UBT_AMOUNT = l_ubt_amount ,

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

9637: WHERE cle_id = l_top_line_id
9638: AND date_cancelled is null) --LLC BUG FIX 4742661
9639: WHERE id = p_true_value_tbl(1).p_top_line_id ;
9640:
9641: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9642: l_currency_code);
9643: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9644: l_currency_code);
9645: l_tot_suppressed_credit :=

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

9639: WHERE id = p_true_value_tbl(1).p_top_line_id ;
9640:
9641: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9642: l_currency_code);
9643: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9644: l_currency_code);
9645: l_tot_suppressed_credit :=
9646: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9647: l_currency_code);

Line 9646: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,

9642: l_currency_code);
9643: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9644: l_currency_code);
9645: l_tot_suppressed_credit :=
9646: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9647: l_currency_code);
9648: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9649: l_currency_code);
9650:

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

9644: l_currency_code);
9645: l_tot_suppressed_credit :=
9646: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9647: l_currency_code);
9648: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9649: l_currency_code);
9650:
9651: open l_check_for_full_credit(p_true_value_tbl(1).p_top_line_id);
9652: fetch l_check_for_full_credit into l_full_count;

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

9701:
9702: l_tot_overridden :=p_true_value_tbl(1).p_con_terminate_amount -
9703: nvl(l_tot_credit,0) - nvl(l_tot_suppressed_credit,0);
9704:
9705: l_tot_true_value:=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_true_value,
9706: l_currency_code);
9707: UPDATE OKC_K_LINES_B
9708: SET price_negotiated = l_tot_true_value
9709: WHERE id = p_true_value_tbl(1).p_top_line_id;

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

9732: l_tax_value := 0 ;
9733: l_tot_tax_value := nvl(l_tax_value,0) + l_tot_tax_value;
9734: End If;
9735:
9736: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9737: l_currency_code);
9738: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9739: l_currency_code);
9740: l_tot_suppressed_credit :=

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

9734: End If;
9735:
9736: l_tot_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_ubt_amount,
9737: l_currency_code);
9738: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9739: l_currency_code);
9740: l_tot_suppressed_credit :=
9741: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9742: l_currency_code);

Line 9741: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,

9737: l_currency_code);
9738: l_tot_credit := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_credit,
9739: l_currency_code);
9740: l_tot_suppressed_credit :=
9741: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9742: l_currency_code);
9743: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9744: l_currency_code);
9745:

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

9739: l_currency_code);
9740: l_tot_suppressed_credit :=
9741: OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_suppressed_credit,
9742: l_currency_code);
9743: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9744: l_currency_code);
9745:
9746:
9747: UPDATE OKS_K_LINES_B

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

9819: BEGIN
9820: l_running_total := 0;
9821: FOR cur in price_break_csr(p_bsl_id)
9822: LOOP
9823: l_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(((p_tot_amount * cur.amount) / p_break_amount),cur.currency_code);
9824: l_unit_price := round((l_amount / cur.quantity) ,29);
9825:
9826: l_running_total := l_running_total + l_amount;
9827: l_id := cur.id;

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

9834: END LOOP;
9835:
9836: IF ( l_running_total <> P_TOT_AMOUNT) THEN
9837: UPDATE oks_price_breaks
9838: SET amount = OKS_EXTWAR_UTIL_PVT.round_currency_amt(amount + (P_TOT_AMOUNT - l_running_total),l_currency_code),
9839: unit_price = round((amount + (P_TOT_AMOUNT - l_running_total)) / quantity,29)
9840: WHERE id = l_id;
9841: END IF;
9842: END prorate_price_breaks ;

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

10169: ELSE
10170: l_ubt_amount := cur.total_amount - l_new_price;
10171: END IF;
10172:
10173: l_new_price := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_new_price,l_currency_code);
10174: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
10175:
10176: UPDATE OKC_K_LINES_B
10177: SET price_negotiated = l_new_price

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

10170: l_ubt_amount := cur.total_amount - l_new_price;
10171: END IF;
10172:
10173: l_new_price := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_new_price,l_currency_code);
10174: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
10175:
10176: UPDATE OKC_K_LINES_B
10177: SET price_negotiated = l_new_price
10178: WHERE id = cur.id;