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_TIME_MEASURES_PUB

Line 5672: l_prddays := OKS_TIME_MEASURES_PUB.get_target_qty_service (

5668: p_period_start IS NOT NULL AND
5669: l_date_billed_from IS NOT NULL AND --mchoudha Fix for bug#5166216
5670: l_date_billed_to IS NOT NULL
5671: THEN
5672: l_prddays := OKS_TIME_MEASURES_PUB.get_target_qty_service (
5673: p_start_date => l_Date_Billed_From,
5674: p_end_date => l_Date_Billed_To,
5675: p_price_uom => p_usage_period,
5676: p_period_type => p_period_type,

Line 5899: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

5895: --------------------------
5896: IF p_period_type IS NOT NULL AND
5897: p_period_start IS NOT NULL
5898: THEN
5899: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
5900: p_start_date => p_cov_prd_start_date,
5901: p_end_date => p_cov_prd_end_date,
5902: p_price_uom => p_usage_period,
5903: p_period_type => p_period_type,

Line 5937: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

5933: ---------------------------------
5934: IF p_period_type IS NOT NULL AND
5935: p_period_start IS NOT NULL
5936: THEN
5937: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
5938: p_start_date => l_cov_start_date,
5939: p_end_date => l_cov_end_date,
5940: p_price_uom => p_usage_period,
5941: p_period_type => p_period_type,

Line 6071: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

6067: --------------------------
6068: IF p_period_type IS NOT NULL AND
6069: p_period_start IS NOT NULL
6070: THEN
6071: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
6072: p_start_date => p_cov_prd_start_date,
6073: p_end_date => p_cov_prd_end_date,
6074: p_price_uom => p_usage_period,
6075: p_period_type => p_period_type,

Line 6126: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

6122: THEN
6123: --mchoudha fix for bug#5207605
6124: --Est Start date has to be counter date + 1
6125: --Est end date has to be termination date -1
6126: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
6127: p_start_date => l_counter_date+1,
6128: p_end_date => p_cov_prd_end_date-1,
6129: p_price_uom => p_usage_period,
6130: p_period_type => p_period_type,

Line 6160: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

6156: p_period_start IS NOT NULL
6157: THEN
6158: --mchoudha fix for bug#5207605
6159: --Est Start date has to be counter date + 1
6160: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
6161: p_start_date => l_counter_date+1,
6162: p_end_date => p_cov_prd_end_date,
6163: p_price_uom => p_usage_period,
6164: p_period_type => p_period_type,

Line 6349: l_temp := OKS_TIME_MEASURES_PUB.GET_TARGET_QTY

6345: /* Commented for Bug#15897052 */
6346: --l_qty:= Round(l_qty,0);
6347: ELSE
6348: --Existing logic
6349: l_temp := OKS_TIME_MEASURES_PUB.GET_TARGET_QTY
6350: (
6351: p_start_date => p_cov_prd_start_date,
6352: p_source_qty => 1,
6353: p_source_uom => p_usage_period,

Line 10154: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10150: RAISE G_EXCEPTION_HALT_VALIDATION;
10151: END IF;
10152: ELSE*/
10153: --Fix for bug#5623498 unit price will be recalculated based on duration based uom if pricelist is not present
10154: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10155: (p_start_date => cur.start_date,
10156: p_end_date => l_line_end_date,
10157: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10158: p_period_type => p_period_type,

Line 10166: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,

10162: -- Calculation of Termination amount using Partial Periods Method
10163: -- Termination Period Start Date = l_termination_date
10164: -- Termination Period End of date = p_line_end_date
10165: -- Determine the termination duration quantity in terms of price list uom for bug#5306921
10166: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10167: p_end_date => l_line_end_date,
10168: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10169: p_period_type => p_period_type,
10170: p_period_start => p_period_start);

Line 10173: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10169: p_period_type => p_period_type,
10170: p_period_start => p_period_start);
10171:
10172: ELSE --for manual covered levels added for bug#4961636
10173: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10174: (p_start_date => cur.start_date,
10175: p_end_date => l_line_end_date,
10176: p_source_uom => l_uom,
10177: p_period_type => p_period_type,

Line 10185: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,

10181: -- Calculation of Termination amount using Partial Periods Method
10182: -- Termination Period Start Date = l_termination_date
10183: -- Termination Period End of date = p_line_end_date
10184: -- Determine the termination duration quantity in terms of effectivity uom for bug#5306921
10185: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10186: p_end_date => l_line_end_date,
10187: p_source_uom => l_uom,
10188: p_period_type => p_period_type,
10189: p_period_start => p_period_start);

Line 10195: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10191: END IF;
10192:
10193: -- END IF;
10194: ELSE
10195: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10196: (p_start_date => cur.start_date,
10197: p_end_date => l_line_end_date,
10198: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10199: p_period_type => p_period_type,

Line 10207: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,

10203: -- Calculation of Termination amount using Partial Periods Method
10204: -- Termination Period Start Date = l_termination_date
10205: -- Termination Period End of date = p_line_end_date
10206: -- Determine the termination duration quantity in terms of price list uom for bug#5306921
10207: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10208: p_end_date => l_line_end_date,
10209: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10210: p_period_type => p_period_type,
10211: p_period_start => p_period_start);

Line 10217: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with end date '||l_line_end_date||' ,p_source_uom '

10213: END IF;
10214:
10215: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10216: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10217: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with end date '||l_line_end_date||' ,p_source_uom '
10218: ||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10219: ||' l_termination_date '||to_char(l_termination_date)||'result l_quantity '||l_quantity);
10220: END IF;
10221:

Line 10583: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10579: END IF;
10580: ELSE*/
10581: --Fix for bug#5623498 unit price will be recalculated based on
10582: --duration based uom if pricelist is not present
10583: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10584: (p_start_date => covlvl_rec.start_date,
10585: p_end_date => l_line_end_date,
10586: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10587: p_period_type => p_period_type,

Line 10593: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,

10589: l_unit_price := covlvl_rec.total_amount / l_quantity;
10590:
10591: --END IF;
10592: --determine the termination duration quantity based on price list uom for bug#5306921
10593: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10594: p_end_date => l_line_end_date,
10595: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10596: p_period_type => p_period_type,
10597: p_period_start => p_period_start);

Line 10600: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10596: p_period_type => p_period_type,
10597: p_period_start => p_period_start);
10598:
10599: ELSE --for manual covered levels added for bug#4961636
10600: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10601: (p_start_date => covlvl_rec.start_date,
10602: p_end_date => l_line_end_date,
10603: p_source_uom => l_uom,
10604: p_period_type => p_period_type,

Line 10609: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,

10605: p_period_start => p_period_start);
10606:
10607: l_unit_price := covlvl_rec.total_amount/l_quantity;
10608: --determine the termination duration quantity based on effectivity uom for bug#5306921
10609: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10610: p_end_date => l_line_end_date,
10611: p_source_uom => l_uom,
10612: p_period_type => p_period_type,
10613: p_period_start => p_period_start);

