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_SCH dependencies on OKS_EXTWAR_UTIL_PVT

Line 2031: l_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, l_currency_code);

2027: ELSE
2028: l_amount := (l_line_amt * p_strm_lvl_tbl(l_tbl_count).level_amount)/l_tot_amt;
2029: END IF;
2030:
2031: l_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, l_currency_code);
2032:
2033: ELSE ---caled for header or top ine in case of not hdr billing.
2034: l_sll_amount := p_strm_lvl_tbl(l_tbl_count).level_amount;
2035: END IF;

Line 2068: l_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, l_currency_code);

2064: ELSE
2065: l_amount := (p_SubLine_amt * p_strm_lvl_tbl(l_tbl_count).level_amount)/l_tot_amt;
2066: END IF;
2067:
2068: l_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_amount, l_currency_code);
2069: END IF;
2070:
2071: IF l_header_billing IS NOT NULL AND p_subline_call <> 'H' THEN
2072: l_sll_id := NULL;

Line 3039: l_round_level_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvlelement_amt, l_currency_code );

3035: Close l_tot_amt_csr;
3036:
3037:
3038:
3039: l_round_level_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvlelement_amt, l_currency_code );
3040: l_round_cycle_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(p_cycle_amt, l_currency_code );
3041:
3042: IF p_total_amt <> l_round_level_amt + l_round_cycle_amt THEN
3043: l_adjusted_amount := p_total_amt - l_round_level_amt;

Line 3040: l_round_cycle_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(p_cycle_amt, l_currency_code );

3036:
3037:
3038:
3039: l_round_level_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvlelement_amt, l_currency_code );
3040: l_round_cycle_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(p_cycle_amt, l_currency_code );
3041:
3042: IF p_total_amt <> l_round_level_amt + l_round_cycle_amt THEN
3043: l_adjusted_amount := p_total_amt - l_round_level_amt;
3044: ELSE

Line 3540: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_adjusted_amount,l_currency_code );

3536:
3537: IF p_Line_rec.chr_id IS NOT NULL THEN --top line
3538: l_lvl_ele_tbl_in(l_tbl_seq).amount := NULL;
3539: ELSE ----cp level
3540: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_adjusted_amount,l_currency_code );
3541: END IF;
3542:
3543: ELSE ----for billing type = p and lse_id = 46
3544:

Line 3545: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_adjusted_amount,l_currency_code );

3541: END IF;
3542:
3543: ELSE ----for billing type = p and lse_id = 46
3544:
3545: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_adjusted_amount,l_currency_code );
3546: END IF;
3547:
3548:
3549: l_lvl_ele_tbl_in(l_tbl_seq).date_receivable_gl := l_fnd_lvl_out_rec.date_recievable_gl;

Line 3870: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_cycle_amt,l_currency_code );

3866:
3867: ELSE ----for E
3868:
3869: l_cycle_amt := TO_NUMBER(p_sll_tbl(l_sll_counter).amount);
3870: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_cycle_amt,l_currency_code );
3871: END IF;
3872:
3873:
3874: l_lvl_ele_tbl_in(l_tbl_seq).date_receivable_gl := l_fnd_lvl_out_rec.date_recievable_gl;

Line 4168: l_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt, l_currency_code);

4164:
4165: IF l_Line_Sll_Csr_Rec.level_amount IS NOT NULL THEN ---------calculate total sll amount
4166:
4167: l_sll_amt := (l_Line_Sll_Csr_Rec.level_amount * l_Line_Sll_Csr_Rec.level_periods);
4168: l_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt, l_currency_code);
4169: l_used_amt := l_used_amt + l_sll_amt;
4170:
4171: -----errorout_ad('sll amount = ' || to_char(l_sll_amt));
4172: -----errorout_ad('total used amount = ' || to_char(l_used_amt));

Line 4255: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

4251:
4252: -----errorout_ad('sll index = '|| to_char(l_sll_index));
4253: -----errorout_ad('sll amount returned = '|| to_char(l_sll_prorate_tbl(l_amt_counter).sll_amount));
4254:
4255: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
4256: l_sll_prorate_tbl(l_amt_counter).sll_amount, l_currency_code);
4257:
4258: l_strm_lvl_tbl_in(l_sll_index).level_amount := l_period_sll_amount;
4259:

Line 4448: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);

4444: l_sll_period := l_curr_frequency/l_uom_per_period;
4445:
4446: l_period_sll_amt := ( l_sll_remain_amount /( nvl(l_tot_frequency,1) * nvl(l_sll_period,1))) * nvl(l_curr_frequency,0) ;
4447:
4448: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4449:
4450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4451: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4452: ' result l_period_sll_amt '||l_period_sll_amt);

Line 4523: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);

4519:
4520:
4521: l_period_sll_amt := ( l_sll_remain_amount /( nvl(l_tot_frequency,1) * nvl(l_sll_period,1))) * nvl(l_curr_frequency,0) ;
4522:
4523: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4524:
4525: l_sll_remain_amount := l_sll_remain_amount - (l_period_sll_amt * nvl(l_sll_period,1)) ;
4526: --errorout_ad('l_period_sll_amt '||l_period_sll_amt);
4527: --errorout_ad('l_sll_remain_amount '||l_sll_remain_amount);

