[Home] [Help]
PACKAGE: APPS.CE_JE_CREATION
Source
1 PACKAGE CE_JE_CREATION AS
2 /* $Header: cejecrns.pls 120.5 2006/01/18 21:44:48 lkwan noship $ */
3 --
4
5 G_spec_revision VARCHAR2(1000) := '$Revision: 120.5 $';
6
7 -- Statement header variables
8 csh_statement_header_id number(10);--CE_STATEMENT_HEADERS_ALL.statement_header_id%TYPE;
9 csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
10 csh_bank_account_ccid CE_GL_ACCOUNTS_CCID.ASSET_CODE_COMBINATION_ID%TYPE;
11 csh_currency_code FND_CURRENCIES.currency_code%TYPE;
12 csh_statement_date DATE;
13 csh_statement_gl_date DATE;
14 ba_currency_code FND_CURRENCIES.currency_code%TYPE;
15
16 -- added for R12
17 ba_legal_entity_id NUMBER(15);
18
19 --
20 -- Statement Lines
21 --
22
23 csl_rowid VARCHAR2(100);
24 csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
25 csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
26 csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27 csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28 csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
29 csl_amount CE_STATEMENT_LINES.amount%TYPE;
30 csl_currency_code FND_CURRENCIES.currency_code%TYPE;
31 csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
32 csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
33 csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
34 csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
35 csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
36 csl_status CE_STATEMENT_LINES.status%TYPE;
37 csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
38 csl_trx_text CE_STATEMENT_LINES.trx_text%TYPE;
39 csl_accounting_date DATE;
40
41 -- added for R12
42 csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
43 csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
44 csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
45 csl_cashflow_id NUMBER(15);
46
47
48 --
49 -- Journal Entry Mappings
50 --
51 jem_je_mapping_id CE_JE_MAPPINGS.je_mapping_id%TYPE;
52 jem_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
53 jem_search_string_txt CE_JE_MAPPINGS.search_string_txt%TYPE;
54 jem_gl_account_ccid CE_JE_MAPPINGS.gl_account_ccid%TYPE;
55 jem_reference_txt CE_JE_MAPPINGS.REFERENCE_TXT%TYPE;
56 jem_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
57 jem_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
58
59 -- added for R12
60 jem_trxn_subtype_code_id CE_JE_MAPPINGS.trxn_subtype_code_id%TYPE;
61
62 --
63 -- SLA event id
64 --
65 sla_event_id NUMBER(15);
66
67 --
68 -- CE system parameters variables
69 --
70 sys_currency_code FND_CURRENCIES.currency_code%TYPE;
71 sys_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
72 sys_exchange_rate_date VARCHAR2(10); --CE_SYSTEM_PARAMETERS.exchange_rate_date%TYPE;
73 sys_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
74
75 --
76 -- Cashflow variables
77 --
78 cf_ledger_id CE_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
79 cf_legal_entity_id NUMBER(15);
80 cf_bank_account_id NUMBER(15);
81 cf_direction CE_CASHFLOWS.cashflow_direction%TYPE;
82 cf_currency_code CE_CASHFLOWS.cashflow_currency_code%TYPE;
83 cf_cashflow_date DATE;
84 cf_cashflow_amount CE_CASHFLOWS.cashflow_amount%TYPE;
85 cf_description CE_CASHFLOWS.description%TYPE;
86 cf_trxn_reference_number CE_CASHFLOWS.trxn_reference_number%TYPE;
87 cf_bank_trxn_number CE_CASHFLOWS.bank_trxn_number%TYPE;
88 cf_source_trxn_type CE_CASHFLOWS.source_trxn_type%TYPE;
89 cf_statement_line_id CE_CASHFLOWS.statement_line_id%TYPE;
90 cf_actual_value_date CE_CASHFLOWS.actual_value_date%TYPE;
91 cf_offset_ccid CE_CASHFLOWS.offset_ccid%TYPE;
92 cf_status_code CE_CASHFLOWS.cashflow_status_code%TYPE;
93 cf_cleared_date CE_CASHFLOWS.cleared_date%TYPE;
94 cf_cleared_amount CE_CASHFLOWS.cleared_amount%TYPE;
95 cf_cleared_exchange_rate CE_CASHFLOWS.cleared_exchange_rate%TYPE;
96 cf_cleared_exchange_date CE_CASHFLOWS.cleared_exchange_date%TYPE;
97 cf_cleared_exchange_rate_type CE_CASHFLOWS.cleared_exchange_rate_type%TYPE;
98 cf_base_amount CE_CASHFLOWS.base_amount%TYPE;
99 cf_reference_text CE_CASHFLOWS.reference_text%TYPE;
100 cf_source_trxn_subtype_code_id CE_CASHFLOWS.source_trxn_subtype_code_id%TYPE;
101 cf_bank_account_text CE_CASHFLOWS.bank_account_text%TYPE;
102 cf_customer_text CE_CASHFLOWS.customer_text%TYPE;
103
104
105
106
107
108 /*
109 je_sob_id CE_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
110 je_accounting_date DATE;
111 je_currency_code FND_CURRENCIES.currency_code%TYPE;
112 je_date_created DATE;
113 je_created_by NUMBER;
114 je_code_combination_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
115 je_user_curr_conversion_type GL_DAILY_RATES.conversion_type%TYPE;
116 je_curr_conversion_date GL_DAILY_RATES.conversion_date%TYPE;
117 je_curr_conversion_rate GL_DAILY_RATES.conversion_rate%TYPE;
118 je_entered_cr CE_STATEMENT_LINES.amount%TYPE;
119 je_entered_dr CE_STATEMENT_LINES.amount%TYPE;
120 je_accounted_cr CE_STATEMENT_LINES.amount%TYPE;
121 je_accounted_dr CE_STATEMENT_LINES.amount%TYPE;
122 je_reference6 GL_INTERFACE.reference6%TYPE;
123 je_reference10 GL_INTERFACE.reference10%TYPE;
124 je_reference21 GL_INTERFACE.reference21%TYPE;
125 je_accounted_amt CE_STATEMENT_LINES.amount%TYPE;
126 je_entered_amt CE_STATEMENT_LINES.amount%TYPE;
127 */
128
129 procedure create_journal( errbuf OUT NOCOPY VARCHAR2,
130 retcode OUT NOCOPY NUMBER,
131 p_bank_branch_id NUMBER,
132 p_bank_account_id NUMBER,
133 p_statement_number_from VARCHAR2,
134 p_statement_number_to VARCHAR2,
135 p_statement_date_from VARCHAR2,
136 p_statement_date_to VARCHAR2);
137 --p_gl_date VARCHAR2,
138 --p_report_mode VARCHAR2);
139 FUNCTION spec_revision RETURN VARCHAR2;
140 FUNCTION body_revision RETURN VARCHAR2;
141
142 PROCEDURE log(p_msg varchar2);
143
144 END;