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_TAX_CTG_LINES

Line 3544: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE

3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE
3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE
3543: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE
3544: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3545: )
3546: IS
3547: CURSOR tax_cat_id IS
3548: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval val_id

Line 3602: INSERT INTO JAI_CMN_TAX_CTG_LINES(

3598: ,p_last_update_login
3599: );
3600:
3601: --create tax category detail line
3602: INSERT INTO JAI_CMN_TAX_CTG_LINES(
3603: TAX_CATEGORY_ID
3604: ,TAX_ID
3605: ,LINE_NO
3606: ,PRECEDENCE_1

Line 3674: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE

3670: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3671: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3672: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3673: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3674: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3675: )
3676: IS
3677:
3678: CURSOR tax_cat is

Line 3710: jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines%ROWTYPE;

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;
3714: ln_base_tax_rate NUMBER;

Line 3818: jai_cmn_tax_ctg_lines_rec := NULL;

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;
3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;
3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;

Line 3819: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

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;
3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;
3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;

Line 3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;

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;
3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;
3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

Line 3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;

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;
3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;
3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

Line 3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;

3818: jai_cmn_tax_ctg_lines_rec := NULL;
3819: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;
3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;
3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;

Line 3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;

3819: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;
3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;
3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

Line 3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

3820: jai_cmn_tax_ctg_lines_rec.tax_id := ln_base_tax_id;
3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

Line 3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
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);

Line 3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;

3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
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:

Line 3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
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

Line 3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
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

Line 3829: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
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

Line 3870: jai_cmn_tax_ctg_lines_rec := NULL;

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;
3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;
3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

Line 3871: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

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;
3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;
3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;

Line 3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;

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;
3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;
3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

Line 3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;

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;
3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;
3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

Line 3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

3870: jai_cmn_tax_ctg_lines_rec := NULL;
3871: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;
3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;
3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;

Line 3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;

3871: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;
3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;
3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

Line 3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

3872: jai_cmn_tax_ctg_lines_rec.tax_id := ln_cess_id;
3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

Line 3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

Line 3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;

3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3882: END IF;

Line 3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3882: END IF;
3883:

Line 3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3882: END IF;
3883:
3884: IF NVL(ln_sh_cess_rate,0) <> 0 THEN

Line 3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3882: END IF;
3883:
3884: IF NVL(ln_sh_cess_rate,0) <> 0 THEN
3885: ln_prcd_cnt := ln_prcd_cnt + 1;

Line 3918: jai_cmn_tax_ctg_lines_rec := NULL;

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;
3920: jai_cmn_tax_ctg_lines_rec.tax_id := ln_sh_cess_id;
3921: IF ln_prcd_cnt = 3 THEN
3922: jai_cmn_tax_ctg_lines_rec.line_no := 3;

Line 3919: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

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;
3920: jai_cmn_tax_ctg_lines_rec.tax_id := ln_sh_cess_id;
3921: IF ln_prcd_cnt = 3 THEN
3922: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3923: ELSE

Line 3920: jai_cmn_tax_ctg_lines_rec.tax_id := ln_sh_cess_id;

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;
3920: jai_cmn_tax_ctg_lines_rec.tax_id := ln_sh_cess_id;
3921: IF ln_prcd_cnt = 3 THEN
3922: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3923: ELSE
3924: jai_cmn_tax_ctg_lines_rec.line_no := 2;

Line 3922: jai_cmn_tax_ctg_lines_rec.line_no := 3;

3918: jai_cmn_tax_ctg_lines_rec := NULL;
3919: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;
3920: jai_cmn_tax_ctg_lines_rec.tax_id := ln_sh_cess_id;
3921: IF ln_prcd_cnt = 3 THEN
3922: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3923: ELSE
3924: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3925: END IF;
3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

Line 3924: jai_cmn_tax_ctg_lines_rec.line_no := 2;

3920: jai_cmn_tax_ctg_lines_rec.tax_id := ln_sh_cess_id;
3921: IF ln_prcd_cnt = 3 THEN
3922: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3923: ELSE
3924: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3925: END IF;
3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

Line 3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

3922: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3923: ELSE
3924: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3925: END IF;
3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;

Line 3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;

3923: ELSE
3924: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3925: END IF;
3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

Line 3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

3924: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3925: END IF;
3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

Line 3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3925: END IF;
3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

Line 3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;

3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3934: END IF;

Line 3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3934: END IF;
3935:

Line 3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3934: END IF;
3935:
3936: IF NVL(ln_surcharge_rate,0) <> 0 THEN

Line 3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3934: END IF;
3935:
3936: IF NVL(ln_surcharge_rate,0) <> 0 THEN
3937: ln_prcd_cnt := ln_prcd_cnt + 1;

Line 3970: jai_cmn_tax_ctg_lines_rec := NULL;

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;
3972: jai_cmn_tax_ctg_lines_rec.tax_id := ln_surcharge_id;
3973: IF ln_prcd_cnt = 4 THEN
3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;

Line 3971: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;

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;
3972: jai_cmn_tax_ctg_lines_rec.tax_id := ln_surcharge_id;
3973: IF ln_prcd_cnt = 4 THEN
3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;
3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

