[Home] [Help]
1802: SIMULATION_PLAN_ID = p_plan_id AND
1803: STATUS_CODE IN ('PLANNING','PARTIALLY RELEASED') AND
1804: START_DATE_TIME IS NOT NULL AND
1805: trunc(START_DATE_TIME) <= p_end_time AND
1806: AHL_VWP_TIMES_PVT.get_visit_end_time(visit_id) >=p_start_time AND
1807: SIMULATION_DELETE_FLAG = 'N';
1808:
1809: CURSOR l_get_primary_visits(p_dept_id IN NUMBER,
1810: p_plan_id IN NUMBER,
1824: AND ASSO_PRIMARY_VISIT_ID = a.VISIT_ID) AND
1825: STATUS_CODE IN ('PLANNING','PARTIALLY RELEASED') AND
1826: START_DATE_TIME IS NOT NULL AND
1827: trunc(START_DATE_TIME) <= p_end_time AND
1828: AHL_VWP_TIMES_PVT.get_visit_end_time(visit_id) >=p_start_time;
1829:
1830: -- yazhou 24Aug2005 ends
1831:
1832: CURSOR l_get_plan_type_csr(p_plan_id IN NUMBER) IS
2749: -- Return all resource requirement for the given department and period
2750: -- Use requirements defined for the routes if there are any, otherwise use those for operations
2751: -- Added department_id and bom_resource_id in the output table
2752: -- And populate required quantity as well as start/end dates
2753: -- Also change to call AHL_VWP_TIMES_PVT.compute_date to calculate operation dates
2754:
2755: PROCEDURE Get_Operation_Details
2756: (
2757: p_task_dtls IN Visit_Task_Times_Rec_Type,
3060: -- Get the duration of the operation
3061: Get_Oper_Max_Duration(l_operation_id, l_temp_duration);
3062:
3063: l_oper_START_TIME := l_oper_END_TIME;
3064: l_oper_END_TIME := AHL_VWP_TIMES_PVT.COMPUTE_DATE(l_oper_START_TIME,p_department_id,l_temp_duration);
3065:
3066: IF (l_log_statement >= l_log_current_level) THEN
3067: fnd_log.string
3068: (