DBA Data[Home] [Help]

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 3459: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity

3455: TRUNC(l_next_cycle_dt,'MM') <> TRUNC(l_next_cycle_dt)
3456: THEN
3457: --New parameters in Bold
3458: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
3459: l_quantity := OKS_TIME_MEASURES_PUB.get_quantity
3460: (p_start_date => l_next_cycle_dt,
3461: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
3462: p_source_uom => l_fnd_lvl_in_rec.tuom ,
3463: p_period_type => p_period_type,

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

3464: p_period_start => p_period_start);
3465:
3466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3467: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3468: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with p_period_type '||p_period_type||' ,p_period_start '||p_period_start
3469: ||' result l_quantity = ' || l_quantity);
3470: END IF;
3471:
3472: IF nvl(l_quantity,0) = 0 THEN

Line 3481: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '

3477: l_adjusted_amount :=p_sll_tbl(l_line_sll_counter).amount*l_quantity/l_fnd_lvl_in_rec.uom_per_period; --bugfix 5485442
3478:
3479: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3480: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_Level_elements.Calendar',
3481: 'after calling OKS_TIME_MEASURES_PUB.get_quantity '
3482: ||' result l_adjusted_amount = ' || l_adjusted_amount);
3483: END IF;
3484: --mchoudha fix for bug#5200003
3485: ELSE

Line 4355: l_temp:= OKS_TIME_MEASURES_PUB.get_quantity (

4351: For j in i+1 .. l_sll_num Loop
4352: l_next_sll_start_date := p_sll_prorated_tab(j).sll_start_date;
4353: l_next_sll_end_date := p_sll_prorated_tab(j).sll_end_date;
4354: /* l_temp:=NULL;
4355: l_temp:= OKS_TIME_MEASURES_PUB.get_quantity (
4356: p_start_date => l_next_sll_start_date,
4357: p_end_date => l_next_sll_end_date,
4358: p_source_uom => l_uom_code,
4359: p_period_type => p_period_type,

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

4360: p_period_start => p_period_start
4361: );
4362: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4363: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4364: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4365: ||' result l_temp '||l_temp);
4366: END IF;
4367:
4368: IF nvl(l_temp,0) = 0 THEN

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

4372: l_next_frequency :=l_next_frequency + l_temp;
4373:
4374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4375: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Calculate_sll_amount.ppc',
4376: 'afer calling OKS_TIME_MEASURES_PUB.get_quantity input parameters period start '||p_period_start||' p_period_type = ' || p_period_type
4377: ||' result l_next_frequency '||l_next_frequency);
4378: END IF;
4379:
4380: */

Line 4384: l_curr_frequency := OKS_TIME_MEASURES_PUB.get_quantity (

4380: */
4381:
4382: END LOOP;
4383:
4384: l_curr_frequency := OKS_TIME_MEASURES_PUB.get_quantity (
4385: p_start_date => l_curr_sll_start_date,
4386: p_end_date => l_curr_sll_end_date,
4387: p_source_uom => l_uom_code,
4388: p_period_type => p_period_type,

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

4389: p_period_start => p_period_start
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_curr_frequency '||l_curr_frequency);
4395: END IF;
4396:
4397: IF nvl(l_curr_frequency,0) = 0 THEN

Line 4402: l_tot_frequency := OKS_TIME_MEASURES_PUB.get_quantity (

4398: RAISE G_EXCEPTION_HALT_VALIDATION;
4399: END IF;
4400: l_tot_frequency := 0;
4401:
4402: l_tot_frequency := OKS_TIME_MEASURES_PUB.get_quantity (
4403: p_start_date => l_curr_sll_start_date,
4404: p_end_date => nvl(l_next_sll_end_date,l_curr_sll_end_date),
4405: p_source_uom => l_uom_code,
4406: p_period_type => p_period_type,

Line 9879: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity

9875: TRUNC(l_next_cycle_dt)<
9876: p_SubLine_rec.cp_start_dt
9877: THEN
9878: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
9879: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity
9880: (p_start_date => p_SubLine_rec.cp_start_dt,
9881: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
9882: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
9883: p_period_type => p_period_type ,

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

9884: p_period_start => p_period_start);
9885:
9886: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9887: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Service',
9888: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
9889: ||' result l_quantity = ' || l_quantity);
9890: END IF;
9891:
9892: IF nvl(l_quantity,0) = 0 THEN

Line 9926: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity

9922: --errorout_ad(' start date '||to_char(TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1));
9923: --errorout_ad('p_period_start '||p_period_start);
9924: --errorout_ad('p_period_type '||p_period_type);
9925: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
9926: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity
9927: (p_start_date => l_next_cycle_dt,
9928: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
9929: p_source_uom => l_fnd_lvl_in_rec.tuom,--nvl(p_SubLine_rec.cp_price_uom,l_uom), --line price uom
9930: p_period_type => p_period_type,

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

9931: p_period_start => p_period_start);
9932:
9933: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9934: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.top_level.Calendar',
9935: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
9936: ||' result l_quantity = ' || l_quantity);
9937: END IF;
9938:
9939: --errorout_ad(' l_quantity '||l_quantity);

Line 10007: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity

10003: --errorout_ad(' end date '||to_char(TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1));
10004: --errorout_ad('p_period_start '||p_period_start);
10005: --errorout_ad('p_period_type '||p_period_type);
10006: IF l_tce_code not in ('DAY','HOUR','MINUTE') THEN
10007: l_quantity:= OKS_TIME_MEASURES_PUB.get_quantity
10008: (p_start_date => l_next_cycle_dt,
10009: p_end_date => TRUNC(l_fnd_lvl_out_rec.next_cycle_date)-1,
10010: p_source_uom => l_fnd_lvl_in_rec.tuom, --line price uom
10011: p_period_type => p_period_type,

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

10012: p_period_start => p_period_start);
10013:
10014: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10015: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Create_cp_lvl_elements.Equal_amount.Calendar',
10016: 'after calling OKS_TIME_MEASURES_PUB.get_quantity with period start '||p_period_start||' ,p_period_type '||p_period_type
10017: ||' result l_quantity = ' || l_quantity);
10018: END IF;
10019:
10020: --errorout_ad(' l_quantity '||l_quantity);