[Home] [Help]
PACKAGE: APPS.JAI_CONSTANTS
Source
1 PACKAGE jai_constants AUTHID CURRENT_USER AS
2 /* $Header: jai_constants.pls 120.27.12020000.2 2012/07/18 17:34:53 nkodakan ship $ */
3
4 /* */
5 /*----------------------------------------------------------------------------------------------------------------------------
6 CHANGE HISTORY for FILENAME: jai_constants_s.sql
7 S.No dd/mm/yyyy Author and Details
8 ------------------------------------------------------------------------------------------------------------------------------
9 1 15/12/2004 Vijay Shankar for Bug#4068823, 3940588, FileVersion:115.0
10 This Package is coded as a common reference to different Constants that are be used across the product
11
12 2 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.1
13 added required constants as part of VAT Implementation
14
15 3. 08-Jun-2005 Version 116.1 jai_constants -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
16 as required for CASE COMPLAINCE.
17
18 4. 13-Jun-2005 In the prorcess of Removal of SQL LITERALs. File Version: 116.2
19 New constants added
20 1. item_class codes
21 2. closed_code codes
22
23 5. 06-Jul-2005 Ramananda for bug#4477004. File Version: 116.1
24 GL Sources and GL Categories got changed. Refer bug for the details
25
26 6. 29-08-2005 rallamse. File Verion 120.2
27 Added the trigger actions inserting, deleting and updating
28
29 7. 02-Sep-2005 Ramananda for bug#4584221. File Version 120.3
30 Two constants added
31 1. regn_type_tds_batch := 'TDS_INVOICE_BATCH'
32 2. tds_regime := 'TDS' ;
33
34 8. 01/11/2006 SACSETHI for bug 5228046, File version 120.4
35 Forward porting the change in 11i bug 5365523 (Additional CVD Enhancement).
36 This bug has datamodel and spec changes.
37
38 9. 02/02/2007 Bgowrava for BUG 5631784, File Version 120.5
39 Forward porting the change in 11i bug 4742259 (TCS enhancement)
40 10. 13/04/2007 bduvarag for the Bug#5989740, file version 120.6
41 Forward porting the changes done in 11i bug#5907436
42
43 11 24-APR-2007 CBABU FOR BUG 6012567, 6012570 FILE VERSION 120.7 (Projects Costing,Billing porting)
44 Project Costing + Billing Changes
45 12 01-Jun-2007 CSahoo for bug#6081806, File version 120.8
46 changed the service_tax_orgn_type from OU to IO.
47
48 13. 04-jun-2007 the table_name for ar trx lines was still the R11i name. It has been changed to reflect the R12 name.
49
50 23. 14/06/2007 sacsethi for bug 6072461 for file version - 120.15
51
52 FP of bug 5183031 ( vat reversal )
53 DEPENDANCY:
54 -----------
55 IN60106 + 4239736 + 4245089
56
57 15. 27/06/2007 csahoo for bug# 6155839, File Version 120.11
58 added the following constants:
59 service_tax_source CONSTANT VARCHAR2(30) := 'Service Tax India';
60 vat_source CONSTANT VARCHAR2(30) := 'VAT India';
61 tcs_source CONSTANT VARCHAR2(30) := 'India TCS Entry';
62
63 16. 28/06/2007 by sacsethi for bug 6157120 file version 120.12
64
65 Two Variables added
66
67 1. pan_no - Organization pan no
68 2. accounting_information -- Organization Accoutning information
69
70 17. 04/09/2007 Bgowrava for Bug#6012570, File version 120.14
71 Added constant pa_je_source for the gl source 'Projects India'
72 18. 04/09/2007 Jeffsen for standalone invoice.
73 Added two constants and one function.
74 19. 02-Apr-2010 Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement).
75 Added six constants.
76
77 20. 01-Sep-2010 Bo Li for bug#10043656
78 12.1.3 GST Enhancement and add two constants
79
80 21. 08-Oct-2010 Peng Zheng for bug#10043656
81 add constant tax_classification
82
83 22. 08-Mar-2011 Add by Xiao for Open Interface ER bug#11683927.
84 Add Customs regime.
85
86 23. 22-Aug-2011 Xiao for POT Phase III changes, reg bug#12895841
87 Fixed: Add Account Name for 'Reversal'.
88
89 24. 23-Feb-2012 Qinglei for bug#13741544
90 Fixed: Change value of trx_type_adv_rvs to ADVANCE_RECEIPT_REVERSAL.
91 ----------------------------------------------------------------------------------------------------------------------------*/
92 -- All global variables are declared as CONSTANT for File.Sql.35 by Brathod
93
94 func_curr CONSTANT VARCHAR2(3) := 'INR';
95
96 accounting_method_cash CONSTANT VARCHAR2(15) := 'Cash';
97 accounting_method_accrual CONSTANT VARCHAR2(15) := 'Accrual';
98
99 no_number_value CONSTANT NUMBER := -999999999999;
100
101 party_type_orgn CONSTANT VARCHAR2(1) := 'O';
102 party_type_vendor CONSTANT VARCHAR2(1) := 'V';
103 party_type_customer CONSTANT VARCHAR2(1) := 'C';
104
105 yes CONSTANT VARCHAR2(1) := 'Y';
106 no CONSTANT VARCHAR2(1) := 'N';
107 value_true CONSTANT VARCHAR2(15) := 'TRUE';
108 value_false CONSTANT VARCHAR2(15) := 'FALSE';
109
110 credit CONSTANT VARCHAR2(2) := 'CR';
111 debit CONSTANT VARCHAR2(2) := 'DR';
112
113 je_category_rg_entry CONSTANT VARCHAR2(30) := 'Register India';
114
115 recovery CONSTANT VARCHAR2(20) := 'RECOVERY';
116 liability CONSTANT VARCHAR2(20) := 'LIABILITY';
117 recovery_interim CONSTANT VARCHAR2(20) := 'INTERIM_RECOVERY';
118 liability_interim CONSTANT VARCHAR2(20) := 'INTERIM_LIABILITY';
119 reversal CONSTANT VARCHAR2(20) := 'REVERSAL';--Add by Xiao for POT Phase III, reg bug#12895841
120
121 source_ap CONSTANT VARCHAR2(2) := 'AP';
122 source_ar CONSTANT VARCHAR2(2) := 'AR';
123 source_po CONSTANT VARCHAR2(2) := 'PO';
124 source_om CONSTANT VARCHAR2(2) := 'OM';
125 source_manual_entry CONSTANT VARCHAR2(15) := 'MANUAL';
126 source_settle_in CONSTANT VARCHAR2(15) := 'SETTLE_IN';
127 source_settle_out CONSTANT VARCHAR2(15) := 'SETTLE_OUT';
128 source_receive CONSTANT VARCHAR2(15) := 'RECEIVE';
129 source_rtv CONSTANT VARCHAR2(20) := 'RETURN TO VENDOR';
130
131 source_wsh CONSTANT VARCHAR2(5) := 'WSH';
132 source_rcv CONSTANT VARCHAR2(5) := 'RCV';
133 source_ttype_delivery CONSTANT VARCHAR2(15) := 'DELIVERY';
134 source_ttype_man_ar_inv CONSTANT VARCHAR2(30) := 'MANUAL AR INVOICE';
135 /*
136 || Added by bgowrava for the TCS enhancement Bug 5631784
137 */
138
139 service_src_distribute_in CONSTANT VARCHAR2(30) := 'SERVICE_DISTRIBUTE_IN';
140 service_src_distribute_out CONSTANT VARCHAR2(30) := 'SERVICE_DISTRIBUTE_OUT';
141
142 orgn_type_ou CONSTANT VARCHAR2(2) := 'OU';
143 orgn_type_io CONSTANT VARCHAR2(2) := 'IO';
144 excise_regime CONSTANT VARCHAR2(15) := 'EXCISE';
145
146 service_tax_orgn_type CONSTANT VARCHAR2(2) := 'IO'; --added by csahoo for bug#6081806
147 service_regime CONSTANT VARCHAR2(15) := 'SERVICE';
148 vat_regime CONSTANT VARCHAR2(15) := 'VAT';
149 tds_regime CONSTANT VARCHAR2(3) := 'TDS' ;
150
151 /* this will be used for rounding the amounts that are hitting service tax repository */
152 service_rgm_rnd_factor CONSTANT NUMBER(1) := 2;
153 vat_rgm_rnd_factor CONSTANT NUMBER(1) := 2;
154
155 tax_type_service CONSTANT VARCHAR2(15) := 'Service';
156 tax_type_excise CONSTANT VARCHAR2(15) := 'Excise';
157 tax_type_exc_additional CONSTANT VARCHAR2(15) := 'Addl. Excise';
158 tax_type_exc_other CONSTANT VARCHAR2(15) := 'Other Excise';
159 tax_type_cvd CONSTANT VARCHAR2(15) := 'CVD';
160 tax_type_add_cvd CONSTANT VARCHAR2(15) := 'ADDITIONAL_CVD'; -- Date 01/11/2006 Bug 5228046 added by SACSETHI
161 tax_type_tds CONSTANT VARCHAR2(15) := 'TDS';
162 tax_type_modvat_recovery CONSTANT VARCHAR2(20) := 'Modvat Recovery';
163 tax_type_customs CONSTANT VARCHAR2(15) := 'Customs';
164 tax_type_cst CONSTANT VARCHAR2(15) := 'CST';
165 tax_type_sales CONSTANT VARCHAR2(15) := 'Sales Tax';
166 tax_type_other CONSTANT VARCHAR2(15) := 'Other';
167 tax_type_octroi CONSTANT VARCHAR2(15) := 'Octrai';
168 tax_type_service_edu_cess CONSTANT VARCHAR2(30) := 'SERVICE_EDUCATION_CESS';
169 tax_type_exc_edu_cess CONSTANT VARCHAR2(30) := 'EXCISE_EDUCATION_CESS';
170 tax_type_cvd_edu_cess CONSTANT VARCHAR2(30) := 'CVD_EDUCATION_CESS';
171 tax_type_customs_edu_cess CONSTANT VARCHAR2(30) := 'CUSTOMS_EDUCATION_CESS';
172 tax_type_freight CONSTANT VARCHAR2(30) := 'Freight';
173 /*Bug 5989740 bduvarag start*/
174 tax_type_sh_exc_edu_cess VARCHAR2(30) := 'EXCISE_SH_EDU_CESS';
175 tax_type_sh_cvd_edu_cess VARCHAR2(30) := 'CVD_SH_EDU_CESS';
176 tax_type_sh_customs_edu_Cess VARCHAR2(30) := 'CUSTOMS_SH_EDU_CESS';
177 tax_type_sh_service_edu_cess VARCHAR2(30) := 'SERVICE_SH_EDU_CESS';
178 tax_type_sh_tcs_edu_cess VARCHAR2(30) := 'TCS_SH_EDU_CESS';
179 /* new add boe tax type by zhiwei begin*/
180 tax_type_boe_other1 CONSTANT VARCHAR2(30) := 'ANY_OTHER_CUSTOMS_TAX_TYPE1';
181 tax_type_boe_other2 CONSTANT VARCHAR2(30) := 'ANY_OTHER_CUSTOMS_TAX_TYPE2';
182 tax_type_boe_other3 CONSTANT VARCHAR2(30) := 'ANY_OTHER_CUSTOMS_TAX_TYPE3';
183 tax_type_boe_other4 CONSTANT VARCHAR2(30) := 'ANY_OTHER_CUSTOMS_TAX_TYPE4';
184 tax_type_boe_other5 CONSTANT VARCHAR2(30) := 'ANY_OTHER_CUSTOMS_TAX_TYPE5';
185 tax_type_boe_surcharge_duty CONSTANT VARCHAR2(30) := 'SURCHARGE_DUTY';
186 tax_type_boe_add_customs CONSTANT VARCHAR2(30) := 'ADDITIONAL_CUSTOMS';
187 /* new add boe tax type by zhiwei end*/
188
189 /*Bug 5989740 bduvarag end*/
190
191 tax_type_entry CONSTANT VARCHAR2(15) := 'ENTRY TAX';
192 tax_type_purchase CONSTANT VARCHAR2(15) := 'PURCHASE TAX';
193 tax_type_turnover CONSTANT VARCHAR2(15) := 'TURNOVER TAX';
194 tax_type_value_added CONSTANT VARCHAR2(20) := 'VALUE ADDED TAX';
195
196 rgm_attr_type_code_primary CONSTANT VARCHAR2(15) := 'PRIMARY';
197 regn_type_tax_types CONSTANT VARCHAR2(15) := 'TAX_TYPES';
198 regn_type_accounts CONSTANT VARCHAR2(15) := 'ACCOUNTS';
199 regn_type_others CONSTANT VARCHAR2(15) := 'OTHERS';
200 regn_type_tds_batch CONSTANT VARCHAR2(20) := 'TDS_INVOICE_BATCH' ;
201
202 attr_code_same_inv_no CONSTANT VARCHAR2(30) := 'SAME_INVOICE_NO';
203 attr_code_regn_no CONSTANT VARCHAR2(30) := 'REGISTRATION_NO';
204
205 register_type_a CONSTANT VARCHAR2(10) := 'A';
206 register_type_c CONSTANT VARCHAR2(10) := 'C';
207 register_type_pla CONSTANT VARCHAR2(10) := 'PLA';
208
209 gl_je_source_name CONSTANT VARCHAR2(30) := 'India Localization Entry';
210
211 repository_name CONSTANT VARCHAR2(30) := 'JAI_RGM_TRX_RECORDS';
212 ap_payments CONSTANT VARCHAR2(30) := 'AP_INVOICE_PAYMENTS_ALL';
213 ap_prepayments CONSTANT VARCHAR2(30) := 'AP_INVOICE_DISTRIBUTIONS_ALL';
214 rgm_trx_refs CONSTANT VARCHAR2(25) := 'JAI_RGM_TRX_REFS';
215 ar_inv_lines_table VARCHAR2(30) := 'JAI_AR_TRX_LINES'; --added by bgowrava /* ssumaith - bug#6109941 */
216
217 already_processed CONSTANT VARCHAR2(1) := 'A';
218 not_accounted CONSTANT VARCHAR2(2) := 'N';
219 expected_error CONSTANT VARCHAR2(2) := 'EE';
220 unexpected_error CONSTANT VARCHAR2(2) := 'UE';
221 successful CONSTANT VARCHAR2(2) := 'SS';
222 not_applicable VARCHAR2(2) := 'NA'; /* Added by bgowrava */
223
224 misc_line CONSTANT VARCHAR2(30) := 'MISCELLANEOUS';
225 prepay_line CONSTANT VARCHAR2(15) := 'PREPAY';
226 future_payment CONSTANT VARCHAR2(15) := 'FUTURE_PAYMENT';
227 payment CONSTANT VARCHAR2(15) := 'PAYMENT';
228 payment_voided CONSTANT VARCHAR2(15) := 'PAYMENT_VOID';
229 payment_reversal CONSTANT VARCHAR2(20) := 'PAYMENT_REVERSAL';
230 prepay_application CONSTANT VARCHAR2(15) := 'PREPAY_APPLY';
231 prepay_unapplication CONSTANT VARCHAR2(15) := 'PREPAY_UNAPPLY';
232
233 cenvat_noclaim CONSTANT VARCHAR2(15) := 'UNCLAIM';
234 vat_noclaim CONSTANT VARCHAR2(15) := 'VAT_UNCLAIM';
235
236 gl_application_id CONSTANT NUMBER(4) := 101;
237
238 -- Lookups Defined in Database
239 lk_type_tax_type CONSTANT VARCHAR2(20) := 'JAI_TAX_TYPE' ;
240 lk_type_ind_tax_rgms CONSTANT VARCHAR2(25) := 'JAI_INDIA_TAX_REGIMES' ;
241
242 /* AR Related Constants */
243 trx_type_inv_comp CONSTANT VARCHAR2(40) := 'INVOICE_COMPLETION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
244 trx_type_inv_incomp CONSTANT VARCHAR2(40) := 'INVOICE_INCOMPLETION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
245 trx_event_app CONSTANT VARCHAR2(40) := 'APPLICATION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
246 trx_event_completion CONSTANT VARCHAR2(40) := 'COMPLETION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
247 trx_event_inv_save CONSTANT VARCHAR2(40) := 'INV_SAVE' ; /*Added by Bgowrava for forward porting Bug#5631784*/
248 trx_type_rct_app CONSTANT VARCHAR2(20) := 'RECEIPT_APPLICATION' ;
249 trx_type_rct_unapp CONSTANT VARCHAR2(40) := 'RECEIPT_UNAPPLICATION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
250 trx_type_rct_rvs CONSTANT VARCHAR2(20) := 'RECEIPT_REVERSAL' ;
251 jai_cash_rcpts CONSTANT VARCHAR2(40) := 'JAI_AR_CASH_RECEIPTS_ALL' ;/*Added by Bgowrava for forward porting Bug#5631784*/
252 trx_type_cm_app CONSTANT VARCHAR2(30) := 'CREDIT_MEMO_APPLICATION' ;
253 trx_type_cm_unapp CONSTANT VARCHAR2(40) := 'CREDIT_MEMO_UNAPPLICATION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
254 trx_type_cm_rvs CONSTANT VARCHAR2(30) := 'CREDIT_MEMO_REVERSAL' ;
255 trx_type_adv_rcpts CONSTANT VARCHAR2(30) := 'ADVANCE_RECEIPT' ; /*Added by Qiong for Advanced Receipts bug#13361952*/
256 --trx_type_adv_rvs CONSTANT VARCHAR2(30) := 'RECEIPT_REVERSAL' ;/*Added by Qiong for Advanced Receipts bug#13361952*/
257 --Commented by Qinglei on 23-Feb-2012 for bug#13741544
258 trx_type_adv_rvs CONSTANT VARCHAR2(30) := 'ADVANCE_RECEIPT_REVERSAL' ;
259 --Added by Qinglei on 23-Feb-2012 for bug#13741544
260 trx_type_adv_app CONSTANT VARCHAR2(30) := 'RECEIPT_APPLY' ;/*Added by Qiong for Advanced Receipts bug#13361952*/
261 trx_type_adv_unapp CONSTANT VARCHAR2(30) := 'RECEIPT_UNAPPLY' ; /*Added by Qiong for Advanced Receipts bug#13361952*/
262 ar_receipt_app CONSTANT VARCHAR2(30) := 'AR_RECEIVABLE_APPLICATIONS_ALL';
263 ar_cash CONSTANT VARCHAR2(4) := 'CASH' ;
264 ar_cash_tax_confirmed CONSTANT VARCHAR2(40) := 'CASH_TAX_CONFIRMED' ;/*Added by Bgowrava for forward porting Bug#5631784*/
265 ar_status_app CONSTANT VARCHAR2(3) := 'APP' ;
266 ar_status_unapp CONSTANT VARCHAR2(5) := 'UNAPP' ;
267 ar_status_activity CONSTANT VARCHAR2(40) := 'ACTIVITY' ;/*Added by Bgowrava for forward porting Bug#5631784*/
268 ar_invoice_type_inv CONSTANT VARCHAR2(3) := 'INV' ;
269 ar_invoice_type_cm CONSTANT VARCHAR2(2) := 'CM' ;
270 ar_doc_type_dm VARCHAR2(2) := 'DM' ; /* Added by bgowrava /*
271
272 /* OM Related Constants */
273 om_action_gen_inv_n_accnt CONSTANT VARCHAR2(15) := 'PROCESS ALL';
274 om_action_gen_invoice CONSTANT VARCHAR2(30) := 'GENERATE INVOICE NO';
275 om_action_gen_accounting CONSTANT VARCHAR2(30) := 'PROCESS ACCOUNTING';
276
277 -- Concurrent Request processing Stage codes
278 request_error CONSTANT NUMBER(1) := 2;
279 request_warning CONSTANT NUMBER(1) := 1;
280
281 -- For Cenvat Register Processing
282 reg_rg23_2_code CONSTANT NUMBER(1) := 1;
283 reg_pla_code CONSTANT NUMBER(1) := 2;
284 reg_rg23d_code CONSTANT NUMBER(1) := 3;
285 reg_receipt_cenvat_code CONSTANT NUMBER(1) := 4;
286
290 reg_pla CONSTANT VARCHAR2(15) := 'PLA';
287 reg_rg23a_2 CONSTANT VARCHAR2(15) := 'RG23A_P2';
288 reg_rg23c_2 CONSTANT VARCHAR2(15) := 'RG23C_P2';
289 reg_rg23d CONSTANT VARCHAR2(15) := 'RG23D';
291 reg_rg23a CONSTANT VARCHAR2(15) := 'RG23A';
292 reg_rg23c CONSTANT VARCHAR2(15) := 'RG23C';
293
294 reg_receipt_cenvat CONSTANT VARCHAR2(15) := 'RECEIPT_CENVAT';
295
296
297 tname_dlry_dtl CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS';
298 tname_cus_trx_lines CONSTANT VARCHAR2(30) := 'CUSTOMER_TRX_LINE_ALL' ;
299
300 contxt_delivery CONSTANT VARCHAR2(15) := 'DELIVERY';
301 contxt_manual_ar CONSTANT VARCHAR2(30) := 'MANUAL AR INVOICE';
302
303 vat_repo_call_from_om_ar CONSTANT VARCHAR2(61) := 'JAI_RGM_OM_AR_VAT_ACCOUNTING.PROCESS_ORDER_INVOICE' ;
304 vat_repo_call_inv_comp CONSTANT VARCHAR2(61) := 'JA_IN_LOC_AR_HDR_UPD_TRG';
305
306 rgm_attr_item_class CONSTANT VARCHAR2(15) := 'ITEM CLASS';
307 rgm_attr_item_folio CONSTANT VARCHAR2(15) := 'ITEM FOLIO';
308 rgm_attr_item_applicable CONSTANT VARCHAR2(15) := 'APPLICABLE';
309 rgm_attr_item_recoverable CONSTANT VARCHAR2(15) := 'RECOVERABLE';
310
311
312 /********************************************
313 || Start of bug 5631784. Added by Bgowrava For TCS enhancement
314 || TCS Regime related entries
315 *********************************************/
316 --rgm_attr_type_code_primary CONSTANT VARCHAR2(15) := 'PRIMARY' ;
317 rgm_attr_code_org_tan CONSTANT VARCHAR2(30) := 'ORG_TAN_NUM' ;
318 rgm_attr_cd_itm_class CONSTANT VARCHAR2(30) := 'ITEM_CLASSIFICATION' ;
319
320 tcs_regime CONSTANT VARCHAR2(30) := 'TCS' ;
321 tcs_event_surcharge CONSTANT VARCHAR2(30) := 'TCS_THRESHOLD_PROCESSING' ;
322 tax_type_tcs CONSTANT VARCHAR2(30) := 'TCS' ;
323 tax_type_tcs_cess CONSTANT VARCHAR2(30) := 'TCS_CESS' ;
324 tax_type_tcs_surcharge CONSTANT VARCHAR2(30) := 'TCS_SURCHARGE' ;
325 tax_type_tcs_surcharge_cess CONSTANT VARCHAR2(30) := 'TCS_SURCHARGE_CESS' ;
326 tax_exmpt_flag_std_rate CONSTANT VARCHAR2(2) := 'SR' ;
327 tax_exmpt_flag_lower_rate CONSTANT VARCHAR2(2) := 'LR' ;
328 tax_exmpt_flag_zero_rate CONSTANT VARCHAR2(2) := 'ZR' ;
329 tax_modified_by_system CONSTANT VARCHAR2(10) := 'SYSTEM' ;
330 tax_modified_by_user CONSTANT VARCHAR2(10) := 'MANUAL' ;
331 thhold_typ_cumulative CONSTANT VARCHAR2(30) := 'CUMULATIVE' ;
332 default_taxes CONSTANT VARCHAR2(15) := 'DEFAULT_TAXES' ;
333 recalculate_taxes CONSTANT VARCHAR2(20) := 'RECALCULATE_TAXES' ;
334 site_use_bill_to CONSTANT VARCHAR2(20) := 'BILL_TO' ;
335 line_type_line CONSTANT VARCHAR2(20) := 'LINE' ;
336 account_class_rec CONSTANT VARCHAR2(10) := 'REC' ;
337 account_class_rev CONSTANT VARCHAR2(10) := 'REV' ;
338 tcs_surcharge_id CONSTANT NUMBER(5) := -700 ;
339 jai_rgm_thresholds CONSTANT VARCHAR2(30) := 'JAI_RGM_THRESHOLDS' ;
340 created_fr_ar_invoice_api CONSTANT VARCHAR2(20) := 'AR_INVOICE_API' ;
341 order_booked CONSTANT VARCHAR2(20) := 'BOOKED' ;
342 conversion_type_user CONSTANT VARCHAR2(20) := 'User' ;
343 tax_code_localization CONSTANT VARCHAR2(20) := 'Localization' ;
344 tcs_dm_prefix CONSTANT VARCHAR2(10) := 'TCS-DM' ;
345 tcs_cm_prefix CONSTANT VARCHAR2(10) := 'TCS-CM' ;
346 batch_src_dm CONSTANT VARCHAR2(20) := 'BATCH_SRC_DM' ;
347 batch_src_cm CONSTANT VARCHAR2(20) := 'BATCH_SRC_CM' ;
348 creation_sign_positive CONSTANT VARCHAR2(30) := 'P' ;
349 creation_sign_negative CONSTANT VARCHAR2(30) := 'N' ;
350 creation_sign_any CONSTANT VARCHAR2(30) := 'A' ;
351 wsh_ship_confirm CONSTANT VARCHAR2(20) := 'SHIP_CONFIRM' ;
352 bill_only_invoice CONSTANT VARCHAR2(25) := 'BILL_ONLY_INVOICE' ;
353 /* End of bug 5631784 */
354
355
356 item_class_rmin CONSTANT VARCHAR2(5) := 'RMIN' ;
357 item_class_rmex CONSTANT VARCHAR2(5) := 'RMEX' ;
358 item_class_cgex CONSTANT VARCHAR2(5) := 'CGEX' ;
359 item_class_cgin CONSTANT VARCHAR2(5) := 'CGIN' ;
360 item_class_ccex CONSTANT VARCHAR2(5) := 'CCEX' ;
361 item_class_ccin CONSTANT VARCHAR2(5) := 'CCIN' ;
362 item_class_fgin CONSTANT VARCHAR2(5) := 'FGIN' ;
363 item_class_fgex CONSTANT VARCHAR2(5) := 'FGEX' ;
364
365 closed_code_open CONSTANT VARCHAR2(20) := 'OPEN';
366 closed_code_inporcess CONSTANT VARCHAR2(20) := 'IN PROCESS' ;
367 closed_code_approved CONSTANT VARCHAR2(20) := 'APPROVED';
368 closed_code_preapproved CONSTANT VARCHAR2(20) := 'PRE-APPROVED';
369 closed_code_req_appr CONSTANT VARCHAR2(25) := 'REQUIRES REAPPROVAL' ;
370 closed_code_incomplete CONSTANT VARCHAR2(20) := 'INCOMPLETE' ;
371
375
372 INSERTING CONSTANT VARCHAR2(15) := 'INSERTING' ;
373 UPDATING CONSTANT VARCHAR2(15) := 'UPDATING' ;
374 DELETING CONSTANT VARCHAR2(15) := 'DELETING' ;
376 -- Start,BUGs 6012567, 6012570
377
378 SETUP_EVENT_TYPE CONSTANT VARCHAR2(20) := 'Event Type';
379 SETUP_EXPENDITURE_TYPE CONSTANT VARCHAR2(20) := 'Expenditure Type';
380 SETUP_PROJECT CONSTANT VARCHAR2(20) := 'Project';
381 SETUP_CUSTOMER_SITE CONSTANT VARCHAR2(20) := 'Customer/Site';
382 PA_DRAFT_INVOICE CONSTANT VARCHAR2 (30) := 'PROJECT_DRAFT_INVOICE';
383 pa_ip_invoices constant varchar2 (30) := 'PA_IP_INVOICES';
384 import_taxes constant varchar2 (30) := 'IMPORT_TAXES';
385 projects_invoices constant varchar2 (30) := 'PROJECTS INVOICES';
386 pa_je_source CONSTANT VARCHAR2(30) := 'Projects India'; --Added by Bgowrava for Bug#6012570
387 -- end,BUGs 6012567, 6012570
388 ------------------------------------------------------
389 -- sacsethi , Added expense constant, w.r.t BUG#6072461 (for VAT Reversal)
390 expense VARCHAR2(20) := 'EXPENSE';
391
392 /*added by csahoo for bug#6155839, start*/
393 service_tax_source CONSTANT VARCHAR2(30) := 'Service Tax India';
394 vat_source CONSTANT VARCHAR2(30) := 'VAT India';
395 tcs_source CONSTANT VARCHAR2(30) := 'India Tax Collected';
396
397 /*bug#6155839, end*/
398
399 -- Date 28/06/2007 by sacsethi for bug 6157120
400 -- pan_no = for Organization pan no
401 -- 'Accounting Information' - This Reference to Organization Additional Information
402
403 pan_no CONSTANT VARCHAR2(10) := 'PAN NO';
404 accounting_information CONSTANT VARCHAR2(30) := 'Accounting Information' ;
405
406 -- Added by Jeffsen for standalone invoice on 2007/09/04
407
408 ---------------------------------------------------------------------------
409 G_AP_STANDALONE_INVOICE CONSTANT VARCHAR2(30) := 'STANDALONE_INVOICE';
410 G_REDEFAULT_TAXES CONSTANT VARCHAR2(15) := 'REDEFAULT_TAXES';
411 G_MODULE_PREFIX VARCHAR2(40) := 'jai.plsql.JAI_CONSTANTS';
412 --==========================================================================
413
414 -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
415 source_nsh CONSTANT VARCHAR2(30) := 'NON-SHIPPABLE LINES';
416 source_ttype_non_shippable CONSTANT VARCHAR2(30) := 'FULFILL';
417 tname_order_lines_all CONSTANT VARCHAR2(30) := 'OE_ORDER_LINES_ALL';
418 contxt_non_shippable CONSTANT VARCHAR2(30) := 'NON-SHIPPABLE LINES';
419 -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
420
421 ---Added by Bo Li for bug#10043656 Begin
422 -------------------------------------------------------------
423 cgst_regime CONSTANT VARCHAR2(15) := 'CGST';
424 sgst_regime CONSTANT VARCHAR2(15) := 'SGST';
425 -------------------------------------------------------------
426 ---Added by Bo Li for bug#10043656 End
427
428 --Added by Bo Li for BOE ER
429 --This field is also referenced by Open Interface ER bug#11683927.
430 ------------------------------------------------------------
431 customs_regime CONSTANT VARCHAR2(15) := 'CUSTOMS';
432 --------------------------------------------------------------
433
434 tax_classification CONSTANT VARCHAR2(30) := 'TAX CLASSIFICATION';---Added by peng.zheng for bug#10043656
435
436 END jai_constants;