DBA Data[Home] [Help]

APPS.JAI_PAN_UPDATE_PKG dependencies on JAI_AP_TDS_PAN_CHANGES

Line 270: -- insert a record in jai_ap_tds_pan_changes

266:
267: end loop;
268:
269:
270: -- insert a record in jai_ap_tds_pan_changes
271: -- This help us to keep track of PAN changes for the given vendor
272:
273:
274: lv_debug_msg := ' 13. Inside insert - ';

Line 280: Insert into jai_ap_tds_pan_changes

276: If lv_debug_flag = 'Y' then
277: Print_log(lv_debug_flag, lv_debug_msg);
278: End if;
279:
280: Insert into jai_ap_tds_pan_changes
281: ( pan_change_id,
282: vendor_id,
283: old_pan_num,
284: new_pan_num,

Line 297: ( jai_ap_tds_pan_changes_s.nextval,

293: last_updated_by,
294: last_update_login
295: )
296: values
297: ( jai_ap_tds_pan_changes_s.nextval,
298: P_vendor_id,
299: P_old_pan_num,
300: P_new_pan_num,
301: ln_request_id,