APPS.OKC_REP_PARTY_MERGE_GRP SQL Statements

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

Line: 91

      UPDATE okc_rep_contract_parties
	 SET party_id    = p_to_fk_id,
	     last_update_date  = sysdate,
	     last_updated_by    = fnd_global.user_id,
	     last_update_login  = fnd_global.user_id,
	     object_version_number = object_version_number+1
      WHERE  party_id = p_from_fk_id
      AND    party_role_code IN (G_PARTNER_ROLE, G_CUSTOMER_ROLE);

Line: 224

     UPDATE okc_rep_contract_parties
	 SET party_location_id = p_to_fk_id,
	     last_update_date  = sysdate,
	     last_updated_by    = fnd_global.user_id,
	     last_update_login  = fnd_global.user_id,
	     object_version_number = object_version_number+1
      WHERE  party_location_id = p_from_fk_id
      AND    party_role_code IN (G_PARTNER_ROLE, G_CUSTOMER_ROLE);

Line: 352

      UPDATE okc_rep_contract_parties
	    SET party_id    = p_to_fk_id,
	     last_update_date  = sysdate,
	     last_updated_by    = fnd_global.user_id,
	     last_update_login  = fnd_global.user_id,
	     object_version_number = object_version_number+1
      WHERE  party_id = p_from_fk_id
      AND    party_role_code = G_SUPPLIER_ROLE;

Line: 368

    OKC_MANAGE_DELIVERABLES_GRP.updateExtPartyOnDeliverables(
      p_api_version               => 1.0,
      p_init_msg_list             => FND_API.G_FALSE,
      p_commit                    => FND_API.G_FALSE,
      p_document_class            => G_OKC_REP_DOCUMENT_CLASS,
      p_from_external_party_id    => p_from_fk_id,
      p_from_external_party_site_id  => NULL,
      p_to_external_party_id         => p_to_fk_id,
      p_to_external_party_site_id    => NULL,
      x_msg_data                  => l_msg_data,
      x_msg_count                 => l_msg_count,
      x_return_status             => l_return_status);

Line: 484

      UPDATE okc_rep_contract_parties
	    SET party_location_id    = p_to_fk_id,
	     last_update_date  = sysdate,
	     last_updated_by    = fnd_global.user_id,
	     last_update_login  = fnd_global.user_id,
	     object_version_number = object_version_number+1
      WHERE  party_location_id = p_from_fk_id
      AND    party_role_code = G_SUPPLIER_ROLE;