APPS.JAI_PAN_UPDATE_PKG dependencies on JAI_AP_TDS_THHOLD_XCEPS

Line 80: (3) jai_ap_tds_thhold_xceps

76: /* Update the tables in the following order
77:
78: (1) ja_in_vendor_tds_info_hdr
79: (2) jai_ap_tds_thhold_grps
80: (3) jai_ap_tds_thhold_xceps
81:
82: */
83:
84: lv_vendor_site_id_updated varchar2(1000) ;

Line 228: -- jai_ap_tds_thhold_xceps

224:
225: end loop;
226:
227:
228: -- jai_ap_tds_thhold_xceps
229:
230: lv_debug_msg := ' 9. Update jai_ap_tds_thhold_xceps';
231:
232: If lv_debug_flag = 'Y' then

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

226:
227:
228: -- jai_ap_tds_thhold_xceps
229:
230: lv_debug_msg := ' 9. Update jai_ap_tds_thhold_xceps';
231:
232: If lv_debug_flag = 'Y' then
233: Print_log(lv_debug_flag, lv_debug_msg);
234: End if;

Line 237: from jai_ap_tds_thhold_xceps tdsxps

233: Print_log(lv_debug_flag, lv_debug_msg);
234: End if;
235:
236: for thhold_xceps in (select tdsxps.*
237: from jai_ap_tds_thhold_xceps tdsxps
238: where tdsxps.vendor_id = P_vendor_id
239: and vendor_pan = P_old_pan_num)
240: loop
241:

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

238: where tdsxps.vendor_id = P_vendor_id
239: and vendor_pan = P_old_pan_num)
240: loop
241:
242: lv_debug_msg := ' 10. Going to update jai_ap_tds_thhold_xceps';
243:
244: If lv_debug_flag = 'Y' then
245: Print_log(lv_debug_flag, lv_debug_msg);
246: End if;

Line 248: Update jai_ap_tds_thhold_xceps

244: If lv_debug_flag = 'Y' then
245: Print_log(lv_debug_flag, lv_debug_msg);
246: End if;
247:
248: Update jai_ap_tds_thhold_xceps
249: set vendor_pan = P_new_pan_num
250: where vendor_id = P_vendor_id
251: and vendor_pan = P_old_pan_num;
252: