7:
8: -- Statement headers
9: --
10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
8: -- Statement headers
9: --
10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
9: --
10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
20: csh_statement_complete_flag CE_STATEMENT_HEADERS.statement_complete_flag%TYPE;
21: csh_org_id CE_STATEMENT_HEADERS.org_id%TYPE;
22: --
23: -- Statement Lines
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
20: csh_statement_complete_flag CE_STATEMENT_HEADERS.statement_complete_flag%TYPE;
21: csh_org_id CE_STATEMENT_HEADERS.org_id%TYPE;
22: --
23: -- Statement Lines
24: --
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
20: csh_statement_complete_flag CE_STATEMENT_HEADERS.statement_complete_flag%TYPE;
21: csh_org_id CE_STATEMENT_HEADERS.org_id%TYPE;
22: --
23: -- Statement Lines
24: --
25: csl_rowid VARCHAR2(100);
60: --
61:
62: G_bank_branch_id CE_BANK_ACCOUNTS.bank_branch_id%TYPE;
63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
61:
62: G_bank_branch_id CE_BANK_ACCOUNTS.bank_branch_id%TYPE;
63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
69: G_debug_path VARCHAR(100);
62: G_bank_branch_id CE_BANK_ACCOUNTS.bank_branch_id%TYPE;
63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
69: G_debug_path VARCHAR(100);
70: G_debug_file VARCHAR(100);
63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
69: G_debug_path VARCHAR(100);
70: G_debug_file VARCHAR(100);
71: G_sweep_flag BOOLEAN DEFAULT FALSE;
69: G_debug_path VARCHAR(100);
70: G_debug_file VARCHAR(100);
71: G_sweep_flag BOOLEAN DEFAULT FALSE;
72:
73: p_offset_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
74: p_cashpool_id NUMBER;
75: p_from_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
76: p_to_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
77:
71: G_sweep_flag BOOLEAN DEFAULT FALSE;
72:
73: p_offset_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
74: p_cashpool_id NUMBER;
75: p_from_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
76: p_to_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
77:
78: G_spec_revision VARCHAR2(1000) := '$Revision: 120.3 $';
79:
72:
73: p_offset_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
74: p_cashpool_id NUMBER;
75: p_from_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
76: p_to_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
77:
78: G_spec_revision VARCHAR2(1000) := '$Revision: 120.3 $';
79:
80: