/*****************************************************************************
*
* Filename         - $Workfile:   proc8.sql  $
*
*                     Name              Date      Version     CR Number
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle Database)
*
* Source Code
* Identifier       - 0/3/300/8010/112
*
* Design Spec
* Section          -
*
* Contents         - Live Schema Stored Procedure calling script
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/

@@pax_bag_count.sql
@@pax_id.sql
@@pax_id2.sql
@@priv_id_to_flt_access.sql
@@rec_uld_posn.sql
@@remove_bag_from_uld.sql
@@remove_uld_dests_record.sql
@@reuse_bag.sql
@@reuse_exception_bag.sql
@@reuse_pax.sql
@@revoke_all_by_flight.sql
@@set_location.sql
@@set_password.sql
@@split_tags.sql
@@stats_last_hour.sql
@@stop_and_unstop.sql
@@store_bpm_user.sql
@@store_bmm_mail.sql
@@sysint.sql
@@uld_class_list.sql
@@uld_ldg_prog.sql
@@uld_ldg_prog_scanner.sql
@@uld_loading_progress.sql
@@unload_entire_flight.sql
@@unload_entire_uld.sql
@@handler_tracing.sql
@@valid_agent.sql
@@xfer_bag.sql
@@store_bmm_mail.sql
@@update_bag.sql

@@fasl_fids.sql
@@onward_count.sql
@@terminating_count.sql
@@uld_destination.sql
@@yvr_get_std.sql
@@handle_bpm.sql
@@maintain_codeshare.sql
@@uld_id_list_tab.sql
@@uld_cards_spec.sql
@@uld_cards.sql
@@maintain_report_config.sql
@@hbmd_authorise.sql
@@hbmd_check.sql
@@hbmd_create.sql
@@get_hbmd_details.sql
@@add_mct_record.sql
@@update_mct_record.sql
@@add_stand_setup_record.sql
@@del_stand_setup_record.sql
@@pkg_inbound_flight_spec.sql
@@copy_uld.sql
@@auto_copy_through.sql
@@auto_copy_uld.sql
@@bag_count_terminating.sql
@@count_bags.sql
@@count_by_uld.sql
@@count_ulds.sql
@@get_best_time.sql
@@get_dest.sql
@@get_transfer_time.sql
@@merge_bag.sql
@@merge_one_bag.sql
@@merge_uld.sql
@@through_uld.sql
@@unthrough_flight.sql
@@untransfer_uld.sql
@@associate_recorded_uld.sql
@@get_recorded_uld.sql
@@get_min_con_time.sql
@@get_max_con_time.sql
@@get_arr_stand.sql
@@get_dep_stand.sql
@@hbmd_pbc.sql
@@pm_store.sql
@@unauthorised_bags.sql
@@freeze_flight.sql
@@store_uld_posn.sql
@@validate_uld_pos.sql
@@eq_tracking.sql
@@delete_duplicates.sql
@@get_config_value.sql
@@tracking.sql
@@holding_pens.sql

@@pkg_constants.sql
@@tss_create_uld.sql
@@tss_get_uld_data.sql
@@tss_is_user_authorised.sql
@@tss_load_bag.sql
@@tss_log_user_in.sql
@@tss_log_user_out.sql
@@tss_merge_ulds.sql
@@tss_offload_bag.sql
@@tss_ping.sql
@@tss_pre_clear_bag.sql
@@tss_register_uld.sql
@@tss_upd_pax_bags_class.sql
@@tss_upd_pax.sql

@@rename_uld.sql
@@mws_rename_uld.sql
@@cancel_flight.sql

@@get_user_preferred_format.sql
@@build_user_bag_tag.sql
@@get_numeric_bag_tag.sql
@@get_user_bag_tag.sql
@@bag_report_utils.sql
@@process_btm.sql
@@validate_bag_tag.sql

@@baggage_segregation_strategies.sql
@@reflighting.sql
@@pre_clear_bag.sql
@@check_btm_exists.sql

@@generate_bag_tag.sql

@@determine_security_status.sql
@@alpha_to_numeric.sql

@@bag_flights.sql
@@check_all_alerts.sql
@@check_alert_tag_exists.sql

@@email_pkg.sql

@@process_message_pkg.sql
@@pax_match.sql

@@inbound_flight.sql

@@def_ldg_strat.sql
@@load_where.sql

@@map_class.sql
@@unknown_bag_bpm.sql
@@add_bag_trace_for_bags_in_uld.sql

@@set_pax_vfdb.sql
@@sort_destination.sql

@@get_gsa_flight_details.sql

@@modify_uld_onwards_details.sql

@@bag_not_seen.sql
@@store_bns_mail.sql

@@set_bag_checkin.sql
@@flight_list.sql
@@pax_and_bag_counts_rec.sql
@@pax_and_bag_counts_tab.sql
@@multi_flight_pax_and_bag_count.sql

@@aggregate_misc_exceptions.sql
@@lost_baggage_report.sql

@@gateway_data.sql

@@get_bag_id.sql
@@first_successful_load.sql
@@get_seat_no.sql

@@bags_short_count.sql
@@user_maintenance.sql
@@reflighting_config.sql

@@onward_reports.sql
@@update_security_messages_sts.sql
@@terminal_config.sql

@@aoss_data.sql
@@add_inbound_terminating_bag.sql

@@ulds_pkg_spec.sql
@@ulds_pkg.sql
@@site_info_pkg_spec.sql
@@site_info_pkg.sql
@@missing_bag_spec.sql
@@missing_bag.sql
@@sortation_system_spec.sql
@@sortation_system.sql
@@add_bag_trace_with_reasons.sql
@@stop_reason.sql
@@locations_pkg_spec.sql
@@locations_pkg.sql
@@get_best_arrival_time.sql
@@get_best_schd_time.sql
@@flight_loop_data_pkg_spec.sql
@@flight_loop_data_pkg.sql

@@add_bag_trace_record_at.sql
