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_TIME_MEASURES_PUB

Line 501: l_duration := OKS_TIME_MEASURES_PUB.get_quantity (

497: --end changes for bug#5359695
498:
499: -- recalculate the unit price
500: IF lin_det_rec.lse_id in (7,9,25) THEN
501: l_duration := OKS_TIME_MEASURES_PUB.get_quantity (
502: p_start_date => lin_det_rec.start_date,
503: p_end_date => lin_det_rec.end_date,
504: p_source_uom => nvl(lin_det_rec.toplvl_uom_code,l_uom),
505: p_period_type => p_period_type,

Line 534: l_duration := OKS_TIME_MEASURES_PUB.get_quantity (

530: AND p_term_date is null THEN
531: IF (total_billed_rec.date_billed_to < p_end_date)
532: THEN -- partially Billed cases
533: l_amount := lin_det_rec.price_negotiated - total_billed_rec.amount;
534: l_duration := OKS_TIME_MEASURES_PUB.get_quantity (
535: p_start_date => total_billed_rec.date_billed_to+1,
536: p_end_date => p_end_date,
537: p_source_uom => P_billing_uom,--nvl(lin_det_rec.price_uom,l_uom), --target uom
538: p_period_type => p_period_type,

Line 543: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start

539: p_period_start => p_period_start
540: );
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
542: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.product_pricing.partially_billed_cases',
543: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
544: ||' result l_duration = ' || l_duration);
545: END IF;
546:
547: IF nvl(l_duration,0) = 0 THEN

Line 597: l_duration :=OKS_TIME_MEASURES_PUB.get_quantity(

593: THEN -- partial billed cases
594: IF (total_billed_rec.date_billed_to < p_end_date)
595: THEN
596: l_amount := lin_det_rec.price_negotiated - total_billed_rec.amount;
597: l_duration :=OKS_TIME_MEASURES_PUB.get_quantity(
598: p_start_date => total_billed_rec.date_billed_to+1,
599: p_end_date => p_end_date,
600: p_source_uom => p_billing_uom,
601: p_period_type => p_period_type,

Line 606: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start

602: p_period_start => p_period_start
603: );
604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
605: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.partially_billed_cases',
606: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
607: ||' result l_duration = ' || l_duration);
608: END IF;
609: IF nvl(l_duration,0) = 0 THEN
610: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 627: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

623: ELSE -- unbilled cases
624: l_amount := lin_det_rec.price_negotiated;
625: l_start_date := lin_det_rec.start_date;
626:
627: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
628: (p_start_date => l_start_date,
629: p_end_date => p_end_date,
630: p_source_uom => p_billing_uom,
631: p_period_type => p_period_type,

Line 636: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start

632: p_period_start => p_period_start);
633:
634: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
635: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Unit_Price_Per_Uom.manual_pricing.unbilled_cases',
636: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with parameters p_period_type '||p_period_type||' p_period_start '||p_period_start
637: ||' result l_quantity = ' || l_quantity);
638: END IF;
639:
640: IF nvl(l_quantity,0) = 0 THEN

Line 757: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

753: END IF;
754: return (l_target_qty);
755: END IF;
756:
757: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
758: (p_start_date => p_start_date,
759: p_end_date => p_end_date,
760: p_source_uom => p_price_uom,
761: p_period_type => p_period_type,

Line 3476: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

3472: TRUNC(l_next_cycle_dt,'MM') <> TRUNC(l_next_cycle_dt)
3473: THEN
3474: --New parameters in Bold
3475: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
3476: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
3477: (p_start_date => l_next_cycle_dt,
3478: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
3479: p_source_uom => l_fnd_lvl_in_rec.tuom ,
3480: p_period_type => p_period_type,

Line 3485: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with p_period_type '||p_period_type||' ,p_period_start '||p_period_start

3481: p_period_start => p_period_start);
3482:
3483: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3484: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3485: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with p_period_type '||p_period_type||' ,p_period_start '||p_period_start
3486: ||' result l_quantity = ' || l_quantity);
3487: END IF;
3488:
3489: IF nvl(l_quantity,0) = 0 THEN

Line 3498: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '

3494: l_adjusted_amount :=p_sll_tbl(l_line_sll_counter).amount*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
3495:
3496: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3497: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3498: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '
3499: ||' result l_adjusted_amount = ' || l_adjusted_amount);
3500: END IF;
3501: --mchoudha fix for bug#5200003
3502: ELSE

