[Home] [Help]
PACKAGE: APPS.XTR_REPLICATE_BANK_BALANCES
Source
1 PACKAGE XTR_REPLICATE_BANK_BALANCES AUTHID CURRENT_USER AS
2 /* | $Header: xtrbbals.pls 120.4.12020000.2 2013/01/18 11:28:05 rtumati ship $ | */
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
88 -- bug 9742850 starts
89 PROCEDURE VALIDATE_OD_LIMIT_BALANCE
90 ( p_company_code IN xtr_bank_balances.company_code%TYPE,
91 p_branch_id IN NUMBER,
92 p_bank_accont_id IN NUMBER,
93 p_ledger_balance IN NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 -- bug 9742850 ends
100
101 FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
102 , p_account_number IN xtr_bank_balances.account_number%TYPE
103 , p_currency IN xtr_bank_accounts.currency%TYPE
104 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
105 , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
106 , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
107 , p_action_flag IN VARCHAR2
108 , p_val_type IN VARCHAR2 )
109 RETURN VARCHAR2;
110
111
112 FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
113 , p_account_number IN xtr_bank_balances.account_number%TYPE
114 , p_currency IN xtr_bank_accounts.currency%TYPE
115 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
116 , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
117 , p_interest_calc_balance IN NUMBER
118 , p_action_flag IN VARCHAR2
119 , p_val_type IN VARCHAR2)
120 RETURN VARCHAR2;
121
122 FUNCTION CHK_ACCRUAL_ON_RENDER
123 ( p_company_code IN xtr_bank_balances.company_code%TYPE
124 , p_account_number IN xtr_bank_balances.account_number%TYPE
125 , p_currency IN xtr_bank_accounts.currency%TYPE
126 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
127 )return boolean;
128
129
130 FUNCTION CHK_REVAL_ON_RENDER
131 ( p_company_code IN xtr_bank_balances.company_code%TYPE
132 , p_account_number IN xtr_bank_balances.account_number%TYPE
133 , p_currency IN xtr_bank_accounts.currency%TYPE
134 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
135 )return boolean;
136
137
138 FUNCTION CHK_ACCRUAL_ON_RENDER
139 ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
140 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
141 )return VARCHAR2;
142
143
144
145 FUNCTION CHK_REVAL_ON_RENDER
146 ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
147 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
148 )return VARCHAR2;
149
150
151
152
153 FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_code%TYPE,
154 p_account_number IN xtr_bank_balances.account_number%TYPE,
155 p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;
156
157 FUNCTION CHK_ACCRUAL_INT (
158 p_party_code xtr_bank_accounts.party_code%type
159 ,p_account_number xtr_bank_accounts.account_number%type
160 )RETURN varchar2;
161
162
163 FUNCTION CHK_INT_OVERRIDE (
164 p_party_code xtr_bank_accounts.party_code%type
165 ,p_account_number xtr_bank_accounts.account_number%type
166 ,p_oldest_date DATE
167 ) RETURN VARCHAR2;
168
169
170 PROCEDURE UPDATE_ROUNDING_DAYCOUNT
171 (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
172 ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
173 ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
174 ,x_return_status OUT NOCOPY VARCHAR2
175 );
176
177
178 PROCEDURE UPDATE_BANK_ACCOUNT
179 ( p_company_code IN xtr_bank_balances.company_code%TYPE,
180 p_account_number IN xtr_bank_balances.account_number%TYPE,
181 p_balance_date IN xtr_bank_balances.balance_date%TYPE,
182 p_action_flag IN VARCHAR2,
183 x_return_status OUT NOCOPY VARCHAR2
184 );
185
186
187
188 FUNCTION CHK_INTEREST_SETTLED
189 ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
190 , p_balance_date IN xtr_bank_balances.balance_date%TYPE
191 )return VARCHAR2;
192
193 PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS
194 (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
195 ,p_balance_date IN xtr_bank_balances.balance_date%TYPE
196 ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
197 ,p_interest_calc_balance IN NUMBER
198 ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
199 ,p_action_flag IN VARCHAR2
200 ,x_return_status OUT NOCOPY VARCHAR2
201 ,x_msg_count OUT NOCOPY NUMBER
202 ,x_msg_data OUT NOCOPY VARCHAR2 );
203
204 END XTR_REPLICATE_BANK_BALANCES; -- Package spec
205