| procedure | type | parameter | datatype | in/out |
|---|---|---|---|---|
| film_in_stock | P | p_film_id | INT | IN |
| film_in_stock | P | p_store_id | INT | IN |
| film_in_stock | P | p_film_count | INT | OUT |
| film_not_in_stock | P | p_film_id | INT | IN |
| film_not_in_stock | P | p_store_id | INT | IN |
| film_not_in_stock | P | p_film_count | INT | OUT |
| rewards_report | P | min_monthly_purchases | TINYINT UNSIGNED | IN |
| rewards_report | P | min_dollar_amount_purchased | DECIMAL(10,2) UNSIGNED | IN |
| rewards_report | P | count_rewardees | INT | OUT |
| get_customer_balance | FN | p_customer_id | INT | |
| get_customer_balance | FN | p_effective_date | DATETIME | |
| inventory_held_by_customer | FN | p_inventory_id | INT | |
| inventory_in_stock | FN | p_inventory_id | INT |