Line 4372: l_temp:= OKS_TIME_MEASURES_PUB.get_quantity (

4368: For j in i+1 .. l_sll_num Loop
4369: l_next_sll_start_date := p_sll_prorated_tab(j).sll_start_date;
4370: l_next_sll_end_date := p_sll_prorated_tab(j).sll_end_date;
4371: /* l_temp:=NULL;
4372: l_temp:= OKS_TIME_MEASURES_PUB.get_quantity (
4373: p_start_date => l_next_sll_start_date,
4374: p_end_date => l_next_sll_end_date,
4375: p_source_uom => l_uom_code,
4376: p_period_type => p_period_type,

Line 4381: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type

4377: p_period_start => p_period_start
4378: );
4379: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4380: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4381: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4382: ||' result l_temp '||l_temp);
4383: END IF;
4384:
4385: IF nvl(l_temp,0) = 0 THEN

Line 4393: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type

4389: l_next_frequency :=l_next_frequency + l_temp;
4390:
4391: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4392: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4393: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4394: ||' result l_next_frequency '||l_next_frequency);
4395: END IF;
4396:
4397: */

Line 4401: l_curr_frequency := OKS_TIME_MEASURES_PUB.get_quantity (

4397: */
4398:
4399: END LOOP;
4400:
4401: l_curr_frequency := OKS_TIME_MEASURES_PUB.get_quantity (
4402: p_start_date => l_curr_sll_start_date,
4403: p_end_date => l_curr_sll_end_date,
4404: p_source_uom => l_uom_code,
4405: p_period_type => p_period_type,

Line 4410: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type

4406: p_period_start => p_period_start
4407: );
4408: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4409: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4410: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4411: ||' result l_curr_frequency '||l_curr_frequency);
4412: END IF;
4413:
4414: IF nvl(l_curr_frequency,0) = 0 THEN

Line 4419: l_tot_frequency := OKS_TIME_MEASURES_PUB.get_quantity (

4415: RAISE G_EXCEPTION_HALT_VALIDATION;
4416: END IF;
4417: l_tot_frequency := 0;
4418:
4419: l_tot_frequency := OKS_TIME_MEASURES_PUB.get_quantity (
4420: p_start_date => l_curr_sll_start_date,
4421: p_end_date => nvl(l_next_sll_end_date,l_curr_sll_end_date),
4422: p_source_uom => l_uom_code,
4423: p_period_type => p_period_type,

Line 10096: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity

10092: TRUNC(l_next_cycle_dt)<
10093: p_SubLine_rec.cp_start_dt
10094: THEN
10095: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
10096: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity
10097: (p_start_date => p_SubLine_rec.cp_start_dt,
10098: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
10099: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
10100: p_period_type => p_period_type ,

Line 10105: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type

10101: p_period_start => p_period_start);
10102:
10103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10104: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
10105: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10106: ||' result l_quantity = ' || l_quantity);
10107: END IF;
10108:
10109: IF nvl(l_quantity,0) = 0 THEN

Line 10143: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity

10139: --errorout_ad(' start date '||to_char(TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1));
10140: --errorout_ad('p_period_start '||p_period_start);
10141: --errorout_ad('p_period_type '||p_period_type);
10142: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
10143: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity
10144: (p_start_date => l_next_cycle_dt,
10145: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
10146: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
10147: p_period_type => p_period_type,

Line 10152: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type

10148: p_period_start => p_period_start);
10149:
10150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10151: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
10152: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10153: ||' result l_quantity = ' || l_quantity);
10154: END IF;
10155:
10156: --errorout_ad(' l_quantity '||l_quantity);

Line 10224: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity

10220: --errorout_ad(' end date '||to_char(TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1));
10221: --errorout_ad('p_period_start '||p_period_start);
10222: --errorout_ad('p_period_type '||p_period_type);
10223: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
10224: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity
10225: (p_start_date => l_next_cycle_dt,
10226: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
10227: p_source_uom => l_fnd_lvl_in_rec.tuom, --line price uom
10228: p_period_type => p_period_type,

Line 10233: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type

10229: p_period_start => p_period_start);
10230:
10231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10232: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10233: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10234: ||' result l_quantity = ' || l_quantity);
10235: END IF;
10236:
10237: --errorout_ad(' l_quantity '||l_quantity);

Line 13257: l_target_qty := OKS_TIME_MEASURES_PUB.get_quantity(

13253: IF l_billing_profile_Csr_Rec.BILLING_TYPE = 'RECURRING' THEN
13254:
13255: --dbms_output.put_line('l_billing_profile_Csr_Rec.interval - '||l_billing_profile_Csr_Rec.interval);
13256:
13257: l_target_qty := OKS_TIME_MEASURES_PUB.get_quantity(
13258: l_start_date
13259: , l_end_date
13260: , l_billing_profile_Csr_Rec.interval);
13261:

Line 13324: l_dur := OKS_TIME_MEASURES_PUB.get_quantity (

13320: /*Added for bug 16293821 */
13321:
13322: okc_time_util_pub.get_duration(p_start_date,p_end_date,l_dur,l_uom,l_return_status);
13323:
13324: l_dur := OKS_TIME_MEASURES_PUB.get_quantity (
13325: p_start_date => p_start_date,
13326: p_end_date => p_end_date,
13327: p_source_uom => l_uom,
13328: p_period_type => l_period_type,

Line 13430: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type

13426: Strm_Start_Date => trunc(to_date(p_start_date)));
13427:
13428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13429: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13430: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type
13431: ||' l_fnd_lvl_out_rec.next_cycle_date = ' || l_fnd_lvl_out_rec.next_cycle_date);
13432: END IF;
13433:
13434:

Line 13441: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity

13437: /* Commented for bug 16293821 as contracts created from OM will always have period_start as SERVICE and no partial period at beginning of schedule
13438:
13439: IF TRUNC(l_fnd_lvl_out_rec.next_cycle_date) > trunc(to_date(p_start_date)) THEN
13440: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
13441: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity
13442: (p_start_date => trunc(to_date(p_start_date)),
13443: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
13444: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
13445: p_period_type => l_period_type ,

Line 13450: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type

13446: p_period_start => l_period_start);
13447:
13448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
13449: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Billed_Amount',
13450: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||l_period_start||' ,l_period_type '||l_period_type
13451: ||' result l_quantity = ' || l_quantity);
13452: END IF;
13453:
13454: IF nvl(l_quantity,0) = 0 THEN