[Home] [Help]
588: SELECT 'x' FROM bom_departments WHERE
589: department_id = l_dept_id;
590:
591: CURSOR l_validate_plan_csr(l_plan_id IN NUMBER) IS
592: SELECT 'x' FROM ahl_simulation_plans_b WHERE
593: simulation_plan_id = l_plan_id;
594:
595: l_api_version CONSTANT NUMBER := 1.0;
596: l_api_name CONSTANT VARCHAR2(30) := 'Get_Plan_Resources';
872: SELECT name FROM hr_all_organization_units WHERE
873: name = l_org_name;
874: --
875: CURSOR l_validate_plan_csr(l_plan_id IN NUMBER) IS
876: SELECT 'x' FROM ahl_simulation_plans_b WHERE
877: simulation_plan_id = l_plan_id;
878: --
879:
880: -- yazhou 24Aug2005 starts
1560: SELECT 'x' FROM bom_departments WHERE
1561: department_id = l_dept_id and exists ( SELECT 'x' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = bom_departments.DEPARTMENT_ID);
1562:
1563: CURSOR l_validate_plan_csr(l_plan_id IN NUMBER) IS
1564: SELECT 'x' FROM ahl_simulation_plans_b WHERE
1565: simulation_plan_id = l_plan_id;
1566:
1567:
1568: l_api_version CONSTANT NUMBER := 1.0;
1817: FROM ahl_visit_tasks_b
1818: where visit_id =a.visit_id
1819: AND department_id =p_dept_id
1820: AND nvl(status_code,'x') ='PLANNING'))) AND
1821: SIMULATION_PLAN_ID IN (SELECT SIMULATION_PLAN_ID FROM ahl_simulation_plans_b WHERE
1822: PRIMARY_PLAN_FLAG = G_PLAN_TYPE_PRIMARY) AND
1823: NOT EXISTS (SELECT 1 FROM ahl_visits_b WHERE SIMULATION_PLAN_ID = p_plan_id
1824: AND ASSO_PRIMARY_VISIT_ID = a.VISIT_ID) AND
1825: STATUS_CODE IN ('PLANNING','PARTIALLY RELEASED') AND
1829:
1830: -- yazhou 24Aug2005 ends
1831:
1832: CURSOR l_get_plan_type_csr(p_plan_id IN NUMBER) IS
1833: SELECT PRIMARY_PLAN_FLAG FROM ahl_simulation_plans_b
1834: WHERE SIMULATION_PLAN_ID = p_plan_id;
1835:
1836: l_api_version CONSTANT NUMBER := 1.0;
1837: l_api_name CONSTANT VARCHAR2(30) := 'Get_Plan_Tasks';