137: -- Defined Balance --
138: ---------------------
139: type DefBal is record
140: (
141: bal_typid pay_balance_types.balance_type_id%type,
142: juris_lvl pay_balance_types.jurisdiction_level%type,
143: dbi_suffix pay_balance_dimensions.database_item_suffix%type,
144: dim_type pay_balance_dimensions.dimension_type%type,
145: dim_name pay_balance_dimensions.dimension_name%type
138: ---------------------
139: type DefBal is record
140: (
141: bal_typid pay_balance_types.balance_type_id%type,
142: juris_lvl pay_balance_types.jurisdiction_level%type,
143: dbi_suffix pay_balance_dimensions.database_item_suffix%type,
144: dim_type pay_balance_dimensions.dimension_type%type,
145: dim_name pay_balance_dimensions.dimension_name%type
146: );
151: -- BHOMAN - can't PLSQL tables of records, so replace DefBalList
152: -- with individual tables for each element
153: -- type DefBalList is table of DefBal index by binary_integer;
154: type ListBalTypeId is table of
155: pay_balance_types.balance_type_id%type
156: index by binary_integer;
157: type ListJurisLvl is table of
158: pay_balance_types.jurisdiction_level%type
159: index by binary_integer;
154: type ListBalTypeId is table of
155: pay_balance_types.balance_type_id%type
156: index by binary_integer;
157: type ListJurisLvl is table of
158: pay_balance_types.jurisdiction_level%type
159: index by binary_integer;
160: type ListDbiSuffix is table of
161: pay_balance_dimensions.database_item_suffix%type
162: index by binary_integer;