DBA Data[Home] [Help]

APPS.OKS_REPRICE_PVT dependencies on FND_PROFILE

Line 2342: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

2338: END IF;
2339:
2340: --end new logic for Partial Periods
2341: /*Added for GSI Bug 14102072*/
2342: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
2343: l_prorated_price_neg := ROUND(l_prorated_price_neg,29); -- bug 5018782
2344: Else
2345:
2346: l_prorated_price_neg := oks_extwar_util_pvt.round_currency_amt

Line 2426: l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');

2422: IF l_tangible THEN
2423: l_period_start := NULL;
2424: l_period_type := NULL;
2425: ELSE
2426: l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
2427: IF nvl(l_pricing_method,'SUBSCRIPTION') <> 'EFFECTIVITY' THEN
2428: l_period_start := NULL;
2429: l_period_type := NULL;
2430: ELSE

Line 2497: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

2493: END IF;
2494:
2495: --end new logic for Partial Periods
2496: /*Added for GSI Bug 14102072*/
2497: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
2498: l_prorated_price_neg := ROUND(l_prorated_price_neg,29); -- bug 5018782
2499: Else
2500: l_prorated_price_neg := oks_extwar_util_pvt.round_currency_amt
2501: (p_amount => l_prorated_price_neg,

Line 2625: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

2621: ) /
2622: 100
2623: );
2624: /*Added for bug 14102072*/
2625: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
2626: l_prorated_price_neg := ROUND(l_prorated_price_neg,29); -- bug 5018782
2627: Else
2628: l_prorated_price_neg := oks_extwar_util_pvt.round_currency_amt
2629: (p_amount => l_prorated_price_neg,

Line 2666: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

2662: ) /
2663: 100
2664: );
2665: /*Added for bug 14102072*/
2666: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
2667: l_prorated_price_neg := ROUND(l_prorated_price_neg,29); -- bug 5018782
2668: Else
2669: l_prorated_price_neg := oks_extwar_util_pvt.round_currency_amt
2670: (p_amount => l_prorated_price_neg,

Line 3260: l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');

3256:
3257: l_period_start := NULL;
3258: l_period_type := NULL;
3259: ELSE
3260: l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
3261: IF nvl(l_pricing_method,'SUBSCRIPTION') <> 'EFFECTIVITY' THEN
3262: l_period_start := NULL;
3263: l_period_type := NULL;
3264: ELSE

Line 3365: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

3361: p_perf_msg => 'MULTI CURRENCY CODE = ' ||
3362: l_currency);
3363:
3364: /*Added for bug 14102072*/
3365: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
3366: l_prorated_price_neg := ROUND(l_prorated_price_neg,29); -- bug 5018782
3367:
3368: fnd_file.put_line(FND_FILE.LOG,'Round l_prorated_price_neg = '||l_prorated_price_neg);
3369: Else

Line 3517: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN

3513: (p_program_name => 'Renewal Consolidation Reprice::',
3514: p_perf_msg => 'MARKED UP PRICE = ' ||
3515: l_prorated_price_neg);
3516: /*Added for bug 14102072*/
3517: If nvl(FND_PROFILE.value('OKS_PRICE_ROUNDING'),'N') ='N' THEN
3518: l_prorated_price_neg := ROUND(l_prorated_price_neg,29); -- bug 5018782
3519:
3520: Else
3521: l_prorated_price_neg := oks_extwar_util_pvt.round_currency_amt