DBA Data[Home] [Help]

APPS.OKS_AUTO_REMINDER dependencies on OKS_TIME_MEASURES_PUB

Line 1157: oks_time_measures_pub.get_quantity (p_start_date => p_end_date,

1153: BEGIN
1154: IF p_start_date > p_end_date
1155: THEN
1156: l_duration :=
1157: oks_time_measures_pub.get_quantity (p_start_date => p_end_date,
1158: p_end_date => p_start_date,
1159: p_source_uom => p_source_uom
1160: );
1161: x_duration := l_duration;

Line 1164: oks_time_measures_pub.get_quantity (p_start_date => p_start_date,

1160: );
1161: x_duration := l_duration;
1162: ELSE
1163: l_duration :=
1164: oks_time_measures_pub.get_quantity (p_start_date => p_start_date,
1165: p_end_date => p_end_date,
1166: p_source_uom => p_source_uom
1167: );
1168: x_duration := l_duration *

Line 2416: l_period := oks_time_measures_pub.get_uom_code ('DAY', 1);

2412:
2413: -- STEP 3: Check if the contract qualifies for a reminder / cancelation notice
2414: IF l_template_set_id IS NOT NULL AND x_is_eligible = 'Y' THEN
2415: l_duration := TRUNC (SYSDATE) - TRUNC (l_k_details_rec.start_date);
2416: l_period := oks_time_measures_pub.get_uom_code ('DAY', 1);
2417:
2418: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2419: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2420: 'l_duration: ' ||l_duration||' l_period: '||l_period );

Line 2458: l_temp_duration := oks_time_measures_pub.get_target_qty

2454: l_applies_to
2455: )
2456: LOOP
2457: IF l_reports_rec.report_duration < 0 THEN
2458: l_temp_duration := oks_time_measures_pub.get_target_qty
2459: (
2460: p_start_date => TRUNC(SYSDATE),
2461: p_source_qty => ABS(l_reports_rec.report_duration),
2462: p_source_uom => l_reports_rec.report_period,

Line 2468: l_temp_duration := oks_time_measures_pub.get_target_qty

2464: p_round_dec => 18
2465: );
2466: l_temp_duration := (l_temp_duration - 1) * -1;
2467: ELSE
2468: l_temp_duration := oks_time_measures_pub.get_target_qty
2469: (
2470: p_start_date => TRUNC(l_k_details_rec.start_date),
2471: p_source_qty => l_reports_rec.report_duration,
2472: p_source_uom => l_reports_rec.report_period,