APPS.CE_XLA_ACCT_EVENTS_PKG dependencies on CE_CASHFLOW_ACCT_H

Line 132: UPDATE ce_cashflow_acct_h

128:
129: log('Event_id: '||l_event_id);
130: log('Row ID: '||X_rowid);
131: -- Update event_id in history table
132: UPDATE ce_cashflow_acct_h
133: SET event_id = l_event_id
134: WHERE rowid = X_rowid;
135:
136: EXCEPTION

Line 250: FROM ce_cashflow_acct_h

246: INTO l_previous_row_id,
247: l_previous_event_id,
248: l_previous_ae_status,
249: l_previous_acct_date
250: FROM ce_cashflow_acct_h
251: WHERE cashflow_id = X_trx_id
252: AND current_record_flag = 'Y';
253:
254: UPDATE ce_cashflow_acct_h

Line 254: UPDATE ce_cashflow_acct_h

250: FROM ce_cashflow_acct_h
251: WHERE cashflow_id = X_trx_id
252: AND current_record_flag = 'Y';
253:
254: UPDATE ce_cashflow_acct_h
255: SET current_record_flag = 'N'
256: WHERE event_id = l_previous_event_id;
257: EXCEPTION
258: WHEN NO_DATA_FOUND THEN

Line 263: -- Populate ce_cashflow_acct_h table with new event info.

259: log('No accounting previous event exists for this cashflow');
260: END;
261:
262: --
263: -- Populate ce_cashflow_acct_h table with new event info.
264: -- Also, update current record flag to 'Y'.
265: --
266: IF X_event_type_code = 'CE_BAT_CREATED' THEN
267: log('Raise create event: ' ||X_event_type_code);

Line 372: UPDATE ce_cashflow_acct_h

368: l_event_source_info,
369: l_security_context);
370:
371: -- Change AE status in history table to 'not applicable'.
372: UPDATE ce_cashflow_acct_h
373: SET status_code = 'NOT_APPLICABLE'
374: WHERE event_id = l_previous_event_id;
375:
376: -- populate history table with 'Not Applicable' status

Line 464: FROM ce_cashflow_acct_h

460: INTO l_creation_event_id,
461: l_creation_ae_status,
462: l_accounting_date,
463: l_creation_row_id
464: FROM ce_cashflow_acct_h
465: WHERE event_id = (SELECT Max(event_id)
466: FROM ce_cashflow_acct_h
467: WHERE cashflow_id = X_trx_id
468: AND event_type = 'CE_BAT_CREATED');

Line 466: FROM ce_cashflow_acct_h

462: l_accounting_date,
463: l_creation_row_id
464: FROM ce_cashflow_acct_h
465: WHERE event_id = (SELECT Max(event_id)
466: FROM ce_cashflow_acct_h
467: WHERE cashflow_id = X_trx_id
468: AND event_type = 'CE_BAT_CREATED');
469:
470: log('Creation event acct status: '|| l_creation_ae_status);

Line 595: UPDATE ce_cashflow_acct_h

591: END IF;
592:
593: FOR c_rec IN event_cur LOOP
594: IF c_rec.process_status_code = 'E' THEN -- accounting error
595: UPDATE ce_cashflow_acct_h
596: SET status_code = 'ACCOUNTING_ERROR'
597: WHERE event_id = c_rec.event_id;
598: ELSIF c_rec.process_status_code = 'P' THEN
599: UPDATE ce_cashflow_acct_h

Line 599: UPDATE ce_cashflow_acct_h

595: UPDATE ce_cashflow_acct_h
596: SET status_code = 'ACCOUNTING_ERROR'
597: WHERE event_id = c_rec.event_id;
598: ELSIF c_rec.process_status_code = 'P' THEN
599: UPDATE ce_cashflow_acct_h
600: SET status_code = 'ACCOUNTED'
601: WHERE event_id = c_rec.event_id
602: and status_code <> 'NOT_APPLICABLE'; -- Bug 7409147
603: END IF;