Le Datasource
SANDALSWEB
    Les Tables:
        agentcan
        certifie
        dual
        ecards
        resorts
        ecards_manager
        ecards_manager_roles
        dual
        obe_help_topics
        obe_help_contents
        obe_setup
        obe_server
        sales_manager
        SANDALS_NIGHTS
        SANDALS_NIGHTS_EVENTS
        SANDALS_NIGHTS_RSVP
        BROCHURES

    Le Procs:
        web_pack.insert_brochure
        web_pack.log_wrong_referral
        obe_pack.insert_obe_timetaken
        web_pack_uk.save_contact_request
        obe_pack.insert_obe_timetaken
        obe_pack.get_countries_usa_ca
        obe_pack.get_states
        obe_pack.get_resort_gateways
        obe_pack.get_obe_setup
        obe_pack.get_obe_links
        obe_pack.get_rollover_help
        obe_pack.get_obe_setup
        obe_pack.get_room_categories
        obe_pack.get_obeservers
        obe_pack.get_obeservers_by_updateflag
        obe_pack.update_obeservers_app
        web_pack_uk.insert_brochure_uk
        web_pack_uk.check_brochure_uk_user
        web_pack_uk.get_brochure_request
        web_pack_uk.log_user
        web_pack_uk.brochurebymonth
        web_pack_uk.brochurebyday
        web_pack_uk.brochure_log
        brochure_package.save_erequest
        brochure_package.get_daily_requests_uk
        brochure_package.get_monthly_requests_uk
        brochure_package.get_requests_uk
        web_pack.insert_brochure
        brochure_package.check_email
        brochure_package.write_brochure_email
        brochure_package.optin_reply
        spa_pack.resort_getall_spa
        spa_pack.resort_getone
        spa_pack.category_getall
        spa_pack.treatment_getall
        OBEADMIN.GetUserInfo
        obeadmin.change_manager_status
        obeadmin.GetAllManagers
        obeadmin.GetManager
        obeadmin.get_manager_security
        obeadmin.delete_manager_security
        obe_pack.insert_obe_timetaken
        obeadmin.update_security_app
        obeadmin.update_security_feature
        obeadmin.Update_Manager
        obeadmin.update_Manager_Password
        obeadmin.LoginCheck
        obeadmin.Create_Manager

DGS_MySQL
    Les Tables:
        Resoluiton
        compensations
        Satisfaction
        GuestInfo
        Issue
        vwguestinfo
        IssueActions
        User


    Proc:
        SP_Resoliton_delete
        SP_Resolution_getByIssueID
        SP_IssueActions_insert
        SP_Satisfaction_getAll
        SP_User_getAll
        SP_Favors_getAll
        SP_Report_getissuesByResort
        SP_GuestInfo_getByBookingNum
        SP_GuestInfo_get
        SP_GuestInfo_insert
        SP_Report_getClosedIssues
        SP_User_getByUserName
        SP_Testimonial_getSpecialFeatured
        SP_Testimonial_getAllFeatured
        SP_Testimonial_getAllFeaturedCount
        SP_Role_getAll
        SP_Report_getPendingissues
        SP_Report_getissuesByDept
        SP_Resolution_getByIssueID
        Last_Insert_ID
        SP_GuestInfo_getByBookingNum
        SP_GuestInfo_get
        SP_GuestInfo_insert
        SP_Report_getIssueByRoom
        SP_User_insert
        SP_User_update
        SP_User_delete
        SP_User_getByUserId
        SP_User_getAllRoles
        SP_User_inserPermission
        SP_User_updatePermission
        SP_User_deletePermission
        SP_Issue_getIDByGroupid
        SP_Issue_getIDByGuest
        SP_Issue_update
        SP_Issue_delete
        SP_Issue_Insert
        SP_Issue_get

CTS_Oracle
    Les Tables:
        Department_codes

ETS
    Les Procs:
        ets_global.get_general
        ets_global.department_procedures
        ets_global.timezones_procedures
        ets_objects.profiles_selects
        ets_objects.insert_profile
        ets_objects.update_profile_openissues
        ets_objects.get_operator_openprofiles
        ets_objects.update_operator_issues
        ets_objects.insert_issue

