DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_MULTI_CURRENCY

Line 2578: l_project_currency_code := pa_multi_currency.get_acct_currency_code;

2574: --Bugfix 2293158 issue 2 --end.
2575: THEN
2576: --Bugfix 2293158 issue 1 --Start
2577: -- l_project_currency_code := 'USD';
2578: l_project_currency_code := pa_multi_currency.get_acct_currency_code;
2579: --Bugfix 2293158 issue 1 --End
2580: ELSE
2581: l_project_currency_code := l_project_in_rec.project_currency_code;
2582: END IF;

Line 12882: ELSIF ( NVL( pa_multi_currency_billing.check_mcb_trans_exist ( p_project_in.pa_project_id ), 'N' ) = 'Y' OR

12878: --2. Check whether project value ,funding ,event,expenditure item, budget transaction exist
12879: --If any one of these exist, then the update should not be allowed. The check for existence of
12880: --sub projects is not done here as this has been already done above thru Bug#3912783.
12881:
12882: ELSIF ( NVL( pa_multi_currency_billing.check_mcb_trans_exist ( p_project_in.pa_project_id ), 'N' ) = 'Y' OR
12883: l_project_rec.project_value IS NOT NULL OR
12884: PA_IMPL_OPTIONS_PUB.check_budget_trans_exists( p_project_in.pa_project_id ) = 'Y'
12885: ) THEN
12886:

Line 14166: IF NVL(pa_multi_currency_billing.check_mcb_trans_exist(p_project_in.pa_project_id),'N') = 'Y'

14162: AND p_project_in.multi_currency_billing_flag IS NOT NULL THEN
14163: IF NVL(p_project_in.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
14164: <> NVL(l_project_rec.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
14165: -- if attempting to change MCB flag; check if it can be allowed
14166: IF NVL(pa_multi_currency_billing.check_mcb_trans_exist(p_project_in.pa_project_id),'N') = 'Y'
14167: OR NVL(pa_multi_currency_billing.check_mcb_setup_exists(p_project_in.pa_project_id),'N') = 'Y' THEN
14168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14169: FND_MESSAGE.SET_NAME('PA','PA_MCB_ALLOW_NO_CHG_AMG'); -- Cannot change MCB flag
14170: FND_MSG_PUB.ADD;

Line 14167: OR NVL(pa_multi_currency_billing.check_mcb_setup_exists(p_project_in.pa_project_id),'N') = 'Y' THEN

14163: IF NVL(p_project_in.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
14164: <> NVL(l_project_rec.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
14165: -- if attempting to change MCB flag; check if it can be allowed
14166: IF NVL(pa_multi_currency_billing.check_mcb_trans_exist(p_project_in.pa_project_id),'N') = 'Y'
14167: OR NVL(pa_multi_currency_billing.check_mcb_setup_exists(p_project_in.pa_project_id),'N') = 'Y' THEN
14168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14169: FND_MESSAGE.SET_NAME('PA','PA_MCB_ALLOW_NO_CHG_AMG'); -- Cannot change MCB flag
14170: FND_MSG_PUB.ADD;
14171: RAISE FND_API.G_EXC_ERROR;

Line 20451: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag

20447: l_INV_RATE_TYPE :=null;
20448: end;
20449: end if;
20450:
20451: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
20452: into l_cc_prvdr_flag,l_mcb_flag
20453: From pa_project_types pt, pa_projects pa
20454: where pa.project_type=pt.project_type AND
20455: pt.org_id = pa.org_id and

Line 21045: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag

21041: If l_INV_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR then
21042: l_INV_RATE_TYPE := cur_customer_rec.INV_RATE_TYPE;
21043: END if;
21044:
21045: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
21046: into l_cc_prvdr_flag,l_mcb_flag
21047: From pa_project_types pt, pa_projects pa
21048: where pa.project_type=pt.project_type
21049: AND pa.org_id = pt.org_id