39: end_date CN_RT_QUOTA_ASGNS.END_DATE%TYPE);
40:
41: -- record type of the formula assignment summary
42: TYPE formula_rec_type IS RECORD
43: (calc_formula_id CN_RT_FORMULA_ASGNS.CALC_FORMULA_ID%TYPE,
44: formula_name CN_CALC_FORMULAS.NAME%TYPE,
45: formula_type CN_LOOKUPS.MEANING%TYPE,
46: start_date CN_RT_FORMULA_ASGNS.START_DATE%TYPE,
47: end_date CN_RT_FORMULA_ASGNS.END_DATE%TYPE);
42: TYPE formula_rec_type IS RECORD
43: (calc_formula_id CN_RT_FORMULA_ASGNS.CALC_FORMULA_ID%TYPE,
44: formula_name CN_CALC_FORMULAS.NAME%TYPE,
45: formula_type CN_LOOKUPS.MEANING%TYPE,
46: start_date CN_RT_FORMULA_ASGNS.START_DATE%TYPE,
47: end_date CN_RT_FORMULA_ASGNS.END_DATE%TYPE);
48:
49: TYPE rate_table_tbl_type IS TABLE OF rate_table_rec_type INDEX BY BINARY_INTEGER;
50: TYPE dims_tbl_type IS TABLE OF dim_rec_type INDEX BY BINARY_INTEGER;
43: (calc_formula_id CN_RT_FORMULA_ASGNS.CALC_FORMULA_ID%TYPE,
44: formula_name CN_CALC_FORMULAS.NAME%TYPE,
45: formula_type CN_LOOKUPS.MEANING%TYPE,
46: start_date CN_RT_FORMULA_ASGNS.START_DATE%TYPE,
47: end_date CN_RT_FORMULA_ASGNS.END_DATE%TYPE);
48:
49: TYPE rate_table_tbl_type IS TABLE OF rate_table_rec_type INDEX BY BINARY_INTEGER;
50: TYPE dims_tbl_type IS TABLE OF dim_rec_type INDEX BY BINARY_INTEGER;
51: TYPE parents_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;