[Home] [Help]
4: /* A Record to hold the neccessary attributes of norm items */
5: TYPE norm_item_rec IS RECORD (
6: schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE
7: ,schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE
8: ,normalized_amount PN_PAYMENT_ITEMS_ALL.actual_amount%TYPE
9: );
10:
11: /* Declare a PL/SQL table type of above record */
12: TYPE norm_item_tbl_type IS TABLE OF norm_item_rec INDEX BY BINARY_INTEGER;