[Home] [Help]
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;
180: l_count_org NUMBER;
181:
182: --Get the count of rows matching with the UC, org and dep of the flight schedule and enabled_flag as Y
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
191: AND op.department_id = c_dep_id;
192: l_count_dep NUMBER;
193:
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
203: AND op.department_id = c_dep_id
204: AND op.flight_category_code = c_flight_cat;
205: l_count_cat NUMBER;
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)
227: OR ( c_org_count = 0 -- there are no non-null org rows meeting mc and enabled_flag
228: AND op.organization_id IS NULL))
229: AND ( ( c_org_count = 0 )
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;
1534: l_count_org NUMBER;
1535:
1536: --Get the count of rows matching with the UC, org and dep of the flight schedule and enabled_flag as Y
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
1545: AND op.department_id = c_dep_id;
1546: l_count_dep NUMBER;
1547:
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
1557: AND op.department_id = c_dep_id
1558: AND op.flight_category_code = c_flight_cat;
1559: l_count_cat NUMBER;
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)
1581: OR ( c_org_count = 0 -- there are no non-null org rows meeting mc and enabled_flag
1582: AND op.organization_id IS NULL))
1583: AND ( ( c_org_count = 0 )
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