66: --------------------------------------------------------------------
67: --Bug# :
68: TYPE AST_DTL_REC_TYPE is RECORD
69: (ASSET_NUMBER FA_ADDITIONS.ASSET_NUMBER%TYPE,
70: BOOK_TYPE_CODE FA_BOOKS.BOOK_TYPE_CODE%TYPE,
71: BOOK_CLASS FA_BOOK_CONTROLS.BOOK_CLASS%TYPE,
72: DEPRN_METHOD FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
73: DEPRN_METHOD_ID FA_METHODS.METHOD_ID%TYPE,
74: IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
68: TYPE AST_DTL_REC_TYPE is RECORD
69: (ASSET_NUMBER FA_ADDITIONS.ASSET_NUMBER%TYPE,
70: BOOK_TYPE_CODE FA_BOOKS.BOOK_TYPE_CODE%TYPE,
71: BOOK_CLASS FA_BOOK_CONTROLS.BOOK_CLASS%TYPE,
72: DEPRN_METHOD FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
73: DEPRN_METHOD_ID FA_METHODS.METHOD_ID%TYPE,
74: IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
75: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
70: BOOK_TYPE_CODE FA_BOOKS.BOOK_TYPE_CODE%TYPE,
71: BOOK_CLASS FA_BOOK_CONTROLS.BOOK_CLASS%TYPE,
72: DEPRN_METHOD FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
73: DEPRN_METHOD_ID FA_METHODS.METHOD_ID%TYPE,
74: IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
75: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
71: BOOK_CLASS FA_BOOK_CONTROLS.BOOK_CLASS%TYPE,
72: DEPRN_METHOD FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
73: DEPRN_METHOD_ID FA_METHODS.METHOD_ID%TYPE,
74: IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
75: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79: PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
72: DEPRN_METHOD FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
73: DEPRN_METHOD_ID FA_METHODS.METHOD_ID%TYPE,
74: IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
75: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79: PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
80: PRORATE_CONVENTION_CODE FA_BOOKS.PRORATE_CONVENTION_CODE%TYPE,
73: DEPRN_METHOD_ID FA_METHODS.METHOD_ID%TYPE,
74: IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
75: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79: PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
80: PRORATE_CONVENTION_CODE FA_BOOKS.PRORATE_CONVENTION_CODE%TYPE,
81: COST FA_BOOKS.COST%TYPE
74: IN_SERVICE_DATE FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
75: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79: PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
80: PRORATE_CONVENTION_CODE FA_BOOKS.PRORATE_CONVENTION_CODE%TYPE,
81: COST FA_BOOKS.COST%TYPE
82: );
75: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79: PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
80: PRORATE_CONVENTION_CODE FA_BOOKS.PRORATE_CONVENTION_CODE%TYPE,
81: COST FA_BOOKS.COST%TYPE
82: );
83: TYPE ast_dtl_tbl_type IS TABLE OF ast_dtl_rec_type INDEX BY BINARY_INTEGER;
76: BASIC_RATE FA_BOOKS.BASIC_RATE%TYPE,
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79: PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
80: PRORATE_CONVENTION_CODE FA_BOOKS.PRORATE_CONVENTION_CODE%TYPE,
81: COST FA_BOOKS.COST%TYPE
82: );
83: TYPE ast_dtl_tbl_type IS TABLE OF ast_dtl_rec_type INDEX BY BINARY_INTEGER;
84:
77: ADJUSTED_RATE FA_BOOKS.ADJUSTED_RATE%TYPE,
78: SALVAGE_VALUE FA_BOOKS.SALVAGE_VALUE%TYPE,
79: PERCENT_SALVAGE_VALUE FA_BOOKS.PERCENT_SALVAGE_VALUE%TYPE,
80: PRORATE_CONVENTION_CODE FA_BOOKS.PRORATE_CONVENTION_CODE%TYPE,
81: COST FA_BOOKS.COST%TYPE
82: );
83: TYPE ast_dtl_tbl_type IS TABLE OF ast_dtl_rec_type INDEX BY BINARY_INTEGER;
84:
85: --Bug# 3621875