APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_TDS_THHOLD_XCEPS

Line 1853: (3) jai_ap_tds_thhold_xceps

1849: /* Update the tables in the following order
1850:
1851: (1) JAI_AP_TDS_VENDOR_HDRS
1852: (2) jai_ap_tds_thhold_grps
1853: (3) jai_ap_tds_thhold_xceps
1854:
1855: */
1856:
1857: lv_vendor_site_id_updated varchar2(1000) ;

Line 2001: -- jai_ap_tds_thhold_xceps

1997:
1998: end loop;
1999:
2000:
2001: -- jai_ap_tds_thhold_xceps
2002:
2003: lv_debug_msg := ' 9. Update jai_ap_tds_thhold_xceps';
2004:
2005: If lv_debug_flag = 'Y' then

Line 2003: lv_debug_msg := ' 9. Update jai_ap_tds_thhold_xceps';

1999:
2000:
2001: -- jai_ap_tds_thhold_xceps
2002:
2003: lv_debug_msg := ' 9. Update jai_ap_tds_thhold_xceps';
2004:
2005: If lv_debug_flag = 'Y' then
2006: Print_log(lv_debug_flag, lv_debug_msg);
2007: End if;

Line 2010: from jai_ap_tds_thhold_xceps tdsxps

2006: Print_log(lv_debug_flag, lv_debug_msg);
2007: End if;
2008:
2009: for thhold_xceps in (select tdsxps.*
2010: from jai_ap_tds_thhold_xceps tdsxps
2011: where tdsxps.vendor_id = P_vendor_id
2012: and vendor_pan = P_old_pan_num)
2013: loop
2014:

Line 2015: lv_debug_msg := ' 10. Going to update jai_ap_tds_thhold_xceps';

2011: where tdsxps.vendor_id = P_vendor_id
2012: and vendor_pan = P_old_pan_num)
2013: loop
2014:
2015: lv_debug_msg := ' 10. Going to update jai_ap_tds_thhold_xceps';
2016:
2017: If lv_debug_flag = 'Y' then
2018: Print_log(lv_debug_flag, lv_debug_msg);
2019: End if;

Line 2021: Update jai_ap_tds_thhold_xceps

2017: If lv_debug_flag = 'Y' then
2018: Print_log(lv_debug_flag, lv_debug_msg);
2019: End if;
2020:
2021: Update jai_ap_tds_thhold_xceps
2022: set vendor_pan = P_new_pan_num
2023: where vendor_id = P_vendor_id
2024: and vendor_pan = P_old_pan_num;
2025: