DBA Data[Home] [Help]

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_BANK_ACCOUNTS

Line 103: , p_currency IN xtr_bank_accounts.currency%TYPE

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

Line 114: , p_currency IN xtr_bank_accounts.currency%TYPE

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

Line 125: , p_currency IN xtr_bank_accounts.currency%TYPE

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:

Line 133: , p_currency IN xtr_bank_accounts.currency%TYPE

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:

Line 139: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%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:

Line 146: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

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:

Line 158: p_party_code xtr_bank_accounts.party_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:

Line 159: ,p_account_number xtr_bank_accounts.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 (

Line 164: p_party_code xtr_bank_accounts.party_code%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:

Line 165: ,p_account_number xtr_bank_accounts.account_number%type

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:

Line 171: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE

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

Line 172: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE

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:

Line 173: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE

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:

Line 189: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

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

Line 194: (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