[Home] [Help]
171: --Get the count of rows matching with the UC and org of the flight schedule and enabled_flag as Y
172: Cursor get_non_null_org_count (c_uc_id IN NUMBER, c_org_id IN NUMBER)
173: IS
174: SELECT count (*)
175: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
176: WHERE op.enabled_flag = 'Y'
177: AND uc.unit_config_header_id = c_uc_id
178: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
179: AND op.organization_id = c_org_id;
182: --Get the count of rows matching with the UC, org and dep of the flight schedule and enabled_flag as Y
183: Cursor get_non_null_dep_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER)
184: IS
185: SELECT count (*)
186: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
187: WHERE op.enabled_flag = 'Y'
188: AND uc.unit_config_header_id = c_uc_id
189: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
190: AND op.organization_id = c_org_id
194: --Get the count of rows matching with the UC, org, dep and category of the flight schedule and enabled_flag as Y
195: Cursor get_non_null_cat_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER, c_flight_cat IN VARCHAR2)
196: IS
197: SELECT count (*)
198: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
199: WHERE op.enabled_flag = 'Y'
200: AND uc.unit_config_header_id = c_uc_id
201: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
202: AND op.organization_id = c_org_id
218: c_org_count IN NUMBER, c_dep_count IN NUMBER, c_cat_count IN NUMBER,
219: c_create_for IN VARCHAR2, c_ground_time IN NUMBER)
220: IS
221: SELECT op.*
222: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
223: WHERE op.enabled_flag = 'Y'
224: AND uc.unit_config_header_id = c_uc_id
225: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
226: AND ( (op.organization_id = c_org_id)
1525: --Get the count of rows matching with the UC and org of the flight schedule and enabled_flag as Y
1526: Cursor get_non_null_org_count (c_uc_id IN NUMBER, c_org_id IN NUMBER)
1527: IS
1528: SELECT count (*)
1529: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1530: WHERE op.enabled_flag = 'Y'
1531: AND uc.unit_config_header_id = c_uc_id
1532: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1533: AND op.organization_id = c_org_id;
1536: --Get the count of rows matching with the UC, org and dep of the flight schedule and enabled_flag as Y
1537: Cursor get_non_null_dep_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER)
1538: IS
1539: SELECT count (*)
1540: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1541: WHERE op.enabled_flag = 'Y'
1542: AND uc.unit_config_header_id = c_uc_id
1543: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1544: AND op.organization_id = c_org_id
1548: --Get the count of rows matching with the UC, org, dep and category of the flight schedule and enabled_flag as Y
1549: Cursor get_non_null_cat_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER, c_flight_cat IN VARCHAR2)
1550: IS
1551: SELECT count (*)
1552: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1553: WHERE op.enabled_flag = 'Y'
1554: AND uc.unit_config_header_id = c_uc_id
1555: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1556: AND op.organization_id = c_org_id
1572: c_org_count IN NUMBER, c_dep_count IN NUMBER, c_cat_count IN NUMBER,
1573: c_create_for IN VARCHAR2, c_ground_time IN NUMBER)
1574: IS
1575: SELECT op.*
1576: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1577: WHERE op.enabled_flag = 'Y'
1578: AND uc.unit_config_header_id = c_uc_id
1579: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1580: AND ( (op.organization_id = c_org_id)
1663: --To get visit type duration of a given visit
1664: --Modified the below cursor by tchimira as a fix for issue 1 in the bug 13777327 on 01-Mar-2012
1665: CURSOR c_Visit_type_dur(c_visit_id IN NUMBER) IS
1666: SELECT vtyp.estimated_duration
1667: FROM ahl_visit_types_b vtyp, ahl_visits_b visit, ahl_unit_config_headers unit, ahl_mc_headers_b mc
1668: WHERE visit.visit_id = c_visit_id
1669: AND vtyp.visit_type_code = visit.visit_type_code
1670: AND unit.csi_item_instance_id = visit.item_instance_id
1671: AND unit.master_config_id = mc.mc_header_id
4198: CLOSE get_visit_type_duration;
4199:
4200: l_visit_rec := null;
4201:
4202: SELECT NAME INTO l_visit_rec.UNIT_NAME FROM AHL_UNIT_CONFIG_HEADERS
4203: WHERE unit_config_header_id= p_flight_schedule_rec.unit_config_header_id;
4204:
4205: -- Populate all the visit attributes
4206: l_visit_rec.VISIT_TYPE_CODE := p_oper_param_rec.visit_type_code;
4457: CLOSE get_visit_type_duration;
4458:
4459: l_visit_rec := null;
4460:
4461: SELECT NAME INTO l_visit_rec.UNIT_NAME FROM AHL_UNIT_CONFIG_HEADERS
4462: WHERE unit_config_header_id= p_flight_schedule_rec.unit_config_header_id;
4463:
4464: -- Populate all the visit attributes
4465: l_visit_rec.VISIT_TYPE_CODE := p_oper_param_rec.visit_type_code;
4720: -- Bug 14336467 :: PRAKKUM :: 13/07/2012
4721: p_is_creation_success := 'Y'; -- Initialize to success
4722:
4723: l_visit_rec := null;
4724: SELECT NAME INTO l_visit_rec.UNIT_NAME FROM AHL_UNIT_CONFIG_HEADERS
4725: WHERE unit_config_header_id= p_flight_schedule_rec.unit_config_header_id;
4726:
4727: OPEN get_succeeding_us_det (p_flight_schedule_rec.unit_schedule_id);
4728: FETCH get_succeeding_us_det INTO l_succeeding_us_id, l_succ_dep_time;