Line 4753: l_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt, l_currency_code);

4749:
4750: IF l_Sll_Csr_Rec.level_amount IS NOT NULL THEN ---------calculate total all amount
4751:
4752: l_sll_amt := to_number(l_Sll_Csr_Rec.level_amount) * to_number(l_Sll_Csr_Rec.level_periods);
4753: l_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt, l_currency_code);
4754: l_used_amt := l_used_amt + l_sll_amt;
4755:
4756: -----errorout_ad('sll amount = ' || to_char(l_sll_amt));
4757: -----errorout_ad('total used amount = ' || to_char(l_used_amt));

Line 4843: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

4839:
4840: -----errorout_ad('sll index = '|| to_char(l_sll_index));
4841: -----errorout_ad('sll amount returned = '|| to_char(l_sll_prorate_tbl(l_amt_counter).sll_amount));
4842:
4843: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
4844: l_sll_prorate_tbl(l_amt_counter).sll_amount, l_currency_code);
4845:
4846: l_strm_lvl_tbl_in(l_sll_index).level_amount := TO_CHAR(l_period_sll_amount);
4847:

Line 8466: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_constant_sll_amt,l_currency_code );

8462:
8463:
8464: IF l_bill_type = 'T' then
8465: --calculated sll amount
8466: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_constant_sll_amt,l_currency_code );
8467:
8468: ELSE ----for E and P
8469: ---sll amt entered by user
8470:

Line 8472: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt,l_currency_code );

8468: ELSE ----for E and P
8469: ---sll amt entered by user
8470:
8471: l_sll_amt := TO_NUMBER(p_sll_tbl(l_line_sll_counter).amount);
8472: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt,l_currency_code );
8473: END IF;
8474:
8475:
8476: l_lvl_ele_tbl_in(l_tbl_seq).date_receivable_gl := l_fnd_lvl_out_rec.date_recievable_gl;

Line 8822: RETURN OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_cal_amt, l_currency_code);

8818: l_cal_amt := (NVL(p_amount,0) * l_term_days)/ NVL(l_cycle_days,1) ;
8819:
8820: -----errorout_ad('l_cal_amt = ' || l_cal_amt);
8821:
8822: RETURN OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_cal_amt, l_currency_code);
8823:
8824: EXCEPTION
8825: WHEN NO_DATA_FOUND THEN
8826: RETURN NULL;

Line 10299: l_adjusted_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvl_amt, l_currency_code );

10295: ---errorout_bill('p_SubLine_rec.cp_amt = ' || p_SubLine_rec.cp_amt);
10296: l_lvl_ele_tbl_in(l_tbl_seq).date_END := l_last_cmp_date;
10297:
10298: ELSE
10299: l_adjusted_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvl_amt, l_currency_code );
10300: END IF;
10301:
10302: l_lvl_ele_tbl_in(l_tbl_seq).amount := l_adjusted_amt;
10303:

Line 10398: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_term_amt, l_currency_code );

10394:
10395: END IF; ---END OF NEXT CYCLE DT CHK
10396:
10397:
10398: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_term_amt, l_currency_code );
10399: END IF;
10400: END IF;
10401:
10402: IF p_top_line_bs.COUNT > 0 THEN

Line 11582: x_bil_sch_out_tbl(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

11578: END IF;
11579:
11580: x_bil_sch_out_tbl(l_tbl_seq).bill_to_date := TRUNC(l_fnd_lvl_out_rec.next_cycle_date) - 1;
11581:
11582: x_bil_sch_out_tbl(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
11583: l_adjusted_amount,NVL(p_line_detail.currency_code,'USD'));
11584:
11585:
11586: x_bil_sch_out_tbl(l_tbl_seq).tx_date := TRUNC(l_fnd_lvl_out_rec.date_transaction);

Line 12708: p_new_sll_tbl(l_index).level_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt

12704:
12705: l_Amt := (NVL(p_old_sll_tbl(l_index).level_amount,0)/l_tot_amt) * nvl(p_new_cp_amt,0);
12706: END IF;
12707:
12708: p_new_sll_tbl(l_index).level_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt
12709: (l_Amt, l_currency_code);
12710:
12711:
12712: p_old_sll_tbl(l_index).level_amount := nvl(p_old_sll_tbl(l_index).level_amount,0) -

Line 13369: l_constant_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_constant_sll_amt, p_currency_code);

13365: ELSE
13366: /*Added for bug 16685173 */
13367: IF p_item_type = 'SUBSCRIPTION' then
13368: l_constant_sll_amt := ( p_total_amount /nvl(l_level_periods,1));
13369: l_constant_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_constant_sll_amt, p_currency_code);
13370:
13371: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13372: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Constant_sll_Amount',
13373: ' Get_Constant_sll_Amount for subscription '

Line 13499: x_bill_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvl_amt,p_currency_code);

13495: END IF;
13496:
13497: --dbms_output.put_line('l_constant_sll_amt - '||l_lvl_amt);
13498:
13499: x_bill_amount :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvl_amt,p_currency_code);
13500: x_bill_enddate :=TRUNC(l_fnd_lvl_out_rec.next_cycle_date) - 1;
13501:
13502: /*Added for bug 16685173 */
13503: if (x_bill_enddate > p_end_date) then