APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_TDS_INV_TAXES

Line 4440: /*To update actual section code in table JAI_AP_TDS_INV_TAXES*/

4436: end update_suppl_default_sec;
4437:
4438:
4439:
4440: /*To update actual section code in table JAI_AP_TDS_INV_TAXES*/
4441: procedure update_inv_tax_sec
4442: is
4443:
4444: lx_ex exception;

Line 4455: update JAI_AP_TDS_INV_TAXES

4451: from jai_tds_section_mapping
4452: )
4453: loop
4454:
4455: update JAI_AP_TDS_INV_TAXES
4456: set actual_section_code = rec_maps.new_section_code
4457: where actual_section_code = rec_maps.old_section_code;
4458:
4459: update_count_out := SQL%ROWCOUNT;

Line 4460: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4456: set actual_section_code = rec_maps.new_section_code
4457: where actual_section_code = rec_maps.old_section_code;
4458:
4459: update_count_out := SQL%ROWCOUNT;
4460: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4461: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4462:
4463: end loop;
4464:

Line 4461: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4457: where actual_section_code = rec_maps.old_section_code;
4458:
4459: update_count_out := SQL%ROWCOUNT;
4460: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4461: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4462:
4463: end loop;
4464:
4465: commit;