[Home] [Help]
PACKAGE: APPS.CE_ZBA_DEAL_GENERATION
Source
1 PACKAGE CE_ZBA_DEAL_GENERATION AS
2 /* $Header: cezdgens.pls 120.3 2005/08/05 10:08:12 sspoonen noship $ */
3 --
4 -- Global variables
5 --
6
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;
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 --
25 csl_rowid VARCHAR2(100);
26 csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27 csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28 csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29 csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30 csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31 csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32 csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33 csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34 csl_amount CE_STATEMENT_LINES.amount%TYPE;
35 csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36 corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37 calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38 csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
39 csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
40 csl_create_misc_trx_flag CE_TRANSACTION_CODES.create_misc_trx_flag%TYPE;
41 csl_matching_against CE_TRANSACTION_CODES.matching_against%TYPE;
42 csl_correction_method CE_TRANSACTION_CODES.correction_method%TYPE;
43 csl_reconcile_flag CE_TRANSACTION_CODES.reconcile_flag%TYPE;
44 csl_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
45 csl_currency_code FND_CURRENCIES.currency_code%TYPE;
46 csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
47 csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
48 csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
49 csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
50 csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
51 csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
52 csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53 csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54 csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55 csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
56 reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
57 csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
58 --
59 -- Passed as parameters
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;
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
78 G_spec_revision VARCHAR2(1000) := '$Revision: 120.3 $';
79
80
81 --
82 -- Functions/procedures required for SQL functions
83 --
84 FUNCTION body_revision RETURN VARCHAR2;
85
86 FUNCTION spec_revision RETURN VARCHAR2;
87
88 FUNCTION get_security_account_type(p_account_type VARCHAR2) RETURN VARCHAR2;
89
90 PROCEDURE xtr_shared_account(X_ACCOUNT_RESULT OUT NOCOPY VARCHAR2);
91
92 FUNCTION lock_statement(lockhandle IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
93
94 FUNCTION lock_statement_line RETURN BOOLEAN;
95
96 FUNCTION get_min_statement_line_id RETURN NUMBER;
97
98 PROCEDURE set_parameters(p_bank_branch_id NUMBER,
99 p_bank_account_id NUMBER,
100 p_statement_number_from VARCHAR2,
101 p_statement_number_to VARCHAR2,
102 p_statement_date_from VARCHAR2,
103 p_statement_date_to VARCHAR2,
104 p_display_debug VARCHAR2,
105 p_debug_path VARCHAR2,
106 p_debug_file VARCHAR2);
107
108 FUNCTION break_bank_link(p_ap_bank_account_id NUMBER) RETURN BOOLEAN;
109
110 PROCEDURE zba_generation (errbuf OUT NOCOPY VARCHAR2,
111 retcode OUT NOCOPY NUMBER,
112 p_bank_branch_id NUMBER,
113 p_bank_account_id NUMBER,
114 p_statement_number_from VARCHAR2,
115 p_statement_number_to VARCHAR2,
116 p_statement_date_from VARCHAR2,
117 p_statement_date_to VARCHAR2,
118 p_display_debug VARCHAR2,
119 p_debug_path VARCHAR2,
120 p_debug_file VARCHAR2);
121
122 END CE_ZBA_DEAL_GENERATION;