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: 45

         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
         AND   vendor_site_id = p_dup_vendor_site_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
         AND   vendor_site_id =  p_dup_vendor_site_id;

Line: 82

         FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 87

          UPDATE  pn_term_templates
          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
          AND   vendor_site_id = p_dup_vendor_site_id;

Line: 103

         FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 107

          UPDATE  pn_payment_terms_history
          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
          AND   vendor_site_id = p_dup_vendor_site_id;

Line: 123

         FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);