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_AP_UTILS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 396: FROM jai_boe_roundings jbr, jai_cmn_taxes_all jct

392: --------------------------------------------------------
393: CURSOR get_tax_amount_cur(pn_boe_id NUMBER) IS
394: SELECT jct.tax_type,
395: SUM(nvl(jbr.total_amount, jbr.tax_amount)) boe_amount
396: FROM jai_boe_roundings jbr, jai_cmn_taxes_all jct
397: WHERE jbr.boe_id = pn_boe_id
398: AND jbr.tax_id = jct.tax_id
399: GROUP BY jct.tax_type;
400:

Line 2418: from JAI_CMN_TAXES_ALL

2414: mod_cr_percentage,
2415: adhoc_flag,
2416: nvl(tax_rate, 0) tax_rate,
2417: tax_type
2418: from JAI_CMN_TAXES_ALL
2419: where tax_id = ln_tax_id;
2420:
2421:
2422: Cursor get_misc_lines (ln_dist_line_number in number,

Line 2768: jai_cmn_taxes_all

2764: CURSOR cur_tax_acc IS
2765: SELECT
2766: tax_account_id
2767: FROM
2768: jai_cmn_taxes_all
2769: WHERE tax_id = pn_tax_id;
2770:
2771: BEGIN
2772: --logging for debug

Line 3020: , jai_cmn_taxes_all tax

3016: , tax.tax_type tax_type
3017: , SUM(tax_line.tax_amount) tax_amount
3018: FROM
3019: jai_ap_match_inv_taxes tax_line
3020: , jai_cmn_taxes_all tax
3021: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
3022: AND tax_line.invoice_id = pn_invoice_id
3023: AND tax_line.parent_invoice_line_number = pn_invoice_line_num
3024: AND tax_line.tax_id = tax.tax_id

Line 3039: , jai_cmn_taxes_all tax

3035: , tax.tax_type tax_type
3036: , SUM(tax_line.tax_amt) tax_amount
3037: FROM
3038: jai_cmn_document_taxes tax_line
3039: , jai_cmn_taxes_all tax
3040: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
3041: AND tax_line.source_doc_type = jai_constants.G_AP_STANDALONE_INVOICE
3042: AND tax_line.source_doc_id = pn_invoice_id
3043: AND tax_line.source_doc_parent_line_no = pn_invoice_line_num

Line 3704: FROM JAI_CMN_TAXES_ALL jcta

3700: ,jcta.vat_flag
3701: ,jcta.section_type
3702: ,jcta.start_date
3703: ,jcta.end_date
3704: FROM JAI_CMN_TAXES_ALL jcta
3705: WHERE jcta.tax_id = p_tax_id
3706: AND jcta.org_id = to_number(p_org_id);
3707:
3708: tax_code_info_rec get_tax_code_info%ROWTYPE;

Line 3709: jai_cmn_taxes_all_rec jai_cmn_taxes_all%ROWTYPE;

3705: WHERE jcta.tax_id = p_tax_id
3706: AND jcta.org_id = to_number(p_org_id);
3707:
3708: tax_code_info_rec get_tax_code_info%ROWTYPE;
3709: jai_cmn_taxes_all_rec jai_cmn_taxes_all%ROWTYPE;
3710: jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines%ROWTYPE;
3711: lv_name VARCHAR2(100);
3712: ln_val_id NUMBER;
3713: ln_base_tax_id NUMBER;

Line 3786: SELECT JAI_CMN_TAXES_ALL_S.nextval

3782: / (ln_base_tax_rate + NVL(tax_code_info_rec.cess_rate,0) + NVL(tax_code_info_rec.sh_cess_rate,0)), 2);
3783:
3784: --@Create new tax code for base TDS tax
3785: --get tax code ID for base tax
3786: SELECT JAI_CMN_TAXES_ALL_S.nextval
3787: INTO ln_base_tax_id
3788: FROM dual;
3789:
3790: ln_prcd_cnt := 1;

Line 3792: jai_cmn_taxes_all_rec := NULL;

