Package - order_package
order_package is a package that contains procedures to manage orders.
- add_item_to_shopping_cart - Adds the product to the shopping cart.
If product already exists, it updates the quantity
- create_order - Creates orders based on the shopping cart contents
- print_order - Prints customer and order details based on order_id

Demonstrated features
- Loops:
- FOR i IN cursor LOOP ... END LOOP
- FOR i IN 1..N LOOP ... END LOOP
- FOR i IN (SELECT ...) LOOP ... END LOOP
- LOOP ... EXIT WHEN ... END LOOP
- Use of procedures, functions and types from other packages:-
- product_package.verify_product_availability
- customer_package.customer_record
- Collection type:
- TYPE ... IS VARRAY(10) OF ...
- VARRAY.COUNT
- SQL extensions and Built-in functions:
- DUAL
- SYSDATE
- DECODE
- TO_CHAR