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,
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,
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: 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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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),
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,
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;