eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_ETCS_PKG dependencies on JAI_CONSTANTS

Line 23: constants jai_constants.ar_cash_tax_confirmed and jai_constants.trx_type_inv_comp

19: Column name org_tan_num is renamed to org_tan_no. So the change is propogated into this
20: package.
21: File name changed to jai_ar_etcs_prc.plb
22: Removed the Hard Coded values and replaced them with the
23: constants jai_constants.ar_cash_tax_confirmed and jai_constants.trx_type_inv_comp
24: 2. 14/05/2007 bduvarag for bug#5631784. File Version 120.1
25: Removed local_fnd_global
26:
27: 3. 26.06.2007 sacsethi for bug 6153881 file version 120.2

Line 48: 5. In File jai_constants.pls - Two variable is used pan_no , accounting_information to Avoid Hard coding of these information.

44:
45: Problem - Table used under this cursor has been obsuleted in R12
46: we should not use ap_check_all , ap_bank_branches etc.
47:
48: 5. In File jai_constants.pls - Two variable is used pan_no , accounting_information to Avoid Hard coding of these information.
49:
50: 4. 03/07/2007 sacsethi for bug 6157120 File version 120.6
51:
52: R12RUP03-ST1:ETCS REPORT RUNS INTO ERROR

Line 2358: and source_document_type IN (jai_constants.ar_cash_tax_confirmed , jai_constants.trx_type_inv_comp)

2354: is
2355: select source_document_type
2356: from jai_rgm_refs_all
2357: where source_document_id = cp_source_ref_id
2358: and source_document_type IN (jai_constants.ar_cash_tax_confirmed , jai_constants.trx_type_inv_comp)
2359: and rownum = 1 ;
2360:
2361: Cursor c_inv_date(cp_inv_id number)
2362: is

Line 2485: open c_tax_amount(jai_constants.tax_type_tcs,rec.source_document_id, rec.tcs_check_id ) ;

2481: open c_line_amt(rec.source_document_id, rec.tcs_check_id) ;
2482: fetch c_line_amt into ln_line_amt ;
2483: close c_line_amt ;
2484:
2485: open c_tax_amount(jai_constants.tax_type_tcs,rec.source_document_id, rec.tcs_check_id ) ;
2486: fetch c_tax_amount into ln_tcs_amount ;
2487: close c_tax_amount ;
2488:
2489: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;

Line 2489: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;

2485: open c_tax_amount(jai_constants.tax_type_tcs,rec.source_document_id, rec.tcs_check_id ) ;
2486: fetch c_tax_amount into ln_tcs_amount ;
2487: close c_tax_amount ;
2488:
2489: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;
2490: fetch c_tax_amount into ln_surcharge_amount ;
2491: close c_tax_amount ;
2492:
2493: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;

Line 2493: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;

2489: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;
2490: fetch c_tax_amount into ln_surcharge_amount ;
2491: close c_tax_amount ;
2492:
2493: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;
2494: fetch c_tax_amount into ln_tcs_cess_amount ;
2495: close c_tax_amount ;
2496:
2497: open c_tax_amount(jai_constants.tax_type_tcs_surcharge_cess, rec.source_document_id, rec.tcs_check_id ) ;

Line 2497: open c_tax_amount(jai_constants.tax_type_tcs_surcharge_cess, rec.source_document_id, rec.tcs_check_id ) ;

2493: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;
2494: fetch c_tax_amount into ln_tcs_cess_amount ;
2495: close c_tax_amount ;
2496:
2497: open c_tax_amount(jai_constants.tax_type_tcs_surcharge_cess, rec.source_document_id, rec.tcs_check_id ) ;
2498: fetch c_tax_amount into ln_sur_cess_amount ;
2499: close c_tax_amount ;
2500:
2501: -- Date 03/07/2007 by sacsethi for bug 6157120

Line 2503: open c_tax_amount(jai_constants.tax_type_sh_tcs_edu_cess, rec.source_document_id, rec.tcs_check_id ) ;

2499: close c_tax_amount ;
2500:
2501: -- Date 03/07/2007 by sacsethi for bug 6157120
2502:
2503: open c_tax_amount(jai_constants.tax_type_sh_tcs_edu_cess, rec.source_document_id, rec.tcs_check_id ) ;
2504: fetch c_tax_amount into ln_tcs_sh_cess_amount ;
2505: close c_tax_amount ;
2506:
2507: ln_cess_amount := ln_tcs_cess_amount + ln_sur_cess_amount + ln_tcs_sh_cess_amount ; -- Date 03/07/2007 by sacsethi for bug 6157120

Line 2525: IF lv_source_ref_type = jai_constants.trx_type_inv_comp THEN

