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 5646: l_prddays := OKS_TIME_MEASURES_PUB.get_target_qty_service (

5642: p_period_start IS NOT NULL AND
5643: l_date_billed_from IS NOT NULL AND --mchoudha Fix for bug#5166216
5644: l_date_billed_to IS NOT NULL
5645: THEN
5646: l_prddays := OKS_TIME_MEASURES_PUB.get_target_qty_service (
5647: p_start_date => l_Date_Billed_From,
5648: p_end_date => l_Date_Billed_To,
5649: p_price_uom => p_usage_period,
5650: p_period_type => p_period_type,

Line 5873: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

5869: --------------------------
5870: IF p_period_type IS NOT NULL AND
5871: p_period_start IS NOT NULL
5872: THEN
5873: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
5874: p_start_date => p_cov_prd_start_date,
5875: p_end_date => p_cov_prd_end_date,
5876: p_price_uom => p_usage_period,
5877: p_period_type => p_period_type,

Line 5911: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

5907: ---------------------------------
5908: IF p_period_type IS NOT NULL AND
5909: p_period_start IS NOT NULL
5910: THEN
5911: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
5912: p_start_date => l_cov_start_date,
5913: p_end_date => l_cov_end_date,
5914: p_price_uom => p_usage_period,
5915: p_period_type => p_period_type,

Line 6045: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

6041: --------------------------
6042: IF p_period_type IS NOT NULL AND
6043: p_period_start IS NOT NULL
6044: THEN
6045: l_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
6046: p_start_date => p_cov_prd_start_date,
6047: p_end_date => p_cov_prd_end_date,
6048: p_price_uom => p_usage_period,
6049: p_period_type => p_period_type,

Line 6100: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

6096: THEN
6097: --mchoudha fix for bug#5207605
6098: --Est Start date has to be counter date + 1
6099: --Est end date has to be termination date -1
6100: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
6101: p_start_date => l_counter_date+1,
6102: p_end_date => p_cov_prd_end_date-1,
6103: p_price_uom => p_usage_period,
6104: p_period_type => p_period_type,

Line 6134: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (

6130: p_period_start IS NOT NULL
6131: THEN
6132: --mchoudha fix for bug#5207605
6133: --Est Start date has to be counter date + 1
6134: l_temp_qty := OKS_TIME_MEASURES_PUB.get_target_qty_service (
6135: p_start_date => l_counter_date+1,
6136: p_end_date => p_cov_prd_end_date,
6137: p_price_uom => p_usage_period,
6138: p_period_type => p_period_type,

Line 6323: l_temp := OKS_TIME_MEASURES_PUB.GET_TARGET_QTY

6319:
6320: l_qty:= Round(l_qty,0);
6321: ELSE
6322: --Existing logic
6323: l_temp := OKS_TIME_MEASURES_PUB.GET_TARGET_QTY
6324: (
6325: p_start_date => p_cov_prd_start_date,
6326: p_source_qty => 1,
6327: p_source_uom => p_usage_period,

Line 10062: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10058: RAISE G_EXCEPTION_HALT_VALIDATION;
10059: END IF;
10060: ELSE*/
10061: --Fix for bug#5623498 unit price will be recalculated based on duration based uom if pricelist is not present
10062: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10063: (p_start_date => cur.start_date,
10064: p_end_date => l_line_end_date,
10065: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10066: p_period_type => p_period_type,

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

10070: -- Calculation of Termination amount using Partial Periods Method
10071: -- Termination Period Start Date = l_termination_date
10072: -- Termination Period End of date = p_line_end_date
10073: -- Determine the termination duration quantity in terms of price list uom for bug#5306921
10074: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10075: p_end_date => l_line_end_date,
10076: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10077: p_period_type => p_period_type,
10078: p_period_start => p_period_start);

Line 10081: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10077: p_period_type => p_period_type,
10078: p_period_start => p_period_start);
10079:
10080: ELSE --for manual covered levels added for bug#4961636
10081: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10082: (p_start_date => cur.start_date,
10083: p_end_date => l_line_end_date,
10084: p_source_uom => l_uom,
10085: p_period_type => p_period_type,

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

10089: -- Calculation of Termination amount using Partial Periods Method
10090: -- Termination Period Start Date = l_termination_date
10091: -- Termination Period End of date = p_line_end_date
10092: -- Determine the termination duration quantity in terms of effectivity uom for bug#5306921
10093: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10094: p_end_date => l_line_end_date,
10095: p_source_uom => l_uom,
10096: p_period_type => p_period_type,
10097: p_period_start => p_period_start);

Line 10103: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10099: END IF;
10100:
10101: -- END IF;
10102: ELSE
10103: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10104: (p_start_date => cur.start_date,
10105: p_end_date => l_line_end_date,
10106: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10107: p_period_type => p_period_type,

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

10111: -- Calculation of Termination amount using Partial Periods Method
10112: -- Termination Period Start Date = l_termination_date
10113: -- Termination Period End of date = p_line_end_date
10114: -- Determine the termination duration quantity in terms of price list uom for bug#5306921
10115: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10116: p_end_date => l_line_end_date,
10117: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10118: p_period_type => p_period_type,
10119: p_period_start => p_period_start);

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

10121: END IF;
10122:
10123: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10124: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10125: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with end date '||l_line_end_date||' ,p_source_uom '
10126: ||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10127: ||' l_termination_date '||to_char(l_termination_date)||'result l_quantity '||l_quantity);
10128: END IF;
10129:

Line 10465: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10461: END IF;
10462: ELSE*/
10463: --Fix for bug#5623498 unit price will be recalculated based on
10464: --duration based uom if pricelist is not present
10465: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10466: (p_start_date => covlvl_rec.start_date,
10467: p_end_date => l_line_end_date,
10468: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10469: p_period_type => p_period_type,

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

10471: l_unit_price := covlvl_rec.total_amount / l_quantity;
10472:
10473: --END IF;
10474: --determine the termination duration quantity based on price list uom for bug#5306921
10475: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10476: p_end_date => l_line_end_date,
10477: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10478: p_period_type => p_period_type,
10479: p_period_start => p_period_start);

Line 10482: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10478: p_period_type => p_period_type,
10479: p_period_start => p_period_start);
10480:
10481: ELSE --for manual covered levels added for bug#4961636
10482: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10483: (p_start_date => covlvl_rec.start_date,
10484: p_end_date => l_line_end_date,
10485: p_source_uom => l_uom,
10486: p_period_type => p_period_type,

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

10487: p_period_start => p_period_start);
10488:
10489: l_unit_price := covlvl_rec.total_amount/l_quantity;
10490: --determine the termination duration quantity based on effectivity uom for bug#5306921
10491: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10492: p_end_date => l_line_end_date,
10493: p_source_uom => l_uom,
10494: p_period_type => p_period_type,
10495: p_period_start => p_period_start);

Line 10504: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10500:
10501: ELSE --OM iStore Case
10502: --The conversion from pricelist uom to price uom is not required as per bug#4686993
10503: --So deriving the quantity based on price list uom
10504: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10505: (p_start_date => covlvl_rec.start_date,
10506: p_end_date => l_line_end_date,
10507: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10508: p_period_type => p_period_type,

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

10508: p_period_type => p_period_type,
10509: p_period_start => p_period_start);
10510: l_unit_price := covlvl_rec.total_amount / l_quantity;
10511: --determine the termination duration quantity based on price list uom for bug#5306921
10512: l_quantity:=OKS_TIME_MEASURES_PUB.get_quantity(p_start_date => l_termination_date,
10513: p_end_date => l_line_end_date,
10514: p_source_uom => nvl(covlvl_rec.toplvl_uom_code,l_uom),
10515: p_period_type => p_period_type,
10516: p_period_start => p_period_start);

Line 10524: '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

10520:
10521:
10522: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10523: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10524: '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
10525: ||'result l_quantity '||l_quantity);
10526: END IF;
10527:
10528: IF nvl(l_quantity,0) = 0 THEN

Line 10631: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10627: END IF;
10628: ELSE*/
10629: --Fix for bug#5623498 unit price will be recalculated based on duration based uom
10630: --if pricelist is not present
10631: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10632: (p_start_date => cur.start_date,
10633: p_end_date => l_line_end_date,
10634: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10635: p_period_type => p_period_type,

Line 10641: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(

10637: l_unit_price := cur.total_amount / l_quantity;
10638:
10639: --END IF;
10640: --determine the termination duration quantity based on price list uom
10641: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(
10642: p_start_date => l_termination_date,
10643: p_end_date => l_line_end_date,
10644: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10645: p_period_type => p_period_type,

Line 10649: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10645: p_period_type => p_period_type,
10646: p_period_start => p_period_start);
10647:
10648: ELSE --for manual covered levels added for bug#4961636
10649: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10650: (p_start_date => cur.start_date,
10651: p_end_date => l_line_end_date,
10652: p_source_uom => l_uom,
10653: p_period_type => p_period_type,

Line 10658: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(

10654: p_period_start => p_period_start);
10655:
10656: l_unit_price := cur.total_amount/l_quantity;
10657: --determine the termination duration quantity based on effectivity uom
10658: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(
10659: p_start_date => l_termination_date,
10660: p_end_date => l_line_end_date,
10661: p_source_uom => l_uom,
10662: p_period_type => p_period_type,

Line 10668: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10664:
10665: END IF;
10666: --END IF;
10667: ELSE --OM iStore Case
10668: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10669: (p_start_date => cur.start_date,
10670: p_end_date => l_line_end_date,
10671: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10672: p_period_type => p_period_type,

Line 10676: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(

10672: p_period_type => p_period_type,
10673: p_period_start => p_period_start);
10674: l_unit_price := cur.total_amount / l_quantity;
10675: --determine the termination duration quantity based on price list uom
10676: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity(
10677: p_start_date => l_termination_date,
10678: p_end_date => l_line_end_date,
10679: p_source_uom => nvl(cur.toplvl_uom_code,l_uom),
10680: p_period_type => p_period_type,

Line 10688: '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

10684:
10685:
10686: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10687: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10688: '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
10689: ||'result l_quantity '||l_quantity);
10690: END IF;
10691:
10692:

Line 10824: l_usage_quantity := OKS_TIME_MEASURES_PUB.get_target_qty_service (

10820: --End Validation
10821: l_prorated_qty := 0;
10822:
10823: --Fetch the quantity wrt usage uom
10824: l_usage_quantity := OKS_TIME_MEASURES_PUB.get_target_qty_service (
10825: p_start_date => p_start_date,
10826: p_end_date => p_end_date,
10827: p_price_uom => p_usage_uom,
10828: p_period_type => p_period_type,

Line 10929: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10925:
10926:
10927:
10928: --Get the partial period between p_termination_date and p_end_date
10929: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10930: (p_start_date => p_termination_date,
10931: p_end_date => p_end_date,
10932: p_source_uom => P_uom,
10933: p_period_type => P_period_type,

Line 10939: '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)

10935: );
10936:
10937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10938: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
10939: '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)
10940: ||'result l_quantity '||l_quantity);
10941: END IF;
10942:
10943: IF nvl(l_quantity,0) = 0 THEN

Line 10947: l_total_quantity := OKS_TIME_MEASURES_PUB.get_quantity

10943: IF nvl(l_quantity,0) = 0 THEN
10944: RAISE G_EXCEPTION_HALT_VALIDATION;
10945: END IF;
10946:
10947: l_total_quantity := OKS_TIME_MEASURES_PUB.get_quantity
10948: (p_start_date => p_start_date,
10949: p_end_date => p_end_date,
10950: p_source_uom => P_uom,
10951: p_period_type => P_period_type,

Line 10957: '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

10953: );
10954:
10955: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10956: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
10957: '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
10958: ||'result l_total_quantity '||l_total_quantity);
10959: END IF;
10960:
10961: IF nvl(l_total_quantity,0) = 0 THEN