1 PACKAGE igi_iac_det_balances_pkg AS
2 -- $Header: igiiadbs.pls 120.4.12000000.1 2007/08/01 16:14:23 npandya ship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_adjustment_id IN NUMBER,
7 x_asset_id IN NUMBER,
8 x_distribution_id IN NUMBER,
9 x_book_type_code IN VARCHAR2,
10 x_period_counter IN NUMBER,
11 x_adjustment_cost IN NUMBER,
12 x_net_book_value IN NUMBER,
13 x_reval_reserve_cost IN NUMBER,
14 x_reval_reserve_backlog IN NUMBER,
15 x_reval_reserve_gen_fund IN NUMBER,
16 x_reval_reserve_net IN NUMBER,
17 x_operating_acct_cost IN NUMBER,
18 x_operating_acct_backlog IN NUMBER,
19 x_operating_acct_net IN NUMBER,
20 x_operating_acct_ytd IN NUMBER,
21 x_deprn_period IN NUMBER,
22 x_deprn_ytd IN NUMBER,
23 x_deprn_reserve IN NUMBER,
24
25 x_deprn_reserve_backlog IN NUMBER,
26 x_general_fund_per IN NUMBER,
27 x_general_fund_acc IN NUMBER,
28 x_last_reval_date IN DATE,
29 x_current_reval_factor IN NUMBER,
30 x_cumulative_reval_factor IN NUMBER,
31 x_active_flag IN VARCHAR2,
32 x_mode IN VARCHAR2 DEFAULT 'R'
33 );
34
35
36 PROCEDURE update_row (
37 x_adjustment_id IN NUMBER,
38 x_asset_id IN NUMBER,
39 x_distribution_id IN NUMBER,
40 x_book_type_code IN VARCHAR2,
41 x_period_counter IN NUMBER,
42 x_adjustment_cost IN NUMBER,
43 x_net_book_value IN NUMBER,
44 x_reval_reserve_cost IN NUMBER,
45 x_reval_reserve_backlog IN NUMBER,
46 x_reval_reserve_gen_fund IN NUMBER,
47 x_reval_reserve_net IN NUMBER,
48 x_operating_acct_cost IN NUMBER,
49 x_operating_acct_backlog IN NUMBER,
50 x_operating_acct_net IN NUMBER,
51 x_operating_acct_ytd IN NUMBER,
52 x_deprn_period IN NUMBER,
53 x_deprn_ytd IN NUMBER,
54 x_deprn_reserve IN NUMBER,
55 x_deprn_reserve_backlog IN NUMBER,
56 x_general_fund_per IN NUMBER,
57 x_general_fund_acc IN NUMBER,
58 x_last_reval_date IN DATE,
59 x_current_reval_factor IN NUMBER,
60 x_cumulative_reval_factor IN NUMBER,
61 x_active_flag IN VARCHAR2,
62 x_mode IN VARCHAR2 DEFAULT 'R'
63 );
64
65 PROCEDURE delete_row (
66 x_adjustment_id IN NUMBER,
67 x_asset_id IN NUMBER,
68 x_distribution_id IN NUMBER,
69 x_book_type_code IN VARCHAR2,
70 x_period_counter IN NUMBER
71 );
72
73
74 END igi_iac_det_balances_pkg;