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_CASHFLOW_PKG dependencies on CE_CASHFLOWS

Line 9: | update_ce_cashflows

5: -- l_DEBUG varchar2(1) := 'Y';
6:
7: /* ---------------------------------------------------------------------
8: | PRIVATE PROCEDURE |
9: | update_ce_cashflows
10: | DESCRIPTION |
11: | update records in CE_CASHFLOWS |
12: | CALLED BY |
13: | clear_cashflow

Line 11: | update records in CE_CASHFLOWS |

7: /* ---------------------------------------------------------------------
8: | PRIVATE PROCEDURE |
9: | update_ce_cashflows
10: | DESCRIPTION |
11: | update records in CE_CASHFLOWS |
12: | CALLED BY |
13: | clear_cashflow
14: --------------------------------------------------------------------- */
15: PROCEDURE update_ce_cashflows(

Line 15: PROCEDURE update_ce_cashflows(

11: | update records in CE_CASHFLOWS |
12: | CALLED BY |
13: | clear_cashflow
14: --------------------------------------------------------------------- */
15: PROCEDURE update_ce_cashflows(
16: X_CASHFLOW_ID number,
17: X_TRX_STATUS varchar2,
18: X_actual_value_date date,
19: X_CLEARED_DATE date,

Line 36: cep_standard.debug('>>CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');

32: X_PASSIN_MODE varchar2
33: ) IS
34: BEGIN
35: IF l_DEBUG in ('Y', 'C') THEN
36: cep_standard.debug('>>CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');
37: cep_standard.debug('X_PASSIN_MODE: '|| X_PASSIN_MODE ||
38: ', X_STATEMENT_LINE_ID: '|| X_STATEMENT_LINE_ID||
39: ', X_TRX_STATUS: '||X_TRX_STATUS||
40: ', X_NEW_TRX_STATUS: '|| X_NEW_TRX_STATUS

Line 53: UPDATE CE_CASHFLOWS

49: -- MANUAL (X_TRX_STATUS = 'RECONCILED', X_NEW_TRX_STATUS = 'CLEARED'),
50: IF ((X_PASSIN_MODE <> 'MANUAL_UC' and X_TRX_STATUS = 'CLEARED') or
51: ((X_PASSIN_MODE <> 'MANUAL_C' or X_PASSIN_MODE = 'MANUAL') and X_NEW_TRX_STATUS = 'CLEARED')) THEN
52: -- for cleared cashflows, keep current clear info
53: UPDATE CE_CASHFLOWS
54: SET CASHFLOW_STATUS_CODE = X_NEW_TRX_STATUS,
55: CLEARED_BY_FLAG = X_CLEARED_BY_FLAG,
56: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
57: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 66: UPDATE CE_CASHFLOWS

62: -- MANUAL_C (X_TRX_STATUS = 'CREATED', X_NEW_TRX_STATUS = 'CLEARED'),
63: -- MANUAL_UC (X_TRX_STATUS = 'CLEARED', X_NEW_TRX_STATUS = 'CREATED' ),
64: -- MANUAL (X_TRX_STATUS = 'CLEARED', X_NEW_TRX_STATUS = 'CREATED')
65: -- MANUAL_L, MANUAL_H, AUTO (X_TRX_STATUS = 'CREATED', X_NEW_TRX_STATUS = 'RECONCILED')
66: UPDATE CE_CASHFLOWS
67: SET CASHFLOW_STATUS_CODE = X_NEW_TRX_STATUS,
68: ACTUAL_VALUE_DATE = X_actual_value_date,
69: CLEARED_DATE = X_CLEARED_DATE ,
70: CLEARED_AMOUNT = abs(X_CLEARED_AMOUNT),

Line 86: cep_standard.debug('<

82:
83: END IF;
84:
85: IF l_DEBUG in ('Y', 'C') THEN
86: cep_standard.debug('< 87: END IF;
88:
89: EXCEPTION
90: WHEN OTHERS THEN

Line 92: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');

88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: IF l_DEBUG in ('Y', 'C') THEN
92: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');
93: END IF;
94: RAISE;
95: END UPDATE_CE_CASHFLOWS;
96:

Line 95: END UPDATE_CE_CASHFLOWS;

91: IF l_DEBUG in ('Y', 'C') THEN
92: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');
93: END IF;
94: RAISE;
95: END UPDATE_CE_CASHFLOWS;
96:
97: /* ---------------------------------------------------------------------
98: | PRIVATE PROCEDURE |
99: | RAISE_ACCT_EVENT

Line 144: | update_ce_cashflows |

140: | PRIVATE PROCEDURE |
141: | clear_cashflow |
142: | DESCRIPTION |
143: | CALLS |
144: | update_ce_cashflows |
145: | CALLED BY |
146: | CE_AUTO_BANK_CLEAR1.reconcile_trx |
147: | CE_AUTO_BANK_CLEAR1.unclear_process |
148: --------------------------------------------------------------------- */

Line 196: FROM ce_cashflows

192: INTO x_source_trxn_type,
193: x_trx_stmt_ln_id,
194: x_cashflow_status_code,
195: x_current_cleared_by_flag
196: FROM ce_cashflows
197: WHERE cashflow_id = X_CASHFLOW_ID;
198:
199: X_NEW_STMT_LN_ID := nvl(X_STATEMENT_LINE_ID, x_trx_stmt_ln_id);
200: X_NEW_STATEMENT_LINE_TYPE := X_STATEMENT_LINE_TYPE;

Line 204: FROM ce_cashflows

200: X_NEW_STATEMENT_LINE_TYPE := X_STATEMENT_LINE_TYPE;
201:
202: -- Bug 10164596
203: SELECT COUNT(*) into l_err
204: FROM ce_cashflows
205: WHERE cashflow_status_code='CANCELED'
206: AND cashflow_id =X_CASHFLOW_ID;
207: if(l_err=1) then
208: FND_MESSAGE.set_name('CE','CE_BAT_CANCELED_WARN');

Line 247: -- from ce_cashflows

243:
244: /* Bug 7395052 - Removed redundant query call */
245: -- select cleared_by_flag
246: -- into x_current_cleared_by_flag
247: -- from ce_cashflows
248: -- where cashflow_id = X_CASHFLOW_ID;
249:
250: /* Bug 7395052 - Added condition to ensure that if the trx is a
251: statement cashflow, its status should not become created */

Line 275: -- UPDATE CE_CASHFLOWS

271:
272:
273: IF (X_PASSIN_MODE in ('MANUAL_C','MANUAL_L', 'MANUAL_H', 'AUTO')) THEN
274:
275: -- UPDATE CE_CASHFLOWS
276: update_ce_cashflows(
277: X_CASHFLOW_ID => X_CASHFLOW_ID,
278: X_TRX_STATUS => X_CF_TRX_STATUS,
279: X_actual_value_date => X_actual_value_date,

Line 276: update_ce_cashflows(

272:
273: IF (X_PASSIN_MODE in ('MANUAL_C','MANUAL_L', 'MANUAL_H', 'AUTO')) THEN
274:
275: -- UPDATE CE_CASHFLOWS
276: update_ce_cashflows(
277: X_CASHFLOW_ID => X_CASHFLOW_ID,
278: X_TRX_STATUS => X_CF_TRX_STATUS,
279: X_actual_value_date => X_actual_value_date,
280: X_CLEARED_DATE => X_CLEARED_DATE ,

Line 317: -- do not remove ce_cashflows.statement_line_id when unclearing/unreconciling JEC/ZBA trx

313: END IF; --x_source_trxn_type = 'BAT'
314:
315: ELSIF (X_PASSIN_MODE in ('MANUAL', 'MANUAL_UC')) THEN
316: -- MANUAL (unreconciled), MANUAL_UC (uncleared)
317: -- do not remove ce_cashflows.statement_line_id when unclearing/unreconciling JEC/ZBA trx
318: -- x_source_trxn_type: 'STMT' (JEC trx), 'BAT' (ZBA trx)
319:
320: IF (X_STATEMENT_LINE_TYPE is null) and
321: ( X_NEW_STMT_LN_ID is not null) THEN

Line 335: update_ce_cashflows(

331: END IF;
332: END IF;
333:
334: IF ((X_PASSIN_MODE = 'MANUAL_UC') or (X_NEW_TRX_STATUS = 'CREATED' and X_CLEARED_BY_FLAG is null)) THEN
335: update_ce_cashflows(
336: X_CASHFLOW_ID => X_CASHFLOW_ID,
337: X_TRX_STATUS => X_CF_TRX_STATUS,
338: X_actual_value_date => null,
339: X_CLEARED_DATE => null,

Line 357: -- UPDATE CE_CASHFLOWS

353: );
354:
355: ELSE
356:
357: -- UPDATE CE_CASHFLOWS
358: update_ce_cashflows(
359: X_CASHFLOW_ID => X_CASHFLOW_ID,
360: X_TRX_STATUS => X_CF_TRX_STATUS,
361: X_actual_value_date => X_actual_value_date,

Line 358: update_ce_cashflows(

354:
355: ELSE
356:
357: -- UPDATE CE_CASHFLOWS
358: update_ce_cashflows(
359: X_CASHFLOW_ID => X_CASHFLOW_ID,
360: X_TRX_STATUS => X_CF_TRX_STATUS,
361: X_actual_value_date => X_actual_value_date,
362: X_CLEARED_DATE => X_CLEARED_DATE ,