Line 10622: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10618:
10619: ELSE --OM iStore Case
10620: --The conversion from pricelist uom to price uom is not required as per bug#4686993
10621: --So deriving the quantity based on price list uom
10622: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10623: (p_start_date => covlvl_rec.start_date,
10624: p_end_date => l_line_end_date,
10625: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10626: p_period_type => p_period_type,

Line 10630: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,

10626: p_period_type => p_period_type,
10627: p_period_start => p_period_start);
10628: l_unit_price := covlvl_rec.total_amount / l_quantity;
10629: --determine the termination duration quantity based on price list uom for bug#5306921
10630: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10631: p_end_date => l_line_end_date,
10632: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10633: p_period_type => p_period_type,
10634: p_period_start => p_period_start);

Line 10642: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '|| nvl(covlvl_rec.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type

10638:
10639:
10640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10641: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10642: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '|| nvl(covlvl_rec.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10643: ||'result l_quantity '||l_quantity);
10644: END IF;
10645:
10646: IF nvl(l_quantity,0) = 0 THEN

Line 10756: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10752: END IF;
10753: ELSE*/
10754: --Fix for bug#5623498 unit price will be recalculated based on duration based uom
10755: --if pricelist is not present
10756: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10757: (p_start_date => cur.start_date,
10758: p_end_date => l_line_end_date,
10759: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10760: p_period_type => p_period_type,

Line 10766: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(

10762: l_unit_price := cur.total_amount / l_quantity;
10763:
10764: --END IF;
10765: --determine the termination duration quantity based on price list uom
10766: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(
10767: p_start_date => l_termination_date,
10768: p_end_date => l_line_end_date,
10769: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10770: p_period_type => p_period_type,

Line 10774: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10770: p_period_type => p_period_type,
10771: p_period_start => p_period_start);
10772:
10773: ELSE --for manual covered levels added for bug#4961636
10774: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10775: (p_start_date => cur.start_date,
10776: p_end_date => l_line_end_date,
10777: p_source_uom => l_uom,
10778: p_period_type => p_period_type,

Line 10783: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(

10779: p_period_start => p_period_start);
10780:
10781: l_unit_price := cur.total_amount/l_quantity;
10782: --determine the termination duration quantity based on effectivity uom
10783: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(
10784: p_start_date => l_termination_date,
10785: p_end_date => l_line_end_date,
10786: p_source_uom => l_uom,
10787: p_period_type => p_period_type,

Line 10793: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10789:
10790: END IF;
10791: --END IF;
10792: ELSE --OM iStore Case
10793: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10794: (p_start_date => cur.start_date,
10795: p_end_date => l_line_end_date,
10796: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10797: p_period_type => p_period_type,

Line 10801: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(

10797: p_period_type => p_period_type,
10798: p_period_start => p_period_start);
10799: l_unit_price := cur.total_amount / l_quantity;
10800: --determine the termination duration quantity based on price list uom
10801: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(
10802: p_start_date => l_termination_date,
10803: p_end_date => l_line_end_date,
10804: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10805: p_period_type => p_period_type,

Line 10813: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type

10809:
10810:
10811: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10812: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10813: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10814: ||'result l_quantity '||l_quantity);
10815: END IF;
10816:
10817:

Line 10973: l_usage_quantity := OKS_TIME_MEASURES_PUB.get_target_qty_service (

10969: --End Validation
10970: l_prorated_qty := 0;
10971:
10972: --Fetch the quantity wrt usage uom
10973: l_usage_quantity := OKS_TIME_MEASURES_PUB.get_target_qty_service (
10974: p_start_date => p_start_date,
10975: p_end_date => p_end_date,
10976: p_price_uom => p_usage_uom,
10977: p_period_type => p_period_type,

Line 11078: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

11074:
11075:
11076:
11077: --Get the partial period between p_termination_date and p_end_date
11078: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
11079: (p_start_date => p_termination_date,
11080: p_end_date => p_end_date,
11081: p_source_uom => P_uom,
11082: p_period_type => P_period_type,

Line 11088: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type||' P_termination_date '||to_char(P_termination_date)

11084: );
11085:
11086: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11087: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
11088: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type||' P_termination_date '||to_char(P_termination_date)
11089: ||'result l_quantity '||l_quantity);
11090: END IF;
11091:
11092: IF nvl(l_quantity,0) = 0 THEN

Line 11096: l_total_quantity := OKS_TIME_MEASURES_PUB.get_quantity

11092: IF nvl(l_quantity,0) = 0 THEN
11093: RAISE G_EXCEPTION_HALT_VALIDATION;
11094: END IF;
11095:
11096: l_total_quantity := OKS_TIME_MEASURES_PUB.get_quantity
11097: (p_start_date => p_start_date,
11098: p_end_date => p_end_date,
11099: p_source_uom => P_uom,
11100: p_period_type => P_period_type,

Line 11106: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type

11102: );
11103:
11104: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11105: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
11106: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
11107: ||'result l_total_quantity '||l_total_quantity);
11108: END IF;
11109:
11110: IF nvl(l_total_quantity,0) = 0 THEN