1 PACKAGE FA_API_TYPES AUTHID CURRENT_USER as
2 /* $Header: FAPTYPES.pls 120.40.12020000.2 2012/11/30 10:47:59 gigupta ship $ */
3
4 -----------------------------------------
5 -- Public Types Used Only Within Types --
6 -----------------------------------------
7
8 -------------------------
9 -- Standard Who Record --
10 -------------------------
11
12 TYPE standard_who_rec_type IS RECORD (
13 last_update_date DATE DEFAULT sysdate,
14 last_updated_by NUMBER(15) DEFAULT fnd_global.user_id,
15 created_by NUMBER(15) DEFAULT fnd_global.user_id,
16 creation_date DATE DEFAULT sysdate,
17 last_update_login NUMBER(15) DEFAULT fnd_global.login_id);
18
19 -----------------------------
20 -- Descriptive Flex Record --
21 -----------------------------
22
23 TYPE desc_flex_rec_type IS RECORD (
24 attribute1 VARCHAR2(150) ,
25 attribute2 VARCHAR2(150) ,
26 attribute3 VARCHAR2(150) ,
27 attribute4 VARCHAR2(150) ,
28 attribute5 VARCHAR2(150) ,
29 attribute6 VARCHAR2(150) ,
30 attribute7 VARCHAR2(150) ,
31 attribute8 VARCHAR2(150) ,
32 attribute9 VARCHAR2(150) ,
33 attribute10 VARCHAR2(150) ,
34 attribute11 VARCHAR2(150) ,
35 attribute12 VARCHAR2(150) ,
36 attribute13 VARCHAR2(150) ,
37 attribute14 VARCHAR2(150) ,
38 attribute15 VARCHAR2(150) ,
39 attribute16 VARCHAR2(150) ,
40 attribute17 VARCHAR2(150) ,
41 attribute18 VARCHAR2(150) ,
42 attribute19 VARCHAR2(150) ,
43 attribute20 VARCHAR2(150) ,
44 attribute21 VARCHAR2(150) ,
45 attribute22 VARCHAR2(150) ,
46 attribute23 VARCHAR2(150) ,
47 attribute24 VARCHAR2(150) ,
48 attribute25 VARCHAR2(150) ,
49 attribute26 VARCHAR2(150) ,
50 attribute27 VARCHAR2(150) ,
51 attribute28 VARCHAR2(150) ,
52 attribute29 VARCHAR2(150) ,
53 attribute30 VARCHAR2(150) ,
54 attribute_category_code VARCHAR2(210) ,
55 context VARCHAR2(210)
56 );
57
58 ------------------
59 -- Public Types --
60 ------------------
61
62 -- Asset Transaction Recordure
63 TYPE trans_rec_type IS RECORD (
64 transaction_header_id NUMBER ,
65 transaction_type_code VARCHAR2(20) ,
66 transaction_date_entered DATE ,
67 transaction_name VARCHAR2(30) ,
68 source_transaction_header_id NUMBER ,
69 mass_reference_id NUMBER ,
70 transaction_subtype VARCHAR2(9) ,
71 transaction_key VARCHAR2(2) ,
72 amortization_start_date DATE ,
73 calling_interface VARCHAR2(30) DEFAULT 'CUSTOM',
74 mass_transaction_id NUMBER ,
75 deprn_override_flag VARCHAR2(1) DEFAULT 'N' ,
76 member_transaction_header_id NUMBER ,
77 trx_reference_id NUMBER ,
78 event_id NUMBER ,
79 desc_flex DESC_FLEX_rec_type ,
80 who_info STANDARD_WHO_rec_type
81 );
82
83 --------------------------------------------------------
84 -- Information used to uniquely identify an asset --
85 -- Neither asset_id and book_type_code cannot be null --
86 --------------------------------------------------------
87
88 TYPE asset_hdr_rec_type IS RECORD (
89 asset_id NUMBER(15) ,
90 book_type_code VARCHAR2(15) ,
91 set_of_books_id NUMBER(15) ,
92 period_of_addition VARCHAR2(1)
93 );
94 -----------------------------------
95 -- Descriptive asset information --
96 -----------------------------------
97
98 TYPE asset_desc_rec_type IS RECORD (
99 asset_number VARCHAR2(15) ,
100 description VARCHAR2(80) ,
101 tag_number VARCHAR2(15) ,
102 serial_number VARCHAR2(35) ,
103 asset_key_ccid NUMBER ,
104 parent_asset_id NUMBER ,
105 manufacturer_name VARCHAR2(360) ,
106 model_number VARCHAR2(40) ,
107 warranty_id NUMBER ,
108 lease_id NUMBER ,
109 in_use_flag VARCHAR2(3) ,
110 inventorial VARCHAR2(3) ,
111 commitment VARCHAR2(150) ,
112 investment_law VARCHAR2(150) ,
113 property_type_code VARCHAR2(10) ,
114 property_1245_1250_code VARCHAR2(4) ,
115 owned_leased VARCHAR2(15) ,
116 new_used VARCHAR2(4) ,
117 current_units NUMBER ,
118 unit_adjustment_flag VARCHAR2(3) ,
119 add_cost_je_flag VARCHAR2(3) ,
120 status VARCHAR2(150) ,
121 lease_desc_flex DESC_FLEX_rec_type,
122 global_desc_flex DESC_FLEX_rec_type
123 );
124
125 TYPE asset_type_rec_type IS RECORD (
126 asset_type VARCHAR2(11) DEFAULT 'CAPITALIZED'
127 );
128
129 TYPE asset_cat_rec_type IS RECORD (
130 category_id NUMBER ,
131 desc_flex DESC_FLEX_REC_TYPE
132 );
133
134 TYPE asset_hierarchy_rec_type IS RECORD (
135 parent_hierarchy_id NUMBER
136 );
137
138 TYPE asset_hr_attr_rec_type IS RECORD (
139 category_id NUMBER ,
140 serial_number VARCHAR2(35) ,
141 lease_id NUMBER ,
142 asset_key_ccid NUMBER ,
143 dist_set_id NUMBER ,
144 life_in_months NUMBER ,
145 prorate_date DATE );
146
147 TYPE asset_hr_options_rec_type IS RECORD (
148 event_code VARCHAR2(30),
149 status_code VARCHAR2(2),
150 source_entity_name VARCHAR2(30),
151 source_entity_value VARCHAR2(30),
152 source_attribute_name VARCHAR2(30),
153 source_attribute_old_id VARCHAR2(30),
154 source_attribute_new_id VARCHAR2(30),
155 amortization_start_date DATE,
156 amortize_flag VARCHAR2(3),
157 description VARCHAR2(50),
158 rejection_reason_code VARCHAR2(30),
159 concurrent_request_id NUMBER,
160 batch_id NUMBER
161 );
162
163 ---------------------------------
164 -- Asset Financial Information --
165 ---------------------------------
166
167 TYPE asset_fin_rec_type IS RECORD (
168 set_of_books_id NUMBER,
169 date_placed_in_service DATE,
170 deprn_start_date DATE,
171 deprn_method_code VARCHAR2(12),
172 life_in_months NUMBER,
173 rate_adjustment_factor NUMBER,
174 adjusted_cost NUMBER,
175 cost NUMBER,
176 original_cost NUMBER,
177 salvage_value NUMBER,
178 prorate_convention_code VARCHAR2(10),
179 prorate_date DATE,
180 cost_change_flag VARCHAR2(3),
181 adjustment_required_status VARCHAR2(4),
182 capitalize_flag VARCHAR2(3),
183 retirement_pending_flag VARCHAR2(3),
184 depreciate_flag VARCHAR2(3),
185 disabled_flag VARCHAR2(1), --HH group enable disable
186 itc_amount_id NUMBER,
187 itc_amount NUMBER,
188 retirement_id NUMBER,
189 tax_request_id NUMBER,
190 itc_basis NUMBER,
191 basic_rate NUMBER,
192 adjusted_rate NUMBER,
193 bonus_rule VARCHAR2(30),
194 ceiling_name VARCHAR2(30),
195 recoverable_cost NUMBER,
196 adjusted_capacity NUMBER,
197 fully_rsvd_revals_counter NUMBER,
198 idled_flag VARCHAR2(3),
199 period_counter_capitalized NUMBER,
200 period_counter_fully_reserved NUMBER,
201 period_counter_fully_retired NUMBER,
202 production_capacity NUMBER,
203 reval_amortization_basis NUMBER,
204 reval_ceiling NUMBER,
205 unit_of_measure VARCHAR2(25),
206 unrevalued_cost NUMBER,
207 annual_deprn_rounding_flag VARCHAR2(5),
208 percent_salvage_value NUMBER,
209 allowed_deprn_limit NUMBER,
210 allowed_deprn_limit_amount NUMBER,
211 period_counter_life_complete NUMBER,
212 adjusted_recoverable_cost NUMBER,
213 annual_rounding_flag VARCHAR2(5),
214 eofy_adj_cost NUMBER,
215 eofy_formula_factor NUMBER,
216 short_fiscal_year_flag VARCHAR2(3),
217 conversion_date DATE,
218 orig_deprn_start_date DATE,
219 remaining_life1 NUMBER,
220 remaining_life2 NUMBER,
221 group_asset_id NUMBER ,
222 old_adjusted_cost NUMBER,
223 formula_factor NUMBER,
224 -- start new fields for group
225 salvage_type VARCHAR2(30),
226 deprn_limit_type VARCHAR2(30),
227 over_depreciate_option VARCHAR2(30),
228 super_group_id NUMBER,
229 reduction_rate NUMBER,
230 reduce_addition_flag VARCHAR2(1),
231 reduce_adjustment_flag VARCHAR2(1),
232 reduce_retirement_flag VARCHAR2(1),
233 -- start of modificaton by toru
234 recognize_gain_loss VARCHAR2(30),
235 recapture_reserve_flag VARCHAR2(1),
236 limit_proceeds_flag VARCHAR2(1),
237 terminal_gain_loss VARCHAR2(30),
238 tracking_method VARCHAR2(30),
239 exclude_fully_rsv_flag VARCHAR2(1),
240 excess_allocation_option VARCHAR2(30),
241 depreciation_option VARCHAR2(30),
242 member_rollup_flag VARCHAR2(1),
243 ytd_proceeds NUMBER,
244 ltd_proceeds NUMBER,
245 allocate_to_fully_rsv_flag VARCHAR2(1),
246 allocate_to_fully_ret_flag VARCHAR2(1),
247 eofy_reserve NUMBER,
248 cip_cost NUMBER,
249 terminal_gain_loss_amount NUMBER,
250 ltd_cost_of_removal NUMBER,
251 -- end of modificaton by toru
252 -- start of modification by hsugimot
253 prior_eofy_reserve NUMBER,
254 eop_adj_cost NUMBER,
255 eop_formula_factor NUMBER,
256 -- end of modification by hsugimot
257 -- start of modification by hhiraga
258 exclude_proceeds_from_basis VARCHAR2(1),
259 retirement_deprn_option VARCHAR2(30),
260 -- end of modification by hhiraga
261 terminal_gain_loss_flag VARCHAR2(1),
262 -- ias36 impairment variables
263 cash_generating_unit_id NUMBER,
264 -- end ias36
265 extended_deprn_flag VARCHAR2(1), -- Japan Tax phase3
266 extended_depreciation_period NUMBER, -- Japan Tax phase3
267 period_counter_fully_extended NUMBER, -- Japan Bug 6645061
268 nbv_at_switch NUMBER, -- -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
269 prior_deprn_limit_type VARCHAR2(30) ,
270 prior_deprn_limit_amount NUMBER ,
271 prior_deprn_limit NUMBER ,
272 period_full_reserve VARCHAR2(30),
273 period_extd_deprn VARCHAR2(30),
277 prior_adjusted_rate NUMBER ,
274 prior_deprn_method VARCHAR2(30) ,
275 prior_life_in_months NUMBER ,
276 prior_basic_rate NUMBER ,
278 rate_in_use NUMBER , --phase5
279 mass_addition_id NUMBER, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
280 dry_hole_flag VARCHAR2(1), --- For AFE Reclass
281 contract_id Number, -- Bug:6021567
282 contract_change_flag boolean DEFAULT FALSE, -- Bug:6950629
283 global_attribute1 VARCHAR2(150) ,
284 global_attribute2 VARCHAR2(150) ,
285 global_attribute3 VARCHAR2(150) ,
286 global_attribute4 VARCHAR2(150) ,
287 global_attribute5 VARCHAR2(150) ,
288 global_attribute6 VARCHAR2(150) ,
289 global_attribute7 VARCHAR2(150) ,
290 global_attribute8 VARCHAR2(150) ,
291 global_attribute9 VARCHAR2(150) ,
292 global_attribute10 VARCHAR2(150) ,
293 global_attribute11 VARCHAR2(150) ,
294 global_attribute12 VARCHAR2(150) ,
295 global_attribute13 VARCHAR2(150) ,
296 global_attribute14 VARCHAR2(150) ,
297 global_attribute15 VARCHAR2(150) ,
298 global_attribute16 VARCHAR2(150) ,
299 global_attribute17 VARCHAR2(150) ,
300 global_attribute18 VARCHAR2(150) ,
301 global_attribute19 VARCHAR2(150) ,
302 global_attribute20 VARCHAR2(150) ,
303 global_attribute_category VARCHAR2(150)
304 );
305
306 TYPE asset_deprn_rec_type IS RECORD (
307 set_of_books_id NUMBER,
308 deprn_amount NUMBER,
309 ytd_deprn NUMBER,
310 deprn_reserve NUMBER,
311 prior_fy_expense NUMBER,
312 bonus_deprn_amount NUMBER,
313 bonus_ytd_deprn NUMBER,
314 bonus_deprn_reserve NUMBER,
315 prior_fy_bonus_expense NUMBER,
316 reval_amortization NUMBER,
317 reval_amortization_basis NUMBER,
318 reval_deprn_expense NUMBER,
319 reval_ytd_deprn NUMBER,
320 reval_deprn_reserve NUMBER,
321 reval_loss_balance NUMBER,
322 production NUMBER,
323 ytd_production NUMBER,
324 ltd_production NUMBER,
325 impairment_amount NUMBER,
326 ytd_impairment NUMBER,
327 impairment_reserve NUMBER,
328 allow_taxup_flag BOOLEAN
329 );
330
331 TYPE asset_dist_rec_type IS RECORD (
332 distribution_id NUMBER,
333 units_assigned NUMBER,
334 transaction_units NUMBER,
335 assigned_to NUMBER,
336 expense_ccid NUMBER,
337 location_ccid NUMBER
338 );
339
340 TYPE asset_dist_tbl_type IS TABLE OF asset_dist_rec_type index by binary_integer;
341
342
343 -- Reclass Options
344 TYPE reclass_options_rec_type IS RECORD(
345 copy_cat_desc_flag VARCHAR2(3),
346 redefault_flag VARCHAR2(3),
347 -- redefault_group_flag VARCHAR2(3),
348 mass_request_id NUMBER );
349
350 -- Group Reclass Options
351 TYPE group_reclass_options_rec_type IS RECORD (
352 transfer_flag varchar2(3),
353 manual_flag varchar2(3),
354 manual_amount number,
355 group_reclass_type varchar2(30),
356 reserve_amount number,
357 source_exp_amount number,
358 destination_exp_amount number,
359 source_eofy_reserve number,
360 destination_eofy_reserve number);
361
362 -- Revaluation Options
363 TYPE reval_options_rec_type IS RECORD (
364 reval_percent NUMBER,
365 value_type VARCHAR2(3), -- Bug#6666666 SORP
366 mass_reval_id NUMBER, -- Bug#6666666 SORP
367 linked_flag VARCHAR2(3), -- Bug#6666666 SORP
368 reval_type_flag VARCHAR2(3), -- Bug#6666666 SORP
369 override_defaults_flag VARCHAR2(1),
370 reval_fully_rsvd_flag VARCHAR2(1),
371 life_extension_factor NUMBER,
372 life_extension_ceiling NUMBER,
373 max_fully_rsvd_revals NUMBER,
374 run_mode VARCHAR2(15),
375 period_end_reval_flag VARCHAR2(1)); --ER 14644811
376
377 -- The following record types have been introduced by Retirement API
378
379 -- Sub record type
380 TYPE asset_retire_det_rec_type IS RECORD (
381 asset_id NUMBER,
382 book_type_code VARCHAR2(15),
383 transaction_header_id_in NUMBER,
384 transaction_header_id_out NUMBER,
385 nbv_retired NUMBER,
386 gain_loss_amount NUMBER,
387 gain_loss_type_code VARCHAR2(15),
388 itc_recaptured NUMBER,
389 itc_recapture_id NUMBER,
390 stl_method_code VARCHAR2(12),
391 stl_life_in_months NUMBER,
392 stl_deprn_amount NUMBER,
393 reval_reserve_retired NUMBER,
394 unrevalued_cost_retired NUMBER,
395 bonus_reserve_retired NUMBER,
396 recapture_amount NUMBER,
397 row_id VARCHAR2(150)
398 );
399
400 -- Main record type
401 TYPE asset_retire_rec_type IS RECORD (
402 retirement_id NUMBER,
403 date_retired DATE,
404 units_retired NUMBER,
408 retirement_type_code VARCHAR2(15),
405 cost_retired NUMBER,
406 proceeds_of_sale NUMBER,
407 cost_of_removal NUMBER,
409 retirement_prorate_convention VARCHAR2(10),
410 sold_to VARCHAR2(30),
411 trade_in_asset_id VARCHAR2(15),
412 reference_num VARCHAR2(15),
413 status VARCHAR2(15),
414 recognize_gain_loss VARCHAR2(30),
415 recapture_reserve_flag VARCHAR2(1),
416 limit_proceeds_flag VARCHAR2(1),
417 terminal_gain_loss VARCHAR2(30),
418 reserve_retired NUMBER,
419 eofy_reserve NUMBER,
420 reduction_rate NUMBER,
421 calculate_gain_loss varchar2(1),
422 detail_info asset_retire_det_rec_type,
423 desc_flex desc_flex_rec_type
424 );
425
426 -- Information used to retire subcomponents of an asset.
427 TYPE subcomp_rec_type IS RECORD
428 (asset_id NUMBER,
429 parent_flag varchar2(1) := FND_API.G_FALSE
430 );
431
432 TYPE subcomp_tbl_type IS TABLE OF subcomp_rec_type index by binary_integer;
433
434 -- Record type used to store (current) period info
435 TYPE period_rec_type IS RECORD
436 (period_name VARCHAR2(15),
437 period_counter NUMBER,
438 period_open_date DATE,
439 period_close_date DATE,
440 calendar_period_open_date DATE,
441 calendar_period_close_date DATE,
442 deprn_run VARCHAR2(1),
443 period_num NUMBER,
444 fiscal_year NUMBER,
445 fy_start_date DATE,
446 fy_end_date DATE
447 );
448
449 -- end of Retirement API
450
451 ----------------------------------------------------------------------------
452 -- Invoice info - because tbl_typeles of invoice exist, we could not include
453 -- the descriptive flex rec_typeure due to PLS-507
454 ----------------------------------------------------------------------------
455
456 ------------------------------
457 -- MRC conversion rate info --
458 ------------------------------
459
460 TYPE inv_rate_rec_type IS RECORD (
461 inv_indicator NUMBER ,
462 set_of_books_id NUMBER ,
463 exchange_rate NUMBER ,
464 cost NUMBER
465 );
466
467 TYPE inv_rate_tbl_type IS TABLE OF inv_rate_rec_type index by binary_integer;
468
469 TYPE inv_rec_type IS RECORD (
470 po_vendor_id NUMBER,
471 asset_invoice_id NUMBER,
472 fixed_assets_cost NUMBER,
473 deleted_flag varchar2(3),
474 po_number varchar2(20),
475 invoice_number varchar2(50),
476 payables_batch_name varchar2(50),
477 payables_code_combination_id NUMBER,
478 feeder_system_name varchar2(40),
479 create_batch_date DATE,
480 create_batch_id NUMBER,
481 invoice_date DATE,
482 payables_cost NUMBER,
483 post_batch_id NUMBER,
484 invoice_id NUMBER,
485 ap_distribution_line_number NUMBER,
486 payables_units NUMBER,
487 split_merged_code varchar2(3),
488 description varchar2(80),
489 parent_mass_addition_id VARCHAR2(15),
490 unrevalued_cost NUMBER,
491 merged_code varchar2(3),
492 split_code varchar2(3),
493 merge_parent_mass_additions_id NUMBER,
494 split_parent_mass_additions_id NUMBER,
495 project_asset_line_id NUMBER,
496 project_id NUMBER,
497 task_id NUMBER,
498 source_line_id NUMBER,
499 prior_source_line_id NUMBER,
500 material_indicator_flag varchar2(1),
501 attribute1 varchar2(150),
502 attribute2 varchar2(150),
503 attribute3 varchar2(150),
504 attribute4 varchar2(150),
505 attribute5 varchar2(150),
506 attribute6 varchar2(150),
507 attribute7 varchar2(150),
508 attribute8 varchar2(150),
509 attribute9 varchar2(150),
510 attribute10 varchar2(150),
511 attribute11 varchar2(150),
512 attribute12 varchar2(150),
513 attribute13 varchar2(150),
514 attribute14 varchar2(150),
515 attribute15 varchar2(150),
516 attribute_category_code varchar2(150),
517
518 cip_cost NUMBER,
519 depreciate_in_group_flag varchar2(1),
520
521 inv_indicator NUMBER ,
522 ytd_deprn NUMBER ,
523 deprn_reserve NUMBER ,
524 bonus_ytd_deprn NUMBER ,
525 bonus_deprn_reserve NUMBER ,
526 reval_amortization_basis NUMBER ,
527 reval_ytd_deprn NUMBER ,
528 reval_deprn_reserve NUMBER ,
529 source_dest_code VARCHAR2(15),
530 invoice_distribution_id NUMBER,
531 invoice_line_number NUMBER,
535
532 po_distribution_id NUMBER,
533 inv_rate_tbl inv_rate_tbl_type
534 );
536 TYPE inv_tbl_type IS TABLE OF inv_rec_type index by binary_integer;
537
538
539 ---------------------------------
540 -- Tax Reserve Adjustment info --
541 ---------------------------------
542
543 TYPE asset_tax_rsv_adj_rec_type IS RECORD (
544 fiscal_year NUMBER,
545 adjusted_ytd_deprn NUMBER,
546 deprn_basis_formula VARCHAR2(30),
547 deprn_adj_factor NUMBER,
548 max_period_ctr_adjusted NUMBER,
549 min_period_ctr_adjusted NUMBER,
550 run_mode VARCHAR2(15)
551 );
552
553
554 ---------------------------------------------------
555 -- Private Types (used within internals of APIs) --
556 ---------------------------------------------------
557
558 TYPE asset_fin_tbl_type IS TABLE OF asset_fin_rec_type index by binary_integer;
559
560 TYPE asset_deprn_tbl_type IS TABLE OF asset_deprn_rec_type index by binary_integer;
561
562 TYPE inv_trans_rec_type IS RECORD (
563 invoice_transaction_id NUMBER ,
564 transaction_type VARCHAR2(20)
565 );
566
567 ------------------------------------------
568 -- Standard types for FA Table Handlers --
569 ------------------------------------------
570
571 TYPE unplanned_deprn_rec_type IS RECORD (
572 code_combination_id NUMBER,
573 unplanned_amount NUMBER,
574 unplanned_type VARCHAR2(9)
575 );
576
577 TYPE trx_ref_rec_type is RECORD (
578 TRX_REFERENCE_ID NUMBER(15),
579 TRANSACTION_TYPE VARCHAR2(30),
580 SRC_TRANSACTION_SUBTYPE VARCHAR2(30),
581 DEST_TRANSACTION_SUBTYPE VARCHAR2(30),
582 BOOK_TYPE_CODE VARCHAR2(15),
583 SRC_ASSET_ID NUMBER(15),
584 SRC_TRANSACTION_HEADER_ID NUMBER(15),
585 DEST_ASSET_ID NUMBER(15),
586 DEST_TRANSACTION_HEADER_ID NUMBER(15),
587 MEMBER_ASSET_ID NUMBER(15),
588 MEMBER_TRANSACTION_HEADER_ID NUMBER(15),
589 SRC_AMORTIZATION_START_DATE DATE,
590 DEST_AMORTIZATION_START_DATE DATE,
591 RESERVE_TRANSFER_AMOUNT NUMBER,
592 SRC_EXPENSE_AMOUNT NUMBER,
593 DEST_EXPENSE_AMOUNT NUMBER,
594 SRC_EOFY_RESERVE NUMBER,
595 DEST_EOFY_RESERVE NUMBER);
596
597
598
599 /*
600
601 ------------------------------------------
602 -- Standard types for FA Table Handlers --
603 ------------------------------------------
604
605 -- FA_ADDITIONS
606
607 TYPE Asset_Id_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_ID%TYPE
608 INDEX BY BINARY_INTEGER;
609
610 TYPE Asset_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_NUMBER%TYPE
611 INDEX BY BINARY_INTEGER;
612
613 TYPE Asset_Key_Ccid_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_KEY_CCID%TYPE
614 INDEX BY BINARY_INTEGER;
615
616 TYPE Units_tbl_type IS TABLE OF FA_ADDITIONS_B.CURRENT_UNITS%TYPE
617 INDEX BY BINARY_INTEGER;
618
619 TYPE Asset_Type_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_TYPE%TYPE
620 INDEX BY BINARY_INTEGER;
621
622 TYPE Tag_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.TAG_NUMBER%TYPE
623 INDEX BY BINARY_INTEGER;
624
625 TYPE Description_tbl_type IS TABLE OF FA_ADDITIONS_TL.DESCRIPTION%TYPE
626 INDEX BY BINARY_INTEGER;
627
628 TYPE Category_Id_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_CATEGORY_ID%TYPE
629 INDEX BY BINARY_INTEGER;
630
631 TYPE Manufacturer_Name_tbl_type IS TABLE OF FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE
632 INDEX BY BINARY_INTEGER;
633
634 TYPE Serial_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.SERIAL_NUMBER%TYPE
635 INDEX BY BINARY_INTEGER;
636
637 TYPE Model_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.MODEL_NUMBER%TYPE
638 INDEX BY BINARY_INTEGER;
639
640 TYPE Property_Type_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.PROPERTY_TYPE_CODE%TYPE
641 INDEX BY BINARY_INTEGER;
642
643 TYPE Property_1245_1250_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.PROPERTY_1245_1250_CODE%TYPE
644 INDEX BY BINARY_INTEGER;
645
646 TYPE In_Use_Flag_tbl_type IS TABLE OF FA_ADDITIONS_B.IN_USE_FLAG%TYPE
647 INDEX BY BINARY_INTEGER;
648
649 TYPE Owned_Leased_tbl_type IS TABLE OF FA_ADDITIONS_B.OWNED_LEASED%TYPE
650 INDEX BY BINARY_INTEGER;
651
652 TYPE New_Used_tbl_type IS TABLE OF FA_ADDITIONS_B.NEW_USED%TYPE
653 INDEX BY BINARY_INTEGER;
654
655 TYPE Unit_Adjustment_Flag_tbl_type IS TABLE OF FA_ADDITIONS_B.UNIT_ADJUSTMENT_FLAG%TYPE
656 INDEX BY BINARY_INTEGER;
657
658 TYPE Add_Cost_Je_Flag_tbl_type IS TABLE OF FA_ADDITIONS_B.ADD_COST_JE_FLAG%TYPE
659 INDEX BY BINARY_INTEGER;
660
661 TYPE Attribute_tbl_type IS TABLE OF FA_ADDITIONS_B.ATTRIBUTE1%TYPE
662 INDEX BY BINARY_INTEGER;
663
664 TYPE Attribute_Category_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.ATTRIBUTE_CATEGORY_CODE%TYPE
665 INDEX BY BINARY_INTEGER;
666
667 TYPE gf_Attribute IS TABLE OF FA_ADDITIONS_B.GLOBAL_ATTRIBUTE1%TYPE
668 INDEX BY BINARY_INTEGER;
669
670 TYPE gf_Attribute_Category_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE
671 INDEX BY BINARY_INTEGER;
672
673 TYPE Context_tbl_type IS TABLE OF FA_ADDITIONS_B.CONTEXT%TYPE
674 INDEX BY BINARY_INTEGER;
675
676 TYPE Lease_Id_tbl_type IS TABLE OF FA_ADDITIONS_B.LEASE_ID%TYPE
680 INDEX BY BINARY_INTEGER;
677 INDEX BY BINARY_INTEGER;
678
679 TYPE Inventorial_tbl_type IS TABLE OF FA_ADDITIONS_B.INVENTORIAL%TYPE
681
682
683 ----------------
684 -- not needed --
685 ----------------
686
687 -- TYPE Last_Update_Date_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATE_DATE%TYPE
688 -- INDEX BY BINARY_INTEGER;
689 --
690 -- TYPE Last_Updated_By_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATED_BY%TYPE
691 -- INDEX BY BINARY_INTEGER;
692 --
693 -- TYPE Created_By_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATED_BY%TYPE
694 -- INDEX BY BINARY_INTEGER;
695 --
696 -- TYPE Creation_Date_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATION_DATE%TYPE
697 -- INDEX BY BINARY_INTEGER;
698 --
699 -- TYPE Last_Update_Login_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATE_LOGIN%TYPE
700 -- INDEX BY BINARY_INTEGER;
701 --
702
703
704 -------------
705 -- generic --
706 -------------
707
708 TYPE updated_by_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATED_BY%TYPE
709 INDEX BY BINARY_INTEGER;
710
711 TYPE Date_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATION_DATE%TYPE
712 INDEX BY BINARY_INTEGER;
713
714 TYPE Login_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATE_LOGIN%TYPE
715 INDEX BY BINARY_INTEGER;
716
717
718 --------------------
719 -- FA_ADJUSTMENTS --
720 --------------------
721 TYPE Source_Type_Code_tbl_type IS TABLE OF FA_ADJUSTMENTS.source_type_code%TYPE
722 INDEX BY BINARY_INTEGER;
723
724 TYPE Adjustment_Type_tbl_type IS TABLE OF FA_ADJUSTMENTS.adjustment_type%TYPE
725 INDEX BY BINARY_INTEGER;
726
727 TYPE Debit_Credit_Flag_tbl_type IS TABLE OF FA_ADJUSTMENTS.debit_credit_flag%TYPE
728 INDEX BY BINARY_INTEGER;
729
730 TYPE Annualized_Adjustment_tbl_type IS TABLE OF FA_ADJUSTMENTS.annualized_adjustment%TYPE
731 INDEX BY BINARY_INTEGER;
732
733
734
735 -- FA_ASSET_INVOICES
736
737 TYPE Po_Vendor_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.Po_Vendor_Id%TYPE
738 INDEX BY BINARY_INTEGER;
739
740 TYPE Asset_Invoice_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.Asset_Invoice_id%TYPE
741 INDEX BY BINARY_INTEGER;
742
743 TYPE Deleted_Flag_tbl_type IS TABLE OF FA_ASSET_INVOICES.deleted_flag%TYPE
744 INDEX BY BINARY_INTEGER;
745
746 TYPE Po_Number_tbl_type IS TABLE OF FA_ASSET_INVOICES.po_number%TYPE
747 INDEX BY BINARY_INTEGER;
748
749 TYPE Invoice_Number_tbl_type IS TABLE OF FA_ASSET_INVOICES.invoice_number%TYPE
750 INDEX BY BINARY_INTEGER;
751
752 TYPE Payables_Batch_Name_tbl_type IS TABLE OF FA_ASSET_INVOICES.payables_batch_name%TYPE
753 INDEX BY BINARY_INTEGER;
754
755 TYPE Feeder_System_Name_tbl_type IS TABLE OF FA_ASSET_INVOICES.feeder_system_name%TYPE
756 INDEX BY BINARY_INTEGER;
757
758 TYPE Create_Batch_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.create_batch_id%TYPE
759 INDEX BY BINARY_INTEGER;
760
761 TYPE Post_Batch_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.post_batch_id%TYPE
762 INDEX BY BINARY_INTEGER;
763
764 TYPE Invoice_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.invoice_id%TYPE
765 INDEX BY BINARY_INTEGER;
766
767 TYPE Ap_Dist_Line_Num_tbl_type IS TABLE OF FA_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER%TYPE
768 INDEX BY BINARY_INTEGER;
769
770 TYPE Split_Merged_Code_tbl_type IS TABLE OF FA_ASSET_INVOICES.split_merged_code%TYPE
771 INDEX BY BINARY_INTEGER;
772
773 TYPE Mass_Addition_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.parent_mass_addition_id%TYPE
774 INDEX BY BINARY_INTEGER;
775
776 TYPE Merged_Code_tbl_type IS TABLE OF FA_ASSET_INVOICES.merged_code%TYPE
777 INDEX BY BINARY_INTEGER;
778
779 TYPE Split_Code_tbl_type IS TABLE OF FA_ASSET_INVOICES.split_code%TYPE
780 INDEX BY BINARY_INTEGER;
781
782 TYPE Project_Asset_Line_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.project_asset_line_id%TYPE
783 INDEX BY BINARY_INTEGER;
784
785 TYPE Project_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.project_id%TYPE
786 INDEX BY BINARY_INTEGER;
787
788 TYPE Task_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.task_id%TYPE
789 INDEX BY BINARY_INTEGER;
790
791 -----------------------------------
792 -- FA_ASSET_INVOICE_TRANSACTIONS --
793 -----------------------------------
794
795 TYPE Invoice_thid_tbl_type IS TABLE OF FA_INVOICE_TRANSACTIONS.invoice_transaction_id%TYPE
796 INDEX BY BINARY_INTEGER;
797
798 TYPE Transaction_Type_tbl_type IS TABLE OF FA_INVOICE_TRANSACTIONS.transaction_type%TYPE
799 INDEX BY BINARY_INTEGER;
800
801
802 ------------------------
803 -- FA_ASSET_INVOICES --
804 ------------------------
805
806
807 --------------
808 -- FA_BOOKS --
809 --------------
810
811 TYPE Deprn_Method_Code_tbl_type IS TABLE OF FA_BOOKS.Deprn_Method_Code%TYPE
812 INDEX BY BINARY_INTEGER;
813
814 TYPE Life_In_Months_tbl_type IS TABLE OF FA_BOOKS.Life_In_Months%TYPE
815 INDEX BY BINARY_INTEGER;
816
817 TYPE Rate_Adjustment_Factor_tbl_type IS TABLE OF FA_BOOKS.Rate_Adjustment_Factor%TYPE
818 INDEX BY BINARY_INTEGER;
819
820 TYPE Cost_tbl_type IS TABLE OF FA_BOOKS.cost%TYPE
821 INDEX BY BINARY_INTEGER;
822
823 TYPE Prorate_Convention_Code_tbl_type IS TABLE OF FA_BOOKS.Prorate_Convention_Code%TYPE
824 INDEX BY BINARY_INTEGER;
825
829 TYPE Adjustment_Required_Status_tbl_type IS TABLE OF FA_BOOKS.Adjustment_Required_Status%TYPE
826 TYPE Cost_Change_Flag_tbl_type IS TABLE OF FA_BOOKS.Cost_Change_Flag%TYPE
827 INDEX BY BINARY_INTEGER;
828
830 INDEX BY BINARY_INTEGER;
831
832 TYPE Capitalize_Flag_tbl_type IS TABLE OF FA_BOOKS.Capitalize_Flag%TYPE
833 INDEX BY BINARY_INTEGER;
834
835 TYPE Retirement_Pending_Flag_tbl_type IS TABLE OF FA_BOOKS.Retirement_Pending_Flag%TYPE
836 INDEX BY BINARY_INTEGER;
837
838 TYPE Depreciate_Flag_tbl_type IS TABLE OF FA_BOOKS.Depreciate_Flag%TYPE
839 INDEX BY BINARY_INTEGER;
840
841 TYPE Itc_Amount_Id_tbl_type IS TABLE OF FA_BOOKS.Itc_Amount_Id%TYPE
842 INDEX BY BINARY_INTEGER;
843
844 TYPE Itc_Amount_tbl_type IS TABLE OF FA_BOOKS.Itc_Amount%TYPE
845 INDEX BY BINARY_INTEGER;
846
847 TYPE Retirement_Id_tbl_type IS TABLE OF FA_BOOKS.Retirement_Id%TYPE
848 INDEX BY BINARY_INTEGER;
849
850 TYPE Tax_Request_Id_tbl_type IS TABLE OF FA_BOOKS.Tax_Request_Id%TYPE
851 INDEX BY BINARY_INTEGER;
852
853 TYPE Itc_Basis_tbl_type IS TABLE OF FA_BOOKS.Itc_Basis%TYPE
854 INDEX BY BINARY_INTEGER;
855
856 TYPE Basic_Rate_tbl_type IS TABLE OF FA_BOOKS.Basic_Rate%TYPE
857 INDEX BY BINARY_INTEGER;
858
859 TYPE Adjusted_Rate_tbl_type IS TABLE OF FA_BOOKS.Adjusted_Rate%TYPE
860 INDEX BY BINARY_INTEGER;
861
862 TYPE Bonus_Rule_tbl_type IS TABLE OF FA_BOOKS.Bonus_Rule%TYPE
863 INDEX BY BINARY_INTEGER;
864
865 TYPE Ceiling_Name_tbl_type IS TABLE OF FA_BOOKS.Ceiling_Name%TYPE
866 INDEX BY BINARY_INTEGER;
867
868 TYPE Adjusted_Capacity_tbl_type IS TABLE OF FA_BOOKS.Adjusted_Capacity%TYPE
869 INDEX BY BINARY_INTEGER;
870
871 TYPE Fully_Rsvd_Revals_Counter_tbl_type IS TABLE OF FA_BOOKS.Fully_Rsvd_Revals_Counter%TYPE
872 INDEX BY BINARY_INTEGER;
873
874 TYPE Idled_Flag_tbl_type IS TABLE OF FA_BOOKS.Idled_Flag%TYPE
875 INDEX BY BINARY_INTEGER;
876
877 TYPE Production_Capacity_tbl_type IS TABLE OF FA_BOOKS.Production_Capacity%TYPE
878 INDEX BY BINARY_INTEGER;
879
880 TYPE Reval_Amortization_Basis_tbl_type IS TABLE OF FA_BOOKS.Reval_Amortization_Basis%TYPE
881 INDEX BY BINARY_INTEGER;
882
883 TYPE Reval_Ceiling_tbl_type IS TABLE OF FA_BOOKS.Reval_Ceiling%TYPE
884 INDEX BY BINARY_INTEGER;
885
886 TYPE Unit_Of_Measure_tbl_type IS TABLE OF FA_BOOKS.Unit_Of_Measure%TYPE
887 INDEX BY BINARY_INTEGER;
888
889 TYPE Annual_Deprn_Rounding_Flag_tbl_type IS TABLE OF FA_BOOKS.Annual_Deprn_Rounding_Flag%TYPE
890 INDEX BY BINARY_INTEGER;
891
892 TYPE Percent_Salvage_Value_tbl_type IS TABLE OF FA_BOOKS.Percent_Salvage_Value%TYPE
893 INDEX BY BINARY_INTEGER;
894
895 TYPE Allowed_Deprn_Limit_tbl_type IS TABLE OF FA_BOOKS.Allowed_Deprn_Limit%TYPE
896 INDEX BY BINARY_INTEGER;
897
898 TYPE Allowed_Deprn_Limit_Amount_tbl_type IS TABLE OF FA_BOOKS.Allowed_Deprn_Limit_Amount%TYPE
899 INDEX BY BINARY_INTEGER;
900
901 TYPE Short_Fiscal_Year_Flag_tbl_type IS TABLE OF FA_BOOKS.Short_Fiscal_Year_Flag%TYPE
902 INDEX BY BINARY_INTEGER;
903
904 TYPE Remaining_Life1_tbl_type IS TABLE OF FA_BOOKS.Remaining_Life1%TYPE
905 INDEX BY BINARY_INTEGER;
906
907 TYPE Remaining_Life2_tbl_type IS TABLE OF FA_BOOKS.Remaining_Life2%TYPE
908 INDEX BY BINARY_INTEGER;
909
910 TYPE Formula_Factor_tbl_type IS TABLE OF FA_BOOKS.Formula_Factor%TYPE
911 INDEX BY BINARY_INTEGER;
912
913 TYPE Group_Asset_ID_tbl_type IS TABLE OF FA_BOOKS.Group_Asset_ID%TYPE
914 INDEX BY BINARY_INTEGER;
915
916
917 -----------------------------
918 -- FA_DISTRIBUTION_HISTORY --
919 -----------------------------
920
921 TYPE DISTRIBUTION_ID_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.DISTRIBUTION_ID%TYPE
922 INDEX BY BINARY_INTEGER;
923
924 TYPE CODE_COMBINATION_ID_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.CODE_COMBINATION_ID%TYPE
925 INDEX BY BINARY_INTEGER;
926
927 TYPE LOCATION_ID_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.LOCATION_ID%TYPE
928 INDEX BY BINARY_INTEGER;
929
930 TYPE ASSIGNED_TO_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.ASSIGNED_TO%TYPE
931 INDEX BY BINARY_INTEGER;
932
933
934 ----------------------
935 -- FA_DEPRN_SUMMARY --
936 ----------------------
937
938
939 TYPE DS_Deprn_Source_Code_tbl_type IS TABLE OF FA_DEPRN_SUMMARY.DEPRN_SOURCE_CODE%TYPE
940 INDEX BY BINARY_INTEGER;
941
942 TYPE Bonus_Rate_tbl_type IS TABLE OF FA_DEPRN_SUMMARY.BONUS_RATE%TYPE
943 INDEX BY BINARY_INTEGER;
944
945
946
947 ---------------------
948 -- FA_DEPRN_DETAIL --
949 ---------------------
950
951 TYPE DD_Deprn_Source_Code_tbl_type IS TABLE OF FA_DEPRN_DETAIL.DEPRN_SOURCE_CODE%TYPE
952 INDEX BY BINARY_INTEGER;
953
954 TYPE je_line_num_tbl_type IS TABLE OF FA_DEPRN_DETAIL.deprn_expense_je_line_num%TYPE
955 INDEX BY BINARY_INTEGER;
956
957 TYPE je_header_id_tbl_type IS TABLE OF FA_DEPRN_DETAIL.je_header_id%TYPE
958 INDEX BY BINARY_INTEGER;
959
960 ------------------------------
961 -- FA_TRANSACTION_HEADERS --
962 ------------------------------
963
964 TYPE thid_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE
965 INDEX BY BINARY_INTEGER;
969
966
967 TYPE Book_Type_Code_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
968 INDEX BY BINARY_INTEGER;
970 TYPE pc_tbl_type IS TABLE OF FA_DEPRN_PERIODS.PERIOD_COUNTER%TYPE
971 INDEX BY BINARY_INTEGER;
972
973 TYPE TRANSACTION_TYPE_CODE_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_TYPE_CODE%TYPE
974 INDEX BY BINARY_INTEGER;
975
976 TYPE TRANSACTION_NAME_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_NAME%TYPE
977 INDEX BY BINARY_INTEGER;
978
979 TYPE INVOICE_TRANSACTION_ID_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID%TYPE
980 INDEX BY BINARY_INTEGER;
981
982 TYPE MASS_REFERENCE_ID_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.MASS_REFERENCE_ID%TYPE
983 INDEX BY BINARY_INTEGER;
984
985 TYPE TRANSACTION_SUBTYPE_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_SUBTYPE%TYPE
986 INDEX BY BINARY_INTEGER;
987
988 TYPE TRANSACTION_KEY_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_KEY%TYPE
989 INDEX BY BINARY_INTEGER;
990
991 -----------------------
992 -- FA_MASS_ADDITIONS --
993 -----------------------
994 TYPE warranty_id_tbl_type IS TABLE OF FA_MASS_ADDITIONS.warranty_id%type
995 index by binary_integer;
996 TYPE lessor_id_tbl_type IS TABLE OF FA_MASS_ADDITIONS.lessor_id%type
997 index by binary_integer;
998 TYPE new_master_flag_tbl_type IS TABLE OF FA_MASS_ADDITIONS.new_master_flag%type
999 index by binary_integer;
1000 TYPE amortize_flag_tbl_type IS TABLE OF FA_MASS_ADDITIONS.amortize_flag%type
1001 index by binary_integer;
1002
1003 */
1004
1005 -- Lease Procedure
1006
1007 TYPE LEASE_DETAILS_REC_TYPE IS RECORD (
1008 LEASE_ID NUMBER,
1009 LEASE_NUMBER VARCHAR2(15),
1010 LESSOR_ID NUMBER(15),
1011 LESSOR_NAME VARCHAR2(240),
1012 LESSOR_SITE_ID NUMBER(15),
1013 LESSOR_SITE VARCHAR2(15),
1014 LESSOR_SITE_ORG_ID NUMBER(15),
1015 PAYMENT_SCHEDULE_ID NUMBER(15),
1016 PAYMENT_SCHEDULE_NAME VARCHAR2(30),
1017 DESCRIPTION VARCHAR2(30),
1018 CURRENCY_CODE VARCHAR2(5),
1019 LEASE_TYPE VARCHAR2(15),
1020 DIST_CODE_COMBINATION_ID NUMBER(15),
1021 CON_DIST_CODE_COMBINATION VARCHAR2(250),
1022 TERMS_ID NUMBER(15),
1023 PAYMENT_TERMS VARCHAR2(50),
1024 TRANSFER_OWNERSHIP VARCHAR2(1),
1025 BARGAIN_PURCHASE_OPTION VARCHAR2(1),
1026 FAIR_VALUE NUMBER,
1027 ASSET_LIFE NUMBER,
1028 LEASE_TERM NUMBER,
1029 DESC_FLEX DESC_FLEX_rec_type
1030 );
1031
1032 TYPE LEASE_SCHEDULES_REC_TYPE IS RECORD (
1033 PAYMENT_SCHEDULE_ID NUMBER,
1034 PAYMENT_SCHEDULE_NAME VARCHAR2(30),
1035 PRESENT_VALUE NUMBER,
1036 INTEREST_RATE NUMBER,
1037 LEASE_INCEPTION_DATE DATE,
1038 CURRENCY_CODE VARCHAR2(5),
1039 FREQUENCY VARCHAR2(15)
1040 );
1041
1042 TYPE LEASE_PAYMENTS_REC_TYPE IS RECORD (
1043 PAYMENT_SCHEDULE_ID NUMBER,
1044 START_DATE DATE,
1045 PAYMENT_AMOUNT NUMBER,
1046 NUMBER_OF_PAYMENTS NUMBER,
1047 PAYMENT_TYPE VARCHAR2(1)
1048 );
1049
1050 TYPE LEASE_PAYMENTS_TBL_TYPE IS TABLE OF LEASE_PAYMENTS_REC_TYPE
1051 INDEX BY BINARY_INTEGER;
1052
1053 TYPE LOG_LEVEL_REC_TYPE IS RECORD (
1054 STATEMENT_LEVEL BOOLEAN,
1055 PROCEDURE_LEVEL BOOLEAN,
1056 EVENT_LEVEL BOOLEAN,
1057 EXCEPTION_LEVEL BOOLEAN,
1058 ERROR_LEVEL BOOLEAN,
1059 UNEXPECTED_LEVEL BOOLEAN,
1060 CURRENT_RUNTIME_LEVEL NUMBER,
1061 INITIALIZED BOOLEAN DEFAULT FALSE
1062 );
1063
1064
1065 ---------------------------------
1066 -- Transaction Interface Table --
1067 ---------------------------------
1068 TYPE trans_interface_rec_type IS RECORD(
1069 TRANSACTION_INTERFACE_ID NUMBER(15),
1070 TRANSACTION_DATE DATE,
1071 TRANSACTION_TYPE_CODE VARCHAR2(30),
1072 POSTING_STATUS VARCHAR2(30),
1073 BOOK_TYPE_CODE VARCHAR2(15),
1074 ASSET_KEY_PROJECT_VALUE VARCHAR2(30),
1075 ASSET_KEY_HIERARCHY_VALUE VARCHAR2(30),
1076 ASSET_KEY_NEW_HIERARCHY_VALUE VARCHAR2(30),
1077 REFERENCE_NUMBER NUMBER,
1078 COMMENTS VARCHAR2(80),
1079 CONCURRENT_REQUEST_ID NUMBER(15),
1080 CREATED_BY NUMBER(15),
1081 CREATION_DATE DATE,
1082 LAST_UPDATED_BY NUMBER(15),
1083 LAST_UPDATE_DATE DATE,
1084 LAST_UPDATE_LOGIN NUMBER(15));
1085
1086 --Bug 8941132: Creating new structure for Amortization InitMemberTable
1087
1088 TYPE tab_num15_type IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
1089 TYPE tab_num_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1090 -----------------------------------
1091 -- Amortization InitMemberTable --
1092 -----------------------------------
1093 TYPE amort_init_rec_type IS RECORD(
1094 tmd_period_counter tab_num15_type,
1095 tmd_cost tab_num_type,
1096 tm_cost tab_num_type,
1097 tmd_cip_cost tab_num_type,
1101 tmd_deprn_limit_amount tab_num_type,
1098 tm_cip_cost tab_num_type,
1099 tmd_salvage_value tab_num_type,
1100 tm_salvage_value tab_num_type,
1102 tm_deprn_limit_amount tab_num_type);
1103
1104 END FA_API_TYPES;
1105