[Home] [Help]
PACKAGE: APPS.FA_ADJUST_TYPE_PKG
Source
1 PACKAGE FA_ADJUST_TYPE_PKG as
2 /* $Header: FAXINAJS.pls 120.4 2005/10/07 00:42:07 yyoon 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 -- Added for Track Member feature
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
38 /* This record type is declared for the table type below which is used to
39 cache records meant for inserting into fa_adjustments.
40 */
41 TYPE fa_adj_ins_struct is RECORD (
42 transaction_header_id FA_ADJUSTMENTS.transaction_header_id%TYPE,
43 asset_invoice_id FA_ADJUSTMENTS.asset_invoice_id%TYPE,
44 source_type_code FA_ADJUSTMENTS.source_type_code%TYPE,
45 adjustment_type FA_ADJUSTMENTS.adjustment_type%TYPE,
46 debit_credit_flag FA_ADJUSTMENTS.debit_credit_flag%TYPE,
47 code_combination_id FA_ADJUSTMENTS.code_combination_id%TYPE,
48 book_type_code FA_ADJUSTMENTS.book_type_code%TYPE,
49 period_counter_created FA_ADJUSTMENTS.period_counter_created%TYPE,
50 asset_id FA_ADJUSTMENTS.asset_id%TYPE,
51 adjustment_amount FA_ADJUSTMENTS.adjustment_amount%TYPE,
52 period_counter_adjusted FA_ADJUSTMENTS.period_counter_adjusted%TYPE,
53 distribution_id FA_ADJUSTMENTS.distribution_id%TYPE,
54 annualized_adjustment FA_ADJUSTMENTS.annualized_adjustment%TYPE,
55 last_update_date FA_ADJUSTMENTS.last_update_date%TYPE,
56 deprn_override_flag FA_DEPRN_SUMMARY.deprn_override_flag%TYPE,
57 -- Added for Track Member features
58 track_member_flag FA_ADJUSTMENTS.track_member_flag%TYPE,
59 adjustment_line_id number,
60 source_dest_code varchar2(15),
61 source_line_id number);
62
63 TYPE fa_adj_ins_table is TABLE of fa_adj_ins_struct
64 INDEX BY BINARY_INTEGER;
65
66 MAX_ADJ_CACHE_ROWS CONSTANT NUMBER := 200; /* The maximum number of cache
67 entries */
68 FA_AJ_ACTIVE CONSTANT NUMBER := 1; /* ACTIVE mode value */
69 FA_AJ_SINGLE CONSTANT NUMBER := 2; /* SINGLE mode value */
70 FA_AJ_CLEAR CONSTANT NUMBER := 3; /* CLEAR mode value */
71 FA_AJ_RETIRE CONSTANT NUMBER := 4; /* RETIRE mode value */
72 FA_AJ_TRANSFER_SINGLE CONSTANT NUMBER := 5; /* SINGLE mode for transfer/
73 reclass */
74 FA_AJ_ACTIVE_REVAL CONSTANT NUMBER := 6; /* ACTIVE mode for reval./
75 Propagated from pro*c version. YYOON */
76
77 FA_AJ_CLEAR_PARTIAL CONSTANT NUMBER := 7; /* Mode for affected rows: Enhancement for Bug# 4617352 */
78 FA_AJ_ACTIVE_PARTIAL CONSTANT NUMBER := 8; /* Mode for affected rows: Enhancement for Bug# 4617352 */
79
80 END FA_ADJUST_TYPE_PKG;