DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_PROFILE

Line 81: IF (Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_INSTALLED'),'N')= 'Y' AND Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_USAGE'),'N')='Y') THEN

77:
78: l_stmt_num := 10;
79:
80: --check the QP profiles for bug 11880769
81: IF (Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_INSTALLED'),'N')= 'Y' AND Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_USAGE'),'N')='Y') THEN
82: l_qp_mc:='Y';
83: ELSE
84: l_qp_mc:='N';
85: END IF;

Line 2283: IF (Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_INSTALLED'),'N')= 'Y' AND Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_USAGE'),'N')='Y') THEN

2279:
2280: l_stmt_num := 10;
2281:
2282: --check the QP profiles 11880769
2283: IF (Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_INSTALLED'),'N')= 'Y' AND Nvl(fnd_profile.Value('QP_MULTI_CURRENCY_USAGE'),'N')='Y') THEN
2284: l_qp_mc:='Y';
2285: ELSE
2286: l_qp_mc:='N';
2287: END IF;