APPS.CE_XLA_ACCT_EVENTS_PKG dependencies on CE_CASHFLOW_ACCT_H

Line 137: UPDATE ce_cashflow_acct_h

133: log('Event_id after xla api '||l_event_id);
134: log('Row ID: '||X_rowid);
135: -- Update event_id in history table
136:
137: UPDATE ce_cashflow_acct_h
138: SET event_id = l_event_id
139: WHERE cashflow_id = X_trx_id
140: and event_type = x_event_type_code
141: and event_id = 0 ; -- Bug 13902100

Line 259: FROM ce_cashflow_acct_h

255: INTO l_previous_row_id,
256: l_previous_event_id,
257: l_previous_ae_status,
258: l_previous_acct_date
259: FROM ce_cashflow_acct_h
260: WHERE cashflow_id = X_trx_id
261: AND current_record_flag = 'Y';
262:
263: UPDATE ce_cashflow_acct_h

Line 263: UPDATE ce_cashflow_acct_h

259: FROM ce_cashflow_acct_h
260: WHERE cashflow_id = X_trx_id
261: AND current_record_flag = 'Y';
262:
263: UPDATE ce_cashflow_acct_h
264: SET current_record_flag = 'N'
265: WHERE event_id = l_previous_event_id;
266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN

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

268: log('No accounting previous event exists for this cashflow');
269: END;
270:
271: --
272: -- Populate ce_cashflow_acct_h table with new event info.
273: -- Also, update current record flag to 'Y'.
274: --
275: IF X_event_type_code = 'CE_BAT_CREATED' THEN
276: log('Raise create event: ' ||X_event_type_code);

Line 384: UPDATE ce_cashflow_acct_h

380: l_event_source_info,
381: l_security_context);
382:
383: -- Change AE status in history table to 'not applicable'.
384: UPDATE ce_cashflow_acct_h
385: SET status_code = 'NOT_APPLICABLE'
386: WHERE event_id = l_previous_event_id;
387:
388: -- populate history table with 'Not Applicable' status

Line 478: FROM ce_cashflow_acct_h

474: INTO l_creation_event_id,
475: l_creation_ae_status,
476: l_accounting_date,
477: l_creation_row_id
478: FROM ce_cashflow_acct_h
479: WHERE event_id = (SELECT Max(event_id)
480: FROM ce_cashflow_acct_h
481: WHERE cashflow_id = X_trx_id
482: AND event_type = 'CE_BAT_CREATED')

Line 480: FROM ce_cashflow_acct_h

476: l_accounting_date,
477: l_creation_row_id
478: FROM ce_cashflow_acct_h
479: WHERE event_id = (SELECT Max(event_id)
480: FROM ce_cashflow_acct_h
481: WHERE cashflow_id = X_trx_id
482: AND event_type = 'CE_BAT_CREATED')
483: and cashflow_id = x_trx_id;
484:

Line 508: UPDATE ce_cashflow_acct_h

504: l_event_source_info,
505: l_security_context);
506:
507: -- Change AE status in history table to 'not applicable'.
508: UPDATE ce_cashflow_acct_h
509: SET status_code = 'NOT_APPLICABLE'
510: WHERE event_id = l_creation_event_id;
511:
512: log('Inserting History with type code: ' ||X_event_type_code);

Line 656: UPDATE ce_cashflow_acct_h

652: END IF;
653:
654: FOR c_rec IN event_cur LOOP
655: IF c_rec.process_status_code = 'E' THEN -- accounting error
656: UPDATE ce_cashflow_acct_h
657: SET status_code = 'ACCOUNTING_ERROR'
658: WHERE event_id = c_rec.event_id;
659: ELSIF c_rec.process_status_code = 'P' THEN
660: UPDATE ce_cashflow_acct_h

Line 660: UPDATE ce_cashflow_acct_h

656: UPDATE ce_cashflow_acct_h
657: SET status_code = 'ACCOUNTING_ERROR'
658: WHERE event_id = c_rec.event_id;
659: ELSIF c_rec.process_status_code = 'P' THEN
660: UPDATE ce_cashflow_acct_h
661: SET status_code = 'ACCOUNTED'
662: WHERE event_id = c_rec.event_id;
663: -- and status_code <> 'NOT_APPLICABLE'; -- Bug 7409147
664: END IF;