APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_TDS_THHOLD_XCEPS

Line 2075: (3) jai_ap_tds_thhold_xceps

2071: /* Update the tables in the following order
2072:
2073: (1) JAI_AP_TDS_VENDOR_HDRS
2074: (2) jai_ap_tds_thhold_grps
2075: (3) jai_ap_tds_thhold_xceps
2076:
2077: */
2078:
2079: lv_vendor_site_id_updated varchar2(1000) ;

Line 2223: -- jai_ap_tds_thhold_xceps

2219:
2220: end loop;
2221:
2222:
2223: -- jai_ap_tds_thhold_xceps
2224:
2225: lv_debug_msg := ' 9. Update jai_ap_tds_thhold_xceps';
2226:
2227: If lv_debug_flag = 'Y' then

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

2221:
2222:
2223: -- jai_ap_tds_thhold_xceps
2224:
2225: lv_debug_msg := ' 9. Update jai_ap_tds_thhold_xceps';
2226:
2227: If lv_debug_flag = 'Y' then
2228: Print_log(lv_debug_flag, lv_debug_msg);
2229: End if;

Line 2232: from jai_ap_tds_thhold_xceps tdsxps

2228: Print_log(lv_debug_flag, lv_debug_msg);
2229: End if;
2230:
2231: for thhold_xceps in (select tdsxps.*
2232: from jai_ap_tds_thhold_xceps tdsxps
2233: where tdsxps.vendor_id = P_vendor_id
2234: and vendor_pan = P_old_pan_num)
2235: loop
2236:

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

2233: where tdsxps.vendor_id = P_vendor_id
2234: and vendor_pan = P_old_pan_num)
2235: loop
2236:
2237: lv_debug_msg := ' 10. Going to update jai_ap_tds_thhold_xceps';
2238:
2239: If lv_debug_flag = 'Y' then
2240: Print_log(lv_debug_flag, lv_debug_msg);
2241: End if;

Line 2243: Update jai_ap_tds_thhold_xceps

2239: If lv_debug_flag = 'Y' then
2240: Print_log(lv_debug_flag, lv_debug_msg);
2241: End if;
2242:
2243: Update jai_ap_tds_thhold_xceps
2244: set vendor_pan = P_new_pan_num
2245: where vendor_id = P_vendor_id
2246: and vendor_pan = P_old_pan_num;
2247: