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 3022: l_round_level_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvlelement_amt, l_currency_code );

3018: Close l_tot_amt_csr;
3019:
3020:
3021:
3022: l_round_level_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvlelement_amt, l_currency_code );
3023: l_round_cycle_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(p_cycle_amt, l_currency_code );
3024:
3025: IF p_total_amt <> l_round_level_amt + l_round_cycle_amt THEN
3026: l_adjusted_amount := p_total_amt - l_round_level_amt;

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

3019:
3020:
3021:
3022: l_round_level_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvlelement_amt, l_currency_code );
3023: l_round_cycle_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(p_cycle_amt, l_currency_code );
3024:
3025: IF p_total_amt <> l_round_level_amt + l_round_cycle_amt THEN
3026: l_adjusted_amount := p_total_amt - l_round_level_amt;
3027: ELSE

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

3519:
3520: IF p_Line_rec.chr_id IS NOT NULL THEN --top line
3521: l_lvl_ele_tbl_in(l_tbl_seq).amount := NULL;
3522: ELSE ----cp level
3523: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_adjusted_amount,l_currency_code );
3524: END IF;
3525:
3526: ELSE ----for billing type = p and lse_id = 46
3527:

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

3524: END IF;
3525:
3526: ELSE ----for billing type = p and lse_id = 46
3527:
3528: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_adjusted_amount,l_currency_code );
3529: END IF;
3530:
3531:
3532: l_lvl_ele_tbl_in(l_tbl_seq).date_receivable_gl := l_fnd_lvl_out_rec.date_recievable_gl;

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

3849:
3850: ELSE ----for E
3851:
3852: l_cycle_amt := TO_NUMBER(p_sll_tbl(l_sll_counter).amount);
3853: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_cycle_amt,l_currency_code );
3854: END IF;
3855:
3856:
3857: l_lvl_ele_tbl_in(l_tbl_seq).date_receivable_gl := l_fnd_lvl_out_rec.date_recievable_gl;

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

4147:
4148: IF l_Line_Sll_Csr_Rec.level_amount IS NOT NULL THEN ---------calculate total sll amount
4149:
4150: l_sll_amt := (l_Line_Sll_Csr_Rec.level_amount * l_Line_Sll_Csr_Rec.level_periods);
4151: l_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt, l_currency_code);
4152: l_used_amt := l_used_amt + l_sll_amt;
4153:
4154: -----errorout_ad('sll amount = ' || to_char(l_sll_amt));
4155: -----errorout_ad('total used amount = ' || to_char(l_used_amt));

Line 4238: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

4234:
4235: -----errorout_ad('sll index = '|| to_char(l_sll_index));
4236: -----errorout_ad('sll amount returned = '|| to_char(l_sll_prorate_tbl(l_amt_counter).sll_amount));
4237:
4238: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
4239: l_sll_prorate_tbl(l_amt_counter).sll_amount, l_currency_code);
4240:
4241: l_strm_lvl_tbl_in(l_sll_index).level_amount := l_period_sll_amount;
4242:

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

4427: l_sll_period := l_curr_frequency/l_uom_per_period;
4428:
4429: l_period_sll_amt := ( l_sll_remain_amount /( nvl(l_tot_frequency,1) * nvl(l_sll_period,1))) * nvl(l_curr_frequency,0) ;
4430:
4431: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4432:
4433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4434: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4435: ' result l_period_sll_amt '||l_period_sll_amt);

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

4502:
4503:
4504: l_period_sll_amt := ( l_sll_remain_amount /( nvl(l_tot_frequency,1) * nvl(l_sll_period,1))) * nvl(l_curr_frequency,0) ;
4505:
4506: l_period_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_period_sll_amt, l_currency_code);
4507:
4508: l_sll_remain_amount := l_sll_remain_amount - (l_period_sll_amt * nvl(l_sll_period,1)) ;
4509: --errorout_ad('l_period_sll_amt '||l_period_sll_amt);
4510: --errorout_ad('l_sll_remain_amount '||l_sll_remain_amount);

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