Line 3972: jai_cmn_tax_ctg_lines_rec.tax_id := ln_surcharge_id;

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;
3972: jai_cmn_tax_ctg_lines_rec.tax_id := ln_surcharge_id;
3973: IF ln_prcd_cnt = 4 THEN
3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;
3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;

Line 3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;

3970: jai_cmn_tax_ctg_lines_rec := NULL;
3971: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;
3972: jai_cmn_tax_ctg_lines_rec.tax_id := ln_surcharge_id;
3973: IF ln_prcd_cnt = 4 THEN
3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;
3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;
3978: ELSIF ln_prcd_cnt = 3 THEN

Line 3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

3971: jai_cmn_tax_ctg_lines_rec.tax_category_id := ln_val_id;
3972: jai_cmn_tax_ctg_lines_rec.tax_id := ln_surcharge_id;
3973: IF ln_prcd_cnt = 4 THEN
3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;
3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;
3978: ELSIF ln_prcd_cnt = 3 THEN
3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;

Line 3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;

3972: jai_cmn_tax_ctg_lines_rec.tax_id := ln_surcharge_id;
3973: IF ln_prcd_cnt = 4 THEN
3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;
3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;
3978: ELSIF ln_prcd_cnt = 3 THEN
3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

Line 3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;

3973: IF ln_prcd_cnt = 4 THEN
3974: jai_cmn_tax_ctg_lines_rec.line_no := 4;
3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;
3978: ELSIF ln_prcd_cnt = 3 THEN
3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3981: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;

Line 3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;

3975: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;
3978: ELSIF ln_prcd_cnt = 3 THEN
3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3981: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3982: ELSE
3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;

Line 3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

3976: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;
3978: ELSIF ln_prcd_cnt = 3 THEN
3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3981: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3982: ELSE
3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

Line 3981: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;

3977: jai_cmn_tax_ctg_lines_rec.precedence_3 := 3;
3978: ELSIF ln_prcd_cnt = 3 THEN
3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3981: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3982: ELSE
3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3985: END IF;

Line 3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;

3979: jai_cmn_tax_ctg_lines_rec.line_no := 3;
3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3981: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3982: ELSE
3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3985: END IF;
3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

Line 3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;

3980: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3981: jai_cmn_tax_ctg_lines_rec.precedence_2 := 2;
3982: ELSE
3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3985: END IF;
3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

Line 3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;

3982: ELSE
3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3985: END IF;
3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

Line 3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;

3983: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3985: END IF;
3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

Line 3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3985: END IF;
3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

Line 3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;

3985: END IF;
3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3993: END IF;

Line 3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3993: END IF;
3994:

Line 3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3993: END IF;
3994:
3995: END AUTO_CREATE_DTC_CATEGORY;

Line 3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3993: END IF;
3994:
3995: END AUTO_CREATE_DTC_CATEGORY;
3996:

Line 4146: -- insert_jai_cmn_tax_ctg_lines Public

4142: END insert_jai_cmn_taxes_all;
4143:
4144: --==========================================================================
4145: -- PROCEDURE NAME:
4146: -- insert_jai_cmn_tax_ctg_lines Public
4147: --
4148: -- DESCRIPTION:
4149: -- Insert a new line for jai_cmn_tax_ctg_lines table
4150: --

Line 4149: -- Insert a new line for jai_cmn_tax_ctg_lines table

4145: -- PROCEDURE NAME:
4146: -- insert_jai_cmn_tax_ctg_lines Public
4147: --
4148: -- DESCRIPTION:
4149: -- Insert a new line for jai_cmn_tax_ctg_lines table
4150: --
4151: -- PARAMETERS:
4152: -- In: p_jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines record
4153: --

Line 4152: -- In: p_jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines record

4148: -- DESCRIPTION:
4149: -- Insert a new line for jai_cmn_tax_ctg_lines table
4150: --
4151: -- PARAMETERS:
4152: -- In: p_jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines record
4153: --
4154: -- DESIGN REFERENCES:
4155: -- For new TDS architecture migration script
4156: --

