DBA Data[Home] [Help]

APPS.OKS_BILL_REC_PUB dependencies on FND_PROFILE

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

1538: OPEN l_calc_bill_amount_csr ( p_id );
1539: FETCH l_calc_bill_amount_csr into l_billed_amount ;
1540: CLOSE l_calc_bill_amount_csr;
1541: --mchoudha fix for bug#4729993
1542: /* l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
1543: IF l_period_start IS NOT NULL AND
1544: l_period_type IS NOT NULL AND
1545: l_pricing_method = 'EFFECTIVITY' THEN
1546: x_amount := l_billed_amount - l_orig_price +

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

1739: ELSE
1740: OPEN l_calc_bill_amount_csr ( line_rec.id );
1741: FETCH l_calc_bill_amount_csr into l_billed_amount ;
1742: CLOSE l_calc_bill_amount_csr;
1743: /* l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
1744: IF l_period_start IS NOT NULL AND
1745: l_period_type IS NOT NULL AND
1746: l_pricing_method = 'EFFECTIVITY' THEN
1747: x_amount := x_amount + l_billed_amount - line_rec.price_negotiated +

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

6367: END IF;
6368: END IF; --period type and period start are not NULL
6369: END IF;
6370:
6371: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');
6372:
6373: X_qty := nvl(l_qty,0);
6374: x_start_reading := l_start_reading;
6375: IF(l_billing_based_on = 'A') THEN

Line 6570: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG'); ---- added by ansraj for 14016663

6566: l_billing_based_on VARCHAR2(15);
6567: l_value_timestamp DATE;
6568: BEGIN
6569: X_return_status := OKC_API.G_RET_STS_SUCCESS;
6570: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG'); ---- added by ansraj for 14016663
6571: ---l_counter_validate_flag := fnd_profile.value('OKS_COUNTER_VALIDATE');
6572: /*OKS_COUNTER_VALIDATE profile is no more used in R12 as the counter readings in IB are validated using disabled_flag and the same is implemented in OKS to validate the counter readings*/
6573: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');
6574:

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

6567: l_value_timestamp DATE;
6568: BEGIN
6569: X_return_status := OKC_API.G_RET_STS_SUCCESS;
6570: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG'); ---- added by ansraj for 14016663
6571: ---l_counter_validate_flag := fnd_profile.value('OKS_COUNTER_VALIDATE');
6572: /*OKS_COUNTER_VALIDATE profile is no more used in R12 as the counter readings in IB are validated using disabled_flag and the same is implemented in OKS to validate the counter readings*/
6573: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');
6574:
6575: OPEN inv_item_csr;

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

6569: X_return_status := OKC_API.G_RET_STS_SUCCESS;
6570: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG'); ---- added by ansraj for 14016663
6571: ---l_counter_validate_flag := fnd_profile.value('OKS_COUNTER_VALIDATE');
6572: /*OKS_COUNTER_VALIDATE profile is no more used in R12 as the counter readings in IB are validated using disabled_flag and the same is implemented in OKS to validate the counter readings*/
6573: l_billing_based_on := fnd_profile.value('OKS_USAGE_BILLING_BASED_ON');
6574:
6575: OPEN inv_item_csr;
6576: FETCH inv_item_csr into l_inv_rec;
6577: CLOSE inv_item_csr;