4732:
4733: IF l_Sll_Csr_Rec.level_amount IS NOT NULL THEN ---------calculate total all amount
4734:
4735: l_sll_amt := to_number(l_Sll_Csr_Rec.level_amount) * to_number(l_Sll_Csr_Rec.level_periods);
4736: l_sll_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt, l_currency_code);
4737: l_used_amt := l_used_amt + l_sll_amt;
4738:
4739: -----errorout_ad('sll amount = ' || to_char(l_sll_amt));
4740: -----errorout_ad('total used amount = ' || to_char(l_used_amt));

Line 4826: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(

4822:
4823: -----errorout_ad('sll index = '|| to_char(l_sll_index));
4824: -----errorout_ad('sll amount returned = '|| to_char(l_sll_prorate_tbl(l_amt_counter).sll_amount));
4825:
4826: l_period_sll_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
4827: l_sll_prorate_tbl(l_amt_counter).sll_amount, l_currency_code);
4828:
4829: l_strm_lvl_tbl_in(l_sll_index).level_amount := TO_CHAR(l_period_sll_amount);
4830:

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

8249:
8250:
8251: IF l_bill_type = 'T' then
8252: --calculated sll amount
8253: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_constant_sll_amt,l_currency_code );
8254:
8255: ELSE ----for E and P
8256: ---sll amt entered by user
8257:

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

8255: ELSE ----for E and P
8256: ---sll amt entered by user
8257:
8258: l_sll_amt := TO_NUMBER(p_sll_tbl(l_line_sll_counter).amount);
8259: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_sll_amt,l_currency_code );
8260: END IF;
8261:
8262:
8263: l_lvl_ele_tbl_in(l_tbl_seq).date_receivable_gl := l_fnd_lvl_out_rec.date_recievable_gl;

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

8605: l_cal_amt := (NVL(p_amount,0) * l_term_days)/ NVL(l_cycle_days,1) ;
8606:
8607: -----errorout_ad('l_cal_amt = ' || l_cal_amt);
8608:
8609: RETURN OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_cal_amt, l_currency_code);
8610:
8611: EXCEPTION
8612: WHEN NO_DATA_FOUND THEN
8613: RETURN NULL;

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

10078: ---errorout_bill('p_SubLine_rec.cp_amt = ' || p_SubLine_rec.cp_amt);
10079: l_lvl_ele_tbl_in(l_tbl_seq).date_END := l_last_cmp_date;
10080:
10081: ELSE
10082: l_adjusted_amt := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_lvl_amt, l_currency_code );
10083: END IF;
10084:
10085: l_lvl_ele_tbl_in(l_tbl_seq).amount := l_adjusted_amt;
10086:

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

10151:
10152: END IF; ---END OF NEXT CYCLE DT CHK
10153:
10154:
10155: l_lvl_ele_tbl_in(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_term_amt, l_currency_code );
10156: END IF;
10157: END IF;
10158:
10159: IF p_top_line_bs.COUNT > 0 THEN

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

11335: END IF;
11336:
11337: x_bil_sch_out_tbl(l_tbl_seq).bill_to_date := TRUNC(l_fnd_lvl_out_rec.next_cycle_date) - 1;
11338:
11339: x_bil_sch_out_tbl(l_tbl_seq).amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(
11340: l_adjusted_amount,NVL(p_line_detail.currency_code,'USD'));
11341:
11342:
11343: x_bil_sch_out_tbl(l_tbl_seq).tx_date := TRUNC(l_fnd_lvl_out_rec.date_transaction);

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

12438:
12439: l_Amt := (NVL(p_old_sll_tbl(l_index).level_amount,0)/l_tot_amt) * nvl(p_new_cp_amt,0);
12440: END IF;
12441:
12442: p_new_sll_tbl(l_index).level_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt
12443: (l_Amt, l_currency_code);
12444:
12445:
12446: p_old_sll_tbl(l_index).level_amount := nvl(p_old_sll_tbl(l_index).level_amount,0) -