DBA Data[Home] [Help]

APPS.AP_VENDOR_SITES_PKG dependencies on PO_VENDOR_SITES_S

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

248: where vendor_id = x_vendor_id
249: and vendor_site_code = x_vendor_site_code; */
250:
251: --(Bug 702458) if (x_vendor_site_id IS NULL) then
252: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
253: Select PO_VENDOR_SITES_S.NEXTVAL
254: into x_vendor_site_id
255: from sys.dual;
256: -- end if;

Line 253: Select PO_VENDOR_SITES_S.NEXTVAL

249: and vendor_site_code = x_vendor_site_code; */
250:
251: --(Bug 702458) if (x_vendor_site_id IS NULL) then
252: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
253: Select PO_VENDOR_SITES_S.NEXTVAL
254: into x_vendor_site_id
255: from sys.dual;
256: -- end if;
257:

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

569: debug_info varchar2(2000);
570:
571: BEGIN
572:
573: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
574: Select PO_VENDOR_SITES_S.NEXTVAL
575: into x_vendor_site_id
576: from sys.dual;
577: -- end if;

Line 574: Select PO_VENDOR_SITES_S.NEXTVAL

570:
571: BEGIN
572:
573: debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
574: Select PO_VENDOR_SITES_S.NEXTVAL
575: into x_vendor_site_id
576: from sys.dual;
577: -- end if;
578: