754: lv_description,
755: lv_tax_account_code,
756: v_org_id,
757: 'N',
758: fnd_global.user_id,
759: SYSDATE,
760: fnd_global.user_id,
761: SYSDATE,
762: fnd_global.login_id);
756: v_org_id,
757: 'N',
758: fnd_global.user_id,
759: SYSDATE,
760: fnd_global.user_id,
761: SYSDATE,
762: fnd_global.login_id);
763:
764: END LOOP;
758: fnd_global.user_id,
759: SYSDATE,
760: fnd_global.user_id,
761: SYSDATE,
762: fnd_global.login_id);
763:
764: END LOOP;
765: IF ln_depb_amount > 0 THEN
766: ln_depb_amount := - ln_depb_amount;
803: lv_description, -- item_description,
804: ln_depb_account_id,
805: v_org_id, -- org_id,
806: 'N', -- amount_includes_tax_flag,
807: fnd_global.login_id,
808: SYSDATE,
809: fnd_global.login_id,
810: SYSDATE,
811: fnd_global.login_id
805: v_org_id, -- org_id,
806: 'N', -- amount_includes_tax_flag,
807: fnd_global.login_id,
808: SYSDATE,
809: fnd_global.login_id,
810: SYSDATE,
811: fnd_global.login_id
812: );
813: END IF;
807: fnd_global.login_id,
808: SYSDATE,
809: fnd_global.login_id,
810: SYSDATE,
811: fnd_global.login_id
812: );
813: END IF;
814:
815:
2093: lv_thhold_xcep_id_updated := '';
2094:
2095: fnd_file.put_line(FND_FILE.LOG, 'START OF Procedure ');
2096:
2097: ln_request_id := FND_GLOBAL.conc_request_id;
2098:
2099: lv_debug_msg := ' A. Report Parameters';
2100:
2101: If lv_debug_flag = 'Y' then
2298: lv_vendor_site_id_updated,
2299: lv_thhold_grp_id_updated,
2300: lv_thhold_xcep_id_updated,
2301: sysdate,
2302: fnd_global.user_id,
2303: sysdate,
2304: fnd_global.user_id,
2305: fnd_global.login_id
2306: );
2300: lv_thhold_xcep_id_updated,
2301: sysdate,
2302: fnd_global.user_id,
2303: sysdate,
2304: fnd_global.user_id,
2305: fnd_global.login_id
2306: );
2307:
2308:
2301: sysdate,
2302: fnd_global.user_id,
2303: sysdate,
2304: fnd_global.user_id,
2305: fnd_global.login_id
2306: );
2307:
2308:
2309: commit;
3756: ,p_item_class_cd
3757: ,p_org_id
3758: ,p_object_version_number
3759: ,sysdate
3760: ,fnd_global.user_id
3761: ,sysdate
3762: ,fnd_global.user_id
3763: ,fnd_global.login_id
3764: );
3758: ,p_object_version_number
3759: ,sysdate
3760: ,fnd_global.user_id
3761: ,sysdate
3762: ,fnd_global.user_id
3763: ,fnd_global.login_id
3764: );
3765:
3766:
3759: ,sysdate
3760: ,fnd_global.user_id
3761: ,sysdate
3762: ,fnd_global.user_id
3763: ,fnd_global.login_id
3764: );
3765:
3766:
3767: --get legacy TDS tax rate from tax code
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
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:
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
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);
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
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
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
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:
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
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);
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:
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
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
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:
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
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);
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:
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
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
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:
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
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);
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:
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;