[Home] [Help]
PACKAGE: APPS.JAI_CONSTANTS
Source
1 PACKAGE jai_constants AS
2 /* $Header: jai_constants.pls 120.15 2008/01/21 12:50:38 eaggarwa 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
75 ----------------------------------------------------------------------------------------------------------------------------*/
76 -- All global variables are declared as CONSTANT for File.Sql.35 by Brathod
77
78 func_curr CONSTANT VARCHAR2(3) := 'INR';
79
80 accounting_method_cash CONSTANT VARCHAR2(15) := 'Cash';
81 accounting_method_accrual CONSTANT VARCHAR2(15) := 'Accrual';
82
83 no_number_value CONSTANT NUMBER := -999999999999;
84
85 party_type_orgn CONSTANT VARCHAR2(1) := 'O';
86 party_type_vendor CONSTANT VARCHAR2(1) := 'V';
87 party_type_customer CONSTANT VARCHAR2(1) := 'C';
88
89 yes CONSTANT VARCHAR2(1) := 'Y';
90 no CONSTANT VARCHAR2(1) := 'N';
91 value_true CONSTANT VARCHAR2(15) := 'TRUE';
92 value_false CONSTANT VARCHAR2(15) := 'FALSE';
93
94 credit CONSTANT VARCHAR2(2) := 'CR';
95 debit CONSTANT VARCHAR2(2) := 'DR';
96
97 je_category_rg_entry CONSTANT VARCHAR2(30) := 'Register India';
98
99 recovery CONSTANT VARCHAR2(20) := 'RECOVERY';
100 liability CONSTANT VARCHAR2(20) := 'LIABILITY';
101 recovery_interim CONSTANT VARCHAR2(20) := 'INTERIM_RECOVERY';
102 liability_interim CONSTANT VARCHAR2(20) := 'INTERIM_LIABILITY';
103
104 source_ap CONSTANT VARCHAR2(2) := 'AP';
105 source_ar CONSTANT VARCHAR2(2) := 'AR';
106 source_po CONSTANT VARCHAR2(2) := 'PO';
107 source_om CONSTANT VARCHAR2(2) := 'OM';
108 source_manual_entry CONSTANT VARCHAR2(15) := 'MANUAL';
109 source_settle_in CONSTANT VARCHAR2(15) := 'SETTLE_IN';
110 source_settle_out CONSTANT VARCHAR2(15) := 'SETTLE_OUT';
111 source_receive CONSTANT VARCHAR2(15) := 'RECEIVE';
112 source_rtv CONSTANT VARCHAR2(20) := 'RETURN TO VENDOR';
113
114 source_wsh CONSTANT VARCHAR2(5) := 'WSH';
115 source_rcv CONSTANT VARCHAR2(5) := 'RCV';
116 source_ttype_delivery CONSTANT VARCHAR2(15) := 'DELIVERY';
117 source_ttype_man_ar_inv CONSTANT VARCHAR2(30) := 'MANUAL AR INVOICE';
118 /*
119 || Added by bgowrava for the TCS enhancement Bug 5631784
120 */
121
122 service_src_distribute_in CONSTANT VARCHAR2(30) := 'SERVICE_DISTRIBUTE_IN';
123 service_src_distribute_out CONSTANT VARCHAR2(30) := 'SERVICE_DISTRIBUTE_OUT';
124
125 orgn_type_ou CONSTANT VARCHAR2(2) := 'OU';
126 orgn_type_io CONSTANT VARCHAR2(2) := 'IO';
127 excise_regime CONSTANT VARCHAR2(15) := 'EXCISE';
128
129 service_tax_orgn_type CONSTANT VARCHAR2(2) := 'IO'; --added by csahoo for bug#6081806
130 service_regime CONSTANT VARCHAR2(15) := 'SERVICE';
131 vat_regime CONSTANT VARCHAR2(15) := 'VAT';
132 tds_regime CONSTANT VARCHAR2(3) := 'TDS' ;
133
134 /* this will be used for rounding the amounts that are hitting service tax repository */
135 service_rgm_rnd_factor CONSTANT NUMBER(1) := 2;
136 vat_rgm_rnd_factor CONSTANT NUMBER(1) := 2;
137
138 tax_type_service CONSTANT VARCHAR2(15) := 'Service';
139 tax_type_excise CONSTANT VARCHAR2(15) := 'Excise';
140 tax_type_exc_additional CONSTANT VARCHAR2(15) := 'Addl. Excise';
141 tax_type_exc_other CONSTANT VARCHAR2(15) := 'Other Excise';
142 tax_type_cvd CONSTANT VARCHAR2(15) := 'CVD';
143 tax_type_add_cvd CONSTANT VARCHAR2(15) := 'ADDITIONAL_CVD'; -- Date 01/11/2006 Bug 5228046 added by SACSETHI
144 tax_type_tds CONSTANT VARCHAR2(15) := 'TDS';
145 tax_type_modvat_recovery CONSTANT VARCHAR2(20) := 'Modvat Recovery';
146 tax_type_customs CONSTANT VARCHAR2(15) := 'Customs';
147 tax_type_cst CONSTANT VARCHAR2(15) := 'CST';
148 tax_type_sales CONSTANT VARCHAR2(15) := 'Sales Tax';
149 tax_type_other CONSTANT VARCHAR2(15) := 'Other';
150 tax_type_octroi CONSTANT VARCHAR2(15) := 'Octrai';
151 tax_type_service_edu_cess CONSTANT VARCHAR2(30) := 'SERVICE_EDUCATION_CESS';
152 tax_type_exc_edu_cess CONSTANT VARCHAR2(30) := 'EXCISE_EDUCATION_CESS';
153 tax_type_cvd_edu_cess CONSTANT VARCHAR2(30) := 'CVD_EDUCATION_CESS';
154 tax_type_customs_edu_cess CONSTANT VARCHAR2(30) := 'CUSTOMS_EDUCATION_CESS';
155 tax_type_freight CONSTANT VARCHAR2(30) := 'Freight';
156 /*Bug 5989740 bduvarag start*/
157 tax_type_sh_exc_edu_cess VARCHAR2(30) := 'EXCISE_SH_EDU_CESS';
158 tax_type_sh_cvd_edu_cess VARCHAR2(30) := 'CVD_SH_EDU_CESS';
159 tax_type_sh_customs_edu_Cess VARCHAR2(30) := 'CUSTOMS_SH_EDU_CESS';
160 tax_type_sh_service_edu_cess VARCHAR2(30) := 'SERVICE_SH_EDU_CESS';
161 tax_type_sh_tcs_edu_cess VARCHAR2(30) := 'TCS_SH_EDU_CESS';
162
163 /*Bug 5989740 bduvarag end*/
164
165 tax_type_entry CONSTANT VARCHAR2(15) := 'ENTRY TAX';
166 tax_type_purchase CONSTANT VARCHAR2(15) := 'PURCHASE TAX';
167 tax_type_turnover CONSTANT VARCHAR2(15) := 'TURNOVER TAX';
168 tax_type_value_added CONSTANT VARCHAR2(20) := 'VALUE ADDED TAX';
169
170 rgm_attr_type_code_primary CONSTANT VARCHAR2(15) := 'PRIMARY';
171 regn_type_tax_types CONSTANT VARCHAR2(15) := 'TAX_TYPES';
172 regn_type_accounts CONSTANT VARCHAR2(15) := 'ACCOUNTS';
173 regn_type_others CONSTANT VARCHAR2(15) := 'OTHERS';
174 regn_type_tds_batch CONSTANT VARCHAR2(20) := 'TDS_INVOICE_BATCH' ;
175
176 attr_code_same_inv_no CONSTANT VARCHAR2(30) := 'SAME_INVOICE_NO';
177 attr_code_regn_no CONSTANT VARCHAR2(30) := 'REGISTRATION_NO';
178
179 register_type_a CONSTANT VARCHAR2(10) := 'A';
180 register_type_c CONSTANT VARCHAR2(10) := 'C';
181 register_type_pla CONSTANT VARCHAR2(10) := 'PLA';
182
183 gl_je_source_name CONSTANT VARCHAR2(30) := 'India Localization Entry';
184
185 repository_name CONSTANT VARCHAR2(30) := 'JAI_RGM_TRX_RECORDS';
186 ap_payments CONSTANT VARCHAR2(30) := 'AP_INVOICE_PAYMENTS_ALL';
187 ap_prepayments CONSTANT VARCHAR2(30) := 'AP_INVOICE_DISTRIBUTIONS_ALL';
188 rgm_trx_refs CONSTANT VARCHAR2(25) := 'JAI_RGM_TRX_REFS';
189 ar_inv_lines_table VARCHAR2(30) := 'JAI_AR_TRX_LINES'; --added by bgowrava /* ssumaith - bug#6109941 */
190
191 already_processed CONSTANT VARCHAR2(1) := 'A';
192 not_accounted CONSTANT VARCHAR2(2) := 'N';
193 expected_error CONSTANT VARCHAR2(2) := 'EE';
194 unexpected_error CONSTANT VARCHAR2(2) := 'UE';
195 successful CONSTANT VARCHAR2(2) := 'SS';
196 not_applicable VARCHAR2(2) := 'NA'; /* Added by bgowrava */
197
198 misc_line CONSTANT VARCHAR2(30) := 'MISCELLANEOUS';
199 prepay_line CONSTANT VARCHAR2(15) := 'PREPAY';
200 future_payment CONSTANT VARCHAR2(15) := 'FUTURE_PAYMENT';
201 payment CONSTANT VARCHAR2(15) := 'PAYMENT';
202 payment_voided CONSTANT VARCHAR2(15) := 'PAYMENT_VOID';
203 payment_reversal CONSTANT VARCHAR2(20) := 'PAYMENT_REVERSAL';
204 prepay_application CONSTANT VARCHAR2(15) := 'PREPAY_APPLY';
205 prepay_unapplication CONSTANT VARCHAR2(15) := 'PREPAY_UNAPPLY';
206
207 cenvat_noclaim CONSTANT VARCHAR2(15) := 'UNCLAIM';
208 vat_noclaim CONSTANT VARCHAR2(15) := 'VAT_UNCLAIM';
209
210 gl_application_id CONSTANT NUMBER(4) := 101;
211
212 -- Lookups Defined in Database
213 lk_type_tax_type CONSTANT VARCHAR2(20) := 'JAI_TAX_TYPE' ;
214 lk_type_ind_tax_rgms CONSTANT VARCHAR2(25) := 'JAI_INDIA_TAX_REGIMES' ;
215
216 /* AR Related Constants */
217 trx_type_inv_comp CONSTANT VARCHAR2(40) := 'INVOICE_COMPLETION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
218 trx_type_inv_incomp CONSTANT VARCHAR2(40) := 'INVOICE_INCOMPLETION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
219 trx_event_app CONSTANT VARCHAR2(40) := 'APPLICATION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
220 trx_event_completion CONSTANT VARCHAR2(40) := 'COMPLETION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
221 trx_event_inv_save CONSTANT VARCHAR2(40) := 'INV_SAVE' ; /*Added by Bgowrava for forward porting Bug#5631784*/
222 trx_type_rct_app CONSTANT VARCHAR2(20) := 'RECEIPT_APPLICATION' ;
223 trx_type_rct_unapp CONSTANT VARCHAR2(40) := 'RECEIPT_UNAPPLICATION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
224 trx_type_rct_rvs CONSTANT VARCHAR2(20) := 'RECEIPT_REVERSAL' ;
225 jai_cash_rcpts CONSTANT VARCHAR2(40) := 'JAI_AR_CASH_RECEIPTS_ALL' ;/*Added by Bgowrava for forward porting Bug#5631784*/
226 trx_type_cm_app CONSTANT VARCHAR2(30) := 'CREDIT_MEMO_APPLICATION' ;
227 trx_type_cm_unapp CONSTANT VARCHAR2(40) := 'CREDIT_MEMO_UNAPPLICATION' ; /*Added by Bgowrava for forward porting Bug#5631784*/
228 trx_type_cm_rvs CONSTANT VARCHAR2(30) := 'CREDIT_MEMO_REVERSAL' ;
229 ar_receipt_app CONSTANT VARCHAR2(30) := 'AR_RECEIVABLE_APPLICATIONS_ALL';
230 ar_cash CONSTANT VARCHAR2(4) := 'CASH' ;
231 ar_cash_tax_confirmed CONSTANT VARCHAR2(40) := 'CASH_TAX_CONFIRMED' ;/*Added by Bgowrava for forward porting Bug#5631784*/
232 ar_status_app CONSTANT VARCHAR2(3) := 'APP' ;
233 ar_status_activity CONSTANT VARCHAR2(40) := 'ACTIVITY' ;/*Added by Bgowrava for forward porting Bug#5631784*/
234 ar_invoice_type_inv CONSTANT VARCHAR2(3) := 'INV' ;
238 /* OM Related Constants */
235 ar_invoice_type_cm CONSTANT VARCHAR2(2) := 'CM' ;
236 ar_doc_type_dm VARCHAR2(2) := 'DM' ; /* Added by bgowrava /*
237
239 om_action_gen_inv_n_accnt CONSTANT VARCHAR2(15) := 'PROCESS ALL';
240 om_action_gen_invoice CONSTANT VARCHAR2(30) := 'GENERATE INVOICE NO';
241 om_action_gen_accounting CONSTANT VARCHAR2(30) := 'PROCESS ACCOUNTING';
242
243 -- Concurrent Request processing Stage codes
244 request_error CONSTANT NUMBER(1) := 2;
245 request_warning CONSTANT NUMBER(1) := 1;
246
247 -- For Cenvat Register Processing
248 reg_rg23_2_code CONSTANT NUMBER(1) := 1;
249 reg_pla_code CONSTANT NUMBER(1) := 2;
250 reg_rg23d_code CONSTANT NUMBER(1) := 3;
251 reg_receipt_cenvat_code CONSTANT NUMBER(1) := 4;
252
253 reg_rg23a_2 CONSTANT VARCHAR2(15) := 'RG23A_P2';
254 reg_rg23c_2 CONSTANT VARCHAR2(15) := 'RG23C_P2';
255 reg_rg23d CONSTANT VARCHAR2(15) := 'RG23D';
256 reg_pla CONSTANT VARCHAR2(15) := 'PLA';
257 reg_rg23a CONSTANT VARCHAR2(15) := 'RG23A';
258 reg_rg23c CONSTANT VARCHAR2(15) := 'RG23C';
259
260 reg_receipt_cenvat CONSTANT VARCHAR2(15) := 'RECEIPT_CENVAT';
261
262
263 tname_dlry_dtl CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS';
264 tname_cus_trx_lines CONSTANT VARCHAR2(30) := 'CUSTOMER_TRX_LINE_ALL' ;
265
266 contxt_delivery CONSTANT VARCHAR2(15) := 'DELIVERY';
267 contxt_manual_ar CONSTANT VARCHAR2(30) := 'MANUAL AR INVOICE';
268
269 vat_repo_call_from_om_ar CONSTANT VARCHAR2(61) := 'JAI_RGM_OM_AR_VAT_ACCOUNTING.PROCESS_ORDER_INVOICE' ;
270 vat_repo_call_inv_comp CONSTANT VARCHAR2(61) := 'JA_IN_LOC_AR_HDR_UPD_TRG';
271
272 rgm_attr_item_class CONSTANT VARCHAR2(15) := 'ITEM CLASS';
273 rgm_attr_item_folio CONSTANT VARCHAR2(15) := 'ITEM FOLIO';
274 rgm_attr_item_applicable CONSTANT VARCHAR2(15) := 'APPLICABLE';
275 rgm_attr_item_recoverable CONSTANT VARCHAR2(15) := 'RECOVERABLE';
276
277
278 /********************************************
279 || Start of bug 5631784. Added by Bgowrava For TCS enhancement
280 || TCS Regime related entries
281 *********************************************/
282 --rgm_attr_type_code_primary CONSTANT VARCHAR2(15) := 'PRIMARY' ;
283 rgm_attr_code_org_tan CONSTANT VARCHAR2(30) := 'ORG_TAN_NUM' ;
284 rgm_attr_cd_itm_class CONSTANT VARCHAR2(30) := 'ITEM_CLASSIFICATION' ;
285
286 tcs_regime CONSTANT VARCHAR2(30) := 'TCS' ;
287 tcs_event_surcharge CONSTANT VARCHAR2(30) := 'TCS_THRESHOLD_PROCESSING' ;
288 tax_type_tcs CONSTANT VARCHAR2(30) := 'TCS' ;
289 tax_type_tcs_cess CONSTANT VARCHAR2(30) := 'TCS_CESS' ;
290 tax_type_tcs_surcharge CONSTANT VARCHAR2(30) := 'TCS_SURCHARGE' ;
291 tax_type_tcs_surcharge_cess CONSTANT VARCHAR2(30) := 'TCS_SURCHARGE_CESS' ;
292 tax_exmpt_flag_std_rate CONSTANT VARCHAR2(2) := 'SR' ;
293 tax_exmpt_flag_lower_rate CONSTANT VARCHAR2(2) := 'LR' ;
294 tax_exmpt_flag_zero_rate CONSTANT VARCHAR2(2) := 'ZR' ;
295 tax_modified_by_system CONSTANT VARCHAR2(10) := 'SYSTEM' ;
296 tax_modified_by_user CONSTANT VARCHAR2(10) := 'MANUAL' ;
297 thhold_typ_cumulative CONSTANT VARCHAR2(30) := 'CUMULATIVE' ;
298 default_taxes CONSTANT VARCHAR2(15) := 'DEFAULT_TAXES' ;
299 recalculate_taxes CONSTANT VARCHAR2(20) := 'RECALCULATE_TAXES' ;
300 site_use_bill_to CONSTANT VARCHAR2(20) := 'BILL_TO' ;
301 line_type_line CONSTANT VARCHAR2(20) := 'LINE' ;
302 account_class_rec CONSTANT VARCHAR2(10) := 'REC' ;
303 account_class_rev CONSTANT VARCHAR2(10) := 'REV' ;
304 tcs_surcharge_id CONSTANT NUMBER(5) := -700 ;
305 jai_rgm_thresholds CONSTANT VARCHAR2(30) := 'JAI_RGM_THRESHOLDS' ;
306 created_fr_ar_invoice_api CONSTANT VARCHAR2(20) := 'AR_INVOICE_API' ;
307 order_booked CONSTANT VARCHAR2(20) := 'BOOKED' ;
308 conversion_type_user CONSTANT VARCHAR2(20) := 'User' ;
309 tax_code_localization CONSTANT VARCHAR2(20) := 'Localization' ;
310 tcs_dm_prefix CONSTANT VARCHAR2(10) := 'TCS-DM' ;
311 tcs_cm_prefix CONSTANT VARCHAR2(10) := 'TCS-CM' ;
312 batch_src_dm CONSTANT VARCHAR2(20) := 'BATCH_SRC_DM' ;
313 batch_src_cm CONSTANT VARCHAR2(20) := 'BATCH_SRC_CM' ;
314 creation_sign_positive CONSTANT VARCHAR2(30) := 'P' ;
315 creation_sign_negative CONSTANT VARCHAR2(30) := 'N' ;
316 creation_sign_any CONSTANT VARCHAR2(30) := 'A' ;
317 wsh_ship_confirm CONSTANT VARCHAR2(20) := 'SHIP_CONFIRM' ;
318 bill_only_invoice CONSTANT VARCHAR2(25) := 'BILL_ONLY_INVOICE' ;
319 /* End of bug 5631784 */
320
321
322 item_class_rmin CONSTANT VARCHAR2(5) := 'RMIN' ;
323 item_class_rmex CONSTANT VARCHAR2(5) := 'RMEX' ;
324 item_class_cgex CONSTANT VARCHAR2(5) := 'CGEX' ;
325 item_class_cgin CONSTANT VARCHAR2(5) := 'CGIN' ;
326 item_class_ccex CONSTANT VARCHAR2(5) := 'CCEX' ;
327 item_class_ccin CONSTANT VARCHAR2(5) := 'CCIN' ;
328 item_class_fgin CONSTANT VARCHAR2(5) := 'FGIN' ;
329 item_class_fgex CONSTANT VARCHAR2(5) := 'FGEX' ;
330
331 closed_code_open CONSTANT VARCHAR2(20) := 'OPEN';
332 closed_code_inporcess CONSTANT VARCHAR2(20) := 'IN PROCESS' ;
333 closed_code_approved CONSTANT VARCHAR2(20) := 'APPROVED';
334 closed_code_preapproved CONSTANT VARCHAR2(20) := 'PRE-APPROVED';
335 closed_code_req_appr CONSTANT VARCHAR2(25) := 'REQUIRES REAPPROVAL' ;
336 closed_code_incomplete CONSTANT VARCHAR2(20) := 'INCOMPLETE' ;
337
338 INSERTING CONSTANT VARCHAR2(15) := 'INSERTING' ;
339 UPDATING CONSTANT VARCHAR2(15) := 'UPDATING' ;
340 DELETING CONSTANT VARCHAR2(15) := 'DELETING' ;
341
342 -- Start,BUGs 6012567, 6012570
343
344 SETUP_EVENT_TYPE CONSTANT VARCHAR2(20) := 'Event Type';
345 SETUP_EXPENDITURE_TYPE CONSTANT VARCHAR2(20) := 'Expenditure Type';
346 SETUP_PROJECT CONSTANT VARCHAR2(20) := 'Project';
347 SETUP_CUSTOMER_SITE CONSTANT VARCHAR2(20) := 'Customer/Site';
348 PA_DRAFT_INVOICE CONSTANT VARCHAR2 (30) := 'PROJECT_DRAFT_INVOICE';
349 pa_ip_invoices constant varchar2 (30) := 'PA_IP_INVOICES';
350 import_taxes constant varchar2 (30) := 'IMPORT_TAXES';
351 projects_invoices constant varchar2 (30) := 'PROJECTS INVOICES';
352 pa_je_source CONSTANT VARCHAR2(30) := 'Projects India'; --Added by Bgowrava for Bug#6012570
353 -- end,BUGs 6012567, 6012570
354 ------------------------------------------------------
355 -- sacsethi , Added expense constant, w.r.t BUG#6072461 (for VAT Reversal)
356 expense VARCHAR2(20) := 'EXPENSE';
357
358 /*added by csahoo for bug#6155839, start*/
359 service_tax_source CONSTANT VARCHAR2(30) := 'Service Tax India';
360 vat_source CONSTANT VARCHAR2(30) := 'VAT India';
361 tcs_source CONSTANT VARCHAR2(30) := 'India Tax Collected';
362
363 /*bug#6155839, end*/
364
365 -- Date 28/06/2007 by sacsethi for bug 6157120
366 -- pan_no = for Organization pan no
367 -- 'Accounting Information' - This Reference to Organization Additional Information
368
369 pan_no CONSTANT VARCHAR2(10) := 'PAN NO';
370 accounting_information CONSTANT VARCHAR2(30) := 'Accounting Information' ;
371
372 -- Added by Jeffsen for standalone invoice on 2007/09/04
373
374 ---------------------------------------------------------------------------
375 G_AP_STANDALONE_INVOICE CONSTANT VARCHAR2(30) := 'STANDALONE_INVOICE';
376 G_REDEFAULT_TAXES CONSTANT VARCHAR2(15) := 'REDEFAULT_TAXES';
377 G_MODULE_PREFIX VARCHAR2(40) := 'jai.plsql.JAI_CONSTANTS';
378 --==========================================================================
379 END jai_constants;