247: where vendor_id = x_vendor_id
248: and vendor_site_code = x_vendor_site_code; */
249:
250: --(Bug 702458) if (x_vendor_site_id IS NULL) then
251: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
252: Select PO_VENDOR_SITES_S.NEXTVAL
253: into x_vendor_site_id
254: from sys.dual;
255: -- end if;
248: and vendor_site_code = x_vendor_site_code; */
249:
250: --(Bug 702458) if (x_vendor_site_id IS NULL) then
251: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
252: Select PO_VENDOR_SITES_S.NEXTVAL
253: into x_vendor_site_id
254: from sys.dual;
255: -- end if;
256:
566: debug_info varchar2(2000);
567:
568: BEGIN
569:
570: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
571: Select PO_VENDOR_SITES_S.NEXTVAL
572: into x_vendor_site_id
573: from sys.dual;
574: -- end if;
567:
568: BEGIN
569:
570: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
571: Select PO_VENDOR_SITES_S.NEXTVAL
572: into x_vendor_site_id
573: from sys.dual;
574: -- end if;
575: