DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on FND_PROFILE

Line 855: IF FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'Y' Then

851: IF p_template_yn is Null OR p_template_yn = OKL_API.G_MISS_CHAR Then
852: Null;
853: Else
854: IF p_template_yn <> l_template_yn then
855: IF FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'Y' Then
856: Null;
857: ElsIf FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'N' Then
858: x_return_status := OKL_API.G_RET_STS_ERROR;
859: End If;

Line 857: ElsIf FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'N' Then

853: Else
854: IF p_template_yn <> l_template_yn then
855: IF FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'Y' Then
856: Null;
857: ElsIf FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'N' Then
858: x_return_status := OKL_API.G_RET_STS_ERROR;
859: End If;
860: End If;
861: END IF;

Line 2461: from fnd_profile_options_vl

2457:
2458: --Bug# 3486065
2459: cursor profile_option_csr(p_profile_option_name in varchar2) is
2460: select user_profile_option_name
2461: from fnd_profile_options_vl
2462: where profile_option_name = p_profile_option_name;
2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

Line 2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

2460: select user_profile_option_name
2461: from fnd_profile_options_vl
2462: where profile_option_name = p_profile_option_name;
2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2468:

Line 2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

2461: from fnd_profile_options_vl
2462: where profile_option_name = p_profile_option_name;
2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2468:
2469: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

Line 2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;

2462: where profile_option_name = p_profile_option_name;
2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2468:
2469: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2470: l_interest_calculation_basis VARCHAR2(30);

Line 2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;

2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2468:
2469: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2470: l_interest_calculation_basis VARCHAR2(30);
2471: l_revenue_recognition_method VARCHAR2(30);