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 195: FROM ce_cashflows

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

Line 234: -- from ce_cashflows

230:
231: /* Bug 7395052 - Removed redundant query call */
232: -- select cleared_by_flag
233: -- into x_current_cleared_by_flag
234: -- from ce_cashflows
235: -- where cashflow_id = X_CASHFLOW_ID;
236:
237: /* Bug 7395052 - Added condition to ensure that if the trx is a
238: statement cashflow, its status should not become created */

Line 262: -- UPDATE CE_CASHFLOWS

258:
259:
260: IF (X_PASSIN_MODE in ('MANUAL_C','MANUAL_L', 'MANUAL_H', 'AUTO')) THEN
261:
262: -- UPDATE CE_CASHFLOWS
263: update_ce_cashflows(
264: X_CASHFLOW_ID => X_CASHFLOW_ID,
265: X_TRX_STATUS => X_CF_TRX_STATUS,
266: X_actual_value_date => X_actual_value_date,

Line 263: update_ce_cashflows(

259:
260: IF (X_PASSIN_MODE in ('MANUAL_C','MANUAL_L', 'MANUAL_H', 'AUTO')) THEN
261:
262: -- UPDATE CE_CASHFLOWS
263: update_ce_cashflows(
264: X_CASHFLOW_ID => X_CASHFLOW_ID,
265: X_TRX_STATUS => X_CF_TRX_STATUS,
266: X_actual_value_date => X_actual_value_date,
267: X_CLEARED_DATE => X_CLEARED_DATE ,

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

300: END IF; --x_source_trxn_type = 'BAT'
301:
302: ELSIF (X_PASSIN_MODE in ('MANUAL', 'MANUAL_UC')) THEN
303: -- MANUAL (unreconciled), MANUAL_UC (uncleared)
304: -- do not remove ce_cashflows.statement_line_id when unclearing/unreconciling JEC/ZBA trx
305: -- x_source_trxn_type: 'STMT' (JEC trx), 'BAT' (ZBA trx)
306:
307: IF (X_STATEMENT_LINE_TYPE is null) and
308: ( X_NEW_STMT_LN_ID is not null) THEN

Line 322: update_ce_cashflows(

318: END IF;
319: END IF;
320:
321: IF ((X_PASSIN_MODE = 'MANUAL_UC') or (X_NEW_TRX_STATUS = 'CREATED' and X_CLEARED_BY_FLAG is null)) THEN
322: update_ce_cashflows(
323: X_CASHFLOW_ID => X_CASHFLOW_ID,
324: X_TRX_STATUS => X_CF_TRX_STATUS,
325: X_actual_value_date => null,
326: X_CLEARED_DATE => null,

Line 344: -- UPDATE CE_CASHFLOWS

340: );
341:
342: ELSE
343:
344: -- UPDATE CE_CASHFLOWS
345: update_ce_cashflows(
346: X_CASHFLOW_ID => X_CASHFLOW_ID,
347: X_TRX_STATUS => X_CF_TRX_STATUS,
348: X_actual_value_date => X_actual_value_date,

Line 345: update_ce_cashflows(

341:
342: ELSE
343:
344: -- UPDATE CE_CASHFLOWS
345: update_ce_cashflows(
346: X_CASHFLOW_ID => X_CASHFLOW_ID,
347: X_TRX_STATUS => X_CF_TRX_STATUS,
348: X_actual_value_date => X_actual_value_date,
349: X_CLEARED_DATE => X_CLEARED_DATE ,