APPS.PN_VENDORMERGE_GRP SQL Statements

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

Line: 18

	    p_last_updated_by    IN   NUMBER                           )

IS

        l_api_name		 CONSTANT VARCHAR2(30)	:= 'Merge_Vendor';

Line: 46

         UPDATE  pn_payment_terms
         SET vendor_id        = p_vendor_id,
             vendor_site_id   = p_vendor_site_id,
             last_updated_by  = p_last_updated_by,
             last_update_date = sysdate
         WHERE vendor_id      = p_dup_vendor_id;

Line: 61

	 FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 66

         UPDATE pn_payment_items
         SET vendor_id         = p_vendor_id,
             vendor_site_id    = p_vendor_site_id,
             last_updated_by   = p_last_updated_by,
             last_update_date  = sysdate
         WHERE vendor_id       = p_dup_vendor_id;

Line: 81

	 FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);