Line 4160: PROCEDURE insert_jai_cmn_tax_ctg_lines (

4156: --
4157: -- CHANGE HISTORY:
4158: -- 24-OCT-2012 Chong created
4159: --==========================================================================
4160: PROCEDURE insert_jai_cmn_tax_ctg_lines (
4161: p_jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines%ROWTYPE
4162: ) IS
4163:
4164: BEGIN

Line 4161: p_jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines%ROWTYPE

4157: -- CHANGE HISTORY:
4158: -- 24-OCT-2012 Chong created
4159: --==========================================================================
4160: PROCEDURE insert_jai_cmn_tax_ctg_lines (
4161: p_jai_cmn_tax_ctg_lines_rec jai_cmn_tax_ctg_lines%ROWTYPE
4162: ) IS
4163:
4164: BEGIN
4165:

Line 4167: INSERT INTO jai_cmn_tax_ctg_lines(

4163:
4164: BEGIN
4165:
4166: --insert tax tagecode
4167: INSERT INTO jai_cmn_tax_ctg_lines(
4168: tax_category_id
4169: ,tax_id
4170: ,line_no
4171: ,precedence_1

Line 4189: p_jai_cmn_tax_ctg_lines_rec.tax_category_id

4185: ,last_update_login
4186: ,object_version_number
4187: )
4188: VALUES(
4189: p_jai_cmn_tax_ctg_lines_rec.tax_category_id
4190: ,p_jai_cmn_tax_ctg_lines_rec.tax_id
4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no
4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2

Line 4190: ,p_jai_cmn_tax_ctg_lines_rec.tax_id

4186: ,object_version_number
4187: )
4188: VALUES(
4189: p_jai_cmn_tax_ctg_lines_rec.tax_category_id
4190: ,p_jai_cmn_tax_ctg_lines_rec.tax_id
4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no
4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3

Line 4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no

4187: )
4188: VALUES(
4189: p_jai_cmn_tax_ctg_lines_rec.tax_category_id
4190: ,p_jai_cmn_tax_ctg_lines_rec.tax_id
4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no
4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4

Line 4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1

4188: VALUES(
4189: p_jai_cmn_tax_ctg_lines_rec.tax_category_id
4190: ,p_jai_cmn_tax_ctg_lines_rec.tax_id
4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no
4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5

Line 4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2

4189: p_jai_cmn_tax_ctg_lines_rec.tax_category_id
4190: ,p_jai_cmn_tax_ctg_lines_rec.tax_id
4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no
4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6

Line 4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3

4190: ,p_jai_cmn_tax_ctg_lines_rec.tax_id
4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no
4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7

Line 4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4

4191: ,p_jai_cmn_tax_ctg_lines_rec.line_no
4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8

Line 4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5

4192: ,p_jai_cmn_tax_ctg_lines_rec.precedence_1
4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9

Line 4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6

4193: ,p_jai_cmn_tax_ctg_lines_rec.precedence_2
4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10

Line 4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7

4194: ,p_jai_cmn_tax_ctg_lines_rec.precedence_3
4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date

Line 4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8

4195: ,p_jai_cmn_tax_ctg_lines_rec.precedence_4
4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by

Line 4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9

4196: ,p_jai_cmn_tax_ctg_lines_rec.precedence_5
4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date

Line 4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10

4197: ,p_jai_cmn_tax_ctg_lines_rec.precedence_6
4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date
4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by

Line 4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date

4198: ,p_jai_cmn_tax_ctg_lines_rec.precedence_7
4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date
4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by
4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login

Line 4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by

4199: ,p_jai_cmn_tax_ctg_lines_rec.precedence_8
4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date
4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by
4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number

Line 4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date

4200: ,p_jai_cmn_tax_ctg_lines_rec.precedence_9
4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date
4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by
4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );

Line 4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by

4201: ,p_jai_cmn_tax_ctg_lines_rec.precedence_10
4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date
4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by
4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );
4209:

Line 4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login

4202: ,p_jai_cmn_tax_ctg_lines_rec.creation_date
4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date
4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by
4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );
4209:
4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',

Line 4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number

4203: ,p_jai_cmn_tax_ctg_lines_rec.created_by
4204: ,p_jai_cmn_tax_ctg_lines_rec.last_update_date
4205: ,p_jai_cmn_tax_ctg_lines_rec.last_updated_by
4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );
4209:
4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',
4211: 'Created a tax category line ' || p_jai_cmn_tax_ctg_lines_rec.line_no || '-' || p_jai_cmn_tax_ctg_lines_rec.tax_id);

Line 4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',

4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );
4209:
4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',
4211: 'Created a tax category line ' || p_jai_cmn_tax_ctg_lines_rec.line_no || '-' || p_jai_cmn_tax_ctg_lines_rec.tax_id);
4212:
4213: END insert_jai_cmn_tax_ctg_lines;
4214: ------------------------------------------------------------------------------------------------

Line 4211: 'Created a tax category line ' || p_jai_cmn_tax_ctg_lines_rec.line_no || '-' || p_jai_cmn_tax_ctg_lines_rec.tax_id);

4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );
4209:
4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',
4211: 'Created a tax category line ' || p_jai_cmn_tax_ctg_lines_rec.line_no || '-' || p_jai_cmn_tax_ctg_lines_rec.tax_id);
4212:
4213: END insert_jai_cmn_tax_ctg_lines;
4214: ------------------------------------------------------------------------------------------------
4215: --Added by Chong.Lei for DTC bug#13359892 on 20111205 end

Line 4213: END insert_jai_cmn_tax_ctg_lines;

4209:
4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',
4211: 'Created a tax category line ' || p_jai_cmn_tax_ctg_lines_rec.line_no || '-' || p_jai_cmn_tax_ctg_lines_rec.tax_id);
4212:
4213: END insert_jai_cmn_tax_ctg_lines;
4214: ------------------------------------------------------------------------------------------------
4215: --Added by Chong.Lei for DTC bug#13359892 on 20111205 end
4216:
4217: --Added by Zhiwei Hou for DTC migration Bug#13359892 on 20120228 begin