sp_get_keycard_issue_info


Parameters

Name Type Mode
i_regiser_id integer IN (DEFAULT NULL)
i_booking_id integer IN (DEFAULT NULL)
i_room_id integer IN (DEFAULT NULL)
default_issue_qty integer IN (DEFAULT 0)
valid_from timestamp without time zone OUT
valid_until timestamp without time zone OUT
register_id integer OUT
booking_id integer OUT
room_id integer OUT
room_number t_room_number OUT
first_name text OUT
last_name text OUT
full_name text OUT
adult smallint OUT
intf_room_id text OUT
room_data jsonb OUT
remark text OUT
card_serial text OUT
card_index smallint OUT
access_code text OUT
agent text OUT
issued_qty integer OUT
max_cards integer OUT

Definition