APPS.OKS_BILL_REC_PUB dependencies on FND_PROFILE

Line 1528: /* l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');

1524: OPEN l_calc_bill_amount_csr ( p_id );
1525: FETCH l_calc_bill_amount_csr into l_billed_amount ;
1526: CLOSE l_calc_bill_amount_csr;
1527: --mchoudha fix for bug#4729993
1528: /* l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
1529: IF l_period_start IS NOT NULL AND
1530: l_period_type IS NOT NULL AND
1531: l_pricing_method = 'EFFECTIVITY' THEN
1532: x_amount := l_billed_amount - l_orig_price +

Line 1729: /* l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');

1725: ELSE
1726: OPEN l_calc_bill_amount_csr ( line_rec.id );
1727: FETCH l_calc_bill_amount_csr into l_billed_amount ;
1728: CLOSE l_calc_bill_amount_csr;
1729: /* l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
1730: IF l_period_start IS NOT NULL AND
1731: l_period_type IS NOT NULL AND
1732: l_pricing_method = 'EFFECTIVITY' THEN
1733: x_amount := x_amount + l_billed_amount - line_rec.price_negotiated +

Line 6345: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');

6341: END IF;
6342: END IF; --period type and period start are not NULL
6343: END IF;
6344:
6345: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');
6346:
6347: X_qty := nvl(l_qty,0);
6348: x_start_reading := l_start_reading;
6349: IF(l_billing_based_on = 'A') THEN

Line 6543: l_counter_validate_flag := fnd_profile.value('OKS_COUNTER_VALIDATE');

6539: l_value_timestamp DATE;
6540: BEGIN
6541: X_return_status := OKC_API.G_RET_STS_SUCCESS;
6542:
6543: l_counter_validate_flag := fnd_profile.value('OKS_COUNTER_VALIDATE');
6544: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');
6545:
6546: OPEN inv_item_csr;
6547: FETCH inv_item_csr into l_inv_rec;

Line 6544: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');

6540: BEGIN
6541: X_return_status := OKC_API.G_RET_STS_SUCCESS;
6542:
6543: l_counter_validate_flag := fnd_profile.value('OKS_COUNTER_VALIDATE');
6544: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');
6545:
6546: OPEN inv_item_csr;
6547: FETCH inv_item_csr into l_inv_rec;
6548: CLOSE inv_item_csr;