APPS.MSC_GET_BIS_VALUES dependencies on MSC_PLANS

Line 256: msc_plans mp

252:
253: CURSOR PERIOD_CURSOR IS
254: SELECT mbp.period_name, mbp.start_date, mbp.end_date
255: FROM msc_bis_periods mbp,
256: msc_plans mp
257: WHERE mbp.organization_id = mp.organization_id
258: and mbp.sr_instance_id = mp.sr_instance_id
259: and ((mbp.start_date between nvl(mp.data_start_date, sysdate)
260: and mp.cutoff_date

Line 857: msc_plans mp

853:
854: CURSOR PERIOD_CURSOR IS
855: SELECT mbp.period_name, mbp.start_date, mbp.end_date
856: FROM msc_bis_periods mbp,
857: msc_plans mp
858: WHERE mbp.organization_id = mp.organization_id
859: and mbp.sr_instance_id = mp.sr_instance_id
860: and ((mbp.start_date between nvl(mp.data_start_date, sysdate)
861: and mp.cutoff_date

Line 872: msc_plans mp

868:
869: CURSOR PERIOD_ZERO_CURSOR IS
870: SELECT mbp.start_date
871: FROM msc_bis_periods mbp,
872: msc_plans mp
873: WHERE mbp.organization_id = mp.organization_id
874: and mbp.sr_instance_id = mp.sr_instance_id
875: and mbp.start_date < g_plan_start_date
876: and mp.plan_id = p_plan_id

Line 900: from msc_plans mp

896:
897: else
898: select nvl(mp.data_start_date,sysdate), mp.cutoff_date
899: into g_plan_start_date, g_plan_end_date
900: from msc_plans mp
901: where plan_id =-1;
902:
903: g_period_name(1).start_date := g_plan_start_date;
904: g_period_name(1).end_date := g_plan_end_date-1;

Line 2217: from msc_plans

2213: nvl(WEEKLY_RESOURCE_CONSTRAINTS,0)+
2214: nvl(PERIOD_RESOURCE_CONSTRAINTS,0),
2215: plan_type
2216: into v_constraint, v_plan_type
2217: from msc_plans
2218: where plan_id = p_plan_id;
2219:
2220: if v_plan_type <>4 and v_constraint = 0 then
2221: -- unconstrained plan is always 100%

Line 2631: FROM msc_plans

2627: l_target NUMBER;
2628:
2629: CURSOR plan_target IS
2630: SELECT service_level
2631: FROM msc_plans
2632: WHERE plan_id = p_plan;
2633:
2634: CURSOR org_target IS
2635: SELECT service_level

Line 2777: from msc_plans

2773: l_ret_code NUMBER;
2774:
2775: cursor show_kpi is
2776: select display_kpi, curr_plan_type
2777: from msc_plans
2778: where plan_id = p_plan_id;
2779:
2780: v_show_kpi number;
2781: v_plan_type number;

Line 2804: select plan_type from msc_plans where plan_id =p_plan_id;

2800: retcode OUT NOCOPY NUMBER,
2801: p_plan_id number) is
2802: l_plan_type number;
2803: cursor c_plan_type is
2804: select plan_type from msc_plans where plan_id =p_plan_id;
2805:
2806:
2807: BEGIN
2808:

Line 2852: from msc_plans

2848:
2849: Function IsKPIAvail(p_plan_id number) return number is
2850: cursor check_kpi is
2851: select kpi_refresh
2852: from msc_plans
2853: where plan_id = p_plan_id;
2854:
2855: v_kpi_refresh number;
2856: begin

Line 2879: from msc_plans

2875: v_status number;
2876: begin
2877: select kpi_refresh
2878: into v_kpi_refresh
2879: from msc_plans
2880: where plan_id = p_plan_id;
2881:
2882: if p_status = 'NOT REFRESH' then
2883: v_status := -1;

Line 2891: update msc_plans

2887: v_status := v_kpi_refresh + 1;
2888: end if;
2889:
2890: MSC_UTIL.MSC_DEBUG('v_status='||v_status);
2891: update msc_plans
2892: set kpi_refresh = decode(v_status,0,0,-1,-1,kpi_refresh+1)
2893: where plan_id = p_plan_id;
2894:
2895: commit;

Line 3206: from msc_plans

3202: AND owner = lv_msc_schema;
3203:
3204: Cursor plan_c is
3205: select display_kpi, plan_type,AUTO_RELEASE_METHOD,generate_worksheet
3206: from msc_plans
3207: where plan_id = p_plan_id;
3208:
3209: v_plan_type number;
3210: v_show_kpi number;

Line 3216: from msc_plans

3212: l_generate_worksheet number;
3213:
3214: cursor c_plan_archive is
3215: select nvl(archive_flag,2)
3216: from msc_plans
3217: where plan_id = p_plan_id;
3218: l_archive_flag number;
3219: l_req_id number;
3220: Begin