[Home] [Help]
PACKAGE: APPS.CE_AUTO_BANK_IMPORT
Source
1 PACKAGE CE_AUTO_BANK_IMPORT AS
2 /* $Header: ceabrims.pls 120.10 2006/04/18 11:29:26 jikumar ship $ */
3 --
4 -- GLOBAL variables
5 --
6
7 G_cshi_control_total_dr CE_STATEMENT_HEADERS.control_total_dr%TYPE;
8 G_cshi_control_total_cr CE_STATEMENT_HEADERS.control_total_cr%TYPE;
9 G_cshi_control_dr_line_count CE_STATEMENT_HEADERS.control_dr_line_count%TYPE;
10 G_cshi_control_cr_line_count CE_STATEMENT_HEADERS.control_cr_line_count%TYPE;
11 G_cshi_control_line_count CE_STATEMENT_HEADERS.control_cr_line_count%TYPE;
12 G_cshi_control_begin_balance CE_STATEMENT_HEADERS.control_begin_balance%TYPE;
13 G_cshi_control_end_balance CE_STATEMENT_HEADERS.control_end_balance%TYPE;
14 G_cshi_cashflow_balance CE_STATEMENT_HEADERS.cashflow_balance%TYPE;
15 G_cshi_int_calc_balance CE_STATEMENT_HEADERS.int_calc_balance%TYPE;
16 G_cshi_close_ledger_mtd CE_BANK_ACCT_BALANCES.average_close_ledger_mtd%TYPE;
17 G_cshi_close_ledger_ytd CE_BANK_ACCT_BALANCES.average_close_ledger_ytd%TYPE;
18 G_cshi_close_available_mtd CE_BANK_ACCT_BALANCES.average_close_available_mtd%TYPE;
19 G_cshi_close_available_ytd CE_BANK_ACCT_BALANCES.average_close_available_ytd%TYPE;
20 G_cshi_one_day_float CE_STATEMENT_HEADERS.one_day_float%TYPE;
21 G_cshi_two_day_float CE_STATEMENT_HEADERS.two_day_float%TYPE;
22 G_cshi_intra_day_flag VARCHAR2(1);
23 G_cshi_subsidiary_flag VARCHAR2(1);
24 G_cshi_attribute_category CE_STATEMENT_HEADERS_INT.attribute_category%TYPE;
25 G_cshi_attribute1 CE_STATEMENT_HEADERS_INT.attribute1%TYPE;
26 G_cshi_attribute2 CE_STATEMENT_HEADERS_INT.attribute2%TYPE;
27 G_cshi_attribute3 CE_STATEMENT_HEADERS_INT.attribute3%TYPE;
28 G_cshi_attribute4 CE_STATEMENT_HEADERS_INT.attribute4%TYPE;
29 G_cshi_attribute5 CE_STATEMENT_HEADERS_INT.attribute5%TYPE;
30 G_cshi_attribute6 CE_STATEMENT_HEADERS_INT.attribute6%TYPE;
31 G_cshi_attribute7 CE_STATEMENT_HEADERS_INT.attribute7%TYPE;
32 G_cshi_attribute8 CE_STATEMENT_HEADERS_INT.attribute8%TYPE;
33 G_cshi_attribute9 CE_STATEMENT_HEADERS_INT.attribute9%TYPE;
34 G_cshi_attribute10 CE_STATEMENT_HEADERS_INT.attribute10%TYPE;
35 G_cshi_attribute11 CE_STATEMENT_HEADERS_INT.attribute11%TYPE;
36 G_cshi_attribute12 CE_STATEMENT_HEADERS_INT.attribute12%TYPE;
37 G_cshi_attribute13 CE_STATEMENT_HEADERS_INT.attribute13%TYPE;
38 G_cshi_attribute14 CE_STATEMENT_HEADERS_INT.attribute14%TYPE;
39 G_cshi_attribute15 CE_STATEMENT_HEADERS_INT.attribute15%TYPE;
40 G_cshi_statement_date CE_STATEMENT_HEADERS_INT.statement_date%TYPE;
41 G_cshi_bank_branch_name CE_STATEMENT_HEADERS_INT.bank_branch_name%TYPE;
42 G_cshi_bank_name CE_STATEMENT_HEADERS_INT.bank_name%TYPE;
43 G_cshi_currency_code CE_STATEMENT_HEADERS_INT.currency_code%TYPE;
44 G_cshi_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;
45 G_cshi_bank_account_num CE_STATEMENT_HEADERS_INT.bank_account_num%TYPE;
46 G_cshi_check_digits CE_STATEMENT_HEADERS_INT.check_digits%TYPE;
47 G_cshi_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
48 G_cshi_org_id NUMBER;
49 G_cshi_rowid VARCHAR2(100);
50 G_dr_sum NUMBER;
51 G_cr_sum NUMBER;
52 G_dr_count NUMBER;
53 G_cr_count NUMBER;
54 G_total_count NUMBER;
55 G_bank_account_id NUMBER;
56 G_spec_revision VARCHAR2(1000) := '$Revision: 120.10 $';
57
58 G_xtr_use_allowed_flag VARCHAR2(1);
59 G_pay_use_allowed_flag VARCHAR2(1);
60 BA_OWNER_LE_ID NUMBER;
61
62 FUNCTION spec_revision RETURN VARCHAR2;
63
64 FUNCTION body_revision RETURN VARCHAR2;
65
66 PROCEDURE import_process;
67
68 PROCEDURE update_header_status(p_status VARCHAR2);
69
70 FUNCTION header_error (error_name VARCHAR2) RETURN BOOLEAN;
71
72 FUNCTION get_sequence_info (app_id IN NUMBER,
73 category_code IN VARCHAR2,
74 set_of_books_id IN NUMBER,
75 entry_method IN CHAR,
76 trx_date IN DATE,
77 seq_name IN OUT NOCOPY VARCHAR2,
78 seq_id IN OUT NOCOPY NUMBER,
79 seq_value IN OUT NOCOPY NUMBER) RETURN BOOLEAN;
80 END CE_AUTO_BANK_IMPORT;