APPS.AP_SUPPLIER_INFO_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 73

    l_site_sel      VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';

Line: 76

    l_contact_sel   VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';

Line: 106

    SELECT  count(1)
    INTO    l_check_vid
    FROM    ap_suppliers
    WHERE   vendor_id = i_vendor_id;

Line: 120

            SELECT  count(1)
            INTO    l_check_vsid
            FROM    ap_supplier_sites_all
            WHERE   vendor_id = i_vendor_id
            AND     vendor_site_id = i_vendor_site_id;

Line: 141

                SELECT  count(1)
                INTO    l_check_vcid
                FROM    po_vendor_contacts
                WHERE   vendor_id = i_vendor_id
                AND     vendor_site_id = i_vendor_site_id
                AND     vendor_contact_id = i_vendor_contact_id;

Line: 164

                SELECT  count(1)
                INTO    l_check_vcid
                FROM    po_vendor_contacts
                WHERE   vendor_id = i_vendor_id
                AND     vendor_contact_id = i_vendor_contact_id;

Line: 181

                                    || 'SELECT vendor_site_id '
                                    || 'FROM   PO_VENDOR_CONTACTS '
                                    || 'WHERE  vendor_contact_id = '
                                    || to_char( i_vendor_contact_id ) || ' )' ;

Line: 211

    SELECT  *
    INTO    o_supplier_info.supp_rec
    FROM    ap_suppliers
    WHERE   vendor_id = i_vendor_id;

Line: 242

		l_contact_tab.DELETE;

Line: 246

	l_site_tab.DELETE;

Line: 306

        SELECT  *
        FROM    ap_suppliers
        WHERE   vendor_id BETWEEN i_from_vendor_id AND i_to_vendor_id;

Line: 315

    l_site_sel      VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';

Line: 317

    l_contact_sel   VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';

Line: 335

    SELECT  count(1)
    INTO    l_check_vid
    FROM    ap_suppliers
    WHERE   vendor_id BETWEEN i_from_vendor_id AND i_to_vendor_id;

Line: 393

                            l_contact_tab.DELETE;

Line: 397

                	l_site_tab.DELETE;

Line: 401

           l_supplier_tab.DELETE;