112: -- x_balancing_segment NUMBER;
113: x_account_segment NUMBER;
114: -- x_cost_ctr_segment NUMBER;
115:
116: x_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
117: -- x_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
118: -- x_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
113: x_account_segment NUMBER;
114: -- x_cost_ctr_segment NUMBER;
115:
116: x_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
117: -- x_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
118: -- x_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
114: -- x_cost_ctr_segment NUMBER;
115:
116: x_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
117: -- x_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
118: -- x_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
115:
116: x_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
117: -- x_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
118: -- x_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
116: x_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
117: -- x_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
118: -- x_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
117: -- x_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
118: -- x_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
118: -- x_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
119: -- x_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
120: -- x_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
121: x_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
122: -- x_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
123: -- x_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
124: -- x_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
125: -- x_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
126: -- x_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
127: -- x_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
128: -- x_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
129:
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
130: x_old_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
131: -- x_old_ia_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
132: -- x_old_ix_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
133: -- x_old_ia_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
134: -- x_old_ix_deprn_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
135: x_old_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
143:
136: -- x_old_ia_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
143:
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
137: -- x_old_ix_cip_cost_ccid fa_category_books.asset_cost_account_ccid%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
143:
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
138: -- x_old_ta_revaluation_ccid fa_category_books.asset_cost_account_ccid%TYPE;
139: -- x_old_ta_surplus_ccid fa_category_books.asset_cost_account_ccid%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
143:
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
140: -- x_old_ta_reserve_ccid fa_category_books.asset_cost_account_ccid%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
143:
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
141: -- x_old_ta_reserve_expense_ccid fa_category_books.asset_cost_account_ccid%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
143:
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
142: -- x_old_ta_reserve_recovery_ccid fa_category_books.asset_cost_account_ccid%TYPE;
143:
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
143:
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
144: x_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
145: x_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
146: x_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
147: x_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
148: x_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
156:
149: x_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
156:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
150: x_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
156:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
151: x_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
152: x_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
156:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
153: x_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
156:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
160: x_old_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
154: x_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
156:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
160: x_old_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
155: x_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
156:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
160: x_old_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
156:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
160: x_old_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
164:
157: x_old_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
160: x_old_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
164:
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
158: x_old_ia_cost_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
160: x_old_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
164:
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
166: x_old_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
159: x_old_ia_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
160: x_old_ia_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
164:
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
166: x_old_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
167: x_old_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
161: x_old_ta_revaluation_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
164:
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
166: x_old_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
167: x_old_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
168: x_old_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
162: x_old_ta_surplus_segm fa_category_books.asset_cost_acct%TYPE;
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
164:
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
166: x_old_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
167: x_old_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
168: x_old_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
170:
163: x_old_ta_reserve_segm fa_category_books.asset_cost_acct%TYPE;
164:
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
166: x_old_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
167: x_old_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
168: x_old_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
170:
171: x_natural_account fa_category_books.asset_cost_acct%TYPE;
164:
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
166: x_old_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
167: x_old_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
168: x_old_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
170:
171: x_natural_account fa_category_books.asset_cost_acct%TYPE;
172: x_natural_account1 fa_category_books.asset_cost_acct%TYPE;
165: x_old_ix_cost_segm fa_category_books.asset_cost_acct%TYPE;
166: x_old_ix_deprn_reserve_segm fa_category_books.asset_cost_acct%TYPE;
167: x_old_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
168: x_old_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
170:
171: x_natural_account fa_category_books.asset_cost_acct%TYPE;
172: x_natural_account1 fa_category_books.asset_cost_acct%TYPE;
173: x_returned_ccid fa_category_books.asset_cost_account_ccid%TYPE;
167: x_old_ix_cip_cost_segm fa_category_books.asset_cost_acct%TYPE;
168: x_old_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
170:
171: x_natural_account fa_category_books.asset_cost_acct%TYPE;
172: x_natural_account1 fa_category_books.asset_cost_acct%TYPE;
173: x_returned_ccid fa_category_books.asset_cost_account_ccid%TYPE;
174: x_concat_segs VARCHAR2(240);
175: x_return_value NUMBER;
168: x_old_ta_reserve_expense_segm fa_category_books.asset_cost_acct%TYPE;
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
170:
171: x_natural_account fa_category_books.asset_cost_acct%TYPE;
172: x_natural_account1 fa_category_books.asset_cost_acct%TYPE;
173: x_returned_ccid fa_category_books.asset_cost_account_ccid%TYPE;
174: x_concat_segs VARCHAR2(240);
175: x_return_value NUMBER;
176:
169: x_old_ta_reserve_recovery_segm fa_category_books.asset_cost_acct%TYPE;
170:
171: x_natural_account fa_category_books.asset_cost_acct%TYPE;
172: x_natural_account1 fa_category_books.asset_cost_acct%TYPE;
173: x_returned_ccid fa_category_books.asset_cost_account_ccid%TYPE;
174: x_concat_segs VARCHAR2(240);
175: x_return_value NUMBER;
176:
177: -----------------------------------------------------------------------------
429: global_attribute12,
430: global_attribute13,
431: global_attribute14,
432: global_attribute15
433: FROM fa_category_books
434: WHERE category_id = pc_category_id
435: AND book_type_code = pc_book_type_code ;
436:
437: -----------------------------------------------------------------------------
443: )
444: IS
445: SELECT reserve_account_ccid,
446: deprn_reserve_acct
447: FROM fa_category_books
448: WHERE category_id = pc_category_id
449: AND book_type_code = pc_book_type_code ;
450:
451: -----------------------------------------------------------------------------