145: type DefBal is record
146: (
147: bal_typid pay_balance_types.balance_type_id%type,
148: juris_lvl pay_balance_types.jurisdiction_level%type,
149: dbi_suffix pay_balance_dimensions.database_item_suffix%type,
150: dim_type pay_balance_dimensions.dimension_type%type,
151: dim_name pay_balance_dimensions.dimension_name%type
152: );
153:
146: (
147: bal_typid pay_balance_types.balance_type_id%type,
148: juris_lvl pay_balance_types.jurisdiction_level%type,
149: dbi_suffix pay_balance_dimensions.database_item_suffix%type,
150: dim_type pay_balance_dimensions.dimension_type%type,
151: dim_name pay_balance_dimensions.dimension_name%type
152: );
153:
154: ------------------------------
147: bal_typid pay_balance_types.balance_type_id%type,
148: juris_lvl pay_balance_types.jurisdiction_level%type,
149: dbi_suffix pay_balance_dimensions.database_item_suffix%type,
150: dim_type pay_balance_dimensions.dimension_type%type,
151: dim_name pay_balance_dimensions.dimension_name%type
152: );
153:
154: ------------------------------
155: -- List of Defined Balances --
163: type ListJurisLvl is table of
164: pay_balance_types.jurisdiction_level%type
165: index by binary_integer;
166: type ListDbiSuffix is table of
167: pay_balance_dimensions.database_item_suffix%type
168: index by binary_integer;
169: type ListDimType is table of
170: pay_balance_dimensions.dimension_type%type
171: index by binary_integer;
166: type ListDbiSuffix is table of
167: pay_balance_dimensions.database_item_suffix%type
168: index by binary_integer;
169: type ListDimType is table of
170: pay_balance_dimensions.dimension_type%type
171: index by binary_integer;
172: type ListDimName is table of
173: pay_balance_dimensions.dimension_name%type
174: index by binary_integer;
169: type ListDimType is table of
170: pay_balance_dimensions.dimension_type%type
171: index by binary_integer;
172: type ListDimName is table of
173: pay_balance_dimensions.dimension_name%type
174: index by binary_integer;
175:
176: -- each PLSQL table type needs a NULL table with which
177: -- we can reset it, since we cannot use delete operator