DBA Data[Home] [Help]

APPS.AP_VENDOR_SITES_PKG dependencies on PO_VENDOR_SITES_S

Line 251: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';

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;

Line 252: Select PO_VENDOR_SITES_S.NEXTVAL

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:

Line 570: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';

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;

Line 571: Select PO_VENDOR_SITES_S.NEXTVAL

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: