Index of /documents/Core-9.17.8/Database/live_schema/stored_procs

• Parent Directory
• CallSpecWriteUldData.sql
• add_app_msg.sql
• add_bag.sql
• add_bag_alert_record.sql
• add_bag_alert_trace_record.sql
• add_bag_data.sql
• add_bag_to_uld.sql
• add_bag_trace_for_bags_in_uld.sql
• add_bag_trace_record.sql
• add_bag_trace_record2.sql
• add_bag_trace_record_at.sql
• add_bag_trace_with_reasons.sql
• add_blo_indicator.sql
• add_carrier_map.sql
• add_class_to_list.sql
• add_crew_bag.sql
• add_flight.sql
• add_flight_trace_record.sql
• add_flt_access.sql
• add_flt_access2.sql
• add_gate_bag.sql
• add_gate_pax.sql
• add_gate_pax_and_bag.sql
• add_hel_fids_data.sql
• add_hold_uld.sql
• add_inbound_terminating_bag.sql
• add_loadall_pax.sql
• add_loaded_bag.sql
• add_log_rec.sql
• add_mct_record.sql
• add_onward_flight.sql
• add_pax.sql
• add_pax_creds.sql
• add_rush_bag.sql
• add_stand_setup_record.sql
• add_stats_access.sql
• add_uld_dests_record.sql
• add_uld_record.sql
• add_uld_trace_record.sql
• add_user_trace_record.sql
• aggregate_misc_exceptions.sql
• all_procs.sql
• alpha_to_numeric.sql
• aoss_data.sql
• associate_recorded_uld.sql
• auto_copy_through.sql
• auto_copy_uld.sql
• bag_count_terminating.sql
• bag_flights.sql
• bag_manifest_totals.sql
• bag_not_seen.sql
• bag_report_utils.sql
• baggage_segregation_strategies.sql
• bags_short_count.sql
• bara_flight_info.sql
• bmm_messages.sql
• build_user_bag_tag.sql
• calc_stats.sql
• call_unload_entire_uld.sql
• cancel_flight.sql
• carrier.sql
• carrier_details.sql
• carrier_name.sql
• carrier_spec.sql
• check_alert.sql
• check_alert_tag_exists.sql
• check_all_alerts.sql
• check_bag_alert.sql
• check_bag_for_load.sql
• check_bag_for_unload.sql
• check_bag_transfer.sql
• check_btm_exists.sql
• check_connect_info.sql
• check_flight.sql
• check_flight_access.sql
• check_priv.sql
• check_uld_alert.sql
• check_uld_weight.sql
• check_ulds.sql
• check_unload_alert.sql
• chk_flt_date_and_no.sql
• chk_ib_flt_if_reqd.sql
• clear_bag.sql
• clear_pd_marker.sql
• clear_rush_bag.sql
• codeshare.sql
• config.sql
• convert_class.sql
• copy_uld.sql
• count_bags.sql
• count_by_uld.sql
• count_ulds.sql
• critical_track_type.sql
• dcs_up_down.sql
• deassign_uld.sql
• def_ldg_strat.sql
• del_flight_priv_record.sql
• del_stand_setup_record.sql
• delete_all_bags.sql
• delete_bag.sql
• delete_duplicates.sql
• delete_pax2.sql
• delete_tagtrak_user.sql
• derive_seq_no.sql
• destination_list.sql
• determine_security_status.sql
• drop_procs.sql
• email_pkg.sql
• eq_tracking.sql
• erase_mail.sql
• erase_mba_flights.sql
• erase_records.sql
• exceed_track_type.sql
• exception_bags.sql
• expected_flow_incoming_types.sql
• extract_carrier.sql
• fasl_fids.sql
• fids_interface.sql
• first_successful_load.sql
• flight_bag_count.sql
• flight_close.sql
• flight_id.sql
• flight_id2.sql
• flight_list.sql
• flight_loading_progress.sql
• flight_loop_data_pkg.sql
• flight_loop_data_pkg_spec.sql
• flight_no.sql
• flight_no2.sql
• flightinfo.sql
• flightpax_bags.sql
• flightpax_id.sql
• flts_bag_count.sql
• flts_ldg_prog_by_time.sql
• flts_pax_bag_count_by_time.sql
• flts_pax_bag_count_by_time_mws.sql
• freeze_flight.sql
• gaddrc.sql
• gateway_data.sql
• gateway_data_spec.sql
• gateway_redo.sql
• generate_bag_tag.sql
• generate_bpmid.sql
• generate_trolley_uld.sql
• get_alert_counts.sql
• get_alpha_code.sql
• get_arr_stand.sql
• get_bag_count.sql
• get_bag_data.sql
• get_bag_id.sql
• get_best_arrival_time.sql
• get_best_schd_time.sql
• get_best_time.sql
• get_best_uld.sql
• get_bpm_data1.sql
• get_bpm_data2.sql
• get_bpm_data4.sql
• get_bpm_status.sql
• get_break_down_data2.sql
• get_carrier_code.sql
• get_carrier_code2.sql
• get_carrier_code3.sql
• get_carrier_cred.sql
• get_config_value.sql
• get_crew_bag_creds.sql
• get_dcs_flightno.sql
• get_dep_stand.sql
• get_dest.sql
• get_event_type.sql
• get_first_bag_load1.sql
• get_first_bag_locn.sql
• get_gate_apron.sql
• get_gate_pax_creds.sql
• get_gsa_flight_details.sql
• get_hbmd_details.sql
• get_last_bag_load1.sql
• get_last_bld_trace.sql
• get_latest_uld_trace.sql
• get_ldg_strat.sql
• get_max_con_time.sql
• get_min_con_time.sql
• get_numeric_bag_tag.sql
• get_offset.sql
• get_onward_flight.sql
• get_pax_bags.sql
• get_pax_cred.sql
• get_pax_data.sql
• get_pax_details.sql
• get_pax_list_data.sql
• get_priv.sql
• get_recorded_uld.sql
• get_rfid_privs.sql
• get_seat_no.sql
• get_stand.sql
• get_timeout.sql
• get_transfer_time.sql
• get_uld_data.sql
• get_uld_pos.sql
• get_uni_mix_ulds.sql
• get_unit_count_data.sql
• get_user_bag_tag.sql
• get_user_preferred_format.sql
• getaddno.sql
• grant_all_flt_access.sql
• grant_by_flight.sql
• grant_contract_access.sql
• grant_flt_access.sql
• grnts.sql
• handle_bpm.sql
• handler_tracing.sql
• hash_key.sql
• hbmd_authorise.sql
• hbmd_check.sql
• hbmd_create.sql
• hbmd_pbc.sql
• hel_fids.sql
• holding_pens.sql
• hot_connection.sql
• how_many_messages.sql
• inbound_flight.sql
• inbound_flight_utils.sql
• increment_warn_count.sql
• insert_inbound_data.sql
• is_bag_transfer.sql
• is_connection_valid.sql
• is_flight_batch.sql
• is_it_hold.sql
• is_it_loaded.sql
• is_uld_shipside.sql
• kit_timeout.sql
• lba_pkg.sql
• load_bag.sql
• load_where.sql
• loading_prog_by_time.sql
• loading_prohibited.sql
• loading_totals_report.sql
• locations_pkg.sql
• locations_pkg_spec.sql
• log_flight_event.sql
• lost_baggage_report.sql
• ltr.sql
• mach_fids.sql
• mail_bpm1.sql
• mail_bpm2.sql
• mail_bpm3.sql
• mail_bpm4.sql
• mail_pack.sql
• maintain_codeshare.sql
• maintain_report_config.sql
• make_sequence_no.sql
• map_class.sql
• mba_new_flights.sql
• mba_new_flt_warns.sql
• mba_new_warns.sql
• merge_bag.sql
• merge_one_bag.sql
• merge_uld.sql
• missed_track_type.sql
• missing_bag.sql
• missing_bag_spec.sql
• modify_flight.sql
• modify_flight_dests.sql
• modify_flight_status.sql
• modify_pax.sql
• modify_pax_bag_count.sql
• modify_uld_onwards_details.sql
• modify_uld_record.sql
• modify_uld_type.sql
• multi_flight_pax_and_bag_count.sql
• multi_site.sql
• mws_add_gate_pax.sql
• mws_add_gate_pax_and_bag.sql
• mws_flow_rate.sql
• mws_rename_uld.sql
• mws_tracking.sql
• mws_web.sql
• mws_web_spec.sql
• normalise_flight_no.sql
• offload_bag.sql
• onward_count.sql
• onward_flight_defs.sql
• onward_reports.sql
• pax_and_bag_count.sql
• pax_and_bag_counts_rec.sql
• pax_and_bag_counts_tab.sql
• pax_bag_count.sql
• pax_id.sql
• pax_id2.sql
• pax_match.sql
• pbc.sql
• pkg_bag_loading.sql
• pkg_bag_loading_spec.sql
• pkg_constants.sql
• pkg_inbound_flight_spec.sql
• pm_store.sql
• pre_clear_bag.sql
• priv_id_to_flt_access.sql
• proc1.sql
• proc2.sql
• proc3.sql
• proc4.sql
• proc5.sql
• proc6.sql
• proc7.sql
• proc8.sql
• process_btm.sql
• process_message_pkg.sql
• rec_uld_posn.sql
• reflighting.sql
• reflighting_config.sql
• remove_bag_from_uld.sql
• remove_uld_dests_record.sql
• rename_uld.sql
• reuse_bag.sql
• reuse_exception_bag.sql
• reuse_pax.sql
• reuse_rush_bag.sql
• revoke_all_by_flight.sql
• security_screening.sql
• set_bag_checkin.sql
• set_event_type.sql
• set_location.sql
• set_password.sql
• set_pax_vfdb.sql
• site_info_pkg.sql
• site_info_pkg_spec.sql
• sort_destination.sql
• sortation_system.sql
• sortation_system_spec.sql
• split_tags.sql
• stats_last_hour.sql
• stop_and_unstop.sql
• stop_reason.sql
• store_bmm_mail.sql
• store_bns_mail.sql
• store_bpm_user.sql
• store_uld_posn.sql
• sysint.sql
• terminal_config.sql
• terminating_count.sql
• through_uld.sql
• timezone_maintainance.sql
• tracking.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.sql
• tss_upd_pax_bags_class.sql
• tu_tagtrak_users_pack.sql
• uas_comma_to_table.sql
• uld_bag_weight.sql
• uld_cards.sql
• uld_cards_spec.sql
• uld_class_list.sql
• uld_destination.sql
• uld_id_list_tab.sql
• uld_ldg_prog.sql
• uld_ldg_prog_scanner.sql
• uld_loading_progress.sql
• uld_max_weight.sql
• uld_object.sql
• ulds_pkg.sql
• ulds_pkg_spec.sql
• unauthorised_bags.sql
• unknown_bag_bpm.sql
• unload_bag.sql
• unload_entire_flight.sql
• unload_entire_uld.sql
• unthrough_flight.sql
• untransfer_uld.sql
• update_bag.sql
• update_mct_record.sql
• update_security_messages_sts.sql
• user_authentication.sql
• user_login_pkg.sql
• user_maintenance.sql
• valid_address_stamp.sql
• valid_agent.sql
• validate_action.sql
• validate_bag_tag.sql
• validate_flight_direction.sql
• validate_uld_pos.sql
• wan_msg.sql
• weight_config.sql
• xfer_bag.sql
• yvr_get_std.sql