[Home] [Help]
PACKAGE: APPS.OKL_TAX_INTERFACE_PVT
Source
1 PACKAGE OKL_TAX_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRTEIS.pls 120.7 2007/07/31 22:25:30 rravikir noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAX_INTERFACE_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22
23 G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
24 G_DEBUG_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
25 G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26 G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
27 ---------------------------------------------------------------------------
28 -- GLOBAL EXCEPTIONS
29 ---------------------------------------------------------------------------
30 G_EXCEPTION_INSURANCE_ERROR EXCEPTION;
31
32 ---------------------------------------------------------------------------
33 -- GLOBAL DATASTRUCTURES
34 ---------------------------------------------------------------------------
35 SUBTYPE transaction_rec_type IS ZX_API_PUB.transaction_rec_type;
36 TYPE zx_trx_lines_tbl_type IS TABLE OF ZX_REVERSE_TRX_LINES_GT%ROWTYPE INDEX BY BINARY_INTEGER;
37
38 TYPE hdr_params_rec_type IS RECORD
39 ( application_id NUMBER,
40 trx_id NUMBER,
41 internal_organization_id NUMBER,
42 entity_code VARCHAR2(30),
43 event_class_code VARCHAR2(30),
44 event_type_code VARCHAR2(30),
45 quote_flag VARCHAR2(1));
46
47 TYPE line_params_rec_type IS RECORD
48 ( application_id NUMBER,
49 trx_id NUMBER,
50 internal_organization_id NUMBER,
51 entity_code VARCHAR2(30),
52 event_class_code VARCHAR2(30),
53 event_type_code VARCHAR2(30), --check
54 trx_date DATE,
55 ledger_id NUMBER,
56 legal_entity_id NUMBER,
57 trx_level_type VARCHAR2(30),
58 line_level_action VARCHAR2(30), --check
59 trx_line_id NUMBER,
60 line_amt NUMBER,
61 tax_reporting_flag VARCHAR2(1),
62 default_taxation_country VARCHAR2(2),
63 product_type VARCHAR2(240),
64 output_tax_classification_code VARCHAR2(50),
65 assessable_value NUMBER,
66 receivables_trx_type_id NUMBER,
67 product_id NUMBER,
68 adjusted_doc_entity_code VARCHAR2(30),
69 adjusted_doc_event_class_code VARCHAR2(30),
70 adjusted_doc_trx_id NUMBER,
71 adjusted_doc_line_id NUMBER,
72 adjusted_doc_trx_level_type VARCHAR2(30),
73 adjusted_doc_number VARCHAR2(150),
74 adjusted_doc_date DATE,
75 line_amt_includes_tax_flag VARCHAR2(1),
76 trx_business_category VARCHAR2(240),
77 product_category VARCHAR2(240),
78 user_defined_fisc_class VARCHAR2(240),
79 line_intended_use VARCHAR2(240),
80 ship_to_cust_acct_site_use_id NUMBER,
81 bill_to_cust_acct_site_use_id NUMBER,
82 bill_to_party_site_id NUMBER,
83 bill_to_location_id NUMBER,
84 bill_to_party_id NUMBER,
85 ship_to_party_site_id NUMBER,
86 ship_to_location_id NUMBER,
87 ship_to_party_id NUMBER,
88 rounding_ship_to_party_id NUMBER,
89 rounding_bill_to_party_id NUMBER,
90 trx_currency_code VARCHAR2(15),
91 precision NUMBER,
92 minimum_accountable_unit NUMBER,
93 currency_conversion_date DATE,
94 currency_conversion_rate NUMBER,
95 currency_conversion_type VARCHAR2(30),
96 provnl_tax_determination_date DATE,
97 ctrl_total_hdr_tax_amt NUMBER);
98
99 TYPE line_params_tbl_type IS TABLE OF line_params_rec_type INDEX BY BINARY_INTEGER;
100
101 ---------------------------------------------------------------------------
102 -- GLOBAL DATA
103 ---------------------------------------------------------------------------
104 G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
105 G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
106 ---------------------------------------------------------------------------
107 -- PROCEDURES
108 ---------------------------------------------------------------------------
109
110 PROCEDURE calculate_tax(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_hdr_params_rec IN hdr_params_rec_type,
117 p_line_params_tbl IN line_params_tbl_type);
118
119 PROCEDURE mark_reporting_flag(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_trx_id IN NUMBER,
126 p_application_id IN NUMBER,
127 p_entity_code IN VARCHAR2,
128 p_event_class_code IN VARCHAR2);
129
130 PROCEDURE set_tax_security_context(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_internal_org_id IN NUMBER,
137 p_legal_entity_id IN NUMBER,
138 p_transaction_date IN DATE);
139
140 PROCEDURE process_tax_determ_override(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2,
143 x_return_status OUT NOCOPY VARCHAR2 ,
144 x_msg_count OUT NOCOPY NUMBER ,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_trx_id IN NUMBER,
147 p_tax_sources_id IN NUMBER,
148 p_trx_business_category IN VARCHAR2,
149 p_product_category IN VARCHAR2,
150 p_user_defined_fisc_class IN VARCHAR2,
151 p_line_intended_use IN VARCHAR2,
152 p_transaction_rec IN transaction_rec_type,
153 x_doc_level_recalc_flag OUT NOCOPY VARCHAR2) ;
154
155 PROCEDURE process_tax_details_override(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2,
158 x_return_status OUT NOCOPY VARCHAR2 ,
159 x_msg_count OUT NOCOPY NUMBER ,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_transaction_rec IN transaction_rec_type,
162 p_override_level IN VARCHAR2,
163 p_event_id IN NUMBER) ;
164
165 PROCEDURE copy_global_tax_data (
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_trx_id IN NUMBER,
172 p_trx_line_id IN NUMBER,
173 p_application_id IN NUMBER,
174 p_trx_level_type IN VARCHAR2,
175 p_entity_code IN VARCHAR2,
176 p_event_class_code IN VARCHAR2);
177
178 PROCEDURE update_document (
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_transaction_rec transaction_rec_type);
185
186 PROCEDURE reverse_document (
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_rev_trx_hdr_rec IN line_params_rec_type,
193 p_rev_trx_lines_tbl IN zx_trx_lines_tbl_type);
194
195 PROCEDURE get_tax_classification_code (
196 x_return_status OUT NOCOPY VARCHAR2,
197 p_ship_to_site_use_id IN NUMBER,
198 p_bill_to_site_use_id IN NUMBER,
199 p_inventory_item_id IN NUMBER,
200 p_organization_id IN NUMBER,
201 p_set_of_books_id IN NUMBER,
202 p_trx_date IN DATE,
203 p_trx_type_id IN NUMBER,
204 p_entity_code IN VARCHAR2,
205 p_event_class_code IN VARCHAR2,
206 p_application_id IN NUMBER,
207 p_internal_organization_id IN NUMBER,
208 p_vendor_id IN NUMBER DEFAULT NULL,
209 p_vendor_site_id IN NUMBER DEFAULT NULL,
210 x_tax_classification_code OUT NOCOPY VARCHAR2 );
211
212 END OKL_TAX_INTERFACE_PVT;