1 PACKAGE FA_API_TYPES as
2 /* $Header: FAPTYPES.pls 120.33.12010000.1 2008/07/28 13:13:28 appldev 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(30) ,
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 dry_hole_flag VARCHAR2(1), --- For AFE Reclass
266 contract_id Number, -- Bug:6021567
267 contract_change_flag boolean DEFAULT FALSE, -- Bug:6950629
268 extended_deprn_flag VARCHAR2(1), -- Japan Tax phase3
269 extended_depreciation_period NUMBER, -- Japan Tax phase3
270 period_counter_fully_extended NUMBER, -- Japan Tax phase3
271 nbv_at_switch NUMBER, -- Bug 6665510: FP: Japan Tax Reform Project
272 global_attribute1 VARCHAR2(150) ,
273 global_attribute2 VARCHAR2(150) ,
274 global_attribute3 VARCHAR2(150) ,
275 global_attribute4 VARCHAR2(150) ,
276 global_attribute5 VARCHAR2(150) ,
277 global_attribute6 VARCHAR2(150) ,
278 global_attribute7 VARCHAR2(150) ,
279 global_attribute8 VARCHAR2(150) ,
280 global_attribute9 VARCHAR2(150) ,
281 global_attribute10 VARCHAR2(150) ,
282 global_attribute11 VARCHAR2(150) ,
283 global_attribute12 VARCHAR2(150) ,
284 global_attribute13 VARCHAR2(150) ,
285 global_attribute14 VARCHAR2(150) ,
286 global_attribute15 VARCHAR2(150) ,
287 global_attribute16 VARCHAR2(150) ,
288 global_attribute17 VARCHAR2(150) ,
289 global_attribute18 VARCHAR2(150) ,
290 global_attribute19 VARCHAR2(150) ,
291 global_attribute20 VARCHAR2(150) ,
292 global_attribute_category VARCHAR2(150)
293 );
294
295 TYPE asset_deprn_rec_type IS RECORD (
296 set_of_books_id NUMBER,
297 deprn_amount NUMBER,
301 bonus_deprn_amount NUMBER,
298 ytd_deprn NUMBER,
299 deprn_reserve NUMBER,
300 prior_fy_expense NUMBER,
302 bonus_ytd_deprn NUMBER,
303 bonus_deprn_reserve NUMBER,
304 prior_fy_bonus_expense NUMBER,
305 reval_amortization NUMBER,
306 reval_amortization_basis NUMBER,
307 reval_deprn_expense NUMBER,
308 reval_ytd_deprn NUMBER,
309 reval_deprn_reserve NUMBER,
310 production NUMBER,
311 ytd_production NUMBER,
312 ltd_production NUMBER,
313 impairment_amount NUMBER,
314 ytd_impairment NUMBER,
315 impairment_reserve NUMBER
316 );
317
318 TYPE asset_dist_rec_type IS RECORD (
319 distribution_id NUMBER,
320 units_assigned NUMBER,
321 transaction_units NUMBER,
322 assigned_to NUMBER,
323 expense_ccid NUMBER,
324 location_ccid NUMBER
325 );
326
327 TYPE asset_dist_tbl_type IS TABLE OF asset_dist_rec_type index by binary_integer;
328
329
330 -- Reclass Options
331 TYPE reclass_options_rec_type IS RECORD(
332 copy_cat_desc_flag VARCHAR2(3),
333 redefault_flag VARCHAR2(3),
334 -- redefault_group_flag VARCHAR2(3),
335 mass_request_id NUMBER );
336
337 -- Group Reclass Options
338 TYPE group_reclass_options_rec_type IS RECORD (
339 transfer_flag varchar2(3),
340 manual_flag varchar2(3),
341 manual_amount number,
342 group_reclass_type varchar2(30),
343 reserve_amount number,
344 source_exp_amount number,
345 destination_exp_amount number,
346 source_eofy_reserve number,
347 destination_eofy_reserve number);
348
349 -- Revaluation Options
350 TYPE reval_options_rec_type IS RECORD (
351 reval_percent NUMBER,
352 override_defaults_flag VARCHAR2(1),
353 reval_fully_rsvd_flag VARCHAR2(1),
354 life_extension_factor NUMBER,
355 life_extension_ceiling NUMBER,
356 max_fully_rsvd_revals NUMBER,
357 run_mode VARCHAR2(15));
358
359 -- The following record types have been introduced by Retirement API
360
361 -- Sub record type
362 TYPE asset_retire_det_rec_type IS RECORD (
363 asset_id NUMBER,
364 book_type_code VARCHAR2(15),
365 transaction_header_id_in NUMBER,
366 transaction_header_id_out NUMBER,
367 nbv_retired NUMBER,
368 gain_loss_amount NUMBER,
369 gain_loss_type_code VARCHAR2(15),
370 itc_recaptured NUMBER,
371 itc_recapture_id NUMBER,
372 stl_method_code VARCHAR2(12),
373 stl_life_in_months NUMBER,
374 stl_deprn_amount NUMBER,
375 reval_reserve_retired NUMBER,
376 unrevalued_cost_retired NUMBER,
377 bonus_reserve_retired NUMBER,
378 recapture_amount NUMBER,
379 row_id VARCHAR2(150)
380 );
381
382 -- Main record type
383 TYPE asset_retire_rec_type IS RECORD (
384 retirement_id NUMBER,
385 date_retired DATE,
386 units_retired NUMBER,
387 cost_retired NUMBER,
388 proceeds_of_sale NUMBER,
389 cost_of_removal NUMBER,
390 retirement_type_code VARCHAR2(15),
391 retirement_prorate_convention VARCHAR2(10),
392 sold_to VARCHAR2(30),
393 trade_in_asset_id VARCHAR2(15),
394 reference_num VARCHAR2(15),
395 status VARCHAR2(15),
396 recognize_gain_loss VARCHAR2(30),
397 recapture_reserve_flag VARCHAR2(1),
398 limit_proceeds_flag VARCHAR2(1),
399 terminal_gain_loss VARCHAR2(30),
400 reserve_retired NUMBER,
401 eofy_reserve NUMBER,
402 reduction_rate NUMBER,
403 calculate_gain_loss varchar2(1),
404 detail_info asset_retire_det_rec_type,
405 desc_flex desc_flex_rec_type
406 );
407
408 -- Information used to retire subcomponents of an asset.
409 TYPE subcomp_rec_type IS RECORD
410 (asset_id NUMBER,
411 parent_flag varchar2(1) := FND_API.G_FALSE
412 );
413
414 TYPE subcomp_tbl_type IS TABLE OF subcomp_rec_type index by binary_integer;
415
416 -- Record type used to store (current) period info
417 TYPE period_rec_type IS RECORD
418 (period_name VARCHAR2(15),
419 period_counter NUMBER,
420 period_open_date DATE,
421 period_close_date DATE,
422 calendar_period_open_date DATE,
423 calendar_period_close_date DATE,
427 fy_start_date DATE,
424 deprn_run VARCHAR2(1),
425 period_num NUMBER,
426 fiscal_year NUMBER,
428 fy_end_date DATE
429 );
430
431 -- end of Retirement API
432
433 ----------------------------------------------------------------------------
434 -- Invoice info - because tbl_typeles of invoice exist, we could not include
435 -- the descriptive flex rec_typeure due to PLS-507
436 ----------------------------------------------------------------------------
437
438 ------------------------------
439 -- MRC conversion rate info --
440 ------------------------------
441
442 TYPE inv_rate_rec_type IS RECORD (
443 inv_indicator NUMBER ,
444 set_of_books_id NUMBER ,
445 exchange_rate NUMBER ,
446 cost NUMBER
447 );
448
449 TYPE inv_rate_tbl_type IS TABLE OF inv_rate_rec_type index by binary_integer;
450
451
452 TYPE inv_rec_type IS RECORD (
453 po_vendor_id NUMBER,
454 asset_invoice_id NUMBER,
455 fixed_assets_cost NUMBER,
456 deleted_flag varchar2(3),
457 po_number varchar2(20),
458 invoice_number varchar2(50),
459 payables_batch_name varchar2(50),
460 payables_code_combination_id NUMBER,
461 feeder_system_name varchar2(40),
462 create_batch_date DATE,
463 create_batch_id NUMBER,
464 invoice_date DATE,
465 payables_cost NUMBER,
466 post_batch_id NUMBER,
467 invoice_id NUMBER,
468 ap_distribution_line_number NUMBER,
469 payables_units NUMBER,
470 split_merged_code varchar2(3),
471 description varchar2(80),
472 parent_mass_addition_id VARCHAR2(15),
473 unrevalued_cost NUMBER,
474 merged_code varchar2(3),
475 split_code varchar2(3),
476 merge_parent_mass_additions_id NUMBER,
477 split_parent_mass_additions_id NUMBER,
478 project_asset_line_id NUMBER,
479 project_id NUMBER,
480 task_id NUMBER,
481 source_line_id NUMBER,
482 prior_source_line_id NUMBER,
483 material_indicator_flag varchar2(1),
484 attribute1 varchar2(150),
485 attribute2 varchar2(150),
486 attribute3 varchar2(150),
487 attribute4 varchar2(150),
488 attribute5 varchar2(150),
489 attribute6 varchar2(150),
490 attribute7 varchar2(150),
491 attribute8 varchar2(150),
492 attribute9 varchar2(150),
493 attribute10 varchar2(150),
494 attribute11 varchar2(150),
495 attribute12 varchar2(150),
496 attribute13 varchar2(150),
497 attribute14 varchar2(150),
498 attribute15 varchar2(150),
499 attribute_category_code varchar2(150),
500
501 cip_cost NUMBER,
502 depreciate_in_group_flag varchar2(1),
503
504 inv_indicator NUMBER ,
505 ytd_deprn NUMBER ,
506 deprn_reserve NUMBER ,
507 bonus_ytd_deprn NUMBER ,
508 bonus_deprn_reserve NUMBER ,
509 reval_amortization_basis NUMBER ,
510 reval_ytd_deprn NUMBER ,
511 reval_deprn_reserve NUMBER ,
512 source_dest_code VARCHAR2(15),
513 invoice_distribution_id NUMBER,
514 invoice_line_number NUMBER,
515 po_distribution_id NUMBER,
516 inv_rate_tbl inv_rate_tbl_type
517 );
518
519 TYPE inv_tbl_type IS TABLE OF inv_rec_type index by binary_integer;
520
521 ---------------------------------
522 -- Tax Reserve Adjustment info --
523 ---------------------------------
524
525 TYPE asset_tax_rsv_adj_rec_type IS RECORD (
526 fiscal_year NUMBER,
527 adjusted_ytd_deprn NUMBER,
528 deprn_basis_formula VARCHAR2(30),
529 deprn_adj_factor NUMBER,
530 max_period_ctr_adjusted NUMBER,
531 min_period_ctr_adjusted NUMBER,
532 run_mode VARCHAR2(15)
533 );
534
535 ---------------------------------------------------
536 -- Private Types (used within internals of APIs) --
537 ---------------------------------------------------
538
539 TYPE asset_fin_tbl_type IS TABLE OF asset_fin_rec_type index by binary_integer;
540
541 TYPE asset_deprn_tbl_type IS TABLE OF asset_deprn_rec_type index by binary_integer;
542
543 TYPE inv_trans_rec_type IS RECORD (
544 invoice_transaction_id NUMBER ,
545 transaction_type VARCHAR2(20)
546 );
547
551
548 ------------------------------------------
549 -- Standard types for FA Table Handlers --
550 ------------------------------------------
552 TYPE unplanned_deprn_rec_type IS RECORD (
553 code_combination_id NUMBER,
554 unplanned_amount NUMBER,
555 unplanned_type VARCHAR2(9)
556 );
557
558 TYPE trx_ref_rec_type is RECORD (
559 TRX_REFERENCE_ID NUMBER(15),
560 TRANSACTION_TYPE VARCHAR2(30),
561 SRC_TRANSACTION_SUBTYPE VARCHAR2(30),
562 DEST_TRANSACTION_SUBTYPE VARCHAR2(30),
563 BOOK_TYPE_CODE VARCHAR2(15),
564 SRC_ASSET_ID NUMBER(15),
565 SRC_TRANSACTION_HEADER_ID NUMBER(15),
566 DEST_ASSET_ID NUMBER(15),
567 DEST_TRANSACTION_HEADER_ID NUMBER(15),
568 MEMBER_ASSET_ID NUMBER(15),
569 MEMBER_TRANSACTION_HEADER_ID NUMBER(15),
570 SRC_AMORTIZATION_START_DATE DATE,
571 DEST_AMORTIZATION_START_DATE DATE,
572 RESERVE_TRANSFER_AMOUNT NUMBER,
573 SRC_EXPENSE_AMOUNT NUMBER,
574 DEST_EXPENSE_AMOUNT NUMBER,
575 SRC_EOFY_RESERVE NUMBER,
576 DEST_EOFY_RESERVE NUMBER);
577
578
579
580 /*
581
582 ------------------------------------------
583 -- Standard types for FA Table Handlers --
584 ------------------------------------------
585
586 -- FA_ADDITIONS
587
588 TYPE Asset_Id_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_ID%TYPE
589 INDEX BY BINARY_INTEGER;
590
591 TYPE Asset_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_NUMBER%TYPE
592 INDEX BY BINARY_INTEGER;
593
594 TYPE Asset_Key_Ccid_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_KEY_CCID%TYPE
595 INDEX BY BINARY_INTEGER;
596
597 TYPE Units_tbl_type IS TABLE OF FA_ADDITIONS_B.CURRENT_UNITS%TYPE
598 INDEX BY BINARY_INTEGER;
599
600 TYPE Asset_Type_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_TYPE%TYPE
601 INDEX BY BINARY_INTEGER;
602
603 TYPE Tag_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.TAG_NUMBER%TYPE
604 INDEX BY BINARY_INTEGER;
605
606 TYPE Description_tbl_type IS TABLE OF FA_ADDITIONS_TL.DESCRIPTION%TYPE
607 INDEX BY BINARY_INTEGER;
608
609 TYPE Category_Id_tbl_type IS TABLE OF FA_ADDITIONS_B.ASSET_CATEGORY_ID%TYPE
610 INDEX BY BINARY_INTEGER;
611
612 TYPE Manufacturer_Name_tbl_type IS TABLE OF FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE
613 INDEX BY BINARY_INTEGER;
614
615 TYPE Serial_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.SERIAL_NUMBER%TYPE
616 INDEX BY BINARY_INTEGER;
617
618 TYPE Model_Number_tbl_type IS TABLE OF FA_ADDITIONS_B.MODEL_NUMBER%TYPE
619 INDEX BY BINARY_INTEGER;
620
621 TYPE Property_Type_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.PROPERTY_TYPE_CODE%TYPE
622 INDEX BY BINARY_INTEGER;
623
624 TYPE Property_1245_1250_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.PROPERTY_1245_1250_CODE%TYPE
625 INDEX BY BINARY_INTEGER;
626
627 TYPE In_Use_Flag_tbl_type IS TABLE OF FA_ADDITIONS_B.IN_USE_FLAG%TYPE
628 INDEX BY BINARY_INTEGER;
629
630 TYPE Owned_Leased_tbl_type IS TABLE OF FA_ADDITIONS_B.OWNED_LEASED%TYPE
631 INDEX BY BINARY_INTEGER;
632
633 TYPE New_Used_tbl_type IS TABLE OF FA_ADDITIONS_B.NEW_USED%TYPE
634 INDEX BY BINARY_INTEGER;
635
636 TYPE Unit_Adjustment_Flag_tbl_type IS TABLE OF FA_ADDITIONS_B.UNIT_ADJUSTMENT_FLAG%TYPE
637 INDEX BY BINARY_INTEGER;
638
639 TYPE Add_Cost_Je_Flag_tbl_type IS TABLE OF FA_ADDITIONS_B.ADD_COST_JE_FLAG%TYPE
640 INDEX BY BINARY_INTEGER;
641
642 TYPE Attribute_tbl_type IS TABLE OF FA_ADDITIONS_B.ATTRIBUTE1%TYPE
643 INDEX BY BINARY_INTEGER;
644
645 TYPE Attribute_Category_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.ATTRIBUTE_CATEGORY_CODE%TYPE
646 INDEX BY BINARY_INTEGER;
647
648 TYPE gf_Attribute IS TABLE OF FA_ADDITIONS_B.GLOBAL_ATTRIBUTE1%TYPE
649 INDEX BY BINARY_INTEGER;
650
651 TYPE gf_Attribute_Category_Code_tbl_type IS TABLE OF FA_ADDITIONS_B.GLOBAL_ATTRIBUTE_CATEGORY%TYPE
652 INDEX BY BINARY_INTEGER;
653
654 TYPE Context_tbl_type IS TABLE OF FA_ADDITIONS_B.CONTEXT%TYPE
655 INDEX BY BINARY_INTEGER;
656
657 TYPE Lease_Id_tbl_type IS TABLE OF FA_ADDITIONS_B.LEASE_ID%TYPE
658 INDEX BY BINARY_INTEGER;
659
660 TYPE Inventorial_tbl_type IS TABLE OF FA_ADDITIONS_B.INVENTORIAL%TYPE
661 INDEX BY BINARY_INTEGER;
662
663
664 ----------------
665 -- not needed --
666 ----------------
667
668 -- TYPE Last_Update_Date_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATE_DATE%TYPE
669 -- INDEX BY BINARY_INTEGER;
670 --
671 -- TYPE Last_Updated_By_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATED_BY%TYPE
672 -- INDEX BY BINARY_INTEGER;
673 --
674 -- TYPE Created_By_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATED_BY%TYPE
675 -- INDEX BY BINARY_INTEGER;
676 --
677 -- TYPE Creation_Date_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATION_DATE%TYPE
681 -- INDEX BY BINARY_INTEGER;
678 -- INDEX BY BINARY_INTEGER;
679 --
680 -- TYPE Last_Update_Login_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATE_LOGIN%TYPE
682 --
683
684
685 -------------
686 -- generic --
687 -------------
688
689 TYPE updated_by_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATED_BY%TYPE
690 INDEX BY BINARY_INTEGER;
691
692 TYPE Date_tbl_type IS TABLE OF FA_ADDITIONS_B.CREATION_DATE%TYPE
693 INDEX BY BINARY_INTEGER;
694
695 TYPE Login_tbl_type IS TABLE OF FA_ADDITIONS_B.LAST_UPDATE_LOGIN%TYPE
696 INDEX BY BINARY_INTEGER;
697
698
699 --------------------
700 -- FA_ADJUSTMENTS --
701 --------------------
702 TYPE Source_Type_Code_tbl_type IS TABLE OF FA_ADJUSTMENTS.source_type_code%TYPE
703 INDEX BY BINARY_INTEGER;
704
705 TYPE Adjustment_Type_tbl_type IS TABLE OF FA_ADJUSTMENTS.adjustment_type%TYPE
706 INDEX BY BINARY_INTEGER;
707
708 TYPE Debit_Credit_Flag_tbl_type IS TABLE OF FA_ADJUSTMENTS.debit_credit_flag%TYPE
709 INDEX BY BINARY_INTEGER;
710
711 TYPE Annualized_Adjustment_tbl_type IS TABLE OF FA_ADJUSTMENTS.annualized_adjustment%TYPE
712 INDEX BY BINARY_INTEGER;
713
714
715
716 -- FA_ASSET_INVOICES
717
718 TYPE Po_Vendor_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.Po_Vendor_Id%TYPE
719 INDEX BY BINARY_INTEGER;
720
721 TYPE Asset_Invoice_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.Asset_Invoice_id%TYPE
722 INDEX BY BINARY_INTEGER;
723
724 TYPE Deleted_Flag_tbl_type IS TABLE OF FA_ASSET_INVOICES.deleted_flag%TYPE
725 INDEX BY BINARY_INTEGER;
726
727 TYPE Po_Number_tbl_type IS TABLE OF FA_ASSET_INVOICES.po_number%TYPE
728 INDEX BY BINARY_INTEGER;
729
730 TYPE Invoice_Number_tbl_type IS TABLE OF FA_ASSET_INVOICES.invoice_number%TYPE
731 INDEX BY BINARY_INTEGER;
732
733 TYPE Payables_Batch_Name_tbl_type IS TABLE OF FA_ASSET_INVOICES.payables_batch_name%TYPE
734 INDEX BY BINARY_INTEGER;
735
736 TYPE Feeder_System_Name_tbl_type IS TABLE OF FA_ASSET_INVOICES.feeder_system_name%TYPE
737 INDEX BY BINARY_INTEGER;
738
739 TYPE Create_Batch_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.create_batch_id%TYPE
740 INDEX BY BINARY_INTEGER;
741
742 TYPE Post_Batch_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.post_batch_id%TYPE
743 INDEX BY BINARY_INTEGER;
744
745 TYPE Invoice_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.invoice_id%TYPE
746 INDEX BY BINARY_INTEGER;
747
748 TYPE Ap_Dist_Line_Num_tbl_type IS TABLE OF FA_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER%TYPE
749 INDEX BY BINARY_INTEGER;
750
751 TYPE Split_Merged_Code_tbl_type IS TABLE OF FA_ASSET_INVOICES.split_merged_code%TYPE
752 INDEX BY BINARY_INTEGER;
753
754 TYPE Mass_Addition_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.parent_mass_addition_id%TYPE
755 INDEX BY BINARY_INTEGER;
756
757 TYPE Merged_Code_tbl_type IS TABLE OF FA_ASSET_INVOICES.merged_code%TYPE
758 INDEX BY BINARY_INTEGER;
759
760 TYPE Split_Code_tbl_type IS TABLE OF FA_ASSET_INVOICES.split_code%TYPE
761 INDEX BY BINARY_INTEGER;
762
763 TYPE Project_Asset_Line_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.project_asset_line_id%TYPE
764 INDEX BY BINARY_INTEGER;
765
766 TYPE Project_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.project_id%TYPE
767 INDEX BY BINARY_INTEGER;
768
769 TYPE Task_Id_tbl_type IS TABLE OF FA_ASSET_INVOICES.task_id%TYPE
770 INDEX BY BINARY_INTEGER;
771
772 -----------------------------------
773 -- FA_ASSET_INVOICE_TRANSACTIONS --
774 -----------------------------------
775
776 TYPE Invoice_thid_tbl_type IS TABLE OF FA_INVOICE_TRANSACTIONS.invoice_transaction_id%TYPE
777 INDEX BY BINARY_INTEGER;
778
779 TYPE Transaction_Type_tbl_type IS TABLE OF FA_INVOICE_TRANSACTIONS.transaction_type%TYPE
780 INDEX BY BINARY_INTEGER;
781
782
783 ------------------------
784 -- FA_ASSET_INVOICES --
785 ------------------------
786
787
788 --------------
789 -- FA_BOOKS --
790 --------------
791
792 TYPE Deprn_Method_Code_tbl_type IS TABLE OF FA_BOOKS.Deprn_Method_Code%TYPE
793 INDEX BY BINARY_INTEGER;
794
795 TYPE Life_In_Months_tbl_type IS TABLE OF FA_BOOKS.Life_In_Months%TYPE
796 INDEX BY BINARY_INTEGER;
797
798 TYPE Rate_Adjustment_Factor_tbl_type IS TABLE OF FA_BOOKS.Rate_Adjustment_Factor%TYPE
799 INDEX BY BINARY_INTEGER;
800
801 TYPE Cost_tbl_type IS TABLE OF FA_BOOKS.cost%TYPE
802 INDEX BY BINARY_INTEGER;
803
804 TYPE Prorate_Convention_Code_tbl_type IS TABLE OF FA_BOOKS.Prorate_Convention_Code%TYPE
805 INDEX BY BINARY_INTEGER;
806
807 TYPE Cost_Change_Flag_tbl_type IS TABLE OF FA_BOOKS.Cost_Change_Flag%TYPE
808 INDEX BY BINARY_INTEGER;
809
810 TYPE Adjustment_Required_Status_tbl_type IS TABLE OF FA_BOOKS.Adjustment_Required_Status%TYPE
811 INDEX BY BINARY_INTEGER;
812
816 TYPE Retirement_Pending_Flag_tbl_type IS TABLE OF FA_BOOKS.Retirement_Pending_Flag%TYPE
813 TYPE Capitalize_Flag_tbl_type IS TABLE OF FA_BOOKS.Capitalize_Flag%TYPE
814 INDEX BY BINARY_INTEGER;
815
817 INDEX BY BINARY_INTEGER;
818
819 TYPE Depreciate_Flag_tbl_type IS TABLE OF FA_BOOKS.Depreciate_Flag%TYPE
820 INDEX BY BINARY_INTEGER;
821
822 TYPE Itc_Amount_Id_tbl_type IS TABLE OF FA_BOOKS.Itc_Amount_Id%TYPE
823 INDEX BY BINARY_INTEGER;
824
825 TYPE Itc_Amount_tbl_type IS TABLE OF FA_BOOKS.Itc_Amount%TYPE
826 INDEX BY BINARY_INTEGER;
827
828 TYPE Retirement_Id_tbl_type IS TABLE OF FA_BOOKS.Retirement_Id%TYPE
829 INDEX BY BINARY_INTEGER;
830
831 TYPE Tax_Request_Id_tbl_type IS TABLE OF FA_BOOKS.Tax_Request_Id%TYPE
832 INDEX BY BINARY_INTEGER;
833
834 TYPE Itc_Basis_tbl_type IS TABLE OF FA_BOOKS.Itc_Basis%TYPE
835 INDEX BY BINARY_INTEGER;
836
837 TYPE Basic_Rate_tbl_type IS TABLE OF FA_BOOKS.Basic_Rate%TYPE
838 INDEX BY BINARY_INTEGER;
839
840 TYPE Adjusted_Rate_tbl_type IS TABLE OF FA_BOOKS.Adjusted_Rate%TYPE
841 INDEX BY BINARY_INTEGER;
842
843 TYPE Bonus_Rule_tbl_type IS TABLE OF FA_BOOKS.Bonus_Rule%TYPE
844 INDEX BY BINARY_INTEGER;
845
846 TYPE Ceiling_Name_tbl_type IS TABLE OF FA_BOOKS.Ceiling_Name%TYPE
847 INDEX BY BINARY_INTEGER;
848
849 TYPE Adjusted_Capacity_tbl_type IS TABLE OF FA_BOOKS.Adjusted_Capacity%TYPE
850 INDEX BY BINARY_INTEGER;
851
852 TYPE Fully_Rsvd_Revals_Counter_tbl_type IS TABLE OF FA_BOOKS.Fully_Rsvd_Revals_Counter%TYPE
853 INDEX BY BINARY_INTEGER;
854
855 TYPE Idled_Flag_tbl_type IS TABLE OF FA_BOOKS.Idled_Flag%TYPE
856 INDEX BY BINARY_INTEGER;
857
858 TYPE Production_Capacity_tbl_type IS TABLE OF FA_BOOKS.Production_Capacity%TYPE
859 INDEX BY BINARY_INTEGER;
860
861 TYPE Reval_Amortization_Basis_tbl_type IS TABLE OF FA_BOOKS.Reval_Amortization_Basis%TYPE
862 INDEX BY BINARY_INTEGER;
863
864 TYPE Reval_Ceiling_tbl_type IS TABLE OF FA_BOOKS.Reval_Ceiling%TYPE
865 INDEX BY BINARY_INTEGER;
866
867 TYPE Unit_Of_Measure_tbl_type IS TABLE OF FA_BOOKS.Unit_Of_Measure%TYPE
868 INDEX BY BINARY_INTEGER;
869
870 TYPE Annual_Deprn_Rounding_Flag_tbl_type IS TABLE OF FA_BOOKS.Annual_Deprn_Rounding_Flag%TYPE
871 INDEX BY BINARY_INTEGER;
872
873 TYPE Percent_Salvage_Value_tbl_type IS TABLE OF FA_BOOKS.Percent_Salvage_Value%TYPE
874 INDEX BY BINARY_INTEGER;
875
876 TYPE Allowed_Deprn_Limit_tbl_type IS TABLE OF FA_BOOKS.Allowed_Deprn_Limit%TYPE
877 INDEX BY BINARY_INTEGER;
878
879 TYPE Allowed_Deprn_Limit_Amount_tbl_type IS TABLE OF FA_BOOKS.Allowed_Deprn_Limit_Amount%TYPE
880 INDEX BY BINARY_INTEGER;
881
882 TYPE Short_Fiscal_Year_Flag_tbl_type IS TABLE OF FA_BOOKS.Short_Fiscal_Year_Flag%TYPE
883 INDEX BY BINARY_INTEGER;
884
885 TYPE Remaining_Life1_tbl_type IS TABLE OF FA_BOOKS.Remaining_Life1%TYPE
886 INDEX BY BINARY_INTEGER;
887
888 TYPE Remaining_Life2_tbl_type IS TABLE OF FA_BOOKS.Remaining_Life2%TYPE
889 INDEX BY BINARY_INTEGER;
890
891 TYPE Formula_Factor_tbl_type IS TABLE OF FA_BOOKS.Formula_Factor%TYPE
892 INDEX BY BINARY_INTEGER;
893
894 TYPE Group_Asset_ID_tbl_type IS TABLE OF FA_BOOKS.Group_Asset_ID%TYPE
895 INDEX BY BINARY_INTEGER;
896
897
898 -----------------------------
899 -- FA_DISTRIBUTION_HISTORY --
900 -----------------------------
901
902 TYPE DISTRIBUTION_ID_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.DISTRIBUTION_ID%TYPE
903 INDEX BY BINARY_INTEGER;
904
905 TYPE CODE_COMBINATION_ID_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.CODE_COMBINATION_ID%TYPE
906 INDEX BY BINARY_INTEGER;
907
908 TYPE LOCATION_ID_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.LOCATION_ID%TYPE
909 INDEX BY BINARY_INTEGER;
910
911 TYPE ASSIGNED_TO_tbl_type IS TABLE OF FA_DISTRIBUTION_HISTORY.ASSIGNED_TO%TYPE
912 INDEX BY BINARY_INTEGER;
913
914
915 ----------------------
916 -- FA_DEPRN_SUMMARY --
917 ----------------------
918
919
920 TYPE DS_Deprn_Source_Code_tbl_type IS TABLE OF FA_DEPRN_SUMMARY.DEPRN_SOURCE_CODE%TYPE
921 INDEX BY BINARY_INTEGER;
922
923 TYPE Bonus_Rate_tbl_type IS TABLE OF FA_DEPRN_SUMMARY.BONUS_RATE%TYPE
924 INDEX BY BINARY_INTEGER;
925
926
927
928 ---------------------
929 -- FA_DEPRN_DETAIL --
930 ---------------------
931
932 TYPE DD_Deprn_Source_Code_tbl_type IS TABLE OF FA_DEPRN_DETAIL.DEPRN_SOURCE_CODE%TYPE
933 INDEX BY BINARY_INTEGER;
934
935 TYPE je_line_num_tbl_type IS TABLE OF FA_DEPRN_DETAIL.deprn_expense_je_line_num%TYPE
936 INDEX BY BINARY_INTEGER;
937
938 TYPE je_header_id_tbl_type IS TABLE OF FA_DEPRN_DETAIL.je_header_id%TYPE
939 INDEX BY BINARY_INTEGER;
940
941 ------------------------------
942 -- FA_TRANSACTION_HEADERS --
946 INDEX BY BINARY_INTEGER;
943 ------------------------------
944
945 TYPE thid_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE
947
948 TYPE Book_Type_Code_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
949 INDEX BY BINARY_INTEGER;
950
951 TYPE pc_tbl_type IS TABLE OF FA_DEPRN_PERIODS.PERIOD_COUNTER%TYPE
952 INDEX BY BINARY_INTEGER;
953
954 TYPE TRANSACTION_TYPE_CODE_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_TYPE_CODE%TYPE
955 INDEX BY BINARY_INTEGER;
956
957 TYPE TRANSACTION_NAME_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_NAME%TYPE
958 INDEX BY BINARY_INTEGER;
959
960 TYPE INVOICE_TRANSACTION_ID_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID%TYPE
961 INDEX BY BINARY_INTEGER;
962
963 TYPE MASS_REFERENCE_ID_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.MASS_REFERENCE_ID%TYPE
964 INDEX BY BINARY_INTEGER;
965
966 TYPE TRANSACTION_SUBTYPE_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_SUBTYPE%TYPE
967 INDEX BY BINARY_INTEGER;
968
969 TYPE TRANSACTION_KEY_tbl_type IS TABLE OF FA_TRANSACTION_HEADERS.TRANSACTION_KEY%TYPE
970 INDEX BY BINARY_INTEGER;
971
972 -----------------------
973 -- FA_MASS_ADDITIONS --
974 -----------------------
975 TYPE warranty_id_tbl_type IS TABLE OF FA_MASS_ADDITIONS.warranty_id%type
976 index by binary_integer;
977 TYPE lessor_id_tbl_type IS TABLE OF FA_MASS_ADDITIONS.lessor_id%type
978 index by binary_integer;
979 TYPE new_master_flag_tbl_type IS TABLE OF FA_MASS_ADDITIONS.new_master_flag%type
980 index by binary_integer;
981 TYPE amortize_flag_tbl_type IS TABLE OF FA_MASS_ADDITIONS.amortize_flag%type
982 index by binary_integer;
983
984 */
985
986
987 -- Lease Procedure
988
989 TYPE LEASE_DETAILS_REC_TYPE IS RECORD (
990 LEASE_ID NUMBER,
991 LEASE_NUMBER VARCHAR2(15),
992 LESSOR_ID NUMBER(15),
993 LESSOR_NAME VARCHAR2(240),
994 LESSOR_SITE_ID NUMBER(15),
995 LESSOR_SITE VARCHAR2(15),
996 LESSOR_SITE_ORG_ID NUMBER(15),
997 PAYMENT_SCHEDULE_ID NUMBER(15),
998 PAYMENT_SCHEDULE_NAME VARCHAR2(30),
999 DESCRIPTION VARCHAR2(30),
1000 CURRENCY_CODE VARCHAR2(5),
1001 LEASE_TYPE VARCHAR2(15),
1002 DIST_CODE_COMBINATION_ID NUMBER(15),
1003 CON_DIST_CODE_COMBINATION VARCHAR2(250),
1004 TERMS_ID NUMBER(15),
1005 PAYMENT_TERMS VARCHAR2(50),
1006 TRANSFER_OWNERSHIP VARCHAR2(1),
1007 BARGAIN_PURCHASE_OPTION VARCHAR2(1),
1008 FAIR_VALUE NUMBER,
1009 ASSET_LIFE NUMBER,
1010 LEASE_TERM NUMBER,
1011 DESC_FLEX DESC_FLEX_rec_type
1012 );
1013
1014 TYPE LEASE_SCHEDULES_REC_TYPE IS RECORD (
1015 PAYMENT_SCHEDULE_ID NUMBER,
1016 PAYMENT_SCHEDULE_NAME VARCHAR2(30),
1017 PRESENT_VALUE NUMBER,
1018 INTEREST_RATE NUMBER,
1019 LEASE_INCEPTION_DATE DATE,
1020 CURRENCY_CODE VARCHAR2(5),
1021 FREQUENCY VARCHAR2(15)
1022 );
1023
1024 TYPE LEASE_PAYMENTS_REC_TYPE IS RECORD (
1025 PAYMENT_SCHEDULE_ID NUMBER,
1026 START_DATE DATE,
1027 PAYMENT_AMOUNT NUMBER,
1028 NUMBER_OF_PAYMENTS NUMBER,
1029 PAYMENT_TYPE VARCHAR2(1)
1030 );
1031
1032 TYPE LEASE_PAYMENTS_TBL_TYPE IS TABLE OF LEASE_PAYMENTS_REC_TYPE
1033 INDEX BY BINARY_INTEGER;
1034
1035 TYPE LOG_LEVEL_REC_TYPE IS RECORD (
1036 STATEMENT_LEVEL BOOLEAN,
1037 PROCEDURE_LEVEL BOOLEAN,
1038 EVENT_LEVEL BOOLEAN,
1039 EXCEPTION_LEVEL BOOLEAN,
1040 ERROR_LEVEL BOOLEAN,
1041 UNEXPECTED_LEVEL BOOLEAN,
1042 CURRENT_RUNTIME_LEVEL NUMBER,
1043 INITIALIZED BOOLEAN DEFAULT FALSE
1044 );
1045
1046 ---------------------------------
1047 -- Transaction Interface Table --
1048 ---------------------------------
1049 TYPE trans_interface_rec_type IS RECORD(
1050 TRANSACTION_INTERFACE_ID NUMBER(15),
1051 TRANSACTION_DATE DATE,
1052 TRANSACTION_TYPE_CODE VARCHAR2(30),
1053 POSTING_STATUS VARCHAR2(30),
1054 BOOK_TYPE_CODE VARCHAR2(15),
1055 ASSET_KEY_PROJECT_VALUE VARCHAR2(30),
1056 ASSET_KEY_HIERARCHY_VALUE VARCHAR2(30),
1057 ASSET_KEY_NEW_HIERARCHY_VALUE VARCHAR2(30),
1058 REFERENCE_NUMBER NUMBER,
1059 COMMENTS VARCHAR2(80),
1060 CONCURRENT_REQUEST_ID NUMBER(15),
1061 CREATED_BY NUMBER(15),
1062 CREATION_DATE DATE,
1063 LAST_UPDATED_BY NUMBER(15),
1064 LAST_UPDATE_DATE DATE,
1065 LAST_UPDATE_LOGIN NUMBER(15));
1066
1067
1068
1069
1070 END FA_API_TYPES;
[Home] [Help]