[Home] [Help]
PACKAGE: APPS.XTR_REPLICATE_BANK_BALANCES
Source
1 PACKAGE XTR_REPLICATE_BANK_BALANCES AS
2 /* | $Header: xtrbbals.pls 120.4 2005/07/25 09:53:52 eaggarwa noship $ | */
3 --
4 -- To replicate the data from CE tables to xtr_bank_balances table
5 --
6 --
7 -- Purpose: This package will insert/delete/update the bank balances
8 -- from CE tables to the xtr_bank_balances table.
9
10 -- replicate_bank_account is the main procedure through which the
11 -- insert/delete/update procedures will be called.
12 --
13 -- -- MODIFICATION HISTORY
14 -- Person Date Comments
15 -- Eakta Aggarwal 19-May-2005 Created
16 -- --------- ------ ----------------------------------
17
18
19 PROCEDURE REPLICATE_BANK_BALANCE
20 ( p_balance_rec IN xtr_bank_balances%rowtype,
21 p_action_flag IN varchar2,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2);
25
26 PROCEDURE REPLICATE_BANK_BALANCE
27 ( p_ce_bank_account_balance_id IN XTR_BANK_BALANCES.ce_bank_account_balance_id%TYPE,
28 p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,
29 p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
30 p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
31 p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
32 p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
33 p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,
34 p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,
35 p_two_day_float IN XTR_BANK_BALANCES.two_day_float%TYPE,
36 p_action_flag IN varchar2,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2);
40
41
42 PROCEDURE INSERT_BANK_BALANCE
43 ( p_balance_rec IN xtr_bank_balances%rowtype,
44 x_return_status In OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE UPDATE_BANK_BALANCE
48 ( p_balance_rec IN xtr_bank_balances%rowtype,
49 x_return_status IN OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE DELETE_BANK_BALANCE
53 ( p_balance_rec IN xtr_bank_balances%rowtype,
54 x_return_status IN OUT NOCOPY VARCHAR2
55 );
56
57
58 PROCEDURE VALIDATE_BANK_BALANCE
59 ( p_company_code IN xtr_bank_balances.company_code%TYPE,
60 p_account_number IN xtr_bank_balances.account_number%TYPE,
61 p_balance_date IN xtr_bank_balances.balance_date%TYPE,
62 p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
63 p_interest_calc_balance IN NUMBER,
64 p_available_balance in NUMBER,
65 p_action_flag IN VARCHAR2,
66 x_return_status OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE VALIDATE_BANK_BALANCE
70 ( p_company_code IN xtr_bank_balances.company_code%TYPE,
71 p_account_number IN xtr_bank_balances.account_number%TYPE,
72 p_balance_date IN xtr_bank_balances.balance_date%TYPE,
73 p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
74 p_interest_calc_balance IN NUMBER,
75 p_available_balance in NUMBER,
76 p_action_flag IN VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2);
80
81 PROCEDURE LOG_ERR_MSG
82 ( p_error_code IN VARCHAR2,
83 p_field_name IN VARCHAR2 default null,
84 p_balance_date IN xtr_bank_balances.balance_date%type DEFAULT NULL
85 );
86
87 FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
88 , p_account_number IN xtr_bank_balances.account_number%TYPE
89 , p_currency IN xtr_bank_accounts.currency%TYPE
90 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
91 , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
92 , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
93 , p_action_flag IN VARCHAR2
94 , p_val_type IN VARCHAR2 )
95 RETURN VARCHAR2;
96
97
98 FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
99 , p_account_number IN xtr_bank_balances.account_number%TYPE
100 , p_currency IN xtr_bank_accounts.currency%TYPE
101 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
102 , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
103 , p_interest_calc_balance IN NUMBER
104 , p_action_flag IN VARCHAR2
105 , p_val_type IN VARCHAR2)
106 RETURN VARCHAR2;
107
108 FUNCTION CHK_ACCRUAL_ON_RENDER
109 ( p_company_code IN xtr_bank_balances.company_code%TYPE
110 , p_account_number IN xtr_bank_balances.account_number%TYPE
111 , p_currency IN xtr_bank_accounts.currency%TYPE
112 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
113 )return boolean;
114
115
116 FUNCTION CHK_REVAL_ON_RENDER
117 ( p_company_code IN xtr_bank_balances.company_code%TYPE
118 , p_account_number IN xtr_bank_balances.account_number%TYPE
119 , p_currency IN xtr_bank_accounts.currency%TYPE
120 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
121 )return boolean;
122
123
124 FUNCTION CHK_ACCRUAL_ON_RENDER
125 ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
126 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
127 )return VARCHAR2;
128
129
130
131 FUNCTION CHK_REVAL_ON_RENDER
132 ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
133 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
134 )return VARCHAR2;
135
136
137
138
139 FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_code%TYPE,
140 p_account_number IN xtr_bank_balances.account_number%TYPE,
141 p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;
142
143 FUNCTION CHK_ACCRUAL_INT (
144 p_party_code xtr_bank_accounts.party_code%type
145 ,p_account_number xtr_bank_accounts.account_number%type
146 )RETURN varchar2;
147
148
149 FUNCTION CHK_INT_OVERRIDE (
150 p_party_code xtr_bank_accounts.party_code%type
151 ,p_account_number xtr_bank_accounts.account_number%type
152 ,p_oldest_date DATE
153 ) RETURN VARCHAR2;
154
155
156 PROCEDURE UPDATE_ROUNDING_DAYCOUNT
157 (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
158 ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
159 ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
160 ,x_return_status OUT NOCOPY VARCHAR2
161 );
162
163
164 PROCEDURE UPDATE_BANK_ACCOUNT
165 ( p_company_code IN xtr_bank_balances.company_code%TYPE,
166 p_account_number IN xtr_bank_balances.account_number%TYPE,
167 p_balance_date IN xtr_bank_balances.balance_date%TYPE,
168 p_action_flag IN VARCHAR2,
169 x_return_status OUT NOCOPY VARCHAR2
170 );
171
172
173
174 FUNCTION CHK_INTEREST_SETTLED
175 ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
176 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
177 )return VARCHAR2;
178
179 PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS
180 (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
181 ,p_balance_date IN xtr_bank_balances.balance_date%TYPE
182 ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
183 ,p_interest_calc_balance IN NUMBER
184 ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
185 ,p_action_flag IN VARCHAR2
186 ,x_return_status OUT NOCOPY VARCHAR2
187 ,x_msg_count OUT NOCOPY NUMBER
188 ,x_msg_data OUT NOCOPY VARCHAR2 );
189
190 END XTR_REPLICATE_BANK_BALANCES; -- Package spec
191