DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_MULTI_CURRENCY_BILLING

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

12558: --2. Check whether project value ,funding ,event,expenditure item, budget transaction exist
12559: --If any one of these exist, then the update should not be allowed. The check for existence of
12560: --sub projects is not done here as this has been already done above thru Bug#3912783.
12561:
12562: ELSIF ( NVL( pa_multi_currency_billing.check_mcb_trans_exist ( p_project_in.pa_project_id ), 'N' ) = 'Y' OR
12563: l_project_rec.project_value IS NOT NULL OR
12564: PA_IMPL_OPTIONS_PUB.check_budget_trans_exists( p_project_in.pa_project_id ) = 'Y'
12565: ) THEN
12566:

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

13841: AND p_project_in.multi_currency_billing_flag IS NOT NULL THEN
13842: IF NVL(p_project_in.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
13843: <> NVL(l_project_rec.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
13844: -- if attempting to change MCB flag; check if it can be allowed
13845: IF NVL(pa_multi_currency_billing.check_mcb_trans_exist(p_project_in.pa_project_id),'N') = 'Y'
13846: OR NVL(pa_multi_currency_billing.check_mcb_setup_exists(p_project_in.pa_project_id),'N') = 'Y' THEN
13847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13848: FND_MESSAGE.SET_NAME('PA','PA_MCB_ALLOW_NO_CHG_AMG'); -- Cannot change MCB flag
13849: FND_MSG_PUB.ADD;

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

13842: IF NVL(p_project_in.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
13843: <> NVL(l_project_rec.multi_currency_billing_flag, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
13844: -- if attempting to change MCB flag; check if it can be allowed
13845: IF NVL(pa_multi_currency_billing.check_mcb_trans_exist(p_project_in.pa_project_id),'N') = 'Y'
13846: OR NVL(pa_multi_currency_billing.check_mcb_setup_exists(p_project_in.pa_project_id),'N') = 'Y' THEN
13847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13848: FND_MESSAGE.SET_NAME('PA','PA_MCB_ALLOW_NO_CHG_AMG'); -- Cannot change MCB flag
13849: FND_MSG_PUB.ADD;
13850: RAISE FND_API.G_EXC_ERROR;

Line 20050: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag

20046: l_INV_RATE_TYPE :=null;
20047: end;
20048: end if;
20049:
20050: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
20051: into l_cc_prvdr_flag,l_mcb_flag
20052: From pa_project_types pt, pa_projects pa
20053: where pa.project_type=pt.project_type AND
20054: pt.org_id = pa.org_id and

Line 20644: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag

20640: If l_INV_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR then
20641: l_INV_RATE_TYPE := cur_customer_rec.INV_RATE_TYPE;
20642: END if;
20643:
20644: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
20645: into l_cc_prvdr_flag,l_mcb_flag
20646: From pa_project_types pt, pa_projects pa
20647: where pa.project_type=pt.project_type
20648: AND pa.org_id = pt.org_id