DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on FND_PROFILE

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

819: IF p_template_yn is Null OR p_template_yn = OKL_API.G_MISS_CHAR Then
820: Null;
821: Else
822: IF p_template_yn <> l_template_yn then
823: IF FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'Y' Then
824: Null;
825: ElsIf FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'N' Then
826: x_return_status := OKL_API.G_RET_STS_ERROR;
827: End If;

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

821: Else
822: IF p_template_yn <> l_template_yn then
823: IF FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'Y' Then
824: Null;
825: ElsIf FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'N' Then
826: x_return_status := OKL_API.G_RET_STS_ERROR;
827: End If;
828: End If;
829: END IF;

Line 2394: from fnd_profile_options_vl

2390:
2391: --Bug# 3486065
2392: cursor profile_option_csr(p_profile_option_name in varchar2) is
2393: select user_profile_option_name
2394: from fnd_profile_options_vl
2395: where profile_option_name = p_profile_option_name;
2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

Line 2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

2393: select user_profile_option_name
2394: from fnd_profile_options_vl
2395: where profile_option_name = p_profile_option_name;
2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2401:

Line 2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

2394: from fnd_profile_options_vl
2395: where profile_option_name = p_profile_option_name;
2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2401:
2402: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

Line 2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;

2395: where profile_option_name = p_profile_option_name;
2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2401:
2402: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2403: l_interest_calculation_basis VARCHAR2(30);

Line 2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;

2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2401:
2402: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2403: l_interest_calculation_basis VARCHAR2(30);
2404: l_revenue_recognition_method VARCHAR2(30);