PROMPT CREATE OR REPLACE PACKAGE unauthorised_bags
CREATE OR REPLACE PACKAGE unauthorised_bags AS

    FUNCTION ok_to_fly (
          p_flight_id IN flight.flight_id%TYPE
        , p_pax_id    IN pax.pax_id%TYPE
        , p_bag_tag2b IN bag.bag_tag2b%TYPE
        , p_bag_tag3  IN bag.bag_tag3%TYPE
    ) RETURN unauthorised_bag.ok_to_fly%TYPE;

    FUNCTION count_authorised_bags (
        p_flight_id IN flight.flight_id%TYPE
    ) RETURN NUMBER;

END unauthorised_bags;
/

PROMPT CREATE OR REPLACE PACKAGE BODY unauthorised_bags
CREATE OR REPLACE PACKAGE BODY unauthorised_bags AS

    FUNCTION ok_to_fly (
          p_flight_id IN flight.flight_id%TYPE
        , p_pax_id    IN pax.pax_id%TYPE
        , p_bag_tag2b IN bag.bag_tag2b%TYPE
        , p_bag_tag3  IN bag.bag_tag3%TYPE
    ) RETURN unauthorised_bag.ok_to_fly%TYPE AS
    BEGIN
        RETURN 0;
    END;

    FUNCTION count_authorised_bags (
        p_flight_id IN flight.flight_id%TYPE
    ) RETURN NUMBER AS
    BEGIN
        RETURN 0;
    END;

END unauthorised_bags;
/

