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 2206: from msc_plans

2202: nvl(WEEKLY_RESOURCE_CONSTRAINTS,0)+
2203: nvl(PERIOD_RESOURCE_CONSTRAINTS,0),
2204: plan_type
2205: into v_constraint, v_plan_type
2206: from msc_plans
2207: where plan_id = p_plan_id;
2208:
2209: if v_plan_type <>4 and v_constraint = 0 then
2210: -- unconstrained plan is always 100%

Line 2620: FROM msc_plans

2616: l_target NUMBER;
2617:
2618: CURSOR plan_target IS
2619: SELECT service_level
2620: FROM msc_plans
2621: WHERE plan_id = p_plan;
2622:
2623: CURSOR org_target IS
2624: SELECT service_level

Line 2766: from msc_plans

2762: l_ret_code NUMBER;
2763:
2764: cursor show_kpi is
2765: select display_kpi, curr_plan_type
2766: from msc_plans
2767: where plan_id = p_plan_id;
2768:
2769: v_show_kpi number;
2770: v_plan_type number;

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

2789: retcode OUT NOCOPY NUMBER,
2790: p_plan_id number) is
2791: l_plan_type number;
2792: cursor c_plan_type is
2793: select plan_type from msc_plans where plan_id =p_plan_id;
2794:
2795:
2796: BEGIN
2797:

Line 2841: from msc_plans

2837:
2838: Function IsKPIAvail(p_plan_id number) return number is
2839: cursor check_kpi is
2840: select kpi_refresh
2841: from msc_plans
2842: where plan_id = p_plan_id;
2843:
2844: v_kpi_refresh number;
2845: begin

Line 2868: from msc_plans

2864: v_status number;
2865: begin
2866: select kpi_refresh
2867: into v_kpi_refresh
2868: from msc_plans
2869: where plan_id = p_plan_id;
2870:
2871: if p_status = 'NOT REFRESH' then
2872: v_status := -1;

Line 2880: update msc_plans

2876: v_status := v_kpi_refresh + 1;
2877: end if;
2878:
2879: MSC_UTIL.MSC_DEBUG('v_status='||v_status);
2880: update msc_plans
2881: set kpi_refresh = decode(v_status,0,0,-1,-1,kpi_refresh+1)
2882: where plan_id = p_plan_id;
2883:
2884: commit;

Line 3195: from msc_plans

3191: AND owner = lv_msc_schema;
3192:
3193: Cursor plan_c is
3194: select plan_type
3195: from msc_plans
3196: where plan_id = p_plan_id;
3197:
3198: v_plan_type number;
3199:

Line 3202: from msc_plans

3198: v_plan_type number;
3199:
3200: cursor c_plan_archive is
3201: select nvl(archive_flag,2)
3202: from msc_plans
3203: where plan_id = p_plan_id;
3204: l_archive_flag number;
3205: l_req_id number;
3206: Begin