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: );
147:
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: );
147:
148: ------------------------------
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: );
147:
148: ------------------------------
149: -- List of Defined Balances --
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;
163: type ListDimType is table of
164: pay_balance_dimensions.dimension_type%type
165: index by binary_integer;
160: type ListDbiSuffix is table of
161: pay_balance_dimensions.database_item_suffix%type
162: index by binary_integer;
163: type ListDimType is table of
164: pay_balance_dimensions.dimension_type%type
165: index by binary_integer;
166: type ListDimName is table of
167: pay_balance_dimensions.dimension_name%type
168: index by binary_integer;
163: type ListDimType is table of
164: pay_balance_dimensions.dimension_type%type
165: index by binary_integer;
166: type ListDimName is table of
167: pay_balance_dimensions.dimension_name%type
168: index by binary_integer;
169:
170: -- each PLSQL table type needs a NULL table with which
171: -- we can reset it, since we cannot use delete operator