[Home] [Help]
PACKAGE: APPS.CE_BANK_STATEMENT_LOADER
Source
1 PACKAGE CE_BANK_STATEMENT_LOADER AUTHID CURRENT_USER AS
2 /*$Header: cebsldrs.pls 120.10.12020000.2 2012/09/28 08:32:21 csutaria ship $ */
3
4 /* 2421690 Added the variable below. */
5
6 G_spec_revision VARCHAR2(1000) := '$Revision: 120.10.12020000.2 $';
7
8 G_request_id NUMBER;
9 G_total_dr NUMBER;
10 G_total_cr NUMBER;
11 G_map_id NUMBER;
12 G_precision NUMBER;
13 G_date_format VARCHAR2(30);
14 G_data_file_name VARCHAR2(240); /*13248081 */
15 G_rec_no NUMBER;
16 G_include_indicator VARCHAR2(1);
17 G_predefined_format VARCHAR2(150);
18 G_concatenate_format_flag VARCHAR2(1);
19
20 G_bank_account_id NUMBER;
21 G_bank_branch_id NUMBER;
22 G_sub_account_id NUMBER;
23 G_sub_branch_id NUMBER;
24 G_process_option VARCHAR2(30);
25 G_gl_date DATE;
26
27 -- added for Intra-Day project
28 G_intra_day_flag VARCHAR2(1);
29 G_timestamp_format VARCHAR2(20);
30
31 -- added for subsidiary bank accounts
32 G_subsidiary_flag VARCHAR2(1);
33
34 -- added for p2p
35 G_gl_date_source VARCHAR2(50);
36 G_receivables_trx_id NUMBER;
37 G_payment_method_id NUMBER;
38 G_nsf_handling VARCHAR2(50);
39 G_display_debug VARCHAR2(50);
40 G_debug_path VARCHAR2(50);
41 G_debug_file VARCHAR2(50);
42
43 G_total_hdr_deleted NUMBER := 0;
44 G_total_line_deleted NUMBER := 0;
45 G_format_type VARCHAR2(30);
46
47 --Header columns
48 G_statement_number VARCHAR2(50);
49 G_bank_account_num VARCHAR2(30);
50 G_statement_date DATE;
51 G_bank_name VARCHAR2(60);
52 G_bank_branch_name VARCHAR2(60);
53 G_control_begin_balance NUMBER;
54 G_control_end_balance NUMBER;
55 G_cashflow_balance NUMBER;
56 G_int_calc_balance NUMBER;
57 G_average_close_ledger_mtd NUMBER;
58 G_average_close_ledger_ytd NUMBER;
59 G_average_close_available_mtd NUMBER;
60 G_average_close_available_ytd NUMBER;
61 G_one_day_float NUMBER;
62 G_two_day_float NUMBER;
63 G_control_total_dr NUMBER;
64 G_control_total_cr NUMBER;
65 G_control_dr_line_count NUMBER;
66 G_control_cr_line_count NUMBER;
67 G_control_line_count NUMBER;
68 G_hdr_currency_code VARCHAR2(15);
69 G_check_digits VARCHAR2(30);
70 G_hdr_precision NUMBER;
71 G_org_id VARCHAR2(30);
72 G_user_id NUMBER;
73
74 -- Line columns
75 G_line_number NUMBER;
76 G_trx_date DATE;
77 G_trx_code VARCHAR2(30);
78 G_effective_date DATE;
79 G_trx_text VARCHAR2(255);
80 G_invoice_text VARCHAR2(70); --Edifact ER Altered the size from 30 chars to 70 chars
81 G_amount NUMBER;
82 G_line_currency_code VARCHAR2(15);
83 G_exchange_rate NUMBER;
84 G_bank_trx_number VARCHAR2(240);
85 G_customer_text VARCHAR2(80);
86 G_user_exchange_rate_type VARCHAR2(30);
87 G_exchange_rate_date DATE;
88 G_original_amount NUMBER;
89 G_charges_amount NUMBER;
90 G_bank_account_text CE_STATEMENT_LINES.BANK_ACCOUNT_TEXT%TYPE;
91 G_line_precision NUMBER;
92
93 G_last_val1 VARCHAR2(30); -- bug 3771128
94
95 G_rec_id VARCHAR2(2); --Edifact ER To hold current record id
96 G_prev_rec_id VARCHAR2(2); --Edifact ER To hold Preiously processed record id
97 G_only_03 VARCHAR2(2) := 'N'; --13324534
98 G_col_Pos NUMBER:=1; --13324534
99
100
101 /* 2421690 Added the two functions below. */
102
103 FUNCTION spec_revision RETURN VARCHAR2;
104
105 FUNCTION body_revision RETURN VARCHAR2;
106
107 PROCEDURE Load_Bank_Statement(errbuf OUT NOCOPY VARCHAR2,
108 retcode OUT NOCOPY NUMBER,
109 X_MAP_ID NUMBER,
110 X_REQUEST_ID NUMBER,
111 X_data_file VARCHAR2,
112 X_process_option VARCHAR2,
113 X_gl_date VARCHAR2,
114 X_org_id VARCHAR2,
115 X_receivables_trx_id NUMBER,
116 X_payment_method_id NUMBER,
117 X_nsf_handling VARCHAR2,
118 X_display_debug VARCHAR2,
119 X_debug_path VARCHAR2,
120 X_debug_file VARCHAR2,
121 X_bank_branch_id NUMBER,
122 X_bank_account_id NUMBER,
123 X_intra_day_flag VARCHAR2 DEFAULT 'N',
124 X_gl_date_source VARCHAR2 DEFAULT NULL);
125
126 FUNCTION Find_Formatted_String(X_format VARCHAR2,
127 X_trx_text varchar2) RETURN VARCHAR2;
128
129 FUNCTION Is_numeric(str IN VARCHAR2) --Edifact ER To check the amount is numeric or not
130 RETURN NUMBER;
131
132 FUNCTION covert_amt_edifact(amount IN VARCHAR2) --Edifact ER To Decode the Non numeric characters and to convert the amount
133 RETURN NUMBER;
134
135 END CE_BANK_STATEMENT_LOADER;