1787: OPEN C1;
1788: FETCH C1 INTO l_target;
1789: If C1%NotFound Then
1790: If p_chart_type = INVENTORY_TURNS Then
1791: l_target := Fnd_Profile.Value('MSC_PERF_INVENTORY_TURNS');
1792: Elsif (p_chart_type = ONTIME_DELIVERY) Then
1793: l_target := Fnd_Profile.Value('MSC_PERF_ONTIME_DELIVERY');
1794: Elsif p_chart_type = MARGIN_PERCENT Then
1795: l_target := Fnd_Profile.Value('MSC_PERF_MARGIN_PERCENT');
1789: If C1%NotFound Then
1790: If p_chart_type = INVENTORY_TURNS Then
1791: l_target := Fnd_Profile.Value('MSC_PERF_INVENTORY_TURNS');
1792: Elsif (p_chart_type = ONTIME_DELIVERY) Then
1793: l_target := Fnd_Profile.Value('MSC_PERF_ONTIME_DELIVERY');
1794: Elsif p_chart_type = MARGIN_PERCENT Then
1795: l_target := Fnd_Profile.Value('MSC_PERF_MARGIN_PERCENT');
1796: Elsif (p_chart_type in (UTILIZATION,UTILIZATION2)) Then
1797: l_target := Fnd_Profile.Value('MSC_PERF_UTILIZATION_PERCENT');
1791: l_target := Fnd_Profile.Value('MSC_PERF_INVENTORY_TURNS');
1792: Elsif (p_chart_type = ONTIME_DELIVERY) Then
1793: l_target := Fnd_Profile.Value('MSC_PERF_ONTIME_DELIVERY');
1794: Elsif p_chart_type = MARGIN_PERCENT Then
1795: l_target := Fnd_Profile.Value('MSC_PERF_MARGIN_PERCENT');
1796: Elsif (p_chart_type in (UTILIZATION,UTILIZATION2)) Then
1797: l_target := Fnd_Profile.Value('MSC_PERF_UTILIZATION_PERCENT');
1798: End If;
1799: End if;
1793: l_target := Fnd_Profile.Value('MSC_PERF_ONTIME_DELIVERY');
1794: Elsif p_chart_type = MARGIN_PERCENT Then
1795: l_target := Fnd_Profile.Value('MSC_PERF_MARGIN_PERCENT');
1796: Elsif (p_chart_type in (UTILIZATION,UTILIZATION2)) Then
1797: l_target := Fnd_Profile.Value('MSC_PERF_UTILIZATION_PERCENT');
1798: End If;
1799: End if;
1800: CLOSE C1;
1801:
3253: end if;
3254:
3255: --pabram..phub
3256: if (nvl(v_show_kpi, 1)=1 and v_plan_type not in (5)
3257: and nvl(fnd_profile.value('MSC_APCC_AFTER_LAUNCH'),1) <> 2) then
3258: open c_plan_archive;
3259: fetch c_plan_archive into l_archive_flag;
3260: close c_plan_archive;
3261: l_req_id := fnd_request.submit_request('MSC','MSCHUBA',NULL, NULL, FALSE, p_plan_id, null, l_archive_flag);