3788: FROM dual;
3789:
3790: ln_prcd_cnt := 1;
3791: lv_name := SUBSTR(ln_base_tax_rate || '% TDS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3792: jai_cmn_taxes_all_rec := NULL;
3793: jai_cmn_taxes_all_rec.tax_id := ln_base_tax_id;
3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;
3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;

Line 3793: jai_cmn_taxes_all_rec.tax_id := ln_base_tax_id;

3789:
3790: ln_prcd_cnt := 1;
3791: lv_name := SUBSTR(ln_base_tax_rate || '% TDS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3792: jai_cmn_taxes_all_rec := NULL;
3793: jai_cmn_taxes_all_rec.tax_id := ln_base_tax_id;
3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;
3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';

Line 3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;

3790: ln_prcd_cnt := 1;
3791: lv_name := SUBSTR(ln_base_tax_rate || '% TDS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3792: jai_cmn_taxes_all_rec := NULL;
3793: jai_cmn_taxes_all_rec.tax_id := ln_base_tax_id;
3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;
3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

Line 3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);

3791: lv_name := SUBSTR(ln_base_tax_rate || '% TDS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3792: jai_cmn_taxes_all_rec := NULL;
3793: jai_cmn_taxes_all_rec.tax_id := ln_base_tax_id;
3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;
3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

Line 3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;

3792: jai_cmn_taxes_all_rec := NULL;
3793: jai_cmn_taxes_all_rec.tax_id := ln_base_tax_id;
3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;
3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

Line 3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';

3793: jai_cmn_taxes_all_rec.tax_id := ln_base_tax_id;
3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;
3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

Line 3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

3794: jai_cmn_taxes_all_rec.tax_rate := ln_base_tax_rate;
3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;

Line 3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

3795: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

Line 3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

3796: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

Line 3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

3797: jai_cmn_taxes_all_rec.tax_type := 'TDS';
3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

Line 3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;

3798: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

Line 3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

3799: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

Line 3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

3800: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

Line 3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

3801: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

Line 3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

3802: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_base_tax_rate;
3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

Line 3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

3803: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

Line 3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

3804: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

Line 3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

3805: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

Line 3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code

Line 3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code
3815: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

Line 3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code
3815: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3816:

Line 3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code
3815: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3816:
3817: --@Create new tax category line for base TDS tax

Line 3815: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code
3815: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3816:
3817: --@Create new tax category line for base TDS tax
3818: jai_cmn_tax_ctg_lines_rec := NULL;
3819: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

Line 3832: SELECT JAI_CMN_TAXES_ALL_S.nextval

3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3829: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3830:
3831: --get tax code ID for base tax
3832: SELECT JAI_CMN_TAXES_ALL_S.nextval
3833: INTO ln_cess_id
3834: FROM dual;
3835:
3836: IF NVL(ln_cess_rate,0) <> 0 THEN

Line 3839: SELECT JAI_CMN_TAXES_ALL_S.nextval

3835:
3836: IF NVL(ln_cess_rate,0) <> 0 THEN
3837: ln_prcd_cnt := ln_prcd_cnt + 1;
3838: --get tax code ID for TDS CESS tax
3839: SELECT JAI_CMN_TAXES_ALL_S.nextval
3840: INTO ln_cess_id
3841: FROM dual;
3842:
3843: lv_name := SUBSTR(ln_cess_rate || '% TDS CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);

Line 3844: jai_cmn_taxes_all_rec := NULL;

3840: INTO ln_cess_id
3841: FROM dual;
3842:
3843: lv_name := SUBSTR(ln_cess_rate || '% TDS CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3844: jai_cmn_taxes_all_rec := NULL;
3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;
3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;
3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;

Line 3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;

3841: FROM dual;
3842:
3843: lv_name := SUBSTR(ln_cess_rate || '% TDS CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3844: jai_cmn_taxes_all_rec := NULL;
3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;
3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;
3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';

Line 3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;

3842:
3843: lv_name := SUBSTR(ln_cess_rate || '% TDS CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3844: jai_cmn_taxes_all_rec := NULL;
3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;
3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;
3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

Line 3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);

3843: lv_name := SUBSTR(ln_cess_rate || '% TDS CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3844: jai_cmn_taxes_all_rec := NULL;
3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;
3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;
3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

Line 3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;

3844: jai_cmn_taxes_all_rec := NULL;
3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;
3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;
3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

Line 3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';

3845: jai_cmn_taxes_all_rec.tax_id := ln_cess_id;
3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;
3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

Line 3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

3846: jai_cmn_taxes_all_rec.tax_rate := ln_cess_rate;
3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;

Line 3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

3847: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

Line 3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

3848: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

Line 3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

3849: jai_cmn_taxes_all_rec.tax_type := 'TDS_EDUCATION_CESS';
3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

Line 3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;

3850: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

Line 3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

3851: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

Line 3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

3852: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

Line 3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

3853: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

Line 3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

3854: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_cess_rate;
3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

Line 3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

3855: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

Line 3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

3856: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

Line 3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

3857: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

Line 3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code

Line 3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code
3867: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

Line 3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code
3867: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3868:

Line 3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code
3867: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3868:
3869: --@Create new tax category TDS CESS tax

Line 3867: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code
3867: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3868:
3869: --@Create new tax category TDS CESS tax
3870: jai_cmn_tax_ctg_lines_rec := NULL;
3871: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

Line 3887: SELECT JAI_CMN_TAXES_ALL_S.nextval

3883:
3884: IF NVL(ln_sh_cess_rate,0) <> 0 THEN
3885: ln_prcd_cnt := ln_prcd_cnt + 1;
3886: --get tax code ID for TDS CESS tax
3887: SELECT JAI_CMN_TAXES_ALL_S.nextval
3888: INTO ln_sh_cess_id
3889: FROM dual;
3890:
3891: lv_name := SUBSTR(ln_sh_cess_rate || '% TDS SH CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);

Line 3892: jai_cmn_taxes_all_rec := NULL;

3888: INTO ln_sh_cess_id
3889: FROM dual;
3890:
3891: lv_name := SUBSTR(ln_sh_cess_rate || '% TDS SH CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3892: jai_cmn_taxes_all_rec := NULL;
3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;
3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;
3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;

Line 3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;

3889: FROM dual;
3890:
3891: lv_name := SUBSTR(ln_sh_cess_rate || '% TDS SH CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3892: jai_cmn_taxes_all_rec := NULL;
3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;
3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;
3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';

Line 3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;

3890:
3891: lv_name := SUBSTR(ln_sh_cess_rate || '% TDS SH CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3892: jai_cmn_taxes_all_rec := NULL;
3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;
3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;
3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

Line 3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);

3891: lv_name := SUBSTR(ln_sh_cess_rate || '% TDS SH CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3892: jai_cmn_taxes_all_rec := NULL;
3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;
3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;
3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

Line 3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;

3892: jai_cmn_taxes_all_rec := NULL;
3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;
3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;
3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

Line 3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';

3893: jai_cmn_taxes_all_rec.tax_id := ln_sh_cess_id;
3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;
3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

Line 3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

3894: jai_cmn_taxes_all_rec.tax_rate := ln_sh_cess_rate;
3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;

Line 3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

3895: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

Line 3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

3896: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

Line 3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

3897: jai_cmn_taxes_all_rec.tax_type := 'TDS_SH_EDU_CESS';
3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

Line 3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;

3898: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

Line 3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

3899: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

Line 3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

3900: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

Line 3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

3901: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

Line 3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

3902: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_sh_cess_rate;
3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

Line 3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

3903: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

Line 3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

3904: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

Line 3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

3905: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

Line 3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code

Line 3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code
3915: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

Line 3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code
3915: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3916:

Line 3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code
3915: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3916:
3917: --@Create new tax category TDS SH CESS tax

Line 3915: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code
3915: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3916:
3917: --@Create new tax category TDS SH CESS tax
3918: jai_cmn_tax_ctg_lines_rec := NULL;
3919: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

Line 3939: SELECT JAI_CMN_TAXES_ALL_S.nextval

3935:
3936: IF NVL(ln_surcharge_rate,0) <> 0 THEN
3937: ln_prcd_cnt := ln_prcd_cnt + 1;
3938: --get tax code ID for TDS CESS tax
3939: SELECT JAI_CMN_TAXES_ALL_S.nextval
3940: INTO ln_surcharge_id
3941: FROM dual;
3942:
3943: lv_name := SUBSTR(ln_surcharge_rate || '% TDS surcharge migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);

Line 3944: jai_cmn_taxes_all_rec := NULL;

3940: INTO ln_surcharge_id
3941: FROM dual;
3942:
3943: lv_name := SUBSTR(ln_surcharge_rate || '% TDS surcharge migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3944: jai_cmn_taxes_all_rec := NULL;
3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;
3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;
3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;

Line 3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;

3941: FROM dual;
3942:
3943: lv_name := SUBSTR(ln_surcharge_rate || '% TDS surcharge migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3944: jai_cmn_taxes_all_rec := NULL;
3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;
3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;
3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';

Line 3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;

3942:
3943: lv_name := SUBSTR(ln_surcharge_rate || '% TDS surcharge migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3944: jai_cmn_taxes_all_rec := NULL;
3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;
3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;
3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

Line 3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);

3943: lv_name := SUBSTR(ln_surcharge_rate || '% TDS surcharge migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);
3944: jai_cmn_taxes_all_rec := NULL;
3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;
3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;
3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

Line 3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;

3944: jai_cmn_taxes_all_rec := NULL;
3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;
3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;
3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

Line 3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';

3945: jai_cmn_taxes_all_rec.tax_id := ln_surcharge_id;
3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;
3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

Line 3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;

3946: jai_cmn_taxes_all_rec.tax_rate := ln_surcharge_rate;
3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;

Line 3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;

3947: jai_cmn_taxes_all_rec.tax_name := SUBSTR(lv_name,1,50);
3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

Line 3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;

3948: jai_cmn_taxes_all_rec.tax_descr := lv_name;
3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

Line 3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;

3949: jai_cmn_taxes_all_rec.tax_type := 'TDS_SURCHARGE';
3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

Line 3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;

3950: jai_cmn_taxes_all_rec.vendor_id := tax_code_info_rec.vendor_id;
3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

Line 3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;

3951: jai_cmn_taxes_all_rec.vendor_site_id := tax_code_info_rec.vendor_site_id;
3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

Line 3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;

3952: jai_cmn_taxes_all_rec.modifiable_flag := tax_code_info_rec.modifiable_flag;
3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

Line 3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;

3953: jai_cmn_taxes_all_rec.tax_account_id := tax_code_info_rec.tax_account_id;
3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

Line 3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;

3954: jai_cmn_taxes_all_rec.orig_tax_percentage := ln_surcharge_rate;
3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

Line 3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;

3955: jai_cmn_taxes_all_rec.org_id := tax_code_info_rec.org_id;
3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

Line 3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;

3956: jai_cmn_taxes_all_rec.duty_drawback_flag := tax_code_info_rec.duty_drawback_flag;
3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

Line 3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;

3957: jai_cmn_taxes_all_rec.vat_flag := tax_code_info_rec.vat_flag;
3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

Line 3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code

Line 3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;

3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code
3967: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

Line 3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code
3967: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3968:

Line 3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code
3967: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3968:
3969: --@Create new tax category TDS Surcharge tax

Line 3967: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);

3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code
3967: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3968:
3969: --@Create new tax category TDS Surcharge tax
3970: jai_cmn_tax_ctg_lines_rec := NULL;
3971: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

Line 3999: -- insert_jai_cmn_taxes_all Public

3995: END AUTO_CREATE_DTC_CATEGORY;
3996:
3997: --==========================================================================
3998: -- PROCEDURE NAME:
3999: -- insert_jai_cmn_taxes_all Public
4000: --
4001: -- DESCRIPTION:
4002: -- Insert a new line for jai_cmn_taxes_all table
4003: --

Line 4002: -- Insert a new line for jai_cmn_taxes_all table

3998: -- PROCEDURE NAME:
3999: -- insert_jai_cmn_taxes_all Public
4000: --
4001: -- DESCRIPTION:
4002: -- Insert a new line for jai_cmn_taxes_all table
4003: --
4004: -- PARAMETERS:
4005: -- In: p_jai_cmn_taxes_all_rec jai_cmn_taxes_all record
4006: --

Line 4005: -- In: p_jai_cmn_taxes_all_rec jai_cmn_taxes_all record

4001: -- DESCRIPTION:
4002: -- Insert a new line for jai_cmn_taxes_all table
4003: --
4004: -- PARAMETERS:
4005: -- In: p_jai_cmn_taxes_all_rec jai_cmn_taxes_all record
4006: --
4007: -- DESIGN REFERENCES:
4008: -- For new TDS architecture migration script
4009: --

Line 4013: PROCEDURE insert_jai_cmn_taxes_all (

4009: --
4010: -- CHANGE HISTORY:
4011: -- 24-OCT-2012 Chong created
4012: --==========================================================================
4013: PROCEDURE insert_jai_cmn_taxes_all (
4014: p_jai_cmn_taxes_all_rec jai_cmn_taxes_all%ROWTYPE
4015: ) IS
4016:
4017: BEGIN

Line 4014: p_jai_cmn_taxes_all_rec jai_cmn_taxes_all%ROWTYPE

4010: -- CHANGE HISTORY:
4011: -- 24-OCT-2012 Chong created
4012: --==========================================================================
4013: PROCEDURE insert_jai_cmn_taxes_all (
4014: p_jai_cmn_taxes_all_rec jai_cmn_taxes_all%ROWTYPE
4015: ) IS
4016:
4017: BEGIN
4018:

Line 4020: INSERT INTO JAI_CMN_TAXES_ALL(

4016:
4017: BEGIN
4018:
4019: --insert tax code
4020: INSERT INTO JAI_CMN_TAXES_ALL(
4021: tax_id
4022: ,tax_name
4023: ,tax_descr
4024: ,tax_type

Line 4080: p_jai_cmn_taxes_all_rec.tax_id

4076: ,auto_create_category
4077: ,reverse_charge_flag
4078: )
4079: VALUES(
4080: p_jai_cmn_taxes_all_rec.tax_id
4081: ,p_jai_cmn_taxes_all_rec.tax_name
4082: ,p_jai_cmn_taxes_all_rec.tax_descr
4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate

Line 4081: ,p_jai_cmn_taxes_all_rec.tax_name

4077: ,reverse_charge_flag
4078: )
4079: VALUES(
4080: p_jai_cmn_taxes_all_rec.tax_id
4081: ,p_jai_cmn_taxes_all_rec.tax_name
4082: ,p_jai_cmn_taxes_all_rec.tax_descr
4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount

Line 4082: ,p_jai_cmn_taxes_all_rec.tax_descr

4078: )
4079: VALUES(
4080: p_jai_cmn_taxes_all_rec.tax_id
4081: ,p_jai_cmn_taxes_all_rec.tax_name
4082: ,p_jai_cmn_taxes_all_rec.tax_descr
4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code

Line 4083: ,p_jai_cmn_taxes_all_rec.tax_type

4079: VALUES(
4080: p_jai_cmn_taxes_all_rec.tax_id
4081: ,p_jai_cmn_taxes_all_rec.tax_name
4082: ,p_jai_cmn_taxes_all_rec.tax_descr
4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag

Line 4084: ,p_jai_cmn_taxes_all_rec.tax_rate

4080: p_jai_cmn_taxes_all_rec.tax_id
4081: ,p_jai_cmn_taxes_all_rec.tax_name
4082: ,p_jai_cmn_taxes_all_rec.tax_descr
4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id

Line 4085: ,p_jai_cmn_taxes_all_rec.tax_amount

4081: ,p_jai_cmn_taxes_all_rec.tax_name
4082: ,p_jai_cmn_taxes_all_rec.tax_descr
4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag

Line 4086: ,p_jai_cmn_taxes_all_rec.uom_code

4082: ,p_jai_cmn_taxes_all_rec.tax_descr
4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id

Line 4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag

4083: ,p_jai_cmn_taxes_all_rec.tax_type
4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag

Line 4088: ,p_jai_cmn_taxes_all_rec.vendor_id

4084: ,p_jai_cmn_taxes_all_rec.tax_rate
4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id

Line 4089: ,p_jai_cmn_taxes_all_rec.vendor_flag

4085: ,p_jai_cmn_taxes_all_rec.tax_amount
4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage

Line 4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id

4086: ,p_jai_cmn_taxes_all_rec.uom_code
4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type

Line 4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag

4087: ,p_jai_cmn_taxes_all_rec.adhoc_flag
4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage

Line 4092: ,p_jai_cmn_taxes_all_rec.tax_account_id

4088: ,p_jai_cmn_taxes_all_rec.vendor_id
4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section

Line 4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage

4089: ,p_jai_cmn_taxes_all_rec.vendor_flag
4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag

Line 4094: ,p_jai_cmn_taxes_all_rec.stform_type

4090: ,p_jai_cmn_taxes_all_rec.vendor_site_id
4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date

Line 4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage

4091: ,p_jai_cmn_taxes_all_rec.modifiable_flag
4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date

Line 4096: ,p_jai_cmn_taxes_all_rec.tds_section

4092: ,p_jai_cmn_taxes_all_rec.tax_account_id
4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date

Line 4097: ,p_jai_cmn_taxes_all_rec.currency_flag

4093: ,p_jai_cmn_taxes_all_rec.mod_cr_percentage
4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by

Line 4098: ,p_jai_cmn_taxes_all_rec.start_date

4094: ,p_jai_cmn_taxes_all_rec.stform_type
4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date

Line 4099: ,p_jai_cmn_taxes_all_rec.end_date

4095: ,p_jai_cmn_taxes_all_rec.orig_tax_percentage
4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by

Line 4100: ,p_jai_cmn_taxes_all_rec.creation_date

4096: ,p_jai_cmn_taxes_all_rec.tds_section
4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login

Line 4101: ,p_jai_cmn_taxes_all_rec.created_by

4097: ,p_jai_cmn_taxes_all_rec.currency_flag
4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id

Line 4102: ,p_jai_cmn_taxes_all_rec.last_update_date

4098: ,p_jai_cmn_taxes_all_rec.start_date
4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate

Line 4103: ,p_jai_cmn_taxes_all_rec.last_updated_by

4099: ,p_jai_cmn_taxes_all_rec.end_date
4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag

Line 4104: ,p_jai_cmn_taxes_all_rec.last_update_login

4100: ,p_jai_cmn_taxes_all_rec.creation_date
4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor

Line 4105: ,p_jai_cmn_taxes_all_rec.org_id

4101: ,p_jai_cmn_taxes_all_rec.created_by
4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag

Line 4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate

4102: ,p_jai_cmn_taxes_all_rec.last_update_date
4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage

Line 4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag

4103: ,p_jai_cmn_taxes_all_rec.last_updated_by
4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag

Line 4108: ,p_jai_cmn_taxes_all_rec.rounding_factor

4104: ,p_jai_cmn_taxes_all_rec.last_update_login
4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type

Line 4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag

4105: ,p_jai_cmn_taxes_all_rec.org_id
4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code

Line 4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage

4106: ,p_jai_cmn_taxes_all_rec.surcharge_rate
4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate

Line 4111: ,p_jai_cmn_taxes_all_rec.vat_flag

4107: ,p_jai_cmn_taxes_all_rec.surcharge_flag
4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number

Line 4112: ,p_jai_cmn_taxes_all_rec.section_type

4108: ,p_jai_cmn_taxes_all_rec.rounding_factor
4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate

Line 4113: ,p_jai_cmn_taxes_all_rec.section_code

4109: ,p_jai_cmn_taxes_all_rec.duty_drawback_flag
4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag

Line 4114: ,p_jai_cmn_taxes_all_rec.cess_rate

4110: ,p_jai_cmn_taxes_all_rec.duty_drawback_percentage
4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1

Line 4115: ,p_jai_cmn_taxes_all_rec.object_version_number

4111: ,p_jai_cmn_taxes_all_rec.vat_flag
4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2

Line 4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate

4112: ,p_jai_cmn_taxes_all_rec.section_type
4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3

Line 4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag

4113: ,p_jai_cmn_taxes_all_rec.section_code
4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4

Line 4118: ,p_jai_cmn_taxes_all_rec.attribute1

4114: ,p_jai_cmn_taxes_all_rec.cess_rate
4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5

Line 4119: ,p_jai_cmn_taxes_all_rec.attribute2

4115: ,p_jai_cmn_taxes_all_rec.object_version_number
4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6

Line 4120: ,p_jai_cmn_taxes_all_rec.attribute3

4116: ,p_jai_cmn_taxes_all_rec.sh_cess_rate
4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7

Line 4121: ,p_jai_cmn_taxes_all_rec.attribute4

4117: ,p_jai_cmn_taxes_all_rec.inclusive_tax_flag
4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8

Line 4122: ,p_jai_cmn_taxes_all_rec.attribute5

4118: ,p_jai_cmn_taxes_all_rec.attribute1
4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9

Line 4123: ,p_jai_cmn_taxes_all_rec.attribute6

4119: ,p_jai_cmn_taxes_all_rec.attribute2
4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10

Line 4124: ,p_jai_cmn_taxes_all_rec.attribute7

4120: ,p_jai_cmn_taxes_all_rec.attribute3
4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11

Line 4125: ,p_jai_cmn_taxes_all_rec.attribute8

4121: ,p_jai_cmn_taxes_all_rec.attribute4
4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12

Line 4126: ,p_jai_cmn_taxes_all_rec.attribute9

4122: ,p_jai_cmn_taxes_all_rec.attribute5
4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13

Line 4127: ,p_jai_cmn_taxes_all_rec.attribute10

4123: ,p_jai_cmn_taxes_all_rec.attribute6
4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14

Line 4128: ,p_jai_cmn_taxes_all_rec.attribute11

4124: ,p_jai_cmn_taxes_all_rec.attribute7
4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15

Line 4129: ,p_jai_cmn_taxes_all_rec.attribute12

4125: ,p_jai_cmn_taxes_all_rec.attribute8
4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category

Line 4130: ,p_jai_cmn_taxes_all_rec.attribute13

4126: ,p_jai_cmn_taxes_all_rec.attribute9
4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category
4134: ,p_jai_cmn_taxes_all_rec.tax_type_id

Line 4131: ,p_jai_cmn_taxes_all_rec.attribute14

4127: ,p_jai_cmn_taxes_all_rec.attribute10
4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category
4134: ,p_jai_cmn_taxes_all_rec.tax_type_id
4135: ,p_jai_cmn_taxes_all_rec.auto_create_category

Line 4132: ,p_jai_cmn_taxes_all_rec.attribute15

4128: ,p_jai_cmn_taxes_all_rec.attribute11
4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category
4134: ,p_jai_cmn_taxes_all_rec.tax_type_id
4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag

Line 4133: ,p_jai_cmn_taxes_all_rec.attribute_category

4129: ,p_jai_cmn_taxes_all_rec.attribute12
4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category
4134: ,p_jai_cmn_taxes_all_rec.tax_type_id
4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );

Line 4134: ,p_jai_cmn_taxes_all_rec.tax_type_id

4130: ,p_jai_cmn_taxes_all_rec.attribute13
4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category
4134: ,p_jai_cmn_taxes_all_rec.tax_type_id
4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );
4138:

Line 4135: ,p_jai_cmn_taxes_all_rec.auto_create_category

4131: ,p_jai_cmn_taxes_all_rec.attribute14
4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category
4134: ,p_jai_cmn_taxes_all_rec.tax_type_id
4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );
4138:
4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',

Line 4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag

4132: ,p_jai_cmn_taxes_all_rec.attribute15
4133: ,p_jai_cmn_taxes_all_rec.attribute_category
4134: ,p_jai_cmn_taxes_all_rec.tax_type_id
4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );
4138:
4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',
4140: 'Created a new tax code ' || p_jai_cmn_taxes_all_rec.tax_id || '-' || p_jai_cmn_taxes_all_rec.tax_name);

Line 4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',

4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );
4138:
4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',
4140: 'Created a new tax code ' || p_jai_cmn_taxes_all_rec.tax_id || '-' || p_jai_cmn_taxes_all_rec.tax_name);
4141:
4142: END insert_jai_cmn_taxes_all;
4143:

Line 4140: 'Created a new tax code ' || p_jai_cmn_taxes_all_rec.tax_id || '-' || p_jai_cmn_taxes_all_rec.tax_name);

4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );
4138:
4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',
4140: 'Created a new tax code ' || p_jai_cmn_taxes_all_rec.tax_id || '-' || p_jai_cmn_taxes_all_rec.tax_name);
4141:
4142: END insert_jai_cmn_taxes_all;
4143:
4144: --==========================================================================

Line 4142: END insert_jai_cmn_taxes_all;

4138:
4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',
4140: 'Created a new tax code ' || p_jai_cmn_taxes_all_rec.tax_id || '-' || p_jai_cmn_taxes_all_rec.tax_name);
4141:
4142: END insert_jai_cmn_taxes_all;
4143:
4144: --==========================================================================
4145: -- PROCEDURE NAME:
4146: -- insert_jai_cmn_tax_ctg_lines Public