1 PACKAGE FA_INS_DETAIL_PKG as
2 /* $Header: FAXINDDS.pls 120.3 2005/06/24 01:55:17 lson ship $ */
3
4 /* ---------------------------------------------------------------------
5 | Name
6 | faxindd
7 |
8 | Description
9 | This function is called from forms to insert a row into fa_deprn_detail
10 |
11 | Parameters
12 | book_type_code - mandatory
13 | asset_id - mandatory
14 |
15 | The following parameters are not mandatory. If they are specified, then the
16 | function uses that value to pass into fadpdtl(insert into fa_deprn_detail)
17 | function. If not specified, then values are retrieved from fa_deprn_summary
18 | table or fa_books(only for cost).
19 |
20 | cost
21 | deprn_reserve - accumulated depreciation
22 | reval_reserve - revaluation reserve
23 | ytd_deprn - year to date depreciation
24 | ytd_reval_deprn_expense - year to date reval depreciation expense
25 | period_counter
26 |
27 | Returns
28 | TRUE if successful, FALSE otherwise
29 |
30 | Notes
31 | even if period_counter is passed in a value, it is always
32 | retrieved from fa_deprn_summary 'BOOKS' row.
33 |
34 | History
35 | 24-Jan-1997 LSON Created
36 |
37 |
38 + -------------------------------------------------------------------- */
39
40 FUNCTION faxindd (X_book_type_code VARCHAR2,
41 X_asset_id NUMBER,
42 X_period_counter NUMBER := NULL,
43 X_cost NUMBER := NULL,
44 X_deprn_reserve NUMBER := NULL,
45 /* Bug 525654 Modification */
46 X_deprn_adjustment_amount NUMBER := NULL,
47 X_reval_reserve NUMBER := NULL,
48 X_ytd NUMBER := NULL,
49 X_ytd_reval_dep_exp NUMBER := NULL,
50 X_bonus_ytd NUMBER := NULL,
51 X_bonus_deprn_reserve NUMBER := NULL,
52 X_init_message_flag VARCHAR2 DEFAULT 'NO',
53 X_mrc_sob_type_code VARCHAR2,
54 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55
56 return BOOLEAN;
57
58
59 /* ---------------------------------------------------------------------
60 | Name
61 | fadpdtl
62 |
63 | Description
64 | This function accepts book type code, asset_id,period_counter,
65 | cost, year to date depreciation amount,depreciation reserve,
66 | revaluation reserve amount, and year to date revaluation
67 | depreciation expense in a structure X_dpr_dtl as parameters
68 | and insert a row to fa_deprn_detail for each distribution.
69 | Amount distributed for fa_deprn_detail row is prorated based on
70 | units_assigend to that distribution and rounded off based on the
71 | currency of the book. If there is remaining pennies from the rounding
72 | the largest distribution id will get the remaining.
73 |
74 | Parameters
75 | X_dpr_dtl dpr_dtl_row_struct record structure defined in faxstds.pls
76 |
77 | X_source_flag TRUE or FALSE
78 | TRUE - creates 'B' row
79 | FALSE - creates 'D' row
80 |
81 | Returns
82 | TRUE if successful, FALSE otherwise
83 |
84 | History
85 | 24-Jan-1997 LSON Created
86 |
87 + -------------------------------------------------------------------- */
88
89 FUNCTION fadpdtl (X_dpr_dtl FA_STD_TYPES.DPR_DTL_ROW_STRUCT,
90 X_source_flag BOOLEAN,
91 X_mrc_sob_type_code VARCHAR2,
92 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
93 return BOOLEAN;
94
95
96 END FA_INS_DETAIL_PKG;