2521: close c_source_ref_type ;
2522:
2523: lv_source_ref_type := substr(lv_source_ref_type, 1,50);
2524:
2525: IF lv_source_ref_type = jai_constants.trx_type_inv_comp THEN
2526: open c_inv_date(rec.source_document_id) ;
2527: fetch c_inv_date into lv_doc_date ;
2528: close c_inv_date ;
2529: ELSIF lv_source_ref_type = jai_constants.ar_cash_tax_confirmed THEN

Line 2529: ELSIF lv_source_ref_type = jai_constants.ar_cash_tax_confirmed THEN

2525: IF lv_source_ref_type = jai_constants.trx_type_inv_comp THEN
2526: open c_inv_date(rec.source_document_id) ;
2527: fetch c_inv_date into lv_doc_date ;
2528: close c_inv_date ;
2529: ELSIF lv_source_ref_type = jai_constants.ar_cash_tax_confirmed THEN
2530: open c_rcpt_date(rec.source_document_id) ;
2531: fetch c_rcpt_date into lv_doc_date ;
2532: close c_rcpt_date ;
2533: END IF ;

Line 2629: where jrorv.attribute_code = jai_constants.pan_no AND

2625: /* Bug 12597773 -End*/
2626: CURSOR c_pan_number(p_organization_id IN NUMBER) IS
2627: Select ATTRIBUTE_VALUE
2628: from jai_rgm_org_regns_v jrorv ,HR_ORGANIZATION_INFORMATION hrou
2629: where jrorv.attribute_code = jai_constants.pan_no AND
2630: hrou.org_information_context= jai_constants.accounting_information and
2631: hrou.organization_id = p_organization_id and
2632: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2633: jrorv.REGIME_CODE = jai_constants.tds_regime ;

Line 2630: hrou.org_information_context= jai_constants.accounting_information and

2626: CURSOR c_pan_number(p_organization_id IN NUMBER) IS
2627: Select ATTRIBUTE_VALUE
2628: from jai_rgm_org_regns_v jrorv ,HR_ORGANIZATION_INFORMATION hrou
2629: where jrorv.attribute_code = jai_constants.pan_no AND
2630: hrou.org_information_context= jai_constants.accounting_information and
2631: hrou.organization_id = p_organization_id and
2632: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2633: jrorv.REGIME_CODE = jai_constants.tds_regime ;
2634: /*

Line 2633: jrorv.REGIME_CODE = jai_constants.tds_regime ;

2629: where jrorv.attribute_code = jai_constants.pan_no AND
2630: hrou.org_information_context= jai_constants.accounting_information and
2631: hrou.organization_id = p_organization_id and
2632: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2633: jrorv.REGIME_CODE = jai_constants.tds_regime ;
2634: /*
2635: SELECT attribute2
2636: FROM hr_all_organization_units
2637: WHERE organization_id = p_organization_id;*/

Line 3117: p_ret_code := jai_constants.request_error ;

3113: INSERT INTO jai_ap_etds_errors_t
3114: (batch_id, record_type, reference_id, error_message) VALUES
3115: ( ln_batch_id,'DD', v_line_number, p_return_message ) ;
3116: ELSE
3117: p_ret_code := jai_constants.request_error ;
3118: p_err_buf := p_return_message ;
3119: RETURN ;
3120: END IF ;
3121: END IF ;

Line 3392: p_ret_code := jai_constants.request_error ;

3388: INSERT INTO jai_ap_etds_errors_t
3389: (batch_id, record_type, error_message) values
3390: ( ln_batch_id, 'FH', p_return_message ) ;
3391: ELSE
3392: p_ret_code := jai_constants.request_error ;
3393: p_err_buf := p_return_message ;
3394: RETURN ;
3395: END IF ;
3396: END IF ;

Line 3616: p_ret_code := jai_constants.request_error ;

3612: IF lv_action = 'V' THEN
3613: insert into jai_ap_etds_errors_t(batch_id, record_type, error_message) values
3614: ( ln_batch_id, 'BH', p_return_message ) ;
3615: ELSE
3616: p_ret_code := jai_constants.request_error ;
3617: p_err_buf := p_return_message ;
3618: RETURN ;
3619: END IF ;
3620: END IF ;

Line 3831: p_ret_code := jai_constants.request_error ;

3827: insert into jai_ap_etds_errors_t
3828: (batch_id, record_type, reference_id, error_message) values
3829: ( ln_batch_id, 'CD', v_line_number, p_return_message ) ;
3830: ELSE
3831: p_ret_code := jai_constants.request_error ;
3832: p_err_buf := p_return_message ;
3833: RETURN ;
3834: END IF ;
3835: END IF ;