[Home] [Help]
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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),
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),
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,
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),
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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: