eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_ZBA_DEAL_GENERATION

Line 1: PACKAGE BODY CE_ZBA_DEAL_GENERATION AS

1: PACKAGE BODY CE_ZBA_DEAL_GENERATION AS
2: /* $Header: cezdgenb.pls 120.11 2006/05/12 14:01:22 svali noship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5:

Line 127: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.xtr_shared_account'|| '----------' ||

123: X_ERROR_MSG VARCHAR2(1000);
124:
125: BEGIN
126: IF l_DEBUG in ('Y', 'C') THEN
127: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.xtr_shared_account'|| '----------' ||
128: 'xtr_shared_account ORG_ID = '|| CE_ZBA_DEAL_GENERATION.csh_org_id|| '----------' ||
129: 'xtr_shared_account BANK_ACCOUNT_ID = '|| CE_ZBA_DEAL_GENERATION.csh_bank_account_id|| '----------' ||
130: 'xtr_shared_account CURRENCY_CODE = '|| CE_ZBA_DEAL_GENERATION.cba_bank_currency);
131: END IF;

Line 128: 'xtr_shared_account ORG_ID = '|| CE_ZBA_DEAL_GENERATION.csh_org_id|| '----------' ||

124:
125: BEGIN
126: IF l_DEBUG in ('Y', 'C') THEN
127: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.xtr_shared_account'|| '----------' ||
128: 'xtr_shared_account ORG_ID = '|| CE_ZBA_DEAL_GENERATION.csh_org_id|| '----------' ||
129: 'xtr_shared_account BANK_ACCOUNT_ID = '|| CE_ZBA_DEAL_GENERATION.csh_bank_account_id|| '----------' ||
130: 'xtr_shared_account CURRENCY_CODE = '|| CE_ZBA_DEAL_GENERATION.cba_bank_currency);
131: END IF;
132:

Line 129: 'xtr_shared_account BANK_ACCOUNT_ID = '|| CE_ZBA_DEAL_GENERATION.csh_bank_account_id|| '----------' ||

125: BEGIN
126: IF l_DEBUG in ('Y', 'C') THEN
127: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.xtr_shared_account'|| '----------' ||
128: 'xtr_shared_account ORG_ID = '|| CE_ZBA_DEAL_GENERATION.csh_org_id|| '----------' ||
129: 'xtr_shared_account BANK_ACCOUNT_ID = '|| CE_ZBA_DEAL_GENERATION.csh_bank_account_id|| '----------' ||
130: 'xtr_shared_account CURRENCY_CODE = '|| CE_ZBA_DEAL_GENERATION.cba_bank_currency);
131: END IF;
132:
133: /* XTR_WRAPPER_API_P.bank_account_verification(

Line 130: 'xtr_shared_account CURRENCY_CODE = '|| CE_ZBA_DEAL_GENERATION.cba_bank_currency);

126: IF l_DEBUG in ('Y', 'C') THEN
127: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.xtr_shared_account'|| '----------' ||
128: 'xtr_shared_account ORG_ID = '|| CE_ZBA_DEAL_GENERATION.csh_org_id|| '----------' ||
129: 'xtr_shared_account BANK_ACCOUNT_ID = '|| CE_ZBA_DEAL_GENERATION.csh_bank_account_id|| '----------' ||
130: 'xtr_shared_account CURRENCY_CODE = '|| CE_ZBA_DEAL_GENERATION.cba_bank_currency);
131: END IF;
132:
133: /* XTR_WRAPPER_API_P.bank_account_verification(
134: P_ORG_ID => CE_ZBA_DEAL_GENERATION.csh_org_id,

Line 134: P_ORG_ID => CE_ZBA_DEAL_GENERATION.csh_org_id,

130: 'xtr_shared_account CURRENCY_CODE = '|| CE_ZBA_DEAL_GENERATION.cba_bank_currency);
131: END IF;
132:
133: /* XTR_WRAPPER_API_P.bank_account_verification(
134: P_ORG_ID => CE_ZBA_DEAL_GENERATION.csh_org_id,
135: P_AP_BANK_ACCOUNT_ID => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,
136: P_CURRENCY_CODE => CE_ZBA_DEAL_GENERATION.cba_bank_currency,
137: P_RESULT => X_ACCOUNT_RESULT,
138: P_ERROR_MSG => X_ERROR_MSG);

Line 135: P_AP_BANK_ACCOUNT_ID => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,

131: END IF;
132:
133: /* XTR_WRAPPER_API_P.bank_account_verification(
134: P_ORG_ID => CE_ZBA_DEAL_GENERATION.csh_org_id,
135: P_AP_BANK_ACCOUNT_ID => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,
136: P_CURRENCY_CODE => CE_ZBA_DEAL_GENERATION.cba_bank_currency,
137: P_RESULT => X_ACCOUNT_RESULT,
138: P_ERROR_MSG => X_ERROR_MSG);
139: */

Line 136: P_CURRENCY_CODE => CE_ZBA_DEAL_GENERATION.cba_bank_currency,

132:
133: /* XTR_WRAPPER_API_P.bank_account_verification(
134: P_ORG_ID => CE_ZBA_DEAL_GENERATION.csh_org_id,
135: P_AP_BANK_ACCOUNT_ID => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,
136: P_CURRENCY_CODE => CE_ZBA_DEAL_GENERATION.cba_bank_currency,
137: P_RESULT => X_ACCOUNT_RESULT,
138: P_ERROR_MSG => X_ERROR_MSG);
139: */
140: IF l_DEBUG in ('Y', 'C') THEN

Line 146: cep_standard.debug('<

142: 'xtr_shared_account x_error_msg = ' || x_error_msg);
143: END IF;
144:
145: IF l_DEBUG in ('Y', 'C') THEN
146: cep_standard.debug('< 147: END IF;
148:
149: EXCEPTION
150: WHEN OTHERS THEN

Line 152: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.xtr_shared_account');

148:
149: EXCEPTION
150: WHEN OTHERS THEN
151: IF l_DEBUG in ('Y', 'C') THEN
152: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.xtr_shared_account');
153: END IF;
154: RAISE;
155: END xtr_shared_account;
156:

Line 180: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement');

176: lockmode NUMBER;
177: timeout NUMBER;
178: release_on_commit BOOLEAN;
179: BEGIN
180: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement');
181:
182: SELECT statement_header_id
183: INTO x_statement_header_id
184: FROM ce_statement_headers

Line 185: WHERE rowid = CE_ZBA_DEAL_GENERATION.csh_rowid

181:
182: SELECT statement_header_id
183: INTO x_statement_header_id
184: FROM ce_statement_headers
185: WHERE rowid = CE_ZBA_DEAL_GENERATION.csh_rowid
186: FOR UPDATE OF statement_header_id NOWAIT;
187:
188: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Regular statement lock OK');
189: lockname := CE_ZBA_DEAL_GENERATION.csh_rowid;

Line 188: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Regular statement lock OK');

184: FROM ce_statement_headers
185: WHERE rowid = CE_ZBA_DEAL_GENERATION.csh_rowid
186: FOR UPDATE OF statement_header_id NOWAIT;
187:
188: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Regular statement lock OK');
189: lockname := CE_ZBA_DEAL_GENERATION.csh_rowid;
190: timeout := 1;
191: lockmode := 6;
192: expiration_secs := 10;

Line 189: lockname := CE_ZBA_DEAL_GENERATION.csh_rowid;

185: WHERE rowid = CE_ZBA_DEAL_GENERATION.csh_rowid
186: FOR UPDATE OF statement_header_id NOWAIT;
187:
188: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Regular statement lock OK');
189: lockname := CE_ZBA_DEAL_GENERATION.csh_rowid;
190: timeout := 1;
191: lockmode := 6;
192: expiration_secs := 10;
193: release_on_commit := FALSE;

Line 197: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Allocating unique');

193: release_on_commit := FALSE;
194: --
195: -- dbms_lock of row to deal with other locking
196: --
197: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Allocating unique');
198: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
199: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,
200: release_on_commit );
201: IF (lock_status <> 0) THEN

Line 205: cep_standard.debug('<

201: IF (lock_status <> 0) THEN
202: lock_status := dbms_lock.release(lockhandle);
203: RAISE APP_EXCEPTIONS.record_lock_exception;
204: END IF;
205: cep_standard.debug('< 206: RETURN(TRUE);
207: EXCEPTION
208: WHEN APP_EXCEPTIONS.record_lock_exception THEN
209: return(FALSE);

Line 211: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement' );

207: EXCEPTION
208: WHEN APP_EXCEPTIONS.record_lock_exception THEN
209: return(FALSE);
210: WHEN OTHERS THEN
211: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement' );
212: RAISE;
213: return(FALSE);
214: END lock_statement;
215:

Line 228: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement_line');

224: | zba_generation |
225: --------------------------------------------------------------------- */
226: FUNCTION lock_statement_line RETURN BOOLEAN IS
227: BEGIN
228: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.lock_statement_line');
229: SELECT statement_line_id,
230: trx_date,
231: trx_type,
232: trx_code_id,

Line 243: INTO CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

239: line_number,
240: customer_text,
241: effective_date,
242: original_amount
243: INTO CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
244: CE_ZBA_DEAL_GENERATION.csl_trx_date,
245: CE_ZBA_DEAL_GENERATION.csl_trx_type,
246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,

Line 244: CE_ZBA_DEAL_GENERATION.csl_trx_date,

240: customer_text,
241: effective_date,
242: original_amount
243: INTO CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
244: CE_ZBA_DEAL_GENERATION.csl_trx_date,
245: CE_ZBA_DEAL_GENERATION.csl_trx_type,
246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,

Line 245: CE_ZBA_DEAL_GENERATION.csl_trx_type,

241: effective_date,
242: original_amount
243: INTO CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
244: CE_ZBA_DEAL_GENERATION.csl_trx_date,
245: CE_ZBA_DEAL_GENERATION.csl_trx_type,
246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,

Line 246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,

242: original_amount
243: INTO CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
244: CE_ZBA_DEAL_GENERATION.csl_trx_date,
245: CE_ZBA_DEAL_GENERATION.csl_trx_type,
246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,

Line 247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,

243: INTO CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
244: CE_ZBA_DEAL_GENERATION.csl_trx_date,
245: CE_ZBA_DEAL_GENERATION.csl_trx_type,
246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,

Line 248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,

244: CE_ZBA_DEAL_GENERATION.csl_trx_date,
245: CE_ZBA_DEAL_GENERATION.csl_trx_type,
246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,

Line 249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,

245: CE_ZBA_DEAL_GENERATION.csl_trx_type,
246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,

Line 250: CE_ZBA_DEAL_GENERATION.csl_amount,

246: CE_ZBA_DEAL_GENERATION.csl_trx_code_id,
247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,

Line 251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,

247: CE_ZBA_DEAL_GENERATION.csl_bank_trx_number,
248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,

Line 252: CE_ZBA_DEAL_GENERATION.csl_currency_code,

248: CE_ZBA_DEAL_GENERATION.csl_invoice_text,
249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,
256: CE_ZBA_DEAL_GENERATION.csl_original_amount

Line 253: CE_ZBA_DEAL_GENERATION.csl_line_number,

249: CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,
256: CE_ZBA_DEAL_GENERATION.csl_original_amount
257: FROM ce_statement_lines

Line 254: CE_ZBA_DEAL_GENERATION.csl_customer_text,

250: CE_ZBA_DEAL_GENERATION.csl_amount,
251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,
256: CE_ZBA_DEAL_GENERATION.csl_original_amount
257: FROM ce_statement_lines
258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid

Line 255: CE_ZBA_DEAL_GENERATION.csl_effective_date,

251: CE_ZBA_DEAL_GENERATION.csl_charges_amount,
252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,
256: CE_ZBA_DEAL_GENERATION.csl_original_amount
257: FROM ce_statement_lines
258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid
259: FOR UPDATE OF status NOWAIT;

Line 256: CE_ZBA_DEAL_GENERATION.csl_original_amount

252: CE_ZBA_DEAL_GENERATION.csl_currency_code,
253: CE_ZBA_DEAL_GENERATION.csl_line_number,
254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,
256: CE_ZBA_DEAL_GENERATION.csl_original_amount
257: FROM ce_statement_lines
258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid
259: FOR UPDATE OF status NOWAIT;
260:

Line 258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid

254: CE_ZBA_DEAL_GENERATION.csl_customer_text,
255: CE_ZBA_DEAL_GENERATION.csl_effective_date,
256: CE_ZBA_DEAL_GENERATION.csl_original_amount
257: FROM ce_statement_lines
258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid
259: FOR UPDATE OF status NOWAIT;
260:
261: cep_standard.debug('< 262: RETURN(TRUE);

Line 261: cep_standard.debug('<

257: FROM ce_statement_lines
258: WHERE rowid = CE_ZBA_DEAL_GENERATION.csl_rowid
259: FOR UPDATE OF status NOWAIT;
260:
261: cep_standard.debug('< 262: RETURN(TRUE);
263:
264: EXCEPTION
265: WHEN APP_EXCEPTIONS.record_lock_exception THEN

Line 268: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement_line' );

264: EXCEPTION
265: WHEN APP_EXCEPTIONS.record_lock_exception THEN
266: return(FALSE);
267: WHEN OTHERS THEN
268: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.lock_statement_line' );
269: RAISE;
270: return(FALSE);
271: END lock_statement_line;
272:

Line 289: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');

285: FUNCTION get_min_statement_line_id RETURN NUMBER IS
286: min_statement_line NUMBER;
287: min_statement_line_num NUMBER;
288: BEGIN
289: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');
290: SELECT min(line_number)
291: INTO min_statement_line_num
292: FROM ce_statement_lines
293: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;

Line 293: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;

289: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');
290: SELECT min(line_number)
291: INTO min_statement_line_num
292: FROM ce_statement_lines
293: WHERE statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
294:
295: SELECT statement_line_id
296: INTO min_statement_line
297: FROM ce_statement_lines

Line 299: AND statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;

295: SELECT statement_line_id
296: INTO min_statement_line
297: FROM ce_statement_lines
298: WHERE line_number = min_statement_line_num
299: AND statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
300: cep_standard.debug('< 301:
302: RETURN (min_statement_line);
303: EXCEPTION

Line 300: cep_standard.debug('<

296: INTO min_statement_line
297: FROM ce_statement_lines
298: WHERE line_number = min_statement_line_num
299: AND statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id;
300: cep_standard.debug('< 301:
302: RETURN (min_statement_line);
303: EXCEPTION
304: WHEN OTHERS THEN

Line 305: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');

301:
302: RETURN (min_statement_line);
303: EXCEPTION
304: WHEN OTHERS THEN
305: cep_standard.debug('EXCEPTION: CE_ZBA_DEAL_GENERATION.get_min_statement_line_id');
306: RAISE;
307: END get_min_statement_line_id;
308:
309: /* ---------------------------------------------------------------------

Line 318: | all parameters of CE_ZBA_DEAL_GENERATION.zba_generation |

314: | Procedure to set parameter values into globals |
315: | CALLED BY |
316: | zba_generation |
317: | REQUIRES |
318: | all parameters of CE_ZBA_DEAL_GENERATION.zba_generation |
319: --------------------------------------------------------------------- */
320: PROCEDURE set_parameters(p_bank_branch_id NUMBER,
321: p_bank_account_id NUMBER,
322: p_statement_number_from VARCHAR2,

Line 331: CE_ZBA_DEAL_GENERATION.G_bank_branch_id := p_bank_branch_id;

327: p_debug_path VARCHAR2,
328: p_debug_file VARCHAR2) IS
329: BEGIN
330:
331: CE_ZBA_DEAL_GENERATION.G_bank_branch_id := p_bank_branch_id;
332: CE_ZBA_DEAL_GENERATION.G_bank_account_id := p_bank_account_id;
333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;
334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');

Line 332: CE_ZBA_DEAL_GENERATION.G_bank_account_id := p_bank_account_id;

328: p_debug_file VARCHAR2) IS
329: BEGIN
330:
331: CE_ZBA_DEAL_GENERATION.G_bank_branch_id := p_bank_branch_id;
332: CE_ZBA_DEAL_GENERATION.G_bank_account_id := p_bank_account_id;
333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;
334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');

Line 333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;

329: BEGIN
330:
331: CE_ZBA_DEAL_GENERATION.G_bank_branch_id := p_bank_branch_id;
332: CE_ZBA_DEAL_GENERATION.G_bank_account_id := p_bank_account_id;
333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;
334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;

Line 334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;

330:
331: CE_ZBA_DEAL_GENERATION.G_bank_branch_id := p_bank_branch_id;
332: CE_ZBA_DEAL_GENERATION.G_bank_account_id := p_bank_account_id;
333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;
334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;
338: CE_ZBA_DEAL_GENERATION.G_debug_path := p_debug_path;

Line 335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');

331: CE_ZBA_DEAL_GENERATION.G_bank_branch_id := p_bank_branch_id;
332: CE_ZBA_DEAL_GENERATION.G_bank_account_id := p_bank_account_id;
333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;
334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;
338: CE_ZBA_DEAL_GENERATION.G_debug_path := p_debug_path;
339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;

Line 336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');

332: CE_ZBA_DEAL_GENERATION.G_bank_account_id := p_bank_account_id;
333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;
334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;
338: CE_ZBA_DEAL_GENERATION.G_debug_path := p_debug_path;
339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;
340:

Line 337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;

333: CE_ZBA_DEAL_GENERATION.G_statement_number_from := p_statement_number_from;
334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;
338: CE_ZBA_DEAL_GENERATION.G_debug_path := p_debug_path;
339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;
340:
341:

Line 338: CE_ZBA_DEAL_GENERATION.G_debug_path := p_debug_path;

334: CE_ZBA_DEAL_GENERATION.G_statement_number_to := p_statement_number_to;
335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;
338: CE_ZBA_DEAL_GENERATION.G_debug_path := p_debug_path;
339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;
340:
341:
342: IF l_DEBUG in ('Y', 'C') THEN

Line 339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;

335: CE_ZBA_DEAL_GENERATION.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
336: CE_ZBA_DEAL_GENERATION.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
337: CE_ZBA_DEAL_GENERATION.G_display_debug := p_display_debug;
338: CE_ZBA_DEAL_GENERATION.G_debug_path := p_debug_path;
339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;
340:
341:
342: IF l_DEBUG in ('Y', 'C') THEN
343: cep_standard.debug('<

Line 343: cep_standard.debug('<

339: CE_ZBA_DEAL_GENERATION.G_debug_file := p_debug_file;
340:
341:
342: IF l_DEBUG in ('Y', 'C') THEN
343: cep_standard.debug('< 344: END IF;
345: END set_parameters;
346:
347: /* ---------------------------------------------------------------------

Line 486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);

482:
483: IF l_DEBUG in ('Y', 'C') THEN
484: cep_standard.enable_debug(p_debug_path, p_debug_file);
485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);

Line 487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);

483: IF l_DEBUG in ('Y', 'C') THEN
484: cep_standard.enable_debug(p_debug_path, p_debug_file);
485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);

Line 488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);

484: cep_standard.enable_debug(p_debug_path, p_debug_file);
485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);

Line 489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);

485:
486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);

Line 490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);

486: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation '||sysdate);
487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);

Line 491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);

487: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_branch_id : '|| p_bank_branch_id);
488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);

Line 492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);

488: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_bank_account_id : '|| p_bank_account_id);
489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:

Line 493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);

489: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_from: '|| p_statement_number_from);
490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:

Line 494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);

490: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_number_to: '|| p_statement_number_to);
491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:
498: END IF;

Line 495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);

491: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_from: '|| p_statement_date_from);
492: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_statement_date_to: '|| p_statement_date_to);
493: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_display_debug: '|| p_display_debug);
494: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_path: '|| p_debug_path);
495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:
498: END IF;
499: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');

Line 499: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');

495: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.p_debug_file: '|| p_debug_file);
496:
497:
498: END IF;
499: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');
500:
501: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
502: CEP_STANDARD.init_security;
503:

Line 514: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_branch_cursor');

510: p_display_debug,
511: p_debug_path,
512: p_debug_file);
513:
514: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_branch_cursor');
515: OPEN r_branch_cursor( CE_ZBA_DEAL_GENERATION.G_bank_branch_id,
516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);
517: j := 0;
518: LOOP

Line 515: OPEN r_branch_cursor( CE_ZBA_DEAL_GENERATION.G_bank_branch_id,

511: p_debug_path,
512: p_debug_file);
513:
514: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_branch_cursor');
515: OPEN r_branch_cursor( CE_ZBA_DEAL_GENERATION.G_bank_branch_id,
516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);
517: j := 0;
518: LOOP
519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');

Line 516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);

512: p_debug_file);
513:
514: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_branch_cursor');
515: OPEN r_branch_cursor( CE_ZBA_DEAL_GENERATION.G_bank_branch_id,
516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);
517: j := 0;
518: LOOP
519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');
520: FETCH r_branch_cursor INTO CE_ZBA_DEAL_GENERATION.csh_bank_account_id;

Line 519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');

515: OPEN r_branch_cursor( CE_ZBA_DEAL_GENERATION.G_bank_branch_id,
516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);
517: j := 0;
518: LOOP
519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');
520: FETCH r_branch_cursor INTO CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
521:
522: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csh_bank_account_id = '||CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
523:

Line 520: FETCH r_branch_cursor INTO CE_ZBA_DEAL_GENERATION.csh_bank_account_id;

516: CE_ZBA_DEAL_GENERATION.G_bank_account_id);
517: j := 0;
518: LOOP
519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');
520: FETCH r_branch_cursor INTO CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
521:
522: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csh_bank_account_id = '||CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
523:
524: IF (r_branch_cursor%ROWCOUNT = j) THEN

Line 522: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csh_bank_account_id = '||CE_ZBA_DEAL_GENERATION.csh_bank_account_id);

518: LOOP
519: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_branch_cursor');
520: FETCH r_branch_cursor INTO CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
521:
522: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csh_bank_account_id = '||CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
523:
524: IF (r_branch_cursor%ROWCOUNT = j) THEN
525: EXIT;
526: ELSE

Line 530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');

526: ELSE
527: j := r_branch_cursor%ROWCOUNT;
528: END IF;
529:
530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');
531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,
532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,
533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,
534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,

Line 531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,

527: j := r_branch_cursor%ROWCOUNT;
528: END IF;
529:
530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');
531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,
532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,
533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,
534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,
535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);

Line 532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,

528: END IF;
529:
530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');
531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,
532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,
533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,
534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,
535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
536: i := 0;

Line 533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,

529:
530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');
531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,
532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,
533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,
534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,
535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
536: i := 0;
537: LOOP

Line 534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,

530: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening r_bank_cursor');
531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,
532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,
533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,
534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,
535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
536: i := 0;
537: LOOP
538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');

Line 535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);

531: OPEN r_bank_cursor (CE_ZBA_DEAL_GENERATION.G_statement_number_from,
532: CE_ZBA_DEAL_GENERATION.G_statement_number_to,
533: CE_ZBA_DEAL_GENERATION.G_statement_date_from,
534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,
535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
536: i := 0;
537: LOOP
538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');
539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

Line 538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');

534: CE_ZBA_DEAL_GENERATION.G_statement_date_to,
535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
536: i := 0;
537: LOOP
538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');
539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,

Line 539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

535: CE_ZBA_DEAL_GENERATION.csh_bank_account_id);
536: i := 0;
537: LOOP
538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');
539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,

Line 540: CE_ZBA_DEAL_GENERATION.csh_statement_number,

536: i := 0;
537: LOOP
538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');
539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,

Line 541: CE_ZBA_DEAL_GENERATION.csh_statement_date,

537: LOOP
538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');
539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,

Line 542: CE_ZBA_DEAL_GENERATION.csh_check_digits,

538: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Fetching r_bank_cursor');
539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,

Line 543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,

539: FETCH r_bank_cursor INTO CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,

Line 544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,

540: CE_ZBA_DEAL_GENERATION.csh_statement_number,
541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,

Line 545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,

541: CE_ZBA_DEAL_GENERATION.csh_statement_date,
542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;

Line 546: CE_ZBA_DEAL_GENERATION.cba_check_digits,

542: CE_ZBA_DEAL_GENERATION.csh_check_digits,
543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');

Line 547: CE_ZBA_DEAL_GENERATION.csh_rowid,

543: CE_ZBA_DEAL_GENERATION.csh_statement_gl_date,
544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||

Line 548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,

544: CE_ZBA_DEAL_GENERATION.cba_bank_currency,
545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||
552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );

Line 549: CE_ZBA_DEAL_GENERATION.csh_org_id;

545: CE_ZBA_DEAL_GENERATION.cba_multi_currency_flag,
546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||
552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );
553:

Line 550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');

546: CE_ZBA_DEAL_GENERATION.cba_check_digits,
547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||
552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );
553:
554: if (r_bank_cursor%ROWCOUNT = i) then

Line 551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||

547: CE_ZBA_DEAL_GENERATION.csh_rowid,
548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||
552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );
553:
554: if (r_bank_cursor%ROWCOUNT = i) then
555: EXIT;

Line 552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );

548: CE_ZBA_DEAL_GENERATION.csh_statement_complete_flag,
549: CE_ZBA_DEAL_GENERATION.csh_org_id;
550: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.After fetch header');
551: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.statement_header_id:' ||
552: CE_ZBA_DEAL_GENERATION.csh_statement_header_id );
553:
554: if (r_bank_cursor%ROWCOUNT = i) then
555: EXIT;
556: else

Line 563: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

559: -- EXIT WHEN r_bank_cursor%NOTFOUND OR r_bank_cursor%NOTFOUND IS NULL;
560:
561: -- Clean up error table
562: CE_ZBA_DEAL_INF_PKG.delete_row(
563: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
564: to_number(NULL));
565:
566: --Validate existing of unreconciled sweep lines
567: select count(1)

Line 570: where statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id

566: --Validate existing of unreconciled sweep lines
567: select count(1)
568: into row_count
569: from ce_statement_lines
570: where statement_header_id = CE_ZBA_DEAL_GENERATION.csh_statement_header_id
571: and trx_type in ('SWEEP_IN', 'SWEEP_OUT');
572:
573: cep_standard.debug('row_count = '||row_count);
574:

Line 577: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

573: cep_standard.debug('row_count = '||row_count);
574:
575: if (row_count = 0 ) then
576: CE_ZBA_DEAL_INF_PKG.insert_row(
577: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
578: to_number(NULL), 'CE_NO_SWEEP_STMT_LINE');
579: EXIT;
580: cep_standard.debug('>>validate existing of unreconciled sweep lines');
581: else --Validate the bank account is an authorized treasury account

Line 585: where ba.bank_account_id = CE_ZBA_DEAL_GENERATION.csh_bank_account_id

581: else --Validate the bank account is an authorized treasury account
582: if fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS') = 'XTR' then
583: select count(1) into l_count
584: from ce_bank_accounts ba, ce_bank_acct_uses_all bau
585: where ba.bank_account_id = CE_ZBA_DEAL_GENERATION.csh_bank_account_id
586: and bau.bank_account_id = ba.bank_account_id
587: and ba.xtr_use_allowed_flag = 'Y'
588: and bau.authorized_flag = 'Y';
589:

Line 592: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

588: and bau.authorized_flag = 'Y';
589:
590: if l_count = 0 then
591: CE_ZBA_DEAL_INF_PKG.insert_row (
592: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
593: to_number(NULL), 'CE_XTR_INVALID_ACCT');
594: EXIT;
595: end if;
596: end if;

Line 601: IF (nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.csh_check_digits, 'NO DIGIT'),

597: end if;
598:
599: cep_standard.debug('>>validate shared bank account is setup correctly');
600:
601: IF (nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.csh_check_digits, 'NO DIGIT'),
602: '0'), '0') = nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.cba_check_digits,
603: 'NO DIGIT'), '0'), '0')) THEN
604:
605: cep_standard.debug('csh_check_digits = '||csh_check_digits);

Line 602: '0'), '0') = nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.cba_check_digits,

598:
599: cep_standard.debug('>>validate shared bank account is setup correctly');
600:
601: IF (nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.csh_check_digits, 'NO DIGIT'),
602: '0'), '0') = nvl(LTRIM(nvl(CE_ZBA_DEAL_GENERATION.cba_check_digits,
603: 'NO DIGIT'), '0'), '0')) THEN
604:
605: cep_standard.debug('csh_check_digits = '||csh_check_digits);
606: cep_standard.debug('cba_check_digits = '||cba_check_digits);

Line 620: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening line_cursor');

616: --
617: -- Read in all the lines on the statement for the selected bank
618: -- account.
619: --
620: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening line_cursor');
621: OPEN line_cursor (CE_ZBA_DEAL_GENERATION.csh_statement_header_id);
622: LOOP
623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

Line 621: OPEN line_cursor (CE_ZBA_DEAL_GENERATION.csh_statement_header_id);

617: -- Read in all the lines on the statement for the selected bank
618: -- account.
619: --
620: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening line_cursor');
621: OPEN line_cursor (CE_ZBA_DEAL_GENERATION.csh_statement_header_id);
622: LOOP
623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,

Line 623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,

619: --
620: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening line_cursor');
621: OPEN line_cursor (CE_ZBA_DEAL_GENERATION.csh_statement_header_id);
622: LOOP
623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,
626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,

Line 624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

620: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.Opening line_cursor');
621: OPEN line_cursor (CE_ZBA_DEAL_GENERATION.csh_statement_header_id);
622: LOOP
623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,
626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,

Line 625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,

621: OPEN line_cursor (CE_ZBA_DEAL_GENERATION.csh_statement_header_id);
622: LOOP
623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,
626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,

Line 626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,

622: LOOP
623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,
626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,

Line 627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,

623: FETCH line_cursor INTO CE_ZBA_DEAL_GENERATION.csl_rowid,
624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,
626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,

Line 628: CE_ZBA_DEAL_GENERATION.csl_matching_against,

624: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,
626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,

Line 629: CE_ZBA_DEAL_GENERATION.csl_correction_method,

625: CE_ZBA_DEAL_GENERATION.csl_receivables_trx_id,
626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,

Line 630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,

626: CE_ZBA_DEAL_GENERATION.csl_receipt_method_id,
627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,

Line 631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,

627: CE_ZBA_DEAL_GENERATION.csl_create_misc_trx_flag,
628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,

Line 632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,

628: CE_ZBA_DEAL_GENERATION.csl_matching_against,
629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,

Line 633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,

629: CE_ZBA_DEAL_GENERATION.csl_correction_method,
630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,

Line 634: CE_ZBA_DEAL_GENERATION.csl_currency_code,

630: CE_ZBA_DEAL_GENERATION.csl_receipt_method_name,
631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,

Line 635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,

631: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_type,
632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,
639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,

Line 636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,

632: CE_ZBA_DEAL_GENERATION.csl_exchange_rate_date,
633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,
639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,

Line 637: CE_ZBA_DEAL_GENERATION.csl_match_found,

633: CE_ZBA_DEAL_GENERATION.csl_exchange_rate,
634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,
639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,
641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;

Line 638: CE_ZBA_DEAL_GENERATION.csl_match_type,

634: CE_ZBA_DEAL_GENERATION.csl_currency_code,
635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,
639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,
641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;
642: EXIT WHEN line_cursor%NOTFOUND OR line_cursor%NOTFOUND IS NULL;

Line 639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,

635: CE_ZBA_DEAL_GENERATION.csl_line_trx_type,
636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,
639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,
641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;
642: EXIT WHEN line_cursor%NOTFOUND OR line_cursor%NOTFOUND IS NULL;
643: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csl_statement_line_id = '|| CE_ZBA_DEAL_GENERATION.csl_statement_line_id);

Line 640: CE_ZBA_DEAL_GENERATION.csl_original_amount,

636: CE_ZBA_DEAL_GENERATION.csl_reconcile_flag,
637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,
639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,
641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;
642: EXIT WHEN line_cursor%NOTFOUND OR line_cursor%NOTFOUND IS NULL;
643: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csl_statement_line_id = '|| CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
644:

Line 641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;

637: CE_ZBA_DEAL_GENERATION.csl_match_found,
638: CE_ZBA_DEAL_GENERATION.csl_match_type,
639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,
641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;
642: EXIT WHEN line_cursor%NOTFOUND OR line_cursor%NOTFOUND IS NULL;
643: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csl_statement_line_id = '|| CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
644:
645:

Line 643: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csl_statement_line_id = '|| CE_ZBA_DEAL_GENERATION.csl_statement_line_id);

639: CE_ZBA_DEAL_GENERATION.csl_clearing_trx_type,
640: CE_ZBA_DEAL_GENERATION.csl_original_amount,
641: CE_ZBA_DEAL_GENERATION.csl_payroll_payment_format;
642: EXIT WHEN line_cursor%NOTFOUND OR line_cursor%NOTFOUND IS NULL;
643: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.csl_statement_line_id = '|| CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
644:
645:
646: select count(*)
647: into rec_status

Line 652: CE_ZBA_DEAL_GENERATION.csl_statement_line_id

648: --from ce_statement_reconciliations
649:
650: from ce_statement_reconcils_all
651: where statement_line_id =
652: CE_ZBA_DEAL_GENERATION.csl_statement_line_id
653: and nvl(status_flag, 'U') = 'M'
654: and nvl(current_record_flag, 'Y') = 'Y';
655:
656: if (rec_status = 0) then

Line 663: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

659: --
660: -- Clear ce_zba_deal_inf table
661: --
662: CE_ZBA_DEAL_INF_PKG.delete_row(
663: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
664: CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
665: IF (lock_statement_line) THEN
666:
667: --Validate zero amount line

Line 664: CE_ZBA_DEAL_GENERATION.csl_statement_line_id);

660: -- Clear ce_zba_deal_inf table
661: --
662: CE_ZBA_DEAL_INF_PKG.delete_row(
663: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
664: CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
665: IF (lock_statement_line) THEN
666:
667: --Validate zero amount line
668: IF (CE_ZBA_DEAL_GENERATION.csl_amount = 0)THEN

Line 668: IF (CE_ZBA_DEAL_GENERATION.csl_amount = 0)THEN

664: CE_ZBA_DEAL_GENERATION.csl_statement_line_id);
665: IF (lock_statement_line) THEN
666:
667: --Validate zero amount line
668: IF (CE_ZBA_DEAL_GENERATION.csl_amount = 0)THEN
669: CE_ZBA_DEAL_INF_PKG.insert_row (
670: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
671: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_ZERO_AMOUNT');
672: END IF;

Line 670: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

666:
667: --Validate zero amount line
668: IF (CE_ZBA_DEAL_GENERATION.csl_amount = 0)THEN
669: CE_ZBA_DEAL_INF_PKG.insert_row (
670: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
671: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_ZERO_AMOUNT');
672: END IF;
673: cep_standard.debug('csl_amount = '||csl_amount);
674:

Line 671: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_ZERO_AMOUNT');

667: --Validate zero amount line
668: IF (CE_ZBA_DEAL_GENERATION.csl_amount = 0)THEN
669: CE_ZBA_DEAL_INF_PKG.insert_row (
670: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
671: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_ZERO_AMOUNT');
672: END IF;
673: cep_standard.debug('csl_amount = '||csl_amount);
674:
675: --Validate different currencies between statement header and line

Line 676: IF (CE_ZBA_DEAL_GENERATION.cba_bank_currency <>

672: END IF;
673: cep_standard.debug('csl_amount = '||csl_amount);
674:
675: --Validate different currencies between statement header and line
676: IF (CE_ZBA_DEAL_GENERATION.cba_bank_currency <>
677: nvl(CE_ZBA_DEAL_GENERATION.csl_currency_code, CE_ZBA_DEAL_GENERATION.cba_bank_currency)) THEN
678: CE_ZBA_DEAL_INF_PKG.insert_row (
679: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
680: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_DIFF_CURRENCY');

Line 677: nvl(CE_ZBA_DEAL_GENERATION.csl_currency_code, CE_ZBA_DEAL_GENERATION.cba_bank_currency)) THEN

673: cep_standard.debug('csl_amount = '||csl_amount);
674:
675: --Validate different currencies between statement header and line
676: IF (CE_ZBA_DEAL_GENERATION.cba_bank_currency <>
677: nvl(CE_ZBA_DEAL_GENERATION.csl_currency_code, CE_ZBA_DEAL_GENERATION.cba_bank_currency)) THEN
678: CE_ZBA_DEAL_INF_PKG.insert_row (
679: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
680: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_DIFF_CURRENCY');
681: END IF;

Line 679: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

675: --Validate different currencies between statement header and line
676: IF (CE_ZBA_DEAL_GENERATION.cba_bank_currency <>
677: nvl(CE_ZBA_DEAL_GENERATION.csl_currency_code, CE_ZBA_DEAL_GENERATION.cba_bank_currency)) THEN
678: CE_ZBA_DEAL_INF_PKG.insert_row (
679: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
680: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_DIFF_CURRENCY');
681: END IF;
682: cep_standard.debug('csl_currency_code = '||csl_currency_code);
683: cep_standard.debug('cba_bank_currency = '||cba_bank_currency);

Line 680: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_DIFF_CURRENCY');

676: IF (CE_ZBA_DEAL_GENERATION.cba_bank_currency <>
677: nvl(CE_ZBA_DEAL_GENERATION.csl_currency_code, CE_ZBA_DEAL_GENERATION.cba_bank_currency)) THEN
678: CE_ZBA_DEAL_INF_PKG.insert_row (
679: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
680: CE_ZBA_DEAL_GENERATION.csl_statement_line_id, 'CE_ZBA_DIFF_CURRENCY');
681: END IF;
682: cep_standard.debug('csl_currency_code = '||csl_currency_code);
683: cep_standard.debug('cba_bank_currency = '||cba_bank_currency);
684:

Line 689: p_header_bank_account_id => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,

685: --
686: -- Deal Generation
687: --
688: cp_match_bool := CE_LEVELING_UTILS.Match_Cashpool(
689: p_header_bank_account_id => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,
690: p_offset_bank_account_num => CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
691: p_trx_type => CE_ZBA_DEAL_GENERATION.csl_trx_type,
692: p_trx_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
693: p_offset_bank_account_id => x_offset_bank_account_id,

Line 690: p_offset_bank_account_num => CE_ZBA_DEAL_GENERATION.csl_bank_account_text,

686: -- Deal Generation
687: --
688: cp_match_bool := CE_LEVELING_UTILS.Match_Cashpool(
689: p_header_bank_account_id => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,
690: p_offset_bank_account_num => CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
691: p_trx_type => CE_ZBA_DEAL_GENERATION.csl_trx_type,
692: p_trx_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
693: p_offset_bank_account_id => x_offset_bank_account_id,
694: p_cashpool_id => x_cashpool_id);

Line 691: p_trx_type => CE_ZBA_DEAL_GENERATION.csl_trx_type,

687: --
688: cp_match_bool := CE_LEVELING_UTILS.Match_Cashpool(
689: p_header_bank_account_id => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,
690: p_offset_bank_account_num => CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
691: p_trx_type => CE_ZBA_DEAL_GENERATION.csl_trx_type,
692: p_trx_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
693: p_offset_bank_account_id => x_offset_bank_account_id,
694: p_cashpool_id => x_cashpool_id);
695:

Line 692: p_trx_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,

688: cp_match_bool := CE_LEVELING_UTILS.Match_Cashpool(
689: p_header_bank_account_id => CE_ZBA_DEAL_GENERATION.csh_bank_account_id,
690: p_offset_bank_account_num => CE_ZBA_DEAL_GENERATION.csl_bank_account_text,
691: p_trx_type => CE_ZBA_DEAL_GENERATION.csl_trx_type,
692: p_trx_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
693: p_offset_bank_account_id => x_offset_bank_account_id,
694: p_cashpool_id => x_cashpool_id);
695:
696: IF (cp_match_bool) THEN -- found matching cash pool

Line 697: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id := x_offset_bank_account_id;

693: p_offset_bank_account_id => x_offset_bank_account_id,
694: p_cashpool_id => x_cashpool_id);
695:
696: IF (cp_match_bool) THEN -- found matching cash pool
697: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id := x_offset_bank_account_id;
698: CE_ZBA_DEAL_GENERATION.p_cashpool_id := x_cashpool_id;
699:
700: -- Bug5122576. The from and to bank accounts will be determined
701: -- in the Generate_Fund_Transfer api. From here, the

Line 698: CE_ZBA_DEAL_GENERATION.p_cashpool_id := x_cashpool_id;

694: p_cashpool_id => x_cashpool_id);
695:
696: IF (cp_match_bool) THEN -- found matching cash pool
697: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id := x_offset_bank_account_id;
698: CE_ZBA_DEAL_GENERATION.p_cashpool_id := x_cashpool_id;
699:
700: -- Bug5122576. The from and to bank accounts will be determined
701: -- in the Generate_Fund_Transfer api. From here, the
702: -- p_from_bank_account_id will always be the statement line's

Line 706: CE_ZBA_DEAL_GENERATION.p_from_bank_account_id :=

702: -- p_from_bank_account_id will always be the statement line's
703: -- bank account and p_to_bank_Account_id will always be the
704: -- offset bank account
705:
706: CE_ZBA_DEAL_GENERATION.p_from_bank_account_id :=
707: CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
708: CE_ZBA_DEAL_GENERATION.p_to_bank_account_id :=
709: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id;
710:

Line 707: CE_ZBA_DEAL_GENERATION.csh_bank_account_id;

703: -- bank account and p_to_bank_Account_id will always be the
704: -- offset bank account
705:
706: CE_ZBA_DEAL_GENERATION.p_from_bank_account_id :=
707: CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
708: CE_ZBA_DEAL_GENERATION.p_to_bank_account_id :=
709: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id;
710:
711:

Line 708: CE_ZBA_DEAL_GENERATION.p_to_bank_account_id :=

704: -- offset bank account
705:
706: CE_ZBA_DEAL_GENERATION.p_from_bank_account_id :=
707: CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
708: CE_ZBA_DEAL_GENERATION.p_to_bank_account_id :=
709: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id;
710:
711:
712: CE_LEVELING_UTILS.Generate_Fund_Transfer(

Line 709: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id;

705:
706: CE_ZBA_DEAL_GENERATION.p_from_bank_account_id :=
707: CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
708: CE_ZBA_DEAL_GENERATION.p_to_bank_account_id :=
709: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id;
710:
711:
712: CE_LEVELING_UTILS.Generate_Fund_Transfer(
713: X_from_bank_account_id => CE_ZBA_DEAL_GENERATION.p_from_bank_account_id,

Line 713: X_from_bank_account_id => CE_ZBA_DEAL_GENERATION.p_from_bank_account_id,

709: CE_ZBA_DEAL_GENERATION.p_offset_bank_account_id;
710:
711:
712: CE_LEVELING_UTILS.Generate_Fund_Transfer(
713: X_from_bank_account_id => CE_ZBA_DEAL_GENERATION.p_from_bank_account_id,
714: X_to_bank_account_id => CE_ZBA_DEAL_GENERATION.p_to_bank_account_id,
715: X_cashpool_id => CE_ZBA_DEAL_GENERATION.p_cashpool_id,
716: X_amount => CE_ZBA_DEAL_GENERATION.csl_amount,
717: X_transfer_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,

Line 714: X_to_bank_account_id => CE_ZBA_DEAL_GENERATION.p_to_bank_account_id,

710:
711:
712: CE_LEVELING_UTILS.Generate_Fund_Transfer(
713: X_from_bank_account_id => CE_ZBA_DEAL_GENERATION.p_from_bank_account_id,
714: X_to_bank_account_id => CE_ZBA_DEAL_GENERATION.p_to_bank_account_id,
715: X_cashpool_id => CE_ZBA_DEAL_GENERATION.p_cashpool_id,
716: X_amount => CE_ZBA_DEAL_GENERATION.csl_amount,
717: X_transfer_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
718: X_settlement_authorized => 'Y',

Line 715: X_cashpool_id => CE_ZBA_DEAL_GENERATION.p_cashpool_id,

711:
712: CE_LEVELING_UTILS.Generate_Fund_Transfer(
713: X_from_bank_account_id => CE_ZBA_DEAL_GENERATION.p_from_bank_account_id,
714: X_to_bank_account_id => CE_ZBA_DEAL_GENERATION.p_to_bank_account_id,
715: X_cashpool_id => CE_ZBA_DEAL_GENERATION.p_cashpool_id,
716: X_amount => CE_ZBA_DEAL_GENERATION.csl_amount,
717: X_transfer_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
718: X_settlement_authorized => 'Y',
719: X_accept_limit_error => 'Y',

Line 716: X_amount => CE_ZBA_DEAL_GENERATION.csl_amount,

712: CE_LEVELING_UTILS.Generate_Fund_Transfer(
713: X_from_bank_account_id => CE_ZBA_DEAL_GENERATION.p_from_bank_account_id,
714: X_to_bank_account_id => CE_ZBA_DEAL_GENERATION.p_to_bank_account_id,
715: X_cashpool_id => CE_ZBA_DEAL_GENERATION.p_cashpool_id,
716: X_amount => CE_ZBA_DEAL_GENERATION.csl_amount,
717: X_transfer_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
718: X_settlement_authorized => 'Y',
719: X_accept_limit_error => 'Y',
720: X_request_id => null,

Line 717: X_transfer_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,

713: X_from_bank_account_id => CE_ZBA_DEAL_GENERATION.p_from_bank_account_id,
714: X_to_bank_account_id => CE_ZBA_DEAL_GENERATION.p_to_bank_account_id,
715: X_cashpool_id => CE_ZBA_DEAL_GENERATION.p_cashpool_id,
716: X_amount => CE_ZBA_DEAL_GENERATION.csl_amount,
717: X_transfer_date => CE_ZBA_DEAL_GENERATION.csl_trx_date,
718: X_settlement_authorized => 'Y',
719: X_accept_limit_error => 'Y',
720: X_request_id => null,
721: X_deal_type => l_deal_type,

Line 727: X_statement_line_id => CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

723: X_trx_number => l_transaction_num,
724: X_offset_deal_no => l_offset_deal_num,
725: X_offset_trx_number => l_offset_transaction_num,
726: X_success_flag => l_success_flag,
727: X_statement_line_id => CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
728: X_msg_count => l_msg_count,
729: X_cashflows_created_flag => l_cashflows_created_flag,
730: X_called_by_flag => 'Z');
731:

Line 749: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

745: offset_transaction_num,
746: deal_status_flag)
747: VALUES (
748: 'CE',
749: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
750: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
751: sysdate,
752: NVL(FND_GLOBAL.user_id,-1),
753: l_deal_type,

Line 750: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

746: deal_status_flag)
747: VALUES (
748: 'CE',
749: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
750: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
751: sysdate,
752: NVL(FND_GLOBAL.user_id,-1),
753: l_deal_type,
754: l_deal_num,

Line 756: CE_ZBA_DEAL_GENERATION.p_cashpool_id,

752: NVL(FND_GLOBAL.user_id,-1),
753: l_deal_type,
754: l_deal_num,
755: l_transaction_num,
756: CE_ZBA_DEAL_GENERATION.p_cashpool_id,
757: l_cashflows_created_flag,
758: l_offset_deal_num,
759: l_offset_transaction_num,
760: 'Y');

Line 774: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

770: deal_status_flag,
771: cashpool_id)
772: VALUES (
773: 'CE',
774: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
775: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
776: FND_MSG_PUB.get(1, FND_API.G_FALSE),
777: sysdate,
778: NVL(FND_GLOBAL.user_id,-1),

Line 775: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

771: cashpool_id)
772: VALUES (
773: 'CE',
774: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
775: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
776: FND_MSG_PUB.get(1, FND_API.G_FALSE),
777: sysdate,
778: NVL(FND_GLOBAL.user_id,-1),
779: 'N',

Line 780: CE_ZBA_DEAL_GENERATION.p_cashpool_id);

776: FND_MSG_PUB.get(1, FND_API.G_FALSE),
777: sysdate,
778: NVL(FND_GLOBAL.user_id,-1),
779: 'N',
780: CE_ZBA_DEAL_GENERATION.p_cashpool_id);
781: FND_MSG_PUB.delete_msg(1);
782: END LOOP;
783: END IF;
784: ELSE

Line 786: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

782: END LOOP;
783: END IF;
784: ELSE
785: CE_ZBA_DEAL_INF_PKG.insert_row(
786: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
787: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
788: 'CE_NO_CASHPOOL_MATCH');
789: END IF;
790: ELSE -- statement line is locked

Line 787: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

783: END IF;
784: ELSE
785: CE_ZBA_DEAL_INF_PKG.insert_row(
786: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
787: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
788: 'CE_NO_CASHPOOL_MATCH');
789: END IF;
790: ELSE -- statement line is locked
791: CE_ZBA_DEAL_INF_PKG.insert_row(

Line 792: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

788: 'CE_NO_CASHPOOL_MATCH');
789: END IF;
790: ELSE -- statement line is locked
791: CE_ZBA_DEAL_INF_PKG.insert_row(
792: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
793: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
794: 'CE_LINE_LOCKED');
795: END IF;
796: IF (statement_line_count =

Line 793: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,

789: END IF;
790: ELSE -- statement line is locked
791: CE_ZBA_DEAL_INF_PKG.insert_row(
792: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
793: CE_ZBA_DEAL_GENERATION.csl_statement_line_id,
794: 'CE_LINE_LOCKED');
795: END IF;
796: IF (statement_line_count =
797: CE_AUTO_BANK_REC.G_lines_per_commit) THEN

Line 810: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

806:
807: ELSE
808: error_statement_line_id := get_min_statement_line_id;
809: CE_ZBA_DEAL_INF_PKG.delete_row(
810: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
811: error_statement_line_id);
812: CE_ZBA_DEAL_INF_PKG.insert_row(
813: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
814: error_statement_line_id, 'CE_STATEMENT_COMPLETED');

Line 813: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,

809: CE_ZBA_DEAL_INF_PKG.delete_row(
810: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
811: error_statement_line_id);
812: CE_ZBA_DEAL_INF_PKG.insert_row(
813: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
814: error_statement_line_id, 'CE_STATEMENT_COMPLETED');
815: END IF; -- statement completed
816:
817: ELSE -- statement is locked

Line 819: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));

815: END IF; -- statement completed
816:
817: ELSE -- statement is locked
818: CE_ZBA_DEAL_INF_PKG.delete_row(
819: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
820: CE_ZBA_DEAL_INF_PKG.insert_row(
821: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
822: 'CE_LOCK_STATEMENT_HEADER_ERR');
823: END IF;

Line 821: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),

817: ELSE -- statement is locked
818: CE_ZBA_DEAL_INF_PKG.delete_row(
819: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
820: CE_ZBA_DEAL_INF_PKG.insert_row(
821: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
822: 'CE_LOCK_STATEMENT_HEADER_ERR');
823: END IF;
824: lock_status := dbms_lock.release(lockhandle);
825:

Line 828: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));

824: lock_status := dbms_lock.release(lockhandle);
825:
826: ELSE -- check digits failed
827: CE_ZBA_DEAL_INF_PKG.delete_row(
828: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
829: CE_ZBA_DEAL_INF_PKG.insert_row(
830: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
831: 'CE_CHECK_DIGITS');
832: END IF; -- check_digits

Line 830: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),

826: ELSE -- check digits failed
827: CE_ZBA_DEAL_INF_PKG.delete_row(
828: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));
829: CE_ZBA_DEAL_INF_PKG.insert_row(
830: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,to_number(NULL),
831: 'CE_CHECK_DIGITS');
832: END IF; -- check_digits
833:
834: END LOOP; -- statement headers

Line 908: cep_standard.debug('<

904: cep_standard.debug('zba_generation: ' || 'EXECUTION REPORT SUBMITTED');
905: END IF;
906: END IF;
907:
908: cep_standard.debug('< 909: cep_standard.disable_debug(p_display_debug);
910:
911: EXCEPTION
912: WHEN OTHERS THEN

Line 913: cep_standard.debug(' EXCEPTION: CE_ZBA_DEAL_GENERATION.zba_generation - OTHERS');

909: cep_standard.disable_debug(p_display_debug);
910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: cep_standard.debug(' EXCEPTION: CE_ZBA_DEAL_GENERATION.zba_generation - OTHERS');
914: IF r_branch_cursor%ISOPEN THEN
915: CLOSE r_branch_cursor;
916: END IF;
917: IF r_bank_cursor%ISOPEN THEN

Line 929: END CE_ZBA_DEAL_GENERATION;

925: cep_standard.debug('DEBUG: sqlerrm:' || sqlerrm);
926: RAISE;
927: END zba_generation;
928:
929: END CE_ZBA_DEAL_GENERATION;