[Home] [Help]
PACKAGE: APPS.FA_ADJUST_TYPE_PKG
Source
1 PACKAGE FA_ADJUST_TYPE_PKG AUTHID CURRENT_USER as
2 /* $Header: FAXINAJS.pls 120.8 2010/10/22 10:10:43 gigupta ship $ */
3
4 TYPE fa_adj_row_struct is RECORD (
5 transaction_header_id FA_ADJUSTMENTS.transaction_header_id%TYPE,
6 asset_invoice_id FA_ADJUSTMENTS.asset_invoice_id%TYPE,
7 source_type_code FA_ADJUSTMENTS.source_type_code%TYPE,
8 adjustment_type FA_ADJUSTMENTS.adjustment_type%TYPE,
9 debit_credit_flag FA_ADJUSTMENTS.debit_credit_flag%TYPE,
10 code_combination_id FA_ADJUSTMENTS.code_combination_id%TYPE,
11 book_type_code FA_ADJUSTMENTS.book_type_code%TYPE,
12 period_counter_created FA_ADJUSTMENTS.period_counter_created%TYPE,
13 asset_id FA_ADJUSTMENTS.asset_id%TYPE,
14 adjustment_amount FA_ADJUSTMENTS.adjustment_amount%TYPE,
15 period_counter_adjusted FA_ADJUSTMENTS.period_counter_adjusted%TYPE,
16 distribution_id FA_ADJUSTMENTS.distribution_id%TYPE,
17 annualized_adjustment FA_ADJUSTMENTS.annualized_adjustment%TYPE,
18 last_update_date FA_ADJUSTMENTS.last_update_date%TYPE,
19 account varchar2(2000),
20 account_type varchar2(55),
21 current_units number,
22 selection_mode number,
23 selection_thid number,
24 selection_retid number,
25 flush_adj_flag boolean,
26 gen_ccid_flag boolean,
27 amount_inserted FA_ADJUSTMENTS.adjustment_amount%TYPE,
28 units_retired number,
29 leveling_flag boolean,
30 deprn_override_flag FA_DEPRN_SUMMARY.deprn_override_flag%TYPE,
31 mrc_sob_type_code varchar2(1),
32 set_of_books_id number,
33 track_member_flag FA_ADJUSTMENTS.track_member_flag%TYPE,
34 adjustment_line_id number,
35 source_dest_code varchar2(15),
36 source_line_id number,
37 insertion_order FA_ADJUSTMENTS.insertion_order%TYPE
38 );
39
40 --
41 -- This record type is declared for the table type below which is used to
42 -- cache records meant for inserting into fa_adjustments.
43 --
44
45 TYPE fa_adj_ins_struct is RECORD (
46 transaction_header_id FA_ADJUSTMENTS.transaction_header_id%TYPE,
47 asset_invoice_id FA_ADJUSTMENTS.asset_invoice_id%TYPE,
48 source_type_code FA_ADJUSTMENTS.source_type_code%TYPE,
49 adjustment_type FA_ADJUSTMENTS.adjustment_type%TYPE,
50 debit_credit_flag FA_ADJUSTMENTS.debit_credit_flag%TYPE,
51 code_combination_id FA_ADJUSTMENTS.code_combination_id%TYPE,
52 book_type_code FA_ADJUSTMENTS.book_type_code%TYPE,
53 period_counter_created FA_ADJUSTMENTS.period_counter_created%TYPE,
54 asset_id FA_ADJUSTMENTS.asset_id%TYPE,
55 adjustment_amount FA_ADJUSTMENTS.adjustment_amount%TYPE,
56 period_counter_adjusted FA_ADJUSTMENTS.period_counter_adjusted%TYPE,
57 distribution_id FA_ADJUSTMENTS.distribution_id%TYPE,
58 annualized_adjustment FA_ADJUSTMENTS.annualized_adjustment%TYPE,
59 last_update_date FA_ADJUSTMENTS.last_update_date%TYPE,
60 deprn_override_flag FA_DEPRN_SUMMARY.deprn_override_flag%TYPE,
61 track_member_flag FA_ADJUSTMENTS.track_member_flag%TYPE,
62 adjustment_line_id number,
63 source_dest_code varchar2(15),
64 source_line_id number,
65 set_of_books_id number,
66 insertion_order FA_ADJUSTMENTS.insertion_order%TYPE
67 );
68
69 TYPE fa_adj_ins_table is TABLE of fa_adj_ins_struct
70 INDEX BY BINARY_INTEGER;
71
72 MAX_ADJ_CACHE_ROWS CONSTANT NUMBER := 200; -- The maximum number of cache entries
73 FA_AJ_ACTIVE CONSTANT NUMBER := 1; -- ACTIVE mode value
74 FA_AJ_SINGLE CONSTANT NUMBER := 2; -- SINGLE mode value
75 FA_AJ_CLEAR CONSTANT NUMBER := 3; -- CLEAR mode value
76 FA_AJ_RETIRE CONSTANT NUMBER := 4; -- RETIRE mode value
77 FA_AJ_TRANSFER_SINGLE CONSTANT NUMBER := 5; -- SINGLE mode for transfer/reclass
78 FA_AJ_ACTIVE_REVAL CONSTANT NUMBER := 6; -- ACTIVE mode for reval
79 FA_AJ_CLEAR_PARTIAL CONSTANT NUMBER := 7; -- Mode for affected rows: Enhancement for Bug# 4617352
80 FA_AJ_ACTIVE_PARTIAL CONSTANT NUMBER := 8; -- Mode for affected rows: Enhancement for Bug# 4617352
81
82 END FA_ADJUST_TYPE_PKG;