DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on FND_PROFILE

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

1701: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1702: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.get_subs_qty.begin','p_cle_id = '||p_cle_id);
1703: END IF;
1704: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1705: l_pricing_method:=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
1706: Open k_item_cur;
1707: Fetch k_item_cur Into l_quantity, l_uom_code;
1708: Close k_item_cur;
1709: Open subs_hdr;

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

1928: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,G_MODULE_CURRENT||'.subs_termn_amount.begin',
1929: 'p_cle_id = '||p_cle_id||' ,p_termn_date = '||to_char(p_termn_date,'DD-MON-YYYY')
1930: ||', Intangible Pricing Method = '||l_pricing_method);
1931: END IF;
1932: l_pricing_method :=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
1933: Open k_line_cur;
1934: Fetch k_line_cur Into l_act_start, l_act_end, l_orig_price;
1935: If k_line_cur%NotFound Then
1936: Close k_line_cur;

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

2174: l_price_uom VARCHAR2(100);
2175:
2176: BEGIN
2177:
2178: l_pricing_method:=FND_PROFILE.value('OKS_SUBS_PRICING_METHOD');
2179: --Dbms_Output.put_line('l_pricing_method -'||l_pricing_method);
2180:
2181: IF p_subscription_template_id IS NULL THEN OPEN get_item_dtls;
2182: