APPS.CE_AUTO_BANK_CLEAR dependencies on CE_STATEMENT_LINES

Line 3: CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;

1: PACKAGE BODY CE_AUTO_BANK_CLEAR AS
2: /* $Header: ceabrcrb.pls 120.14.12010000.3 2008/11/20 09:04:33 vnetan ship $ */
3: CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;
4:
5: FUNCTION body_revision RETURN VARCHAR2 IS
6: BEGIN
7:

Line 67: UPDATE ce_statement_lines l

63: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');
64: if (X_status = 'RECONCILED') then
65: if (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK'
66: and CE_AUTO_BANK_MATCH.foreign_exchange_defaulted = 'Y') then
67: UPDATE ce_statement_lines l
68: SET status = X_status,
69: reconcile_to_statement_flag =
70: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
71: WHERE statement_line_id = X_statement_line_id

Line 79: UPDATE ce_statement_lines l

75: where statement_line_id = l.statement_line_id
76: and current_record_flag = 'Y'
77: and status_flag = 'M');
78: else
79: UPDATE ce_statement_lines l
80: SET status = X_status,
81: exchange_rate_type = CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
82: exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
83: exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,

Line 96: UPDATE ce_statement_lines

92: and current_record_flag = 'Y'
93: and status_flag = 'M');
94: end if;
95: else /* UNRECONCILED */
96: UPDATE ce_statement_lines
97: SET status = X_status,
98: reconcile_to_statement_flag =
99: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
100: WHERE statement_line_id = X_statement_line_id;