Media
    Les Tables:
        image_data
        dual
        press_resorts
        press

    Les Procs:
        image_package.save_image
        image_package.get_image
        image_package.get_images
        image_package.delete_image
        group_package.save_group
        group_package.get_group
        group_package.get_groups
        group_package.delete_group
        gallery_group_package.save_gallery_group
        gallery_group_package.get_gallery_group
        gallery_group_package.get_gallery_groups
        gallery_group_package.delete_gallery_group
        image_gallery_package.save_image_gallery
        image_gallery_package.get_image_gallery
        image_gallery_package.get_image_galleries
        image_gallery_package.delete_image_gallery
        image_data_package.delete_image_data
        gallery_package.save_gallery
        gallery_package.get_gallery
        gallery_package.get_galleries
        gallery_package.delete_gallery

Press
    Les Tables:
        images
        dual


    Les Procs:
        agency_package.save_agency
        agency_package.get_agency
        agency_package.get_agencies
        agency_package.delete_agency
        kit_package.save_kit
        kit_package.get_kit
        kit_package.get_kits
        kit_package.delete_kit
        release_package.save_release
        release_package.get_release
        release_package.get_releases
        release_package.get_resort_releases
        release_package.get_kit_releases
        release_package.delete_release
        release_package.save_release_image
        release_package.get_release_images
        release_package.delete_release_image
        release_package.search_description
        release_package.get_archive_years
        contact_package.save_contact
        contact_package.get_contact
        contact_package.get_contacts
        contact_package.delete_contact
        contact_package.save_request
        contact_package.get_contact_requests
        contact_package.get_contact_requests_by_date
        contact_package.close_contact_request
        article_package.save_article
        article_package.save_pdf
        article_package.get_article
        article_package.get_articles
        article_package.get_resort_articles
        article_package.delete_article

unique_villas
    Les Tables:
        rates
        wg_newsletter

webgold:
    Les Procs:
        WHOLESALER_PAK.search_name_mv
        WHOLESALER_PAK.search_wholesaler
        WHOLESALER_PAK.gold_name_id
        WHOLESALER_PAK.get_wholesalers
        WHOLESALER_PAK.create_wholesaler
        WHOLESALER_PAK.update_wholesaler
        WHOLESALER_PAK.delete_wholesaler
        obe_pack.check_wholesaler
        obe_pack.get_ssg_spending_points
        obe_pack.log_server_in_booking
        obe_pack.log_commision_junction
        obe_pack.log_airTime
        obe_pack.get_ssg_spending_points
        obe_pack.log_server_in_booking
        obe_pack.log_commision_junction
        obe_pack.log_airTime
        obe_pack.get_ssg_spending_points
        obe_pack.log_commision_junction
        obe_pack.log_airTime
        obe_pack.get_invoice_id
        obe_pack.get_ssg_spending_points
        obe_pack.log_server_in_booking
        obe_pack.log_commision_junction
        obe_pack.log_airTime
        obe_pack.get_invoice_id
        EVENT_Scheduler_PKG.Insert_Evt_Schedule_Inventory
        EVENT_Scheduler_PKG.Update_Evt_Schedule_Inventory
        EVENT_Scheduler.Get_Inventory
        EVENT_Scheduler.Get_Schedule_Inventory
        EVENT_Scheduler_PKG.Insert_Event_Schedule
        EVENT_Scheduler_PKG.Update_Event_Schedule
        EVENT_Scheduler.Get_Event_Schedule
        EVENT_Scheduler.Get_Event_Schedules
        EVENT_Scheduler_PKG.Insert_Schedule
        EVENT_Scheduler.Get_event_Schedule
        EVENT_Scheduler_PKG.Insert_Event
        EVENT_Scheduler_PKG.Update_Event
        EVENT_Scheduler.Get_Event
        EVENT_Scheduler.get_Events
        EVENT_Scheduler_PKG.Insert_Event_Schedule_Rate
        EVENT_Scheduler_PKG.Update_Event_Schedule_Rate
        EVENT_Scheduler.Get_Event_Schedule_Rate
        EVENT_Scheduler.Get_Event_Schedule_Rates
        EVENT_Scheduler.Get_Resorts