APPS.BIS_BUSINESS_PLAN_PVT dependencies on BIS_BUSINESS_PLANS

Line 246: FROM bis_business_plans bp, bis_business_plans_tl bptl

242: , x_Business_Plan_Rec.business_plan_name
243: , x_Business_Plan_Rec.description
244: , x_Business_Plan_Rec.version_number
245: , x_Business_Plan_Rec.current_plan_flag
246: FROM bis_business_plans bp, bis_business_plans_tl bptl
247: WHERE bp.plan_id = p_Business_Plan_Rec.business_plan_id
248: AND bp.plan_id = bptl.plan_id
249: AND bptl.language = userenv('LANG');
250:

Line 349: select bis_business_plans_s.NextVal into l_id from dual;

345:
346: l_login_id := fnd_global.LOGIN_ID;
347: --
348:
349: select bis_business_plans_s.NextVal into l_id from dual;
350:
351: insert into bis_business_plans(
352: PLAN_ID
353: , SHORT_NAME

Line 351: insert into bis_business_plans(

347: --
348:
349: select bis_business_plans_s.NextVal into l_id from dual;
350:
351: insert into bis_business_plans(
352: PLAN_ID
353: , SHORT_NAME
354: , VERSION_NO
355: , CURRENT_PLAN_FLAG

Line 374: insert into bis_BUSINESS_PLANS_TL (

370: , l_user_id
371: , l_login_id
372: );
373:
374: insert into bis_BUSINESS_PLANS_TL (
375: PLAN_ID,
376: LANGUAGE,
377: NAME,
378: DESCRIPTION,

Line 399: , BIS_BUSINESS_PLANS P

395: , l_login_id
396: , 'Y'
397: , userenv('LANG')
398: FROM FND_LANGUAGES L
399: , BIS_BUSINESS_PLANS P
400: WHERE L.INSTALLED_FLAG IN ('I', 'B')
401: AND P.SHORT_NAME = l_Business_Plan_Rec.Business_Plan_Short_Name
402: AND NOT EXISTS
403: (SELECT 'EXISTS'

Line 404: FROM BIS_BUSINESS_PLANS_TL TL

400: WHERE L.INSTALLED_FLAG IN ('I', 'B')
401: AND P.SHORT_NAME = l_Business_Plan_Rec.Business_Plan_Short_Name
402: AND NOT EXISTS
403: (SELECT 'EXISTS'
404: FROM BIS_BUSINESS_PLANS_TL TL
405: , BIS_BUSINESS_PLANS P
406: WHERE TL.PLAN_ID = P.PLAN_ID
407: AND P.SHORT_NAME = l_Business_Plan_Rec.Business_Plan_Short_Name
408: AND TL.LANGUAGE = L.LANGUAGE_CODE) ;

Line 405: , BIS_BUSINESS_PLANS P

401: AND P.SHORT_NAME = l_Business_Plan_Rec.Business_Plan_Short_Name
402: AND NOT EXISTS
403: (SELECT 'EXISTS'
404: FROM BIS_BUSINESS_PLANS_TL TL
405: , BIS_BUSINESS_PLANS P
406: WHERE TL.PLAN_ID = P.PLAN_ID
407: AND P.SHORT_NAME = l_Business_Plan_Rec.Business_Plan_Short_Name
408: AND TL.LANGUAGE = L.LANGUAGE_CODE) ;
409:

Line 513: Update bis_business_plans

509:
510: l_login_id := fnd_global.LOGIN_ID;
511: --
512:
513: Update bis_business_plans
514: set
515: SHORT_NAME
516: = l_Business_Plan_Rec.Business_Plan_Short_Name
517: , VERSION_NO

Line 640: Update bis_business_plans_TL

636:
637: l_login_id := fnd_global.LOGIN_ID;
638: --
639:
640: Update bis_business_plans_TL
641: set
642: NAME = l_Business_Plan_Rec.Business_Plan_Name
643: , DESCRIPTION = l_Business_Plan_Rec.description
644: , LAST_UPDATE_DATE = SYSDATE

Line 796: FROM bis_business_plans

792: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Short_Name)
793: = FND_API.G_TRUE) then
794:
795: SELECT plan_id into x_Business_Plan_ID
796: FROM bis_business_plans
797: WHERE short_name = p_Business_Plan_Short_Name;
798:
799: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Name)
800: = FND_API.G_TRUE) then

Line 803: FROM bis_business_plans_tl

799: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Business_Plan_Name)
800: = FND_API.G_TRUE) then
801:
802: SELECT plan_id into x_Business_Plan_ID
803: FROM bis_business_plans_tl
804: WHERE name = p_Business_Plan_Name
805: AND language = userenv('LANG